Re: main database is too old or corrupt

Dan O'Donnell writes:
 > On Tue, April 18, 2006 12:07 am, Markus Hoenicka wrote:
 > > Hi,
 > >
 > > Daniel O'Donnell <[email protected]> was heard to say:
 > >
 > >> I think the trouble is coming if you try to access mysql rather than
 > >> mysql lite.
 > >>
 > >

Thanks for the dump file. It clearly shows that the database is up to
date. The error must be somewhere else.

I've had another look at the sourcecode. The main database check is
actually the first attempt to access the main database after a command
is issued. Contrary to what I wrote in a previous message, the error
might well be caused by insufficient access rights to the refdb
database. You'd get a clear error message saying you can't connect to
the server only if you don't have permissions to talk to the server at
all - one of the peculiarities of MySQL. Apparently you may access
your mysqld server, but not the refdb database.

Unless the Debian installation does some black magic, you will have to
add at least one user to your RefDB installation. This will grant
permission to refdb too. Alternatively you could make a test run using
the MySQL administrator account. This account should have the
permissions to read the database anyway.

If this does not help, could you please check whether you can connect
to the refdb database using the mysql command line client? Try it like
this, using your own MySQL account info:

markus@yeti:~# mysql -u markus -p refdb
Enter password: 

mysql> select * from t_meta;
[...]
1 row in set (0.00 sec)

mysql>

If this does not work, repeat with the MySQL administrator account
info.

regards,
Markus

-- 
Markus Hoenicka
[email protected]
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de



-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642