[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