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@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