Any step-by-step installing FOP2 on separate server from *?

[nicolas]

You said you used root user pass in config, but the thing you copied from your config.php has the "fop2" mysql user.. are you sure you got the mysql credentials set up correctly?

There is one thing you might want to comment to prevent warnings that will distract more than help troubleshooting, look in config.php for this line:

set_config($DBSETUP);

And remove it.

[johnny2000]

Sorry but here is the config on config.php:
$DBHOST = 'localhost';
$DBNAME = 'fop2';
$DBUSER = 'root';
$DBPASS = 'mysld root password';
johnny2000

Posts: 4
Joined: Sun Feb 16, 2014 7:36 pm

[nicolas]

Did you comment or remove the set_config line? My guess is still that your mysql credentials are wrong.

[johnny2000]

I commented it out and the result is similar:
notice
/var/www/html/fop2/lib/dblib.php (line 390)

mysql_close() expects parameter 1 to be resource, boolean given
notice
/var/www/html/fop2/lib/dblib.php (line 80)

mysql_query() expects parameter 2 to be resource, boolean given
notice
/var/www/html/fop2/lib/dblib.php (line 80)

mysql_query() expects parameter 2 to be resource, boolean given
Phonebook

notice
/var/www/html/fop2/lib/dblib.php (line 390)

[johnny2000]

By the way, as you mentioned that the database and tables will be created automatically with this version, so I drop the fop2 database that was created when I tried to install the phonebook manually. So there is no fop2 database in the mysql. I am trying to figure out which line on the config.php where the database is created and the table.

[nicolas]

I still believe your mysql credentials are wrong. Did you try to connect to mysql with the exact parameters you have in config.php? Try to catch me on the live help to give me access to your server, there is no quick way we could fix this here in the forum.

[nicolas]

By the way, as you mentioned that the database and tables will be created automatically with this version, so I drop the fop2 database that was created when I tried to install the phonebook manually. So there is no fop2 database in the mysql. I am trying to figure out which line on the config.php where the database is created and the table.

No, I never mentioned that the DATABASE is created, only the TABLES. So, create the fop2 database again. The phonebook.php script will create the visual_phonebook table if it does not exists.

[johnny2000]

I created the fop2 database, and I did try to connect to fop2 database using the user root and password for root, and no problem connecting to database. I restarted the fop2 service and the error is similar but only 1 line. I commented the
// set_config($DBSETUP);
Below is the result:
notice
/var/www/html/fop2/phonebook.php (line 42)

Undefined index: phonebook
You do not have permissions to access this resource.

I will try to catch you on the live help, if there is nothing we can do here in the forum. Thanks very much.

[nicolas]

That last one is not an error, if you look you will see that the table is most probably created. Is it? You are probably lacking permissions to open the phonebook or the php sessions are broken.

Best regards,

[johnny2000]

I just check the fop2 database and it is empty, no tables were created.

[johnny2000]

After checking and correcting the credentials, I still get one line of the "notice". But finally I have it working even the seLinux is running. Below are the boolean that I turned on with in seLinux.

setsebool -P telepathy_tcp_connect_generic_network_ports 1
setsebool -P httpd_can_network_connect 1
setsebool -P allow_user_mysql_connect 1
setsebool -P httpd_can_network_connect_db 1

After turning it on, everything works. Thanks Nico.