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?

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

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

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

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

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

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

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

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.

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

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

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

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

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

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

Thanks for all the help!

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

kind regards,

Bob