[Serusers] SER/SERWeb Howto...

Dan Austin Dan_Austin at Phoenix.com
Fri Dec 6 18:40:45 CET 2002


Are you running the script as root?  Before upgrading MySQL I did use the grant command,
and managed to get the correct permissions installed.  I ran into other problems with the
client libraries, so I did a complete upgrade.

After upgrading the ser_mysql.sh script did everyting it should have and I did not need to
make any changes.

I'm also fairly new to MySQL, but from your error message, it looks like you are running
the script from an account that does not have permissions inside the database.

As root if you run mysql, does it prompt for a password?  From your select statement, I
would not expect it to.  If it allows you to logon to the database, you can try to assign the
default permissions manually.


Dan
-----Original Message-----
From: MANSOOR Usama FTRD/DMR/LON [mailto:usama.mansoor at rd.francetelecom.com] 
Sent: Friday, December 06, 2002 8:40 AM
To: Jan Janak; serusers at lists.iptel.org
Subject: RE: RE: [Serusers] SER/SERWeb Howto...


>> 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
_______________________________________________
Serusers mailing list
serusers at lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers



More information about the sr-users mailing list