Am i crazy?
Xojo 2018 R1.1
My WebApplication does not connect to mysqlserver. I’m getting error 2003!!!
I tested the login/password using phpmyadmin AND on terminal. All up and running.
I rechecked all values bellow, 5 times!
What i’m doing wrong???
App:Properties:
Public Property DB as MySQLCommunityServer
App:Event:Open:
[code]DB = new MySQLCommunityServer
DB.Host = “dev.server.com ”
DB.DatabaseName = “girassol”
DB.UserName = “girassol”
DB.Password = “girassol”
if DB.Connect then
system.DebugLog(“Connected to database”)
DB.sqlExecute(“SET NAMES ‘utf8’”)
else
system.DebugLog(str(DB.ErrorCode) + " - " + DB.ErrorMessage)
end if[/code]
PaulS
(PaulS)
February 20, 2019, 7:26am
2
Also, make sure that MySQL is listening on dev.server.com .
If your web app is running on that same server, host should be set to 127.0.0.1.
[quote=425496:@Paul Sondervan]Could it be that you forgot to add the port (DB.Port = …)?
http://documentation.xojo.com/api/databases/mysqlcommunityserver.html[/quote]
I never use the port
but i’ll try!
Login to the Server via shell and try “telnet dev.server.com 3306” you should get something like “Escape character is ‘^]’.” otherwise the mysql server is not listening on the interface, there is a firewall blocking or there is no routing.
425704:@Marius Dieter Noetzel:
Login to the Server via shell and try “telnet dev.server.com 3306” you should get something like “Escape character is ‘^]’.” otherwise the mysql server is not listening on the interface, there is a firewall blocking or there is no routing.
mysql server is up and running
More info:
i can connect to any databases on my mysql thru terminal or navicat or phpmyadmin(hosted on same server)
I noticed i cannot access my databases within xojo anymore.
All my old projects cannot connect!
What’s going on?
I just restarted and the problem persists
I’ll download a fresh copy of Xojo!
Did you try to use the ip?
Fixed!
The problem was caused by last Mac OS X Security Update.
I installed the lastest version and it fixed. Now all previous xojo projects are connecting to database.
Alex
[quote=425744:@Alexandre Cunha]Fixed!
The problem was caused by last Mac OS X Security Update.
[/quote]
which macos are you on ?