FOP2 Community Forum

I found the messages, I will post what I will find.

I disabled the iptable service. And the same error I am getting. The contact and recording giving the same error message that "could not create/connect the phonebook table, please verify your mysql credentials in config.php", even though the credentials are correct. I tried enabling the debug, but I could not see where the debug messages, could you tell me where to find the debug messages so that I could check where the problem is?

I found the culprit, it is the iptables. However it say's "an error has occurred, there are no records found. I attached the screen shot of the error.

Hi,

I just upgraded to version 2.31, as far as the main functionality of fop2 is concern it is working, however two things that I could not figure out how to make it work, the call history and the contacts or the phonebook. They are all blank. Are there any other places that I need to manually configure the fop2? Things that I did manually are the fop2.cfg, both config.php, where I place the values of the database for authentication and connection, and the AMI values for connection to asterisk in the fo2.cfg file. Also the users, buttons etc.

I tried importing a csv file but nothing is being imported. It will say that a "number of records being imported" but the phone book is still blank. What I did, I exported the phone book first with a single entry in it so that I will have a template that I could populate and import it back to the phone book.

Sorry, I found the answer.

I have a serial key with my current version 2.8, If I upgrade it to 2.9 will the serial key still valid? If it is valid, do you have any documentation on how to to the upgrade? Thank you.

Have you solve this problem? This is also happening to my fop2 server as you described.

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.

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

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.