Lost connection to Database.

users
#1

Thanks Alex and Dan.

I had forgotten to do that - so have downloaded 5.1.37 and set it up in LO but I still get the same error.

I notice also that when checking Services I have no htppd available to switch on!!??

Any other ideas please?

Thanks a lot.

#2

Hi Ian,

Thanks Alex and Dan.

I had forgotten to do that - so have downloaded 5.1.37 and set it up in
LO but I still get the same error.

I notice also that when checking Services I have no htppd available to
switch on!!??

You don't need a httpd daemon running to access a mysql db via the jdbc
connector, that httpd service is however required for phpmyadmin (your
browser-based management interface to mysql database server).

Is the mysql server actually running ?

Is your JDK recognized by LO (Tools - Options - Advanced) ?

Alex

#3

Is a JDK/JRE installed ?

Alex

#4

Is the mysql server actually running ?

mysqld is running, (start on boot) in Services.

Is your JDK recognized by LO (Tools - Options - Advanced) ?

YES- /usr/lib/jvm/java-1.8.0-sun-1.8.0.60/jre

#5

Just because mysql is supposed to start on boot, doesn't mean that it is
actually running. From a terminal, type :

mysqladmin status

You might be required to enter your admin (root/sudo) password for this,
or you might get an error message saying that you are not authorised, in
which case try :

mysqladmin status -p

and then you'll be asked for a password.

You can also check whether it is running in the list of active processes
by typing :

ps aux | grep mysql

Is mysql listening on the default port 3306 ?

netstat -ant | grep 3306

Can you access your database/tables from the mysql management interface,
for example ?

The original jdbc error that you posted is indicative of something not
being setup correctly in your connection to the database. When you open
the ODB file, if you click on Tables, then right mouse button click on
the space in which the tables are listed, you should see a context menu
that says "Database" which leads to another menu entry "Advanced". This
takes you through the connection configuration screens, it might be
helpful to post the output of those here. One of these screens allows
you to test whether the driver is loading properly. If it isn't, then LO
either isn't seeing your JRE, or the driver configuration is wrong
(wrong strings, wrong version, wrong place, etc)

Alex

#6

Up-date

I have been busy with other things and just got back to this problem.

I found that the link to the Class file was not working so corrected that and the whole set-up now works fine.

But when I try to open the Database it opens the input Form and pops up an error -
"The data content could not be loaded
Can't find file: ./FS/Members.frm (errno:13)"

But the Members form IS opening all right, and its actual path is root/var/lib/mysql/FS/Members.frm. But it is not being populate.

Any thoughts??

IanW
Pretoria RSA

#7

Hi Ian,

./FS/Members.frm (errno:13)

The frm file extension has nothing to do with a form, it is the internal
MySQL table format stored in binary hexadecimal form :

https://dev.mysql.com/doc/internals/en/frm-file-format.html

In other words, the error message you are getting indicates that the
file in question Members.frm is not in the place where it is supposed to
be. This means that your mysql database is missing one or more correctly
referenced files and is probably either corrupt or in an inconsistent state.

You need to run a check on your mysql instance installation from the
terminal with :

mysqlcheck -g --all-databases=true

(as superuser do or as a user with admin privileges to the database server)

Alex

#8

More particularly, errno 13 is a file permissions problem :

http://serverfault.com/questions/20650/fixing-cant-find-file-errno-13-on-mysql

If you read that thread, there are a number of different causes and
suggestions for remedying the error. You need to examine each one to
find out which applies in your case.

Alex