Tuesday, August 31, 2010

SQL Server for Farmville

Today i got an interested error message.
can't connect to server with dsn='mysql:host=10.211.50.239;port=3306;dbname=farm_1;',
error message SQLSTATE[HY000] [2003]
Can't connect to MySQL server on '10.211.50.239' (4).;
PDOMySqlClient.class.php:70
What information can we extract from it?

Farmville uses PHP Data Objects for the MySQL requests.
In line 70 of the php class, they are using the command PDO::__construct().

The MySQL server runs on:
  • ip = 10.211.50.239
  • port = 3306 (default)
The database in my request is called farm_1, but maybe there are others like farm_2.

I assume Farmville run multiple hosts with MySQL databases, but this is one we could extract from the error messages :)

No comments:

Post a Comment