installation error mysql user rights

Jos

hiya,
i'm getting an error msg during my installation proces (ie running setup.php)

--------------------------------------------------------------------
mySQL access rights [insufficient]

Your mySQL user must have Select, Insert, Update, and Delete rights.

Grants found:

GRANT USAGE ON *.* TO 'kaahoo_foto'@'localhost' IDENTIFIED BY PASSWORD '*37A63CC314140A4B7FA09711CEA529914FA6838C' *

GRANT SELECT, INSERT, UPDATE, DELETE ON `kaahoo_zenphoto`.* TO 'kaahoo_foto'@'localhost'
----------------------------------------------------------------------
i think i did everything right:
i created the database, added the user and given him the rights using cpanel
i also tried giving the user all priveliges, but that didn't work either.

Can someone help me out please?

acrylian

http://www.zenphoto.org/support/topic.php?id=2303&replies=2#post-13750

sbillard

What is the name of the database you are using with zenphoto?

(The message is a warning, so you can try ignoring it.)

Jos

ah indeed,
just ignored it and works fine now.
thank you both.

reef

I'm getting the same error with a new install (1.2.6) on the server. However if I ignore it I get an error message while the tables are updated.

The first message is:
Your MySQL user must have Alter, Create, Delete, Drop, Index, Insert, Select and Update rights.

Grants found:

GRANT USAGE ON *.* TO 'username'@'localhost' IDENTIFIED BY PASSWORD '7c97b920244f50e5'

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX ON `username`.* TO 'username'@'localhost'

When clicking Go I get the following:

About to update tables...
Zenphoto Error
MySQL Query ( SELECT `name`, `id` FROM `zp_administrators` WHERE `user` = 'administrators' AND `valid`=0 ) failed. Error: Unknown column 'valid' in 'where clause'

At this point the installation halts.

I contacted the hosting company to ask about the mysql user rights and they said I should have all the grants mentioned.

Any ideas how to solve this problem?

Thanks!

Bob

sbillard

Please set the `DEBUG_ERROR` definition to `true` in functions-basic.php. This will give us some more information on the error.

reef

Sorry for my late reply. I have now set DEBUG_ERROR to true and this is the additional information I get for the MySQL error:

Backtrace:
in query (functions-db.php [103])
in query_single_row (lib-auth.php [105])
in saveAdmin (setup-option-defaults.php [285])
in require (setup.php [1717])

Hope this helps.

regards,

Bob

sbillard

Setup should have created that column befor this point. I suspect that there is some kind of permissions issue with your database. Setup needs to be able to update tables. There may be further information in the setup log found in the zp-data folder.

reef

I just ran the setup again and there is no additional information in the log. However I also dropped all the tables in the database to start fresh. Now I get an additional error message after I press 'go'.

Table creation failure: ALTER command denied to user 'jiri8200'@'localhost' for table 'zp_images'

(And the message on the setup page (see above) seems to say that I have no ALTER permission)

So should I now contact the hosting company?

regards,

Bob

acrylian

Yes, please do so to be sure it is not a server configuration issue.

sbillard

It is definately a MySQL permissions issue. The user that Zenphoto uses to acces the database must be able to make changes to it.

reef

Just checking before I mail them (I'd like to have a strong case :-): I used phpMyAdmin to check the following:

SHOW GRANTS FOR 'username'@ 'localhost';

And this gives me the following result:

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX ON `username`.* TO 'username'@'localhost'

This means the Alter rights are missing, right?

Thanks for the help!

regards,

Bob

sbillard

Yes, alter is missing. The rights Zenphoto needs are:

'SELECT','CREATE','DROP','INSERT','UPDATE','ALTER','DELETE', and 'INDEX'

reef

Thanks for all the help!

The problem is now fixed. Some of the user rights were indeed incorrect.

kind regards,

Bob