RT Windows Version Help

Hello,

I am currently running the Windows Version of RT (found here:
http://wiki.bestpractical.com/index.cgi?WindowsOSInstallGuide).

I have everything installed and up and running. I would like to look at and
administer the MySQL Database using the MySQL Control Center and MySQL
Administrator (found at http://www.mysql.com/products/). The only thing I
need is the port to tell the application to find the Database Server on my
server. The default port of 3306 does not work; I have also tried 8285 with
no success.

Any help or insight would be appreciated.

Thank you,

Dennis Christilaw

I can’t tell you the default MySQL port used in the Windows RT bundle,
but I can help you try to figure it out.

If you know you have MySQL running, you can try to use the command
netstat -a to view open (LISTENING) ports and try to deduce which port
is being used by which app.

You can also use a tool called fport which tries to match applications
to the open ports on your machine.

http://www.foundstone.com/index.htm?subnav=resources/navigation.htm&subc
ontent=/resources/proddesc/fport.htm

Hope that helps,

Ryan Roland

Application Developer
Information Technology
Division of Recreational Sports
Indiana University

812.855.9617
rmroland@indiana.edu-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Dennis
Christilaw
Sent: Friday, June 11, 2004 09:49
To: rt-users@lists.bestpractical.com
Subject: [rt-users] RT Windows Version Help

Hello,

I am currently running the Windows Version of RT (found here:
http://wiki.bestpractical.com/index.cgi?WindowsOSInstallGuide).

I have everything installed and up and running. I would like to look at
and administer the MySQL Database using the MySQL Control Center and
MySQL Administrator (found at http://www.mysql.com/products/). The only
thing I need is the port to tell the application to find the Database
Server on my server. The default port of 3306 does not work; I have also
tried 8285 with no success.

Any help or insight would be appreciated.

Thank you,

Dennis Christilaw

Ryan,

Thank you for your prompt reply and the information that you provided.

I ran the FPORT tool you pointed me to and got the following out of it:

1568 mysqld-nt -> 8285 TCP C:\Program
Files\OurInternet\Common\mysql\bin\mysqld-nt.exe

Ok, so based on the information above, we can see that it is listening port
8285.

When I try to connect to the SQL Server via port 8285, it tells me that it
can not find a MySQL Server on that port.

Is there any other way that I can access the DB directly. I would like to
populate the data base with information for existing customers and so forth
and would like to save time by NOT having to manually input the data… :o)

Thanks again

Dennis Christilaw-----Original Message-----
From: Roland, Ryan M [mailto:rmroland@indiana.edu]
Sent: Friday, June 11, 2004 10:10 AM
To: Dennis Christilaw; rt-users@lists.bestpractical.com
Subject: RE: [rt-users] RT Windows Version Help

I can’t tell you the default MySQL port used in the Windows RT bundle,
but I can help you try to figure it out.

If you know you have MySQL running, you can try to use the command
netstat -a to view open (LISTENING) ports and try to deduce which port
is being used by which app.

You can also use a tool called fport which tries to match applications
to the open ports on your machine.

http://www.foundstone.com/index.htm?subnav=resources/navigation.htm&subc
ontent=/resources/proddesc/fport.htm

Hope that helps,

Ryan Roland

Application Developer
Information Technology
Division of Recreational Sports
Indiana University

812.855.9617
rmroland@indiana.edu

-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Dennis
Christilaw
Sent: Friday, June 11, 2004 09:49
To: rt-users@lists.bestpractical.com
Subject: [rt-users] RT Windows Version Help

Hello,

I am currently running the Windows Version of RT (found here:
http://wiki.bestpractical.com/index.cgi?WindowsOSInstallGuide).

I have everything installed and up and running. I would like to look at
and administer the MySQL Database using the MySQL Control Center and
MySQL Administrator (found at http://www.mysql.com/products/). The only
thing I need is the port to tell the application to find the Database
Server on my server. The default port of 3306 does not work; I have also
tried 8285 with no success.

Any help or insight would be appreciated.

Thank you,

Dennis Christilaw

Well, I suppose there could be a permission setup on the windows bundle
which keeps you from connecting, but I would suspect a different message
than server not found.

You can always try the CLI mysql tool:

C:\Program Files\OurInternet\Common\mysql\bin\mysql.exe (I’m guessing
here)

You’ll have to pass the port number to it and the special user/pass for
RT.

Here is a connection guide to the CLI mysql:

http://dev.mysql.com/doc/mysql/en/Connecting-disconnecting.html

Keep in mind, I haven’t used this bundle, I’m just sharing what I know
about mysql in general. If none of the above works for you, there may
be a specific setup that was done to the mysql used in the RT Windows
bundle which limits connection methods. If that is the case, then
someone more familiar with that needs to help you from here.

Thanks,

Ryan Roland

Application Developer
Information Technology
Division of Recreational Sports
Indiana University

812.855.9617
rmroland@indiana.edu-----Original Message-----
From: Dennis Christilaw [mailto:dchristilaw@onduty.com]
Sent: Friday, June 11, 2004 10:33
To: Roland, Ryan M; rt-users@lists.bestpractical.com
Subject: RE: [rt-users] RT Windows Version Help

Ryan,

Thank you for your prompt reply and the information that you provided.

I ran the FPORT tool you pointed me to and got the following out of it:

1568 mysqld-nt -> 8285 TCP C:\Program
Files\OurInternet\Common\mysql\bin\mysqld-nt.exe

Ok, so based on the information above, we can see that it is listening
port
8285.

When I try to connect to the SQL Server via port 8285, it tells me that
it
can not find a MySQL Server on that port.

Is there any other way that I can access the DB directly. I would like
to
populate the data base with information for existing customers and so
forth
and would like to save time by NOT having to manually input the data…
:o)

Thanks again

Dennis Christilaw

-----Original Message-----
From: Roland, Ryan M [mailto:rmroland@indiana.edu]
Sent: Friday, June 11, 2004 10:10 AM
To: Dennis Christilaw; rt-users@lists.bestpractical.com
Subject: RE: [rt-users] RT Windows Version Help

I can’t tell you the default MySQL port used in the Windows RT bundle,
but I can help you try to figure it out.

If you know you have MySQL running, you can try to use the command
netstat -a to view open (LISTENING) ports and try to deduce which port
is being used by which app.

You can also use a tool called fport which tries to match applications
to the open ports on your machine.

http://www.foundstone.com/index.htm?subnav=resources/navigation.htm&subc
ontent=/resources/proddesc/fport.htm

Hope that helps,

Ryan Roland

Application Developer
Information Technology
Division of Recreational Sports
Indiana University

812.855.9617
rmroland@indiana.edu

-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Dennis
Christilaw
Sent: Friday, June 11, 2004 09:49
To: rt-users@lists.bestpractical.com
Subject: [rt-users] RT Windows Version Help

Hello,

I am currently running the Windows Version of RT (found here:
http://wiki.bestpractical.com/index.cgi?WindowsOSInstallGuide).

I have everything installed and up and running. I would like to look at
and administer the MySQL Database using the MySQL Control Center and
MySQL Administrator (found at http://www.mysql.com/products/). The only
thing I need is the port to tell the application to find the Database
Server on my server. The default port of 3306 does not work; I have also
tried 8285 with no success.

Any help or insight would be appreciated.

Thank you,

Dennis Christilaw

Ryan,

Thanks again for all your help!

I will try those suggestions out and see what happens. If I find anything
new, I will be sure to share.

Thanks Again!

Dennis Christilaw-----Original Message-----
From: Roland, Ryan M [mailto:rmroland@indiana.edu]
Sent: Friday, June 11, 2004 10:44 AM
To: Dennis Christilaw; rt-users@lists.bestpractical.com
Subject: RE: [rt-users] RT Windows Version Help

Well, I suppose there could be a permission setup on the windows bundle
which keeps you from connecting, but I would suspect a different message
than server not found.

You can always try the CLI mysql tool:

C:\Program Files\OurInternet\Common\mysql\bin\mysql.exe (I’m guessing
here)

You’ll have to pass the port number to it and the special user/pass for
RT.

Here is a connection guide to the CLI mysql:

http://dev.mysql.com/doc/mysql/en/Connecting-disconnecting.html

Keep in mind, I haven’t used this bundle, I’m just sharing what I know
about mysql in general. If none of the above works for you, there may
be a specific setup that was done to the mysql used in the RT Windows
bundle which limits connection methods. If that is the case, then
someone more familiar with that needs to help you from here.

Thanks,

Ryan Roland

Application Developer
Information Technology
Division of Recreational Sports
Indiana University

812.855.9617
rmroland@indiana.edu

-----Original Message-----
From: Dennis Christilaw [mailto:dchristilaw@onduty.com]
Sent: Friday, June 11, 2004 10:33
To: Roland, Ryan M; rt-users@lists.bestpractical.com
Subject: RE: [rt-users] RT Windows Version Help

Ryan,

Thank you for your prompt reply and the information that you provided.

I ran the FPORT tool you pointed me to and got the following out of it:

1568 mysqld-nt -> 8285 TCP C:\Program
Files\OurInternet\Common\mysql\bin\mysqld-nt.exe

Ok, so based on the information above, we can see that it is listening
port
8285.

When I try to connect to the SQL Server via port 8285, it tells me that
it
can not find a MySQL Server on that port.

Is there any other way that I can access the DB directly. I would like
to
populate the data base with information for existing customers and so
forth
and would like to save time by NOT having to manually input the data…
:o)

Thanks again

Dennis Christilaw

-----Original Message-----
From: Roland, Ryan M [mailto:rmroland@indiana.edu]
Sent: Friday, June 11, 2004 10:10 AM
To: Dennis Christilaw; rt-users@lists.bestpractical.com
Subject: RE: [rt-users] RT Windows Version Help

I can’t tell you the default MySQL port used in the Windows RT bundle,
but I can help you try to figure it out.

If you know you have MySQL running, you can try to use the command
netstat -a to view open (LISTENING) ports and try to deduce which port
is being used by which app.

You can also use a tool called fport which tries to match applications
to the open ports on your machine.

http://www.foundstone.com/index.htm?subnav=resources/navigation.htm&subc
ontent=/resources/proddesc/fport.htm

Hope that helps,

Ryan Roland

Application Developer
Information Technology
Division of Recreational Sports
Indiana University

812.855.9617
rmroland@indiana.edu

-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Dennis
Christilaw
Sent: Friday, June 11, 2004 09:49
To: rt-users@lists.bestpractical.com
Subject: [rt-users] RT Windows Version Help

Hello,

I am currently running the Windows Version of RT (found here:
http://wiki.bestpractical.com/index.cgi?WindowsOSInstallGuide).

I have everything installed and up and running. I would like to look at
and administer the MySQL Database using the MySQL Control Center and
MySQL Administrator (found at http://www.mysql.com/products/). The only
thing I need is the port to tell the application to find the Database
Server on my server. The default port of 3306 does not work; I have also
tried 8285 with no success.

Any help or insight would be appreciated.

Thank you,

Dennis Christilaw