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 ?

[[email protected] src]# cd /usr/src/
[[email protected] src]# svn co https://svn.sourceforge.net/svnroot/amportal/freepbx/branches/2.1 freepbx
[ro[email protected] src]# cd freepbx/

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

mysql> GRANT ALL PRIVILEGES ON asteriskcdrdb.* TO [email protected] IDENTIFIED BY ‘amp109’;
mysql> GRANT ALL PRIVILEGES ON asterisk.* TO [email protected] IDENTIFIED BY ‘amp109’;
mysql> quit

[[email protected] freepbx]# ./install_amp

Thanks for your help !

Omer

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

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…

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…

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

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

you are right

that’s it thanks a lot !

omer

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 ?

[[email protected] src]# cd /usr/src/
[[email protected]sterisk src]# svn co
https://svn.sourceforge.net/svnroot/amportal/freepbx/branches/2.1
freepbx [[email protected] src]# cd freepbx/

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

mysql> GRANT ALL PRIVILEGES ON asteriskcdrdb.* TO [email protected]

mysql> IDENTIFIED BY ‘amp109’; GRANT ALL PRIVILEGES ON asterisk.* TO
mysql> [email protected] IDENTIFIED BY ‘amp109’; quit

[[email protected] 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)

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?