no connect over network

[kaloschke]

Hi,
Hi,
I have installed mysql 4.1.7. I use D7 with update 1
and mydac 3.30.1.13. Locally my app works fine, but not using the net.

Configuration: 1 W2003 domainserver FS, 1 W2003 ISA 2004 server KS,
1 workstation W2000 WS

I have MySQL installed on server KS, firewallrule for port 3306 is installed
too.When I try connect from another workstation or server, it appears error:
Can't connect to MySQL server on KS (or IP)

I don't beleave that the ISA 2004 firewall is the reason, because the problem exists on a normal workstation installation too.
The mysqluser is root with full rights on all host in the subnet (by the way,
its a testnet using vmware). I can connect to mysql using the browser and
phpmyadmin.

Thank you for your suggestions,

Kaloschke

[Ikar]

Please specify how you set a name of the server; by network name or as IP address. Do you set a name in phpmyadmin at the same way? Does something change if use MyConnection.Options.Direct := False?

[Guest]

Hi,
I have used a network name and an IP address. Nothing works.
Using the browser I can use network name or IP address, it works
both.
Changing the direct option to false has no success. I have tried also
different protocols in TMyConnection. Nothing helps.

Thank you for your answer

Detlef

[kaloschke]

Hi,

I'm sorry. I send the above post under guest and name detlef without
logging in.

In the meantime I tried the following:
I have installed the old mysqlversion 4-0.15 on another machine
and in Delphi I uninstalled MyDAC 3.30.1.13 and reinstalled
2.00.3.5 and everything works fine!

So I think the reason is 3.30.1.13
Hope, you can help.

Regards Kaloschke

[Ikar]

Working in Direct := False mode in MyDAC changed slightly between 2.00.3.5 and 3.30.1.13. Try to install 3.30.1.13 again and in Direct := False mode use MySQL client libmysql.dll from MySQL 4.0.15.

[kaloschke]

Hi,
I tried that, but it doesn't work, soory.
Any other suggestions?

Kaloschke

[Ikar]

We sent you by email compiled test application. Please make the following tests.

1) at workstation:
1.1) Connect with remote server 4.1.7
1.2) Connect with local server 4.0.15

2) at the server:
> 2.1) Connect with remote server 4.0.15
> 2.2) Connect with local server 4.1.7

All tests should be done for both Direct modes.

Please send us all results of your testing.

[kaloschke]

Hi,
Im soory, but I didn't get any email from you.

Kaloschke

[Ikar]

Resended to kaloschke*yah oo*de

[kaloschke]

Hi,
I'm sorry again. Under kaloschke*yahoo*de I got only your info
about my forum account, nothing else. Sonething goes wrong.
Perhaps you could sent it to dfricke*t-online*de as a last try.

Thank you very much

Kaloschke

[Ikar]

Have you received our email?

[Guest]

Hi,
No. Ok, I give you my email once again in a clear form:
[email protected] or perhaps not so good [email protected].
I hope it helps.

Regards
kaloschke

[Ikar]

Ok, we sent it to both your email addresses once more. Please check.

[kaloschke]

Hi,
I can't understand it. I checked both email addresses and the junk mail folder too, but nothing to see. I haven't had any problems with the addresses before.
So I have to use the older version of MySQL and wait for a newer version of your components, hoping, that it will working better.
I am very soory about that.

Regards Kaloschke

[yuanyelss]

Changing the direct option to false has no success. I have tried also
different protocols in TMyConnection. Nothing helps. Using the browser I can use network name or IP address, it works both.
So what's wrong?