[OpenSIPS-Users] mysql database connection error

Brett Nemeroff brett at nemeroff.com
Tue Jun 30 18:30:47 CEST 2009


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> 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>)
> > Changes by Steve Harvey (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>> 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>)
> >     Changes by Steve Harvey (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>
> >
> >
> >     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>>> 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>>>> 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>>>
> >     >     >     >
> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20090630/06bdfccc/attachment-0001.htm 


More information about the Users mailing list