Hi Raúl,
The problem is that until you are not connected to the cluster you can't
issue any query. This is why you get the "command out of sync" error
message. You are connected to the cluster only if you specify the
username, password, hosts and database name for mysql_real_connect(). If
you not specify the database than libMySequoia will do a "lazy" connect.
This means that will return OK when you specify only the username,
password and host BUT will not do a real connection to the cluster until
you not specify the database name.
Let see your user scenarios:
1. for PHP if you modify the mysqli_query($this->Link_ID, "USE
$Database") to mysql_select_db($this->Link_ID, "$Database") the
application will work.
2. for mysql command line client you can use the following trick:
in the /etc/mysequoia/mysequoia.conf specify this line:
database=VirtualDatabase
Regards,
Csaba
_______________________________________________
Carob mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/carob
