| Bug #34682 | DNS resolution fails or redirects to a faulty location | ||
|---|---|---|---|
| Submitted: | 20 Feb 2008 3:50 | Modified: | 29 May 2013 7:58 |
| Reporter: | Mohiuddin Khan Inamdar | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | Connector / ODBC | Severity: | S3 (Non-critical) |
| Version: | 5.1 | OS: | Windows (XP sp2) |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | dns, domain, host, name, NetBios, odbc51_postga, Resolution | ||
[10 Apr 2008 12:42]
Tonci Grgin
Hi Mohnkhan and thanks for your report. We are unable to reproduce reported behavior. Did you make sure there are no unsaved changes to DSN and/or ASP page before running?
[11 Apr 2008 8:10]
Mohiuddin Khan Inamdar
i am sure i had saved the DSN and no changes were made to either ASP page ..... DSN. I will try to resetup this test enviroment. in my office during free time. and post an update to you. Thanks for trying to find the bug. Sincerely Mohiuddin Khan Inamdar http://www.mohitech.com
[11 Apr 2008 8:31]
Tonci Grgin
Mohiuddin, please do as no one here is able to repeat the problem... Waiting on your results.
[11 Apr 2008 8:38]
Tonci Grgin
Mohiuddin, I double checked code and with my colleagues, there is no such function (address resolution) built in MyODBC... So I see few possible culprits here: - Registry holding incorrect DSN info - ASP page not saved when DSN changed - Host lookup tables - Some network HW malfunction - libmysqlclient bug (but that would already risen much bug reports and I see none)
[11 May 2008 23:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
[29 May 2013 7:58]
Bogdan Degtyariov
I'm closing this bug because I can not continue without feedback from the reporter. If you have new info, please reopen the report.
Description: Actual Problem: Sometimes database connects to localdatabase instead of remote database.. when using netbios names as hostnames for mysql server and both servers are absolutely identical. How to repeat: How to duplicate it. The WebServer: I have one Web application Running on Windows XP SP2.. with all latest patches till today. IIS , Web application on Micosoft ASP 2.0. This Webserver also runs a copy of the same database MySQL server 5.0.45 Community Edition. The current Stable production version database name MRP user mohn pass mohn user priviliges all port:3306 all fields are UTF-8,UTF_collation_ci Host Name PC. IP: 192.168.1.108 Connected Via Wireless accesspoint. with near ZERO interference Has a System DSN called TreeTestMySQL. it connects to the host DBserver,port 3306 username and password are mohn. now when this web application is being accessed and tables being inserted. I suddenly get data from the localhost database server and not the remote database server. so sometimes local database gets updated while sometimes remote. This appears to be a bug in the MySQL connector 5.1 beta (LATEST at this moment)... This problem has really made me think. The Database Server Host Name: DBServer IP:192.168.1.187 MySQL server 5.0.45 Community Edition. The current Stable production version database name MRP user mohn pass mohn user priviliges all port:3306 all fields are UTF-8,UTF_collation_ci Connected to a switch which is directly a part of the same subnet as the webapplication server. Regards Mohnkhan http://www.mohitech.com