[FOP2][Problems]VisualPhonebook
Hey there,
I've got one more problem with my visual phonebook. My fop2 version is 2.26 and, as it is written over here _http://fop2.com/documentation-configuration-web.php#VisualPhonebook
i didn't create any mysql databases/tables by myself. So after runnin' fop2 service, connectin'the web GUI and clickin' visual phonebook button I've got this message:
"Could not connect/create the phonebook table. Please verify your mysql credentials in config.php".
So I did. After connectin' to mysql I've found out that there is no fop2 database created. I decided to create it by myself, by followin' the instructions posted here:
_http://www.fop2.com/documentation-configuration-4.php (in the end of the page).
After creatin' database (fop2) and tables (fop2recordings, visual_phonebook) and editin' my /var/www/html/fop2/config.php file by addin' $DBHOST/NAME/USER/PASS I restarted mysql and fop2 services. But after clickin' Visual Phonebook button I get the same message:
"Could not connect/create the phonebook table. Please verify your mysql credentials in config.php"
Waitin' 4 ur advices guys, thx.
Cheers, kga.
I've got one more problem with my visual phonebook. My fop2 version is 2.26 and, as it is written over here _http://fop2.com/documentation-configuration-web.php#VisualPhonebook
i didn't create any mysql databases/tables by myself. So after runnin' fop2 service, connectin'the web GUI and clickin' visual phonebook button I've got this message:
"Could not connect/create the phonebook table. Please verify your mysql credentials in config.php".
So I did. After connectin' to mysql I've found out that there is no fop2 database created. I decided to create it by myself, by followin' the instructions posted here:
_http://www.fop2.com/documentation-configuration-4.php (in the end of the page).
After creatin' database (fop2) and tables (fop2recordings, visual_phonebook) and editin' my /var/www/html/fop2/config.php file by addin' $DBHOST/NAME/USER/PASS I restarted mysql and fop2 services. But after clickin' Visual Phonebook button I get the same message:
"Could not connect/create the phonebook table. Please verify your mysql credentials in config.php"
Waitin' 4 ur advices guys, thx.
Cheers, kga.
Comments
Now, if you have created the database and tables and a special db user and pass, and you still get the error, then try to use the mysql command line client with that information to check that you can actually connect to it.
Something like:
mysql -u user -pPassword fop2 -e "show tables"
I have the same problem. I don't use freepbx so I suppose that is normal that I have to create the DB and the tables and say to FOP2 where to find these information.
If so where I have to set up these information? In which way? Which is the format of the DB? Is there a documentation for people, like me, that don't use freepbx?
Thanks so much!
Gianluca
If you do not use freepbx, then you need to create the db , the tables will be autocreated if the mysql user has create permissions, or it will use existing ones. If you still have issues, it is because mysql credentials are wrong somehow.
So, the only thing you have to change is config.php. Did you try to access mysql from the command line with the same credentials as I have suggested?