table jchemproperties not found with apache user

Dear Chemaxon,





INFO : APACHE - MYSQL 4 - FEDORA - Core 2 Duo - Last version of jchem. (5.1.2).





I have the same problem than this post :


http://www.chemaxon.com/forum/viewpost9932.html&highlight=fingerprint#9932





When i create jchemproperties table with jcman and i execute jcsearch with apache user (with line command) i have a error message "table jchemproperties not found or fingerprint...." (see post http://www.chemaxon.com/forum/viewpost9932.html&highlight=fingerprint#9932)





But when i execute jcsearch with root user in line command it works.


I'm connected to Mysql with a user which have all privileges.





The table jchemproperties seems not visible by user apache ... ?











Karim.

Hi,





Please be aware that in MySQL the table names are case sensitive.


This also applies to the property table. (e.g. "JChemPropeties" / "jchemproperties")





Maybe your two users are connected to different property tables and the structure table is only registered in one of them.


You can check the .jchem file under <user_home>/.chemaxon for the difference in connection parameters.





Szilard

Thanks for response,





I have checked : in .jchem file i have "jchemproperties" and in mysql "jchemproperties". So, there is no difference.

I found solution ! User apache have not .jchem file but user root have a .jchem file.





I have executed jcman -u .... with the user apache and now it's ok !





Thanks,





This post is closed.