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

[nicolas]

Having a correct path of communication between the fop2 server and AMI is important, but it is not the only thing needed in order to send correct commands to Asterisk. I put emphasis in correct.

In general, for every command to work -except for hangup or record-, you have to configure an extension and context in the button definition that must match your dialplan, as set in asterisk's extensions.conf. Also, you need the "originate" permission in /etc/asterisk/manager.conf

If you want to troubleshot, you need to start fop2 with debug level 15 and then inspect the output when you try to originate a call, to start fop2 in debug mode you have to pass -X 15 to the startup command.. you can do something like this

killall fop2_server
cd /usr/local/fop2
script capture.log
./fop2_server.pl -X 15
(connect to fop2, try to originate/dial a call)
ctrl-C
exit

at this point you have a capture.log file to inspect.

My guess? You might have incorrect extenxion/context configured in your buttons, you might lack the originate permission in manager.conf.

[xeper]

It looks like our Asterisk guy changed the context to something other than the default "from-internal" to "phones".

I had him create a new context to mirror "phones" called "flash-op" and it works like a charm.

Thanks to the awesome chat support guys here who helped me out with this.

[johnny2000]

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.

[nicolas]

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.

In the latest fop2 versions there is no need to create the tables, they will be autocreated if they are missing.

Did you setup proper mysql credentials in config.php?

[johnny2000]

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';

[johnny2000]

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

[johnny2000]

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

[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.