海运的博客

新建脚本，备份数据库并上传到FTP。

#/bin/bash
#Cretated by www.haiyun.me
sqluser=root #sql用户
sqlpasswd=onovps #sql密码
dbname=onovps #数据库名称
ftphost=www.haiyun.me #ftp地址
ftpuser=onovps #ftp用户
ftppasswd=onovps #ftp密码
yum -y install lftp
/usr/local/mysql/bin/mysqldump --user=$sqluser --password=$sqlpasswd --lock-all-tables $dbname > $dbname.sql
tar zcvf blog-$(date -d "today" +"%Y-%m-%d").tar.gz $dbname.sql --remove-files
lftp << EOF
open ftphost
user ftpuser ftppasswd
cd /mnt/back
put -Ec $dbname-$(date -d "today" +"%Y-%m-%d").tar.gz
bye
EOF

添加计划任务：

crontab -e
30 1 * * * sh /back.sh #每天凌晨1点30执行

kloxo经常出现Could not open database connection真是个让人头痛的问题，按照官方提供的方法修复后有客户反应以后还是出现此问题，不得已写个脚本放后台定时监控网站，反正也不占用多少资源，如遇到Could not open database connection问题自动修复。

#!/bin/bash
#set -x
#Created by https://www.haiyun.me
website=0.0.0.0:7778 #kloxo面板地址
while true
do
if
curl $website|grep Could
then
sh /script/fix-program-mysql
/etc/init.d/mysqld restart
fi
sleep 120
done

执行：

nohup sh /path/file.sh & #以nohup方式后台运行
echo "nohup sh /path/file.sh &" >> /etc/rc.local #开机启动

1.Reset Kloxo mysql password: --> Error "Could not open database connection." when access to Kloxo

sh /script/fix-program-mysql {mysqlrootpassword}

或

sh /script/fix-program-mysql

2.Reset Horde password: --> Error "Could not open database connection."

sh /script/fixhorde

3.Reset Roundcube password: --> Error "Could not open database connection."

cat /home/kloxo/httpd/webmail/roundcube/config/db.inc.php #查看配置文件
$rcmail_config['db_dsnw'] = 'mysql://roundcube:pass@localhost/roundcubemail'; #找到这行,修改数据库密码
service mysqld stop
mysqld_safe --skip-grant-tables &
mysql -u root
mysql>
mysql> use mysql;
mysql> UPDATE user SET Password = PASSWORD ('pass') WHERE User='roundcube';
mysql> FLUSH PRIVILEGES;
mysql> quit;
service mysqld start

一客户网站连接Mysql出现以下错误：

 Lost connection to MySQL server at 'reading initial communication packet', system error: 0

解决方法，关闭DNS反查，修改Mysql配置文件，添加以下参数并重启Mysql服务。

skip-name-resolve

Windows下请参考windows下重置mysql root密码
1.停止mysql服务

/etc/init.d/mysql stop

2.以skip-grant-tables参数启动mysql

/usr/local/mysql/bin/mysqld_safe --skip-grant-tables &

3.以空密码方式登录mysql

mysql -u root

4.重置root账号密码

update mysql.user set password=PASSWORD('newpassword') where User='root';

5.刷新权限表

flush privileges;
````
6.退出mysq并重启

/etc/init.d/mysql restart