[OpenSIPS-Users] mysql database connection error
Brett Nemeroff
brett at nemeroff.com
Tue Jun 30 17:46:41 CEST 2009
Here is what I got:password too long? really? it's not that long.. <shrug>
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 :
'127.0.0.1','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 :
'127.0.0.1','opensips','641b9f69397f5d64','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'
On Tue, Jun 30, 2009 at 10:41 AM, Uwe Kastens <kiste at kiste.org> wrote:
> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20090630/7d4d6b8d/attachment-0001.htm
More information about the Users
mailing list