[Serusers] Mysql DB on remote host

[Chundao Che]

Klaus,

thanks for your response. To question #1, after 'make modules' there is 
no mysql.so file generated. Question #2, the db_url does not seem to do 
anything differently.

Chundao

Klaus Darilion wrote:

>
>
> 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
>
> _______________________________________________
> Serusers mailing list
> serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers