MySQL Setup for FC6, Asterisk, AstPP and ComtelPBX

1) Set Permissions:
chown mysql:mysql -R /var/lib/mysql/data/

2) Automatic Launch:
Copy /var/lib/mysql/support-files/mysql.server to /etc/init.d/mysql
Do bash# chkconfig --add mysql && chkconfig --levels 345 mysql on

3) Build DBD::MySQL with the new client library in the client servers. You can download the source here:
http://search.cpan.org/CPAN/authors/id/C/CA/CAPTTOFU/DBD-mysql-4.001.tar.gz

Make sure mysql_config is in your path. If it's not you can add it this way:
export PATH=$PATH:/usr/bin/mysql
Then you just need to do this:
perl Makefile.PL
make
make install

4) Old Passwords Support:
Put this line in /etc/my.cnf file (global mysql configuration file):
...
[mysqld]
...
old-passwords
...

5) Open access through iptables-save:
[0:0] -A INPUT -p tcp -m tcp --dport 3306 -j ACCEPT


1) Set Permissions:
chown mysql:mysql -R /var/lib/mysql/data/

2) Automatic Launch:
Copy /var/lib/mysql/support-files/mysql.server to /etc/init.d/mysql
Do bash# chkconfig --add mysql && chkconfig --levels 345 mysql on

3) Build DBD::MySQL with the new client library in the client servers. You can download the source here:
http://search.cpan.org/CPAN/authors/id/C/CA/CAPTTOFU/DBD-mysql-4.001.tar.gz

Make sure mysql_config is in your path. If it's not you can add it this way:
export PATH=$PATH:/usr/bin/mysql
Then you just need to do this:
perl Makefile.PL
make
make install

4) Old Passwords Support:
Put this line in /etc/my.cnf file (global mysql configuration file):
...
[mysqld]
...
old-passwords
...

5) Open access through iptables-save:
[0:0] -A INPUT -p tcp -m tcp --dport 3306 -j ACCEPT


Created by: mglucksmann, Last modification: Sat 16 of Jun, 2012 (03:39 UTC) by admin
Please update this page with new information, just login and click on the "Edit" or "Discussion" tab. Get a free login here: Register Thanks! - Find us on Google+