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(a)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
MANSOOR Usama FTRD/DMR/LON