Mysql won't restart after install of freepbx

General Help
1

Hello list,

I have installed the freepbx could run it after install then I reboot the pc and mysql won’t restart.

I removed mysql-server, tried to reboot several times no problem sql-server is booting. So I did a new install of freepbx no error message, after installation I can access it. Reboot. Same problem with sql-server !

What I am doing wrong here ? Did I forgot something ?

[root@asterisk src]# cd /usr/src/
[root@asterisk src]# svn co https://svn.sourceforge.net/svnroot/amportal/freepbx/branches/2.1 freepbx
[root@asterisk src]# cd freepbx/

[root@asterisk freepbx]# mysqladmin create asterisk
[root@asterisk freepbx]# mysqladmin create asteriskcdrdb
[root@asterisk freepbx]# mysql asterisk < SQL/newinstall.sql
[root@asterisk freepbx]# mysql asteriskcdrdb < SQL/cdr_mysql_table.sql
[root@asterisk freepbx]# mysql

mysql> GRANT ALL PRIVILEGES ON asteriskcdrdb.* TO asteriskuser@localhost IDENTIFIED BY ‘amp109’;
mysql> GRANT ALL PRIVILEGES ON asterisk.* TO asteriskuser@localhost IDENTIFIED BY ‘amp109’;
mysql> quit

[root@asterisk freepbx]# ./install_amp

Thanks for your help !

Omer

2

Have you set mysql to start on bootup? CentOS is ‘chkconfig mysqld on’ I think.

Also, try to start mysql manually - /etc/init.d/mysqld start

–Rob

3

I had the same issue but try this one…

See where the mysql databases are stored in the /etc/my.cnf and goto that directory (usually datadir=/var/lib/mysql) and check and change ownership to mysql:mysql.

cd /var/lib
chown -R mysql:mysql mysql

and restart mysql…

/etc/init.d/mysqld start

It worked for me…hope this helps…it took me acouple of hours to figure that one out as a newbee to Linux and Asterisk…

4

Sorry…here is the whole picture…the error that crops up in the mysqld.log file is that /var/run/mysqld cannot be witten to… additionally I had to change the ownership of this directory and everything started working again…

cd /var/run
chown -R mysql:mysql mysqld

/etc/init.d/mysqld

and voiala the MySQL server comes up without a glitch…

I believe that this is where the Panel display problemas are aswell…but I hav´nt found anything yet…

5

Yes that was the problem warlock !

you are right the owner of /var/run/mysqld was asterisk as user and group.
i followed your mail and could start mysql again !

can you explain this to me ?

Thank

Omer

6

Your ‘astrundir’ in /etc/asterisk/asterisk.conf is set to ‘/var/run’, rather than /var/run/asterisk. In 2.2, it checks to make sure it’s not set incorrectly, whilst 2.1 doesn’t. Fix it, and it won’t happen again.

–Rob

7

you are right

that’s it thanks a lot !

omer

8

Check the permisions of files in /var/run
I have the same problem, when execute then “amportal start”, Freepbx
change the owner of the files in /var/run so some servers not start

Sorry for my english, it’s not my native languague

David González

Nodo 07 de la REDLIBRE de Guadalajara
www.guada07.guadawireless.net

davidALGARROBAguada07.guadawireless.net
david EN Jabber.guadawireless.org

Linux user: 139902
www.valdeavellano.org
Tu tienda de redes inalambricas www.tiendasincables.com
-----Mensaje original-----
De: [email protected]
[mailto:[email protected]] En nombre de omer
Enviado el: viernes, 29 de septiembre de 2006 15:37
Para: [email protected]
Asunto: [Amportal-users] mysql won’t restart after install of freepbx

Hello list,

I have installed the freepbx could run it after install then I reboot
the pc and mysql won’t restart.

I removed mysql-server, tried to reboot several times no problem
sql-server is booting. So I did a new install of freepbx no error
message, after installation I can access it. Reboot. Same problem with
sql-server !

What I am doing wrong here ? Did I forgot something ?

[root@asterisk src]# cd /usr/src/
[root@asterisk src]# svn co
https://svn.sourceforge.net/svnroot/amportal/freepbx/branches/2.1
freepbx [root@asterisk src]# cd freepbx/

[root@asterisk freepbx]# mysqladmin create asterisk [root@asterisk
freepbx]# mysqladmin create asteriskcdrdb [root@asterisk freepbx]# mysql
asterisk < SQL/newinstall.sql [root@asterisk freepbx]# mysql
asteriskcdrdb < SQL/cdr_mysql_table.sql [root@asterisk freepbx]# mysql

mysql> GRANT ALL PRIVILEGES ON asteriskcdrdb.* TO asteriskuser@localhost

mysql> IDENTIFIED BY ‘amp109’; GRANT ALL PRIVILEGES ON asterisk.* TO
mysql> asteriskuser@localhost IDENTIFIED BY ‘amp109’; quit

[root@asterisk freepbx]# ./install_amp

Thanks for your help !

Omer

Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net’s Techsay panel and you’ll get the chance to share
your opinions on IT & business topics through brief surveys – and earn
cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDE
V

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

Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net’s Techsay panel and you’ll get the chance to share your
opinions on IT & business topics through brief surveys – and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV

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

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

9

Your ‘astrundir’ in /etc/asterisk/asterisk.conf is set to ‘/var/run’, rather than /var/run/asterisk. In 2.2, it checks to make sure it’s not set incorrectly, whilst 2.1 doesn’t. Fix it, and it won’t happen again.

–Rob[/quote]

I changed the directory to /var/run/asterisk, but after a restart the same problem…mysql+ssh won´t start. the owner si changed to asterisk.

so what could I do?