[Serusers] remote mysql server

[Richard]

should the protocol be mysql, not sql?

> -----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