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.

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.

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)

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

I turned on the debug and this is what I got: By the way I use the root user and root password for the mysql on the config.php file.
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 234)

mysql_fetch_assoc() expects parameter 1 to be resource, null 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)

mysql_close() expects parameter 1 to be resource, boolean given

Also I check the fop2 database, it is created but there are no tables in it.

This is what I got when I click the phone book icon:
"You do not have permissions to access this resource." However the permission on the user is set to "all"
Below is the config.php:
$DBHOST = 'localhost';
$DBNAME = 'fop2';
$DBUSER = 'fop2';
$DBPASS = 'mysld root password';

I have the fop2 installed on a separate non PBX server and it seems that everything is working as it should aside from the Phonebook. I tried installing the Phonebook, however on the step of creating the table I received this error:
-bash: mysql.db: No such file or directory
Am I missing something? The fop2 database was created properly and the mysql is running.