MySQL question

RT-Users:

I am trying to connect to the MySQL database on my RT system using the MyODBC
package on a Windows server; however my connection invariably fails.

Does anyone know if MySQL, as downloaded as a RPM package, has the
LocalNetworkingOnly option set to no or yes?

Ennis McCaffrey

Time Warner Cable
Digital Network Engineer

1001 West Kennedy Avenue
PO Box 145
Kimberly, WI 54136

(920) 831-9220 Office
(920) 378-0416 Cell

Ennis@Mail.TWCGB.NET

Ennis William McCaffrey wrote:

RT-Users:

I am trying to connect to the MySQL database on my RT system using the MyODBC
package on a Windows server; however my connection invariably fails.

Does anyone know if MySQL, as downloaded as a RPM package, has the
LocalNetworkingOnly option set to no or yes?

I don’t believe it is set by default. Make sure that rt_user has rights
to access the db from the host RT is running on.

DB

I’m sorry, I meant to say the following; please padron me:

  1. I have rt 3.4.1 set up on a Fedora Core 3 machine, and RT is running fine.

  2. I have installed the MyODBC connector on this machine.

  3. I have installed the MyODBC connector on a Windows 2000 server.
    It is from this machine that I want to access RT.

  4. On the Windows machine, I have the ODBC set up as follows:

    Data Source Name: RT3
    Description: MySQL ODBC 3.51 Driver DSN
    Server: 172.16.0.16 (the ip address of my rt server)
    User: rt_user
    Password: ***** (my rt-user password on MySQL)
    Database: rt3

    When I try to conenct I get the following error:

    [MySQL][ODBC 3.51 Driver]Can’t connect to MySQL server on
    ‘172.16.0.16’(10065)

  5. rt_user can access RT from the host RT is running on.

Does anybody have a clue as to how to set up MyODBC?

Thanks in advance,

Ennis McCaffrey

Time Warner Cable
Digital Network Engineer

1001 West Kennedy Avenue
PO Box 145
Kimberly, WI 54136

(920) 831-9220 Office
(920) 378-0416 Cell

Ennis@Mail.TWCGB.NET

Uhmm, actually I should be posting this to a MySQl mailing list.

Pardon me again.

Ennis McCaffrey

Time Warner Cable
Digital Network Engineer

1001 West Kennedy Avenue
PO Box 145
Kimberly, WI 54136

(920) 831-9220 Office
(920) 378-0416 Cell

Ennis@Mail.TWCGB.NET