Version 3 Install issues - PDO Connection Error:

Installed Centos5.4 and followed Freeswitch install instructions to a T...
All seemed well there, then I followed instructions for FreePBX-v3 install and have received some errors and I am at a standstill...
I did change the root password on the sql server, but did that after I was getting this error....
Unable to establish a connection to mysql!
PDO Connection Error: SQLSTATE[HY000] [2003] Can't connect to MySQL server on '127.0.0.1' (13)
MYSQL server is running and I stopped IPTABLES. I am installing this from a workstation that is access the server remotely.
Can anyone share what they think the issue is?
__________________



Have you got 32 bit or 64
Have you got 32 bit or 64 bit?
What versions of sofware?
#uname -a
#rpm -qa | grep php
#rpm -qa | grep mysql
I have 32bit : (
But that didn't turn out to be the issue. Seems as though I needed to create freepbx user and password and give proper permissions. I thought that maybe the wizard was going to do that, as the directions didn't tell me to do that myself.
Anywho, with the help of pyite on IRC, we got it installed. There were several other oversights in the directions, some of which I was able to document and hope to add to the project.
I may have to create a new post for this but, do you have any setup step by steps to get extension/phone setup? I created 2 devices using numbers that were there, 2010 and 2011.
Then I set my user with the proper domain under location area. Since this box only has one NIC setup, I think I setup the SIP interface correct, taking off the NAT setting. The softphones seem to register, but cant call each other.
Do I have to setup dialing plan? I can see attempts with in fs_cli.
Also I see the status of the device as offline....
I have the same issue with Fedora 12 64 bit
I created the database and user in mysql, still having issue.
Can you please post your steps on resolving this.
Issac Simchayof
As I understand it...
You are NOT to create a DB. IF you have drop it. Leave the mysql db...
I assume that you are installing this by the instructions that were posted. In those directions, it seems to not share that the freepbx username needs to be created with proper permissions, prior to running automated install script.
Run this command from your mysqladmin
grant all privileges on freepbx.* to 'freepbx'@'localhost' identnfied by 'YOURPASSWORD';
Then if you still can't push the install, change the 127.0.0.1 to localhost ...
Please report back if that worked...
localhost
localhost did the trick.
Issac Simchayof
Glad to hear, sounds like a bug, as that was my issue too
+1
It was password problem for me
I was failing to connect because of the wrong password. I had run as suggested this command from mysqladmin:
grant all privileges on freepbx.* to 'freepbx'@'localhost' identified by 'YOURPASSWORD';
However when run the install wizard it kept using a Password of 'freepbx'. I saw no place in the install wizard to change what password it used to access the database. Therefore I went to the file database.php, which in my case was located at /var/www/html/freepbx/freepbx/config/database.php, and edited the password there. If you look at this file it has
$config['default'] = array
(
'benchmark' => TRUE,
'persistent' => FALSE,
'connection' => array
(
'type' => 'mysql',
'user' => 'freepbx',
'pass' => 'YOURPASSWORD',
'host' => '127.0.0.1',
'port' => FALSE,
'socket' => FALSE,
'database' => 'freepbx'
),
'character_set' => 'utf8',
'table_prefix' => '',
'object' => TRUE,
'cache' => FALSE,
'escape' => TRUE
);
I just changed the line for password in here to match the password I set for the database and it worked no problem. I am not sure if I missed the spot to enter the password through the GUI or this feature has not been implemented yet.
Sorry, my mistake
I had changed the /var/www/html/freepbx/freepbx/views/installer/configure.php file on my system to work around this issue, http://www.freepbx.org/forum/freepbx/freepbx-v3/error-on-install-shows-o...
When I did that I accidentally turned off the dbCredentials part of the page. This is why I was not prompted for the password. This error was self inflicted so please ignore previous post.