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
Quote1. Can I use a tcp connection insted of a socket one?
yes
Quote2. 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:
[email protected]/superb_web_mail
Quote from: JohnDoh on June 04, 2014, 07:12:47 AM
Quote1. Can I use a tcp connection insted of a socket one?
yes
Quote2. 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:[email protected]/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/....)
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?
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!!!