[SOLVED] mysql connect

[guletz2002]

Hello,

I am a new roundube user. I make a setup with a mysql cluster(4 nodes active/active, all in rw mode). But because I can not figure how to modify the db_dsnw, for a tcp connection to the mysql, not a socket one(I try some tcp from pear_db documentation, but is not working), I have some cluster issues!!! So, my qustions are:

1. Can I use a tcp connection insted of a socket one?
- if the answer at 1. is yes, then:

2. Could anybody post a simple example, for me(user="triangle_cube", passwd="hexagon", mysql_IP="192.168.222.100", db_name="superb_web_mail")?


PS: I use the last stable version on roundcube.

Thx. in advance,

 Iulian

[JohnDoh]

1. Can I use a tcp connection insted of a socket one?

yes

2. Could anybody post a simple example, for me(user="triangle_cube", passwd="hexagon", mysql_IP="192.168.222.100", db_name="superb_web_mail")?

mysql://triangle_cube:hexagon@192.168.222.100/superb_web_mail

[guletz2002]

1. Can I use a tcp connection insted of a socket one?

yes

2. Could anybody post a simple example, for me(user="triangle_cube", passwd="hexagon", mysql_IP="192.168.222.100", db_name="superb_web_mail")?

mysql://triangle_cube:hexagon@192.168.222.100/superb_web_mail

Are you sure? Not working, and the syntax is:

phptype(syntax)://user:pass@protocol(proto_opts)/database

... so I try even this:


mysql://triangle_cube:hexagon@tcp(192.168.222.100)/superb_web_mail, an the same response : ...... SOCKET (... could not connect on socket /var/lib/....)

[JohnDoh]

yes i'm sure. what is said is the same as the example provided in the rc config file

are you sure you are putting it in the correct place? assuming you are using rouncube 1.x then it needs to be set in `$config['db_dsnw']` in config.inc.php

have you tried using the same details to connect to mysql using another client or the command line, just to confirm that the mysql is ok?

[guletz2002]

   Yessssssssssssssss!!!!! Thx. you very much! My mistake.....! No my roundcube cluster(4 active nodes - load-balancing and fail-over) is fully operational.

Off-topic: the cluster method who is describe in the roundcube wiki it is the worst case posbible and is not scale-able(I reffer only when it is use mysql). If someone want details, plese disturb me

Thx. again!!!