[OpenSIPS-Users] mysql database connection error

[Uwe Kastens]

Hi,

Hmmm.
- password to long

Have you mysqlaccess on the system?
This is how the output looks on my testsystem



 mysqlaccess  localhost opensips opensips -U root -P
mysqlaccess Version 2.06, 20 Dec 2000
By RUG-AIV, by Yves Carlier (Yves.Carlier at rug.ac.be)
Changes by Steve Harvey (sgh at vex.net)
This software comes with ABSOLUTELY NO WARRANTY.
Password for MySQL superuser root:

Access-rights
for USER 'opensips', from HOST 'localhost', to DB 'opensips'
	+-----------------+---+	+-----------------+---+
	| Select_priv     | Y |	| Lock_tables_priv | Y |
	| Insert_priv     | Y |	| Execute_priv    | Y |
	| Update_priv     | Y |	| Repl_slave_priv | N |
	| Delete_priv     | Y |	| Repl_client_priv | N |
	| Create_priv     | Y |	| Create_view_priv | Y |
	| Drop_priv       | Y |	| Show_view_priv  | Y |
	| Reload_priv     | N |	| Create_routine_priv | Y |
	| Shutdown_priv   | N |	| Alter_routine_priv | Y |
	| Process_priv    | N |	| Create_user_priv | N |
	| File_priv       | N |	| Ssl_type        | ? |
	| Grant_priv      | N |	| Ssl_cipher      | ? |
	| References_priv | Y |	| X509_issuer     | ? |
	| Index_priv      | Y |	| X509_subject    | ? |
	| Alter_priv      | Y |	| Max_questions   | 0 |
	| Show_db_priv    | N |	| Max_updates     | 0 |
	| Super_priv      | N |	| Max_connections | 0 |
	| Create_tmp_table_priv | Y |	| Max_user_connections | 0 |
	+-----------------+---+	+-----------------+---+
NOTE:	 A password is required for user `opensips' :-(

The following rules are used:
 db    :
'%','opensips','opensips','Y','Y','Y','Y','Y','Y','N','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y'
 host  : 'Not processed: host-field is not empty in db-table.'
 user  :
'%','opensips','*30C28A928E2BE5EFD59FF20CB8705B31ACCF3730','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','','','','','0','0','0','0'

BUGs can be reported by email to bugs at mysql.com


BR

Uwe


Brett Nemeroff schrieb:
> Yeah, it's in there. I'm really puzzled. This should be the easy part. ;)
> 
> Any other ideas?
> 
> 
> 
> On Tue, Jun 30, 2009 at 10:25 AM, Uwe Kastens <kiste at kiste.org
> <mailto:kiste at kiste.org>> wrote:
> 
>     Hi,
> 
>     looks good for me. Did you reload mysql after grant or flush priv?
> 
>     Should be, otherwise you wont be able to connect via mysql client.
> 
>     Your /etc/hosts have the entry for localhost?
> 
>     BR
> 
>     Uwe
> 
>     Brett Nemeroff schrieb:
>     > yeah, I tried localhost, 127.0.0.1, and the actual ip (I usually use
>     > localhost)
>     >
>     > here's my connect string:
>     > modparam("auth_db", "db_url",
>     >         "mysql://opensips:23u83fwhwkgh@localhost/opensips")
>     >
>     > Here's the mysql grant:
>     > GRANT ALL ON opensips.* TO 'opensips'@'localhost' IDENTIFIED BY
>     > '23u83fwhwkgh';
>     >
>     > On Tue, Jun 30, 2009 at 9:56 AM, Uwe Kastens <kiste at kiste.org
>     <mailto:kiste at kiste.org>
>     > <mailto:kiste at kiste.org <mailto:kiste at kiste.org>>> wrote:
>     >
>     >     Brett,
>     >
>     >     Could you post your URL from your config please?
>     >
>     >     127.0.0.1 is not the same as localhost!
>     >     BR
>     >
>     >     Uwe
>     >
>     >     > Hey all,
>     >     > sorry for such a noob question here, but I just can't figure
>     out what
>     >     > I'm doing wrong.. I'm getting the error:
>     >     > Jun 30 15:36:33 nguenj297 /usr/local/sbin/opensips[10159]:
>     >     > ERROR:db_mysql:db_mysql_new_connection: driver error(1045):
>     Access
>     >     > denied for user 'opensips'@'localhost' (using password: YES)
>     >     >
>     >     > So of course, I checked the usernames and passwords.. I tried
>     >     logging in
>     >     > manually with:
>     >     > mysql -u opensips -h localhost -p opensips
>     >     > (with the same password of course)
>     >     >
>     >     > And it works fine.. so I'm not sure where the hangup is.. Where
>     >     should I
>     >     > debug this?
>     >     >
>     >     > Thanks,
>     >     > Brett
>     >     >
>     >     >
>     >     >
>     >     >
>     >     >
>     >     >
>     >    
>     ------------------------------------------------------------------------
>     >     >
>     >     > _______________________________________________
>     >     > Users mailing list
>     >     > Users at lists.opensips.org <mailto:Users at lists.opensips.org>
>     <mailto:Users at lists.opensips.org <mailto:Users at lists.opensips.org>>
>     >     > http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>     >
>     >
>     >     --
>     >
>     >     kiste lat: 54.322684, lon: 10.13586
>     >
>     >
> 
> 
>     --
> 
>     kiste lat: 54.322684, lon: 10.13586
> 
> 


-- 

kiste lat: 54.322684, lon: 10.13586