Koozali.org: home of the SME Server
Legacy Forums => General Discussion (Legacy) => Topic started by: grahowler on November 01, 2003, 01:18:45 AM
-
Hi
I have a problem connecting to my SME server via ODBC. I have an SME server acting as a gateway and server for a small network. The SME machine is set to 192.168.0.1 and I am trying to connect to MySQL via a windows machine, 192.168.0.2.
When I try and connect via ODBC I get an Error:
[MySQL][ODBC Driver 3.51] Lost connection to MySQL Server during query.
I have created two users as per the MySQL documentation using:
1. "GRANT ALL PRIVILEGES ON *.* TO myUser@localhost IDENTIFIED BY 'myUserPass'"
2. "GRANT ALL PRIVILEGES ON *.* TO myUser@"%" IDENTIFIED BY 'myUserPass'"
The MySQL documentation states:
"A full superuser who can connect to the server from anywhere... Note that we must issue GRANT statements for both monty@localhost and monty@"%"."
I know I should check to see if port 3306 is open but I am unsure how to do this. I am at a dead end now in that I don't know what to try next. Any ideas?
Thx in advance.
-
You don't say which version sme you are using.
On v5.6 some extra rpms are needed (glibc.....)
On 6.0b3 there is a command line mod to do
Search these forums on mysql and I'm sure you'll find the references I'm referring to
Regs
Ray
-
is there a link to the command line fix somewhere? My MySQL is working properly in PHP and from a terminal screen, but not via ODBC
( 6b3 SME )
Suggetions welcome
Mike
-
Mike
Search these forums on mysql and you'll find the references, go back a few months though.
Ray
[%sig%]
-
On version 6b3 you need to do the following:
/sbin/e-smith/config setprop mysqld LocalNetworkingOnly no