Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: Mahmood Al-Yousif on July 27, 2003, 12:27:02 PM

Title: ODBC and 6.0b2
Post by: Mahmood Al-Yousif on July 27, 2003, 12:27:02 PM

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

Title: Re: ODBC and 6.0b2
Post by: Michael Doerner on July 27, 2003, 02:16:29 PM

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

Title: Re: ODBC and 6.0b2
Post by: Mahmood Al-Yousif on July 27, 2003, 06:02:27 PM

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.

Title: Re: ODBC and 6.0b2
Post by: Mahmood Al-Yousif on July 27, 2003, 06:05:21 PM

strange, just did that again and now it works!

Title: Re: ODBC and 6.0b3?
Post by: Doyle Glaze on August 19, 2003, 09:28:29 PM

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


Doyle

Title: Re: ODBC and 6.0b2
Post by: Doyle Glaze on August 19, 2003, 09:39:26 PM

/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

Title: Re: ODBC and 6.0b3?
Post by: Charlie Brady on August 19, 2003, 10:45:54 PM

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