Topic: ODBC and 6.0b2

[Mahmood Al-Yousif]

I don't know if this is a but, hence the question first before submitting it if it is indeed a bug

Since installing 6.0b2 no one on the internal network can connect to MySQL via ODBC.

I have installed the dev package, compiled and installed unixODBC 2.2.6
Installed MyODBC 3.51.06-1 (rpm)

Scanned the ports of the server, 3306 is not mentioned in the list.

Question is: should that port be open?
Question: how do I open it (yes I did search)
Question: is there a known incompatibility with the versions of ODBC drivers I have used and SME/RedHat 7.3?

Suggestions?

Thank you
mahmood

[Michael Doerner]

Mahmood,

did you install the 2 newer glibc... rpms as this was required for 5.6 already? If not, just search here in the forums.

Also Mitel had announced that TCP access to MySQL will not be enabled by default for future versions and I believe this is with 6.0b2 already so you will have to enable this in the configuration database:

(Charlie Brady on devinfo mailing list):
 
/sbin/e-smith/config setprop mysqld LocalNetworkingOnly no
/sbin/e-smith/expand-template /root/.my.cnf
/etc/rc.d/rc7.d/S90mysqld restart

I actually believe that you also need to expand the template /etc/my.cnf otherwise the MySQL daemon is started with an option 'skip-network' and won't accept TCP connections.

Regards,
Michael

[Mahmood Al-Yousif]

You're absolutely right! Thank you very much for the explanations.

However, although I followed the steps and expanded the /etc/my.cnf, the "skip-networking" still appears in the file. I have disabled it manually for now just to get going.

Many thanks again Michael.

[Mahmood Al-Yousif]

strange, just did that again and now it works!

[Doyle Glaze]

This string of commands will not fix it in verision b3. Needed to remove by hand....


Doyle

[Doyle Glaze]

/sbin/e-smith/config setprop mysqld LocalNetworkingOnly no
/sbin/e-smith/expand-template /root/.my.cnf
/etc/rc.d/rc7.d/S90mysqld restart

There is a typo in the commands it should be:

/sbin/e-smith/config setprop mysqld LocalNetworkingOnly no
/sbin/e-smith/expand-template /etc/my.cnf
/etc/rc.d/rc7.d/S90mysqld restart


Thanks

[Charlie Brady]

Doyle Glaze wrote:
 
> This string of commands will not fix it in verision b3.

If so, that's a bug. Be sure to report it.

Charlie