MRatWork Forum by Mustafa Ramadhan
Sawo Project - Kloxo-MR Discussions => Kloxo-MR Technical Helps => Topic started by: aneeshtan on 2014-01-10, 09:49:27
-
Hello,
My first post related to errors after upgrade from kloxo offical to kloxo MR.
*** Restart services - BEGIN ***
Stopping mysqld: [ OK ]
MySQL Daemon failed to start.
Starting mysqld: [FAILED]
Stopping named: [ OK ]
Starting named: [ OK ]
Stopping Hiawatha web server: [FAILED]
Stopping qmail-toaster: svscan qmail logging.
qmail-send: no process killed
Starting qmail-toaster: svscan.
Stopping xinetd: [ OK ]
Starting xinetd: [ OK ]
Stopping kloxo-phpcgi: [ OK ]
Starting kloxo-phpcgi: [ OK ]
Stopping kloxo-hiawatha: [ OK ]
Starting kloxo-hiawatha: [ OK ]
Stopping php-fpm: [FAILED]
Starting php-fpm: /bin/bash: php-fpm: command not found
[FAILED]
*** Restart services - END ***
As you can see I cannot run mysql -or - PHP
AND one more problem I can access to Kloxo MR login page but it says no access password is incorrect .
I have tried to change master password but still stuck and I have no chance in fixing this thing.
I tried to read all topics related but no change yet !
-
Inform here 'yum list installed php* mysql* qmail* *-toaster'.
-
Loaded plugins: fastestmirror, priorities, protectbase, replace
Installed Packages
autorespond-toaster.i386 2.0.5-1.4.0 installed
courier-authlib-toaster.i386 0.59.2-1.3.10 installed
courier-imap-toaster.i386 4.1.2-1.8.7 installed
daemontools-toaster.i386 0.76-1.3.6 installed
ezmlm-toaster.i386 0.53.324-1.3.6 installed
libdomainkeys-toaster.i386 0.68-1.3.3 installed
libsrs2-toaster.i386 1.0.18-1.3.6 installed
maildrop-toaster.i386 2.0.3-1.3.8 installed
php.i686 5.2.17-37.el5 installed
php-bcmath.i686 5.2.17-37.el5 installed
php-cli.i686 5.2.17-37.el5 installed
php-common.i686 5.2.17-37.el5 installed
php-devel.i686 5.2.17-37.el5 installed
php-fpm.i686 5.2.17-37.el5 installed
php-gd.i686 5.2.17-37.el5 installed
php-imap.i686 5.2.17-37.el5 installed
php-mbstring.i686 5.2.17-37.el5 installed
php-mcrypt.i686 5.2.17-37.el5 installed
php-mysql.i686 5.2.17-37.el5 installed
php-pdo.i686 5.2.17-37.el5 installed
php-pear.noarch 1:1.9.1-1.el5 installed
php-pecl-geoip.i386 1.0.8-3.el5 installed
php-pecl-imagick.i386 2.2.1-3.el5 installed
php-pgsql.i686 5.2.17-37.el5 installed
php-xcache.i386 1:5.2.17-1.3.2.el5 installed
php-xml.i686 5.2.17-37.el5 installed
php52s.i386 5.2.17-10.mr.el5 installed
qmail.i386 1.03-1.5.15 installed
ripmime-toaster.i386 1.4.0.6-1.3.6 installed
ucspi-tcp-toaster.i386 0.88-1.3.9 installed
-
Try update Kloxo-MR with 'yum clean all; yum update kloxomr' and then run 'sh /script/disable-mysql-aio'. MySQL 5.5 latest version have a trouble if running in OpenVZ VPS.
-
Still mysql-php- not working .
Here is what I got when I ran /script/fix-all
[root@199960 ~]# /script/fix-all
- For help, type '/script/fixdns --help'
- No argument supplied. Defaulting to localhost (master) servers
Fixing DNS server config
- For help, type '/script/fixphp --help'
- No argument supplied. Defaulting to localhost (master) servers
Fixing php.ini
- For help, type '/script/fixweb --help'
- No argument supplied. Defaulting to localhost (master) servers
Fixing Web server config
PHP Warning: PHP Startup: geoip: Unable to initialize module
Module compiled with module API=20050922, debug=0, thread-safety=0
PHP compiled with module API=20060613, debug=0, thread-safety=0
These options need to match
in Unknown on line 0
Warning: PHP Startup: geoip: Unable to initialize module
Module compiled with module API=20050922, debug=0, thread-safety=0
PHP compiled with module API=20060613, debug=0, thread-safety=0
These options need to match
in Unknown on line 0
PHP Warning: PHP Startup: imagick: Unable to initialize module
Module compiled with module API=20050922, debug=0, thread-safety=0
PHP compiled with module API=20060613, debug=0, thread-safety=0
These options need to match
in Unknown on line 0
Warning: PHP Startup: imagick: Unable to initialize module
Module compiled with module API=20050922, debug=0, thread-safety=0
PHP compiled with module API=20060613, debug=0, thread-safety=0
These options need to match
in Unknown on line 0
- For help, type '/script/fixftpuser --help'
- No argument supplied. Defaulting to localhost (master) servers
Fixing FTP User
Change qmail.init
--------------------------
Set '/home/vpopmail/bin/vchkpw' for root:root ownership
chown: cannot access `/home/vpopmail/bin/vchkpw': No such file or directory
Set '/home/vpopmail/bin/vchkpw' for 4751 permissions
chmod: cannot access `/home/vpopmail/bin/vchkpw': No such file or directory
--------------------------
Set '/var/qmail/control/locals' with 'localhost' only
--------------------------
Using qmail-lxcenter - fix '/home/lxadmin/mail/etc/vpopmail.mysql'
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib
/mysql/mysql.sock' (2)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib
/mysql/mysql.sock' (2)
--------------------------
--------------------------
- For help, type '/script/fixmail --help'
- No argument supplied. Defaulting to localhost (master) servers
Fixing Mail accounts (also 'lists' if exists)
--------------------------
Preparing Horde database
- Fix MySQL commands in import files of Horde
cp: cannot stat `/home/kloxo/httpd/webmail/horde/scripts/sql/horde_groupware.mys
ql.sql': No such file or directory
cp: cannot stat `/home/kloxo/httpd/webmail/horde/config/horde_conf.php': No such
file or directory
- Generating password
- Add password to configuration file
Could not grant privileges. Script Aborted
-
if I can't solve these problems at least please tell me I can go back to official Kloxo and same old mysql and php version
One more thing mysql.sock doesn't exists in var/lib/mysql/ folder
-
If not exist, try 'mksock /var/lib/mysql/mysql.sock'.
-
i changed the dir to tmp/ in my.cnf and now i have mysql service running
but what about php ? how can I solve this one ?
[root@199960 ~]# /script/restart-all
Stopping mysqld: [ OK ]
Starting mysqld: [ OK ]
Stopping named: [ OK ]
Starting named: [ OK ]
Stopping qmail-toaster: svscan qmail logging.
qmail-send: no process killed
Starting qmail-toaster: svscan.
Stopping xinetd: [ OK ]
Starting xinetd: [ OK ]
Stopping kloxo-phpcgi: [ OK ]
Starting kloxo-phpcgi: [ OK ]
Stopping kloxo-hiawatha: [ OK ]
Starting kloxo-hiawatha: [ OK ]
Stopping php-fpm: [FAILED]
Starting php-fpm: /bin/bash: php-fpm: command not found
[FAILED]
-
Where is httpd (Apache) ?
-
Go to 'switch program' and 'php config' and 'webserver config' to configure your KLoxo-MR.
-
Oh Please !!! I said I can't login to kloxo because it says Alert: Login Unsuccessful
I tried to reset the password but it says :
Notice : The resource you have requested doesn't exist. The server returned the
error message: <br> not_admin_cannot_modify_general <br>
-
Oh Please !!! I said I can't login to kloxo because it says Alert: Login Unsuccessful
I tried to reset the password but it says :
Notice : The resource you have requested doesn't exist. The server returned the
error message: <br> not_admin_cannot_modify_general <br>
Try this:
yum clean all
yum update kloxomr -y
qmailctl stop
# need force install again
sh /script/upcp -y
reboot
-
problem with php_fpm and mysql is solved but still can't login to kloxo mr admin
Alert: Login Unsuccessful
and still error message: <br> not_admin_cannot_modify_general <br> when I want to change the password
-
Try:
sh /script/reset-mysql-root-password YOURMYSQLROOTPASSWORD
sh /script/resetpassword master YOURKLOXOMRPASSWORD
-
[root@199960 ~]# sh /script/resetpassword master test
Notice : The resource you have requested doesn't exist. The ser
error message: <br> not_admin_cannot_modify_general <br>
As you see I can't change the master password for kloxo login page
Still I get this error on login page :
Alert: Login Unsuccessful
-
inform here 'sh /script/sysinfo; cat /etc/my.cnf'.
-
[root@199960 ~]# sh /script/sysinfo; cat /etc/my.cnf
A. Kloxo-MR: 6.5.0.f-2014011001
B. OS: CentOS release 5.3 (Final) i686
C. Apps:
1. MySQL: mysql55-5.5.35-1.ius.el5
2. PHP: php53u-5.3.28-1.ius.el5
3. Httpd: httpd-2.2.26-1
4. Lighttpd: --uninstalled--
5. Nginx: --uninstalled--
6. Qmail: --uninstalled--
7. Dns: --uninstalled--
D. Php-type (for Httpd/proxy):
E. Memory:
total used free shared buffers cached
Mem: 1024 108 916 0 0 0
-/+ buffers/cache: 108 916
Swap: 0 0 0
## _______________________________________________________________________
## / Rackspace MySQL 5.5 Terse Configuration File \
## | |
## | This is a base configuration file containing the most frequently used |
## | settings with reasonably defined default values for configuring and |
## | tuning MySQL. Note that these settings can likely be further tuned in |
## | order to get optimum performance from MySQL based upon the database |
## | configuration and hardware platform. |
## | |
## | While the settings provided are likely sufficient for most |
## | situations, an exhaustive list of settings (with descriptions) can be |
## | found at: |
## | http://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html |
## | |
## | Take care to only add/remove/change a setting if you are comfortable |
## | doing so! For Rackspace customers, if you have any questions or |
## | concerns, please contact the MySQL Database Services Team. Be aware |
## | that some work performed by this team can involve additional billable |
## \ fees. /
## -----------------------------------------------------------------------
## \ ^__^
## \ (oo)\_______
## (__)\ )\/\
## ||----w |
## || ||
[mysqld]
#OpenVZ AIO bug fix
innodb_use_native_aio=0
## General
datadir = /var/lib/mysql
tmpdir = /var/lib/mysqltmp
socket = /var/lib/mysql/mysql.sock
skip-name-resolve
sql-mode = NO_ENGINE_SUBSTITUTION
#event-scheduler = 1
## Cache
thread-cache-size = 16
table-open-cache = 4096
table-definition-cache = 2048
query-cache-size = 32M
query-cache-limit = 1M
## Per-thread Buffers
sort-buffer-size = 1M
read-buffer-size = 1M
read-rnd-buffer-size = 1M
join-buffer-size = 1M
## Temp Tables
tmp-table-size = 32M
max-heap-table-size = 64M
## Networking
back-log = 100
#max-connections = 200
max-connect-errors = 10000
max-allowed-packet = 16M
interactive-timeout = 3600
wait-timeout = 600
### Storage Engines
#default-storage-engine = InnoDB
innodb = FORCE
## MyISAM
key-buffer-size = 64M
myisam-sort-buffer-size = 128M
## InnoDB
#innodb-buffer-pool-size = 128M
#innodb-log-file-size = 100M
#innodb-log-buffer-size = 8M
#innodb-file-per-table = 1
#innodb-open-files = 300
## Replication
server-id = 1
#log-bin = /var/log/mysql/bin-log
#relay-log = /var/log/mysql/relay-log
relay-log-space-limit = 16G
expire-logs-days = 7
#read-only = 1
#sync-binlog = 1
#log-slave-updates = 1
#binlog-format = STATEMENT
#auto-increment-offset = 1
#auto-increment-increment = 2
## Logging
#log-output = FILE
#slow-query-log = 1
#slow-query-log-file = /var/log/mysql/slow-log
#log-slow-slave-statements
#long-query-time = 2
[mysqld_safe]
log-error = /var/log/mysqld.log
open-files-limit = 65535
[mysql]
no-auto-rehash
-
Try 'yum reinstall mysql*'.
-
still I can't login to kloxo or I can't reset the master password !
-
Send your ssh password to my PM. I want to know what's happen in your VPS.
-
Please check your PM.
Thanks for the help
-
i have same issues .. mr can you help me out..
-
i'm having the same problem, anyone can help ?
tks
-
mysql running?
-
[root@xerver ~]# service mysqld status
mysqld (pid 1715) is running...
-
then
cd /usr/local/lxlabs/kloxo/httpdocs
/usr/bin/lphp.exe ../bin/common/resetpassword.php master NEWPASSWORD
-
already done that :(
Notice : The resource you have requested doesn't exist. The server returned the error message: <br> not_admin_cannot_modify_general <br>
-
did you get that via ssh?
do you have cd /usr/local/lxlabs/kloxo/httpdocs folder?
-
yes
[root@xerver httpdocs]#
-
ok and now if you execute
/usr/bin/lphp.exe ../bin/common/resetpassword.php master NEWPASSWORD
what you get?
-
like i said on a previous message
already done that :(
Notice : The resource you have requested doesn't exist. The server returned the error message: <br> not_admin_cannot_modify_general <br>
-
do you have /usr/local/lxlabs/lxadmin/httpdocs folder?
-
like i said before ... yes :(
yes
[root@xerver httpdocs]#
-
It's look like something trouble with kloxo database.
But, try 'sh /script/mysql-convert --engine=myisam' first.
-
done that, finish ok
but still no luck on login :(
-
I asked 2 different paths…..
-
Give me to your ssh dan Kloxo-panel access and send to my PM.
-
sent
tks
-
Didn't receive info for IP.
-
Didn't receive info for IP.
i've sent a 2nd pm :)
sorry
-
@zecompadre,
I didn't found kloxo database inside /var/lib/mysql.
It's fresh install or update from Kloxo official?.
-
i've used the Install Kloxo-MR (B.2)
from the https://github.com/mustafaramadhan/kloxo/blob/release/how-to-install.txt
CentoOs 5.7 before the updates
i can again do a fresh VPS install
but i've done that already 3 times :(
-
i've used the Install Kloxo-MR (B.2)
from the https://github.com/mustafaramadhan/kloxo/blob/release/how-to-install.txt
CentoOs 5.7 before the updates
i can again do a fresh VPS install
but i've done that already 3 times :(
So, use CentOS 6 64bit.
I will waiting.
-
i've reinstall the server !
just wait a second :)
can u try to install for me after VPS reinstall ?
-
i've reinstall the server !
just wait a second :)
can u try to install for me after VPS reinstall ?
Yes.
-
Hi there.
It's been a bad day here. I have the same problem, and tried all approaches to solve by myself.
Could someone take a look to my box?
I can't wipe data since there're mail accounts for one of my customers AND it's a master in itself.
-
What's you mean 'wipe data'?.
-
I mean reprovision the server. Beforehand, I have to recover emaill accounts at least and make a backup for databases and /home for users.
-
1. if you forgot Kloxo Admin password. Execute command after logined VPS by SSH:
'sh /script/resetpassword kloxopassword' -> kloxo login password
2. if you could not login by correct admin password
- Reset Mysql Root password by:
'sh /script/reset-mysql-root-password mysqlrootpassword-> mysql root password
- Reset password that Kloxo use for connect to MySQL by
'sh /script/reset-mysql-kloxo-password mysqlrootpassword-> mysql kloxo database password (the same MySQL root password)