[Serusers] Ser & mysql problem

[Charles Wang]

Make sure your DB allows your "ser" account to access via 192.168.1.20
to 192.168.1.70. And you should check your my.cnf under /etc. If find
skip-networking, comment it. Then restart your DB.

Or login in your DB with "root", then grant some privileges for ser user.
For example,
mysql > grant all privileges on ser.* to ser at 192.168.1.20 identified by 'heslo';
mysql > flush privileges;

Best Regards
Charles



On Tue, 15 Mar 2005 10:12:54 +0100 (CET), bouchra benyelloul
<bouchra_benyelloul at yahoo.fr> wrote:
> Hi all,
> 
> I've Problem with ser and mysql databases:
> 
> In first time, I can connect to ser mysql database
> without any problem, but when i try to do it twice, I'
> have this errors :
> 
> Listening on
>             udp: 127.0.0.1 [127.0.0.1]:5060
>             udp: 192.168.1.20 [192.168.1.20]:5060
>             tcp: 127.0.0.1 [127.0.0.1]:5060
>             tcp: 192.168.1.20 [192.168.1.20]:5060
> Aliases:
>             tcp: linux:5060
>             tcp: linux.local:5060
>             tcp: localhost:5060
>             udp: linux:5060
>             udp: linux.local:5060
>             udp: localhost:5060
> 
> stateless - initializing
> 
> 0(0) Maxfwd module- initializing
> textops - initializing
> acc - initializing
> 0(4479) new_connection(): Can't connect to MySQL
> server on '192.168.1.70' (111) 0(4479) db_init():
> Could not create a connection
> 0(4479) ERROR: child_init(0): Error while connecting
> database
> 0(4479) init_mod_child(): Error while initializing
> module usrloc
> 0(4479) main: error in init_child
> 
> Thanks for advance.
> Bouchra.
> 
> Découvrez nos promotions exclusives "destination de la Tunisie, du Maroc, des Baléares et la Rép. Dominicaine sur Yahoo! Voyages :
> http://fr.travel.yahoo.com/promotions/mar14.html
> 
> _______________________________________________
> Serusers mailing list
> serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers
>