[Serusers] remote mysql server

Barry Murphy barry at unix.co.nz
Wed Mar 9 19:57:13 CET 2005


----- Original Message -----
From: "Richard" <richard at o-matrix.org>
>
> should the protocol be mysql, not sql?


Sorry I forgot to mention, I have tried both, I thought I had put that in,
but obviously not :)



> > -----Original Message-----
> > From: serusers-bounces at iptel.org [mailto:serusers-bounces at lists.iptel.org] On
> > Behalf Of Barry Murphy
> > Sent: Wednesday, March 09, 2005 8:39 AM
> > To: Klaus Darilion
> > Cc: serusers at lists.iptel.org
> > Subject: Re: [Serusers] remote mysql server
> >
> > Ok, so I've tried just about everything, is SER just built to work with
a
> > local mysql server and not a remote one?
> >
> > ser.cfg:
> > modparam("usrloc", "db_mode", 2)
> >
> > ## tried 1 ##
> > modparam("usrloc", "db_url","sql://ser:pwd@db.fast.co.nz/ser")
> > ## /tried 1 ##
> >
> > ## tried 2 ##
> > modparam("usrloc|acc|auth_db|group|msilo", "db_url",
> > "sql://ser:pwd@db.fast.co.nz/ser")
> > ## /tried 2 ##
> >
> >
> > I get this error (seen from debug level):
> > Maxfwd module- initializing
> >  0(80209) DEBUG: init_mod: usrloc
> >  0(80209) usrloc - initializing
> >  0(80209) DEBUG: register_fifo_cmd: new command (ul_stats) registered
> >  0(80209) DEBUG: register_fifo_cmd: new command (ul_rm) registered
> >  0(80209) DEBUG: register_fifo_cmd: new command (ul_rm_contact)
registered
> >  0(80209) DEBUG: register_fifo_cmd: new command (ul_dump) registered
> >  0(80209) DEBUG: register_fifo_cmd: new command (ul_flush) registered
> >  0(80209) DEBUG: register_fifo_cmd: new command (ul_add) registered
> >  0(80209) DEBUG: register_fifo_cmd: new command (ul_show_contact)
> > registered
> >  0(80209) find_export: <db_use_table> not found
> >  0(80209) mod_init(): Can't bind database module
> >  0(80209) init_mod(): Error while initializing module usrloc
> >
> > Thanks
> > Barry
> >
> >
> > ----- Original Message -----
> > From: "Klaus Darilion" <klaus.mailinglists at pernau.at>
> > To: "Barry Murphy" <barry at unix.co.nz>
> > Cc: <serusers at lists.iptel.org>
> > Sent: Wednesday, March 09, 2005 8:15 PM
> > Subject: Re: [Serusers] remote mysql server
> >
> >
> > > wrong syntax!
> > >
> > > modparam("domain","db_url","mysql://ser:heslo@localhost/ser")
> > >
> > > // is missing
> > >
> > > regards,
> > > klaus
> > >
> > >
> > > Barry Murphy wrote:
> > >
> > > > I'm trying to get SER to talk to a remtoe DB, I notice other people
in
> > #SER
> > > > on FreeNode also have this issue, but no one has a fix.
> > > >
> > > > I'm using the following in the config:
> > > > modparam("usrloc|acc|auth_db|group|msilo", "db_url",
> > > > "mysql::asterisk:passwd at dbserver/ser")
> > > >
> > > > Ser seems to be looking at /tmp/mysql.sock instead of the remote
mysql
> > > > server.
> > > >
> > > > Has anyone got this working?
> > > >
> > > > Thanks
> > > > Barry
> > > >
> > > > _______________________________________________
> > > > Serusers mailing list
> > > > serusers at lists.iptel.org
> > > > http://lists.iptel.org/mailman/listinfo/serusers
> > > >
> > > >
> > >
> >
> > _______________________________________________
> > Serusers mailing list
> > serusers at lists.iptel.org
> > http://lists.iptel.org/mailman/listinfo/serusers
>
>




More information about the sr-users mailing list