Hello,
PF7.2's database address is /var/lib/mysql,now I need to change it to
/opt/sqldata,and I change it follow these steps:
#cp -arp /var/lib/mysql /opt/sqldata
change mysql script:
#vim /etc/init.d/mysql
commented out70 line??# datadir=/var/lib/mysql
add line??datadir=/opt/sqldata
save and exit
#vim /usr/local/pf/addons/dev-helpers/centos-chroot/my.cnf
commented out datadir:# datadir=/var/lib/mysql
add datadir:datadir=/opt/sqldata
commented socket:# socket=/var/lib/mysql/mysql.sock
add socket: socket=/opt/sqldata/mysql.sock
save and exit
#vim /usr/locol/pf/conf/mariadb/maraidb.conf.tt
change as below:
#socket = /var/lib/mysql/mysql.sock
socket = /opt/sqldata/mysql.sock
#innodb_data_home_dir = /var/lib/mysql
innodb_data_home_dir = /opt/sqldata
#innodb_log_group_home_dir = /var/lib/mysql
innodb_log_group_home_dir = /opt/sqldata
#chown -R mysql:mysql /opt/sqldata
#reboot
when system rebooted,pf still cannot connect database, the log show it as below:
Jul 25 11:03:21 localhost packetfence: FATAL -e(656): unable to connect to
database: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2 "No such file or directory") at -e line 1.
how can I do to fix the problem?thank you!
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
PacketFence-devel mailing list
PacketFence-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/packetfence-devel
