[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