racetech
Posts: 6
|
| Posted: 09/13/2007, 6:27 AM |
|
Hello,
My problem is in the design connection, I had intalled the new MySQL ODBC and creat an ODBC Connection, but when I test the connection show me a error: "Request returned with SQL_ERROR", in the diagnostic show me: [MySQL][ODBC 3.51 Driver]Access denied for user '*************'@'201.87.12.58' (using password: YES), the problem is in the IP number, this IP number is diferent of I insert in "Server" field, I insert IP number: 67.15.36.6 no IP: 201.87.12.58 this IP is of my Internet connection provider....
Help please!
Thanks,
_________________
Fernando Jimenez
Brazil |
 |
 |
wkempees
|
| Posted: 09/13/2007, 10:37 AM |
|
You are trying to ODBC connect in Design time to the MySQL server hosted
remote.
This will probably not work because your remote host does not allow remote
connections.
Several topics in this forum describe how to setup a local mysql database
for design time use.
Search forum (using search button in top menu, for ODBC or XAMPP
Walter
|
|
|
|
racetech
Posts: 6
|
| Posted: 09/13/2007, 11:24 AM |
|
Quote wkempees:
You are trying to ODBC connect in Design time to the MySQL server hosted
remote.
This will probably not work because your remote host does not allow remote
connections.
Several topics in this forum describe how to setup a local mysql database
for design time use.
Search forum (using search button in top menu, for ODBC or XAMPP
Walter
Hi walter, thanks, but...
My DB are in remote internet hosting...
The problem is:
I insert in MySQL ODBC, "Server" field, the IP of my remote hosting provider: 67.15.36.6 but when I test the connection, in diagnostic, show me an error with autentication failled with 'my_password'@'201.87.12.58' but the correct it had to be 'my_password'@'67.15.36.6'.
I don't understand why th MySQL ODBC change my inserted IP for other...
The IP 201.87.12.58 is of my ADSL Provider...
Have any idea?
Thanks and best regards...
Fernando
_________________
Fernando Jimenez
Brazil |
|
|
|
wkempees
|
| Posted: 09/13/2007, 11:42 AM |
|
Your remote hosted database, hosted as you state at 67.15.36.6
receives your connection attempt and tries to see if you are authenticated
to access the database.
Your credentials (the way you present yourself to the host) are
blabla@201.87.12.58
Subsequently you are denied acces, because you host database server does NOT
accept connections from outside it's own domain (localhost = 67.15.36.6)
This is a well known situation. As I stated before your host (ISP) does not
accept remote connection to the database (common amongst 80% of all ISP's).
We (do hosting aso) allow remote access on request only.
So back to my original post:
You need a local development environment such as Xampp/WAMPP and the likes.
You need to import your database schema to your local MysQL db.
Then you need to setup in Project->Properties->Connections:
Design: ODBC connect to the local MySQL database.
Server: localhost MySQL connection.
Use this setup to do design work and publish, actualy publishing to your
local Apache MySQL environment.
When you finalize (a step of) the project, then you create a second Server
Profile.
That profile will have the same design settings but a different Server
setting.
It will mostly be an FTP connection to the publishing directory on the ISP
machine
AND a Server is LOCALHOST definition of the database used there.
Walter
|
|
|
|
racetech
Posts: 6
|
| Posted: 09/13/2007, 12:00 PM |
|
Quote wkempees:
Your remote hosted database, hosted as you state at 67.15.36.6
receives your connection attempt and tries to see if you are authenticated
to access the database.
Your credentials (the way you present yourself to the host) are
blabla@201.87.12.58
Subsequently you are denied acces, because you host database server does NOT
accept connections from outside it's own domain (localhost = 67.15.36.6)
This is a well known situation. As I stated before your host (ISP) does not
accept remote connection to the database (common amongst 80% of all ISP's).
We (do hosting aso) allow remote access on request only.
Hi Walter,
My server accept connections from outside, I have a control over it, my ISP isinde in a 20% that accept connections of outside. I use de same DB for many websites and work fine, I connect from other programs (eg,. Visual Pardigm), DBsModelers and work fine, this is not a problem.
For me the problem is this change of IPs make by MySQL ODBC....
Thanks...
Fernando
_________________
Fernando Jimenez
Brazil |
|
|
|
Benjamin Krajmalnik
|
| Posted: 09/13/2007, 4:35 PM |
|
That is correct.
MySQL sees the IP of your machine (i.e. - your ADSL provider) since that is
where the connection is coming from.
The ODBC driver is not doing anything - the reply you are getting is from
the MySQL Server based on failed authentication.
|
|
|
|
Benjamin Krajmalnik
|
| Posted: 09/13/2007, 4:39 PM |
|
Once again, MySQL ODBC is not changing anything.
That is the IP which your MySQL server is seeing.
Go to your users table in the mysql database, and create an entry with
201.87.12.58 as the host, whatever username and password, and give it access
to your databases.
This is simple MySQL server management.
It has nothing to do with MyODBC.
|
|
|
|
racetech
Posts: 6
|
| Posted: 09/14/2007, 2:12 AM |
|
Quote Benjamin Krajmalnik:
Once again, MySQL ODBC is not changing anything.
That is the IP which your MySQL server is seeing.
Go to your users table in the mysql database, and create an entry with
201.87.12.58 as the host, whatever username and password, and give it access
to your databases.
This is simple MySQL server management.
It has nothing to do with MyODBC.
Hi Benjamin, thanks... but...
I already had made this in my ISP with the "MySQL Remote", IP 201.87.12.58 already was with the set free access to MySQL BD in my server.
As it said before, I already access my BD with other programs (eg. Visual Paradigm) without problem.
Do you any other idea to solve this problem?
Thanks and best regards.
_________________
Fernando Jimenez
Brazil |
|
|
|
racetech
Posts: 6
|
| Posted: 09/14/2007, 2:26 AM |
|
Ok. Already it is working fine, I'm created a new user with shortest username and a different password, without special characters, as "*", and functioned immediately.
Thaks to all and best regards.
_________________
Fernando Jimenez
Brazil |
|
|
|
wkempees
Posts: 1679
|
| Posted: 09/14/2007, 5:37 AM |
|
Username had special characters like '*' ?
Good that it works now.
Walter
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
racetech
Posts: 6
|
| Posted: 09/14/2007, 7:04 AM |
|
Quote wkempees:
Username had special characters like '*' ?
Good that it works now.
Walter
Hi Walter,
In previous password I had used, in the composition, the character "*" also a longer userername, later that I changed both, started to work well. I believe that it has been this. When I will have free time, I go to make some tests with username and password variants to try to discover this. If I obtain the reason of this fail I publish one post here.
Thank for your effort in aid.
Best regards,
_________________
Fernando Jimenez
Brazil |
|
|
|
whiterabbitwond
Posts: 28
|
| Posted: 09/18/2007, 11:20 AM |
|
Just to chime in my 2c, I HIGHLY recommend you NOT allow mysql connections from anything other than 'localhost'. If you need to connect from your development computer (assuming windows), then use Putty (http://www.chiark.greenend.org.uk/~sgtatham/putty/) to ssh into your server, and configure it to create a ssh tunnel that bridges port 3307 on your development machine with localhost:3306 on the server. That way your server is safe and secure only allowing local connections and it never knows you are tunneling through ssh. That way your server only has port 80(http) and 22(ssh) open to the world. The reason I suggest port 3307 above, is then it allows you to easily run mysql locally without conflicting. Incidentally my "design" connection is my local mysql on port 3306 and my "production" db is localhost:3307 (tunneled through ssh). Lots of tutorials on net if you need help, just ask here.
|
|
|
|
|
