[OpenSIPS-Users] mysql database connection error
Uwe Kastens
kiste at kiste.org
Tue Jun 30 19:59:08 CEST 2009
Hi Brett,
good to know
BR
Uwe
Brett Nemeroff schrieb:
> Hey.. Ok I found the error and I feel like a complete idiot. I had
> modules loaded without a db_url specified for it (one module's db_url
> was missing).
>
> I think the whole idea of a "default db_url" is a mistake... that's my
> personal opinion. Thanks for helping me find this..
> -Brett
>
>
> On Tue, Jun 30, 2009 at 12:48 PM, Uwe Kastens <kiste at kiste.org
> <mailto:kiste at kiste.org>> wrote:
>
> Hi Brett,
>
> Could be broken libs. I would start opensips with strace and look for
> errors.
>
> Which OS are you using?
>
> BR
>
> Uwe
>
> Brett Nemeroff schrieb:
> > Still can't connect :( What could I be doing wrong? I wonder if
> it's the
> > mysql client libs somehow?!
> >
> > 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 :
> >
> '%','opensips','*4DDB979A2666D0CF0A83FCCED820A64E8EBB6AFD','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 11:01 AM, Uwe Kastens <kiste at kiste.org
> <mailto:kiste at kiste.org>
> > <mailto:kiste at kiste.org <mailto:kiste at kiste.org>>> wrote:
> >
> > Hmm,
> >
> > And you did change the host in the opensips url from localhost to
> > 127.0.0.1?
> >
> > For a test change the 127.0.0.1 in the mysql to % and try
> again. And
> > mabye change the password with update user set
> > password=password("yourpassword") where user="opensips";
> >
> >
> > Your password entry looks like from a elder version.
> >
> > BR
> >
> > Uwe
> >
> >
> > Brett Nemeroff schrieb:
> > > 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
> <mailto:Yves.Carlier at rug.ac.be>
> > <mailto:Yves.Carlier at rug.ac.be <mailto:Yves.Carlier at rug.ac.be>>
> > > <mailto:Yves.Carlier at rug.ac.be
> <mailto:Yves.Carlier at rug.ac.be> <mailto:Yves.Carlier at rug.ac.be
> <mailto:Yves.Carlier at rug.ac.be>>>)
> > > Changes by Steve Harvey (sgh at vex.net <mailto:sgh at vex.net>
> <mailto:sgh at vex.net <mailto:sgh at vex.net>>
> > <mailto:sgh at vex.net <mailto:sgh at vex.net> <mailto:sgh at vex.net
> <mailto: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 <mailto:kiste at kiste.org>
> > <mailto:kiste at kiste.org <mailto:kiste at kiste.org>>
> > > <mailto:kiste at kiste.org <mailto:kiste at kiste.org>
> <mailto:kiste at kiste.org <mailto: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
> <mailto:Yves.Carlier at rug.ac.be>
> > <mailto:Yves.Carlier at rug.ac.be <mailto:Yves.Carlier at rug.ac.be>>
> > > <mailto:Yves.Carlier at rug.ac.be
> <mailto:Yves.Carlier at rug.ac.be> <mailto:Yves.Carlier at rug.ac.be
> <mailto:Yves.Carlier at rug.ac.be>>>)
> > > Changes by Steve Harvey (sgh at vex.net
> <mailto:sgh at vex.net> <mailto:sgh at vex.net <mailto:sgh at vex.net>>
> > <mailto:sgh at vex.net <mailto:sgh at vex.net> <mailto:sgh at vex.net
> <mailto: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
> <mailto:bugs at mysql.com>
> > <mailto:bugs at mysql.com <mailto:bugs at mysql.com>>
> <mailto:bugs at mysql.com <mailto:bugs at mysql.com>
> <mailto:bugs at mysql.com <mailto: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>
> <mailto:kiste at kiste.org <mailto:kiste at kiste.org>>
> > > <mailto:kiste at kiste.org <mailto:kiste at kiste.org>
> <mailto:kiste at kiste.org <mailto:kiste at kiste.org>>>
> > > > <mailto:kiste at kiste.org <mailto:kiste at kiste.org>
> <mailto:kiste at kiste.org <mailto:kiste at kiste.org>>
> > <mailto:kiste at kiste.org <mailto:kiste at kiste.org>
> <mailto: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>>
> > <mailto:kiste at kiste.org <mailto:kiste at kiste.org>
> <mailto:kiste at kiste.org <mailto:kiste at kiste.org>>>
> > > > <mailto:kiste at kiste.org <mailto:kiste at kiste.org>
> <mailto:kiste at kiste.org <mailto:kiste at kiste.org>>
> > <mailto:kiste at kiste.org <mailto:kiste at kiste.org>
> <mailto:kiste at kiste.org <mailto:kiste at kiste.org>>>>
> > > > > <mailto:kiste at kiste.org <mailto:kiste at kiste.org>
> <mailto:kiste at kiste.org <mailto:kiste at kiste.org>>
> > <mailto:kiste at kiste.org <mailto:kiste at kiste.org>
> <mailto:kiste at kiste.org <mailto:kiste at kiste.org>>>
> > > <mailto:kiste at kiste.org <mailto:kiste at kiste.org>
> <mailto:kiste at kiste.org <mailto:kiste at kiste.org>>
> > <mailto: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>>
> > > <mailto:Users at lists.opensips.org
> <mailto:Users at lists.opensips.org>
> > <mailto:Users at lists.opensips.org
> <mailto:Users at lists.opensips.org>>> <mailto:Users at lists.opensips.org
> <mailto:Users at lists.opensips.org>
> > <mailto:Users at lists.opensips.org
> <mailto:Users at lists.opensips.org>>
> > > <mailto:Users at lists.opensips.org
> <mailto:Users at lists.opensips.org>
> > <mailto:Users at lists.opensips.org
> <mailto:Users at lists.opensips.org>>>>
> > > > <mailto:Users at lists.opensips.org
> <mailto:Users at lists.opensips.org>
> > <mailto:Users at lists.opensips.org
> <mailto:Users at lists.opensips.org>>
> > > <mailto:Users at lists.opensips.org
> <mailto:Users at lists.opensips.org>
> > <mailto:Users at lists.opensips.org
> <mailto:Users at lists.opensips.org>>> <mailto:Users at lists.opensips.org
> <mailto:Users at lists.opensips.org>
> > <mailto:Users at lists.opensips.org
> <mailto:Users at lists.opensips.org>>
> > > <mailto: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
> > >
> > >
> >
> >
> > --
> >
> > kiste lat: 54.322684, lon: 10.13586
> >
> >
>
>
> --
>
> kiste lat: 54.322684, lon: 10.13586
>
>
--
kiste lat: 54.322684, lon: 10.13586
More information about the Users
mailing list