On 09/04/15 19:57, Lorne Tyndale wrote:
Check your bind-address in my.cnf (on the computer running your mysql
server) and make sure it will allow MySQL to accept connections from any
computer on your network. Normally it defaults to 127.0.0.1
I hadn't changed it, but I now have
[root@rdserver ~]# grep bind-address /etc/my.cnf
bind-address=0.0.0.0
Also, check your /etc/rd.conf and look for the hostname line under the
[mysql] configuration. Make sure your hostname is pointing to the IP
address where your MySQL server is running.
I think that's OK too:
[root@rdclienta ~]# grep -i Hostname /etc/rd.conf
Hostname=rdserver
[root@rdclienta ~]# ping rdserver
PING rdserver (172.24.0.221) 56(84) bytes of data.
64 bytes from rdserver (172.24.0.221): icmp_seq=1 ttl=64 time=0.409 ms
Having changed/checked all that I rebooted both the client and the
server, but the SQL error was still there. Moreover, mysql access from
rdclienta to rdserver is OK, which presumably has some significance:
[rd@rdclienta ~]$ mysql -h rdserver -u rduser -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 12
... etc
But your suggestions have had some effect: "rdlibrary" now works
correctly on the server, but still not on the client.
By the way, "rdadmin" comes up on the client, but with the message (on
the terminal) "QSqlQuery::value: not positioned on a valid record".
This message is issued five times by rdlibrary (on the client) before
the SQL error.
--
Henry Law Manchester, England
_______________________________________________
Rivendell-dev mailing list
[email protected]
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
