Visual Phonebook with database

clinnovations

Im trying to make my fop2 version 2.26 use phonebook with my database in a non pbx installation

I activated
define('DEBUG',true); in config.php

when i go to:
http://X.X.X.X/fop2/phonebook.php

i get :
"']+)\s*$/",$line,$matches)) { $conf[ $matches[1] ] = trim($matches[2]); } } } else { die("
".sprintf("Missing or unreadable config file (%s)...cannot continue", $filename)."
"); } return $conf; } ?> You do not have permissions to access this resource.

nicolas

At the top of config.php you can define a mysql user, password and database. You have to create that database and populate it with the tables found in the mysql-tables.db file in the web directory. Once that is done, everything will work. You do not need to modify php files, just create the database and set the proper credentials at the top of config.php

Best regards,

clinnovations

I populated my database with the mysql.db from the fop2 web directory and set config.php mysql user, password and database.

when i go to:
http://X.X.X.X/fop2/phonebook.php

i still get this error:
"']+)\s*$/",$line,$matches)) { $conf[ $matches[1] ] = trim($matches[2]); } } } else { die("
".sprintf("Missing or unreadable config file (%s)...cannot continue", $filename)."
"); } return $conf; } ?> You do not have permissions to access this resource.

when i go in my fop2 web interface and click on phonebook it won't open it just kept loading.

nicolas

An error should not display php code,... what fop2 version do you have? how does the first two lines of phonebook.php look like?

clinnovations

Im using version 2.26 and the first 2 line of phonebook.php look like this
<?php
header("Content-Type: text/html; charset=utf-8");
require_once("config.php");
?>
and those are the one for config.php

<?
// Database connection details
//
// Only needed if you do not use FreePBX or want to specify
// a different database than the freepbx one.

$DBHOST = 'localhost';
$DBNAME = 'fop2';
$DBUSER = 'XXX';
$DBPASS = 'XXXXXXX';

clinnovations

config.php

<?php
// Database connection details
//
// Only needed if you do not use FreePBX or want to specify
// a different database than the freepbx one.
added php but now i getting this
notice
/var/www/fop2/lib/dblib.php (line 234)

mysql_fetch_assoc() expects parameter 1 to be resource, boolean given
notice
/var/www/fop2/lib/dbgrid.php (line 1020)

Function split() is deprecated
notice
/var/www/fop2/lib/dbgrid.php (line 1020)

Function split() is deprecated
Add Delete Marked Export Import Search

First Name Last Name Phone 1 Phone 2 Company Picture
No records found
«‹1 ›»
Page : 1 of 0 . Total records found: 0

nicolas

Im using version 2.26 and the first 2 line of phonebook.php look like this

$DBHOST = 'localhost';
$DBNAME = 'fop2';
$DBUSER = 'XXX';
$DBPASS = 'XXXXXXX';

Are you sure the above data is correct? can you connect to it with the mysql command line client:

mysql -u XXX -pXXXXXXX -h localhost fop2

clinnovations

yes im able to connect to mysql database fop2 with the command.

mysql -u XXX -pXXXXXXX -h localhost fop2

nicolas

You are seeing unparsed php code in phonebook.php, be sure the php is interpreted correctly, there is a missing opening php tag , or some error of that sort.

boatman810

I think I blew away my correct permissions for visual_phonebook
re-applied these
grant all privileges on . to 'root'@'%' with grant option;
grant all privileges on . to 'root'@'localhost' with grant option;
flush privileges;
restarted db
have 4900+ entries, and can see only the 2 that I have manually entered from gui
I can see the 2 from the command line as well
mysql -u root -pfakenew-password -h localhost fop2 -e "show tables"
this command works fine
any suggestions

ver 2.29.01

FOP2 Community Forum

Visual Phonebook with database