RE: RE: [Serusers] SER/SERWeb Howto... - sr-users

7 Dec 2002

At 05:39 PM 12/6/2002, MANSOOR Usama FTRD/DMR/LON wrote:
...
    My last question/issue is about dependancies.  When I
started working with SER
 I already had MySQL install, version 3.23.36 I believe.  I could not get the MySQL
 portion integration to work, and found that permissions were not correctly granted.
 After manually correcting the permissions, I had errors about the communications
 between SER and MySQL.  I updated MySQL to the latest stable release and
 client programs, and the integration worked with no manual intervention. 
 I personaly use 3.23.52 for development, but I am sure that 3.23.36 works, we use it. 
 What kind of communication error did you get ? Could you send me some error logs ?  

I've also had similiar trouble regarding the permissions. I've installed v3.23.52
of MySQL, and run the ser_mysql.sh script, but get the following error message:

Dec  6 14:50:42 localhost /usr/sbin/ser[4766]: connect_db(): Access denied for user:
&#39;user(a)localhost.localdomain&#39; (Using password: YES) 
Dec  6 14:50:42 localhost /usr/sbin/ser[4766]: db_init(): Error while trying to connect
database 

When I check the permissions I see the following:

mysql> select * from user;
Where both 'ser' and 'serro' have no privileges at all.  [...]

I guess that's ok -- the user database just tells that these user have no 
general privileges to change any database. They are granted permissions
for accessing ser database in the 'db' table.

I have no clue where the error might live. Try manual login using
mysql with the same username and password to get closer to the
problem.

-Jiri 