[Serusers] SER/SERWeb Howto...

MANSOOR Usama FTRD/DMR/LON usama.mansoor at rd.francetelecom.com
Fri Dec 6 17:39:35 CET 2002


>> 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: 'user at localhost.localdomain' (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;
+-----------------------+-------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
| Host                  | User  | Password         | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv |
+-----------------------+-------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
| localhost             | root  |                  | Y           | Y           | Y           | Y           | Y           | Y         | Y           | Y             | Y            | Y         | Y          | Y               | Y          | Y          |
| localhost.localdomain | root  |                  | Y           | Y           | Y           | Y           | Y           | Y         | Y           | Y             | Y            | Y         | Y          | Y               | Y          | Y          |
| localhost             |       |                  | N           | N           | N           | N           | N           | N         | N           | N             | N            | N         | N          | N               | N          | N          |
| localhost.localdomain |       |                  | N           | N           | N           | N           | N           | N         | N           | N             | N            | N         | N          | N               | N          | N          |
| %                     | ser   | 4e633cf914a735a0 | N           | N           | N           | N           | N           | N         | N           | N             | N            | N         | N          | N               | N          | N          |
| localhost             | ser   | 4e633cf914a735a0 | N           | N           | N           | N           | N           | N         | N           | N             | N            | N         | N          | N               | N          | N          |
| %                     | serro | 7cb73a267cb7bd5f | N           | N           | N           | N           | N           | N         | N           | N             | N            | N         | N          | N               | N          | N          |
| localhost             | serro | 7cb73a267cb7bd5f | N           | N           | N           | N           | N           | N         | N           | N             | N            | N         | N          | N               | N          | N          |
+-----------------------+-------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+

Where both 'ser' and 'serro' have no privileges at all. 

This is my first time using MySQL, so I'm not entirely sure how to resolve this. Do I use the 'grant' command, or is did you try something different?

- Usama



More information about the sr-users mailing list