[Serusers] Mysql DB on remote host

[Klaus Darilion]

Chundao Che wrote:

> hello group,
> 
> I just started setting up Ser on a linux box (Debian). Please excuse me 
> if my questions have been asked many times before.
> I have two questions here
> 1.  when I compile from source, the mysql module is not compiled, I 
> cannot find mysql.so anywhere. I use the latest 0.8.12 release. The 
> daemon started okay without mysql modules.
you have to enable mysql in the Makefile or by typing:
make modules ........... as described in 
http://lists.iptel.org/pipermail/serusers/2004-March/006904.html

> 
> 2. after no luck with the source, I switched to Debian package. I see 
> mysql modules are properly installed. I installed the mysql client on my 
> Debian box, and the Mysql database on a external box, I created all 
> tables and users successfully and I can manually access the database 
> from command line. But when I start the Ser daemon, it would not start 
> and still trying to look the Mysql.sock on local machine. my questions 
> is where do you tell Ser daemon to use global my.cnf file for external 
> database?

you have to set the database url:
modparam("auth_db", "password_column", "password")
modparam("auth_db", "db_url", "mysql://ser:XXXXXXX@your.server.com/ser")


klaus