海运的博客

Kloxo面板重启Apache时提示以下错误：

[Tue Dec 18 22:07:51 2012] [warn] NameVirtualHost 8.8.8.8:80 has no VirtualHosts
[Tue Dec 18 22:07:51 2012] [warn] NameVirtualHost 8.8.8.8:443 has no VirtualHosts

原因是在以下配置文件内重复设置NameVirtualHost，注释一个即可。

/etc/httpd/conf/kloxo/init.conf
/etc/httpd/conf/kloxo/virtualhost.conf

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