App and Installer cannot connect to the database

Archived from the Xataface Users forum.

olliwalli — Tue Jan 10, 2012 3:02 am

Hello

I installed Xataface and a test app on my server. I have also created the database and the database table.

When I start the installer it is possible to select one of the existing databases (when choosing the option ‘Create application for existing database’). Then I select the correct database and enter the MySQL Username, Password and click “Test DB Connection”. I get the error: “Could not connect to the MySQL server with username web385.”

Also when I try to start my testapp, I get the result: “Error loading config file. No tables specified.”

I am absolutely sure that:

• the username ans password for the database are correct (in the installer, also in the config.ini of the testapp)
• the database exists
• the table in the database of the testapp is existent

Xataface is installed in:

Code: Select all

/var/www/web385/html/xataface/

testapp is installed in:

Code: Select all

/var/www/web385/html/testapp

The config.ini of the testapp:

Code: Select all

`[_database]
host = localhost
user = web385
password = XXXXXXXXXX
name = usr_web385_5

[_tables]
patient = patient`

The index.php of the testapp:

Code: Select all

<? require_once '/var/www/web385/html/xataface/dataface-public-api.php'; df_init(__FILE__, 'MYDOMAIN/xataface/'); $app =& Dataface_Application::getInstance(); $app->display(); ?>

Attached is my testapp directory.

I would really be happy, if someone could help.

---

shannah — Tue Jan 10, 2012 11:51 am

config.ini should by conf.ini

-Steve

---

olliwalli — Tue Jan 10, 2012 11:19 pm

Hi shannah

Thanks for the tip! Now it worked!

Kind regards,
Olliwalli