Conecting to a remote mysql host in conf.ini

[razvanrusu]

Hi everyone

I'm trying to set-up xataface for a web host that has the database server on a different host (not localhost)

When configuring conf.ini for the database I get a blank page. (I use Firefox on a MAC. I also tried Safari)

The configuration file looks like that:

Code: Select all

;;Configuration settings for application
title="test_mini"

[_database]                                                                                                                                                                     
host="mysql5.hostbase.net"                                                                                                                                               
name="test_mini"                                                                                                                                           
user="user"                                                                                                                                                               
password="password"

[_tables]
utilizator = "Utilizator"
categorii = "Categorii"
produs = "Produs"


Is Dataface working only for localhost?
I tried the a resembling configuration for another server and I get the same results.

Can someone help me? As soon as possible? If I don't fix this in fast (one or two days), I'll have to think at another possibility, and I don't wanna do that.
Thank you in advance.

[shannah]

Blank screen means you're getting an error somewhere. Check your error log. Xataface will work perfectly well with a remote database.
-Steve

[razvanrusu]

Hi everyone.

I checked the error log, corrected some configuration path.
I managed to connect to the database but now I have another problem. I have the same blank screen.
When I checked the error log I got this:

Code: Select all

[Wed Feb 11 19:41:48 2009] [error] [client 93.122.210.22] PHP Warning: Smarty::include() [<a>function.include</a>]: Failed opening '/var/www/vhosts/bidminwin.com/httpdocs/xataface-1.1.3/Dataface/templates_c/dataface/%%E4^E4B^E4B41A3D%%Dataface_List_View.html.php' for inclusion (include_path='.:/var/www/vhosts/bidminwin.com/httpdocs/xataface-1.1.3:/var/www/vhosts/bidminwin.com/httpdocs/xataface-1.1.3/lib:') in /var/www/vhosts/bidminwin.com/httpdocs/xataface-1.1.3/lib/Smarty/Smarty.class.php on line 1258


I have configured 0777 for templates_c. It makes a directory called dataface that has apache as owner. In that directory are some files but their size is 0. As I told you, this is a virtual host, and I don't have access to command line, nor superuser privileges, only ftp, and a visual interface for some additional services.

Thank you for your answer.
Have a good day

Razvan

[shannah]

Check if PHP is running in safe mode.

You can do this by creating a php script with the following contents:

Code: Select all

<?php
phpinfo();


And navigate to it in your web browser - and look at the line that talks about safe mode.

Note that safe mode is deprecated and has been removed as of PHP 6.0 (http://ca2.php.net/safe_mode).

Unfortunately safe mode messes with directory creation so Xataface cannot work under it.

Other than that, I'd suggest deleting all of the files in your templates_c directory and try again to see if the problem still exists.

-Steve

[razvanrusu]

Unfortunately safe mode is on. I guess I'll have to think of another way to deal with the project.

But I'm still using xataface for another project I'm working on. And I might ask some questions if I get into trouble.

Thank you for your help.