FreePBX 2.1.3, Pound Key Version 1.1.2

General Help
1

Hi All,

I have installed Poundkey 1.1.2 and FreePBX 2.1.3 the installation went ok, when I rebooted the server everything else loads up ok except MSQL. error as follows: loading MYSQL [Failed] Why has this happened? I have tried about 3 fresh installs and have the same results. Please Help.

StillLearning :?

2

Hi Andrew & Specialtel,

Thankyou for your replies, I have followed your post and made the necessary changes and MYSQL now starts and runs ok. But I still have another problem, when I use the ip address I entered during the FreePBX installation I get the Http server test page not FreePBX, what could this be?

:roll:

3

Just a guess but try

http:///admin

4

[quote=“dumeinst”]Just a guess but try

http:///admin[/quote]

Tried it several times no sucess.

5

Hi Specialtel,

How do I do this? Please help

Cheers

6

change the pid-file location in /etc/my.cnf

change the line pid-file=/var/run/mysqld/mysqld.pid to pid-file=/srv/mysql/mysqld.pid

Each time the amportal script runs it sets asterisk as the owner on the /var/run directory which is where the default pid-file is located.
The pid-file must be owned by the mysql user so that causes the problem, if change the ownership on the pid-file in the /var/run/mysqld/ directory next time the amportal script runs it will set the owner back to asterisk. Another option would be to edit the amportal script.

7

StillLearning wrote:

[quote] 061020 00:20:53 mysqld started
061020 0:20:53 InnoDB: Started; log sequence number 0 43655
061020 0:20:53 [ERROR] /usr/sbin/mysqld: Can’t create/write to file ‘/var/run/mysqld/mysqld.pid’ (Errcode: 13)
061020 0:20:53 [ERROR] Can’t start server: can’t create PID file: Permission denied
061020 00:20:53 mysqld ended

What could be the problem?

[/quote]

The permissions are wrong on the directory. Run:

chown mysql. /var/run/mysqld

and that should get it going.

Andrew

Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642

Amportal-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/amportal-users

Post generated using Mail2Forum (http://www.mail2forum.com)

8

Hi Dumeinst,

Thanks for your prompt reply here is the info.

Oct 20 00:20:35 localhost sshd(pam_unix)[2586]: session opened for user root by root(uid=0)

061020 00:20:53 mysqld started
061020 0:20:53 InnoDB: Started; log sequence number 0 43655
061020 0:20:53 [ERROR] /usr/sbin/mysqld: Can’t create/write to file ‘/var/run/mysqld/mysqld.pid’ (Errcode: 13)
061020 0:20:53 [ERROR] Can’t start server: can’t create PID file: Permission denied
061020 00:20:53 mysqld ended

What could be the problem?

9

I don’t know what OS poundkey is running on… is it centos? If that’s so try doing an /etc/init.d/mysqld start and pay attention to what’s in /var/log/messages or /var/log/mysqld.log

This should give you some insight as to why mysql isn’t starting. You could then post the relevant lines from the log file here