MRatWork Forum by Mustafa Ramadhan
Sawo Project - Kloxo-MR Discussions => Kloxo-MR Technical Helps => Topic started by: South on 2018-07-10, 12:24:44
-
Hello Im on centos 6x and installed kloxoMR7 but cant access control panel on first instance with the default admin password
I get this errors
error: 'Access denied for user 'root'@'localhost' (using password: YES)'
-bash: /script/clearallowedblockedip: Permission denied
-bash: /script/update: Permission denied
Please provide support if you can I will be glad
-
Try this in /root/.my.cnf
user=root
password="pass"
-
That file is for mysql root password it need an statement first because I have [client]
maybe for kloxo control panel password could be other thing
Look I cant login to kloxo because Im using CWP along since CWP cant restore kloxo backup files,so I can only login to CWP but I cant login to kloxo it just dont accept admin as first time password
-
1 'sh /script/reset-mysql-root-password your password-> mysql root password
2. 'sh /script/reset-mysql-kloxo-password your password-> mysql kloxo database password
3. 'sh /script/resetpassword master your password-> kloxo login password
-
Yes thank you very much that aint the proper syntax,I tried as following:
sh /script/reset-mysql-root-password wiggypop
Stop MySQL service...
MySQL ROOT password reset...
Start MySQL service...
sh /script/reset-mysql-kloxo-password wiggypop
grant all on kloxo.* to kloxo@localhost identified by 'wiggypop'
sh /script/resetpassword master brickerset54654
Error message: only_admin_can_modify_general nname
Still I get by trying to asccess admin on control panel
login unsuccesfull
I also tried:
/script/resetpassword master brickerset54654
-bash: /script/resetpassword: Permission denied
-
please twice sh /script/reset-mysql-kloxo-password wiggypop and then reset pasword again
-
Try 'sh /script/fix-missing-admin'
-
sh /script/reset-mysql-kloxo-password wiggypop
grant all on kloxo.* to kloxo@localhost identified by 'wiggypop'
sh /script/fix-missing-adminsh /script/fix-missing-admin
This script will be fixed an issue:
- Run 'sh /script/resetpassword' will appear 'only_admin_can_modify_general'
- Fail login as 'admin' with error 'This login has been Disabled'
sh /script/resetpassword
Usage: ../bin/common/resetpassword.php <master/slave> <password>
Note:
- Process just only running 'sh /script/reset-mysql-root-password' an
'sh /script/reset-mysql-kloxo-password'
This script will be fixed an issue:
- Run 'sh /script/resetpassword' will appear 'only_admin_can_modify_general'
- Fail login as 'admin' with error 'This login has been Disabled'
reset-mysql-kloxo-password
I guess admin login is disabled
Thank you very much for awesome support
-
In my case, I uninstalled klox and reinstall.
yum remove kloxomr7 ,mratwork-*
and reinstall
-
Wouldnt it be the fact that kloxo aint master panel and thats why admin is disabled?,do you know in which file I can set kloxo to be master?
Thank you
-
Please list sh /script/sysinfo
-
A. Control Panel:
- Kloxo-MR: 7.0.0.c-2017091202
- Web: hiawatha-10.6.0-f.1.mr.el6.x86_64
- PHP: php56s - 5.6.36-1.ius.centos6 (fpm mode)
B. Plateform:
- OS: CentOS release 6.10 (Final) x86_64
- Hostname: SERVER.NAILS.COM
C. Services:
1. MySQL: MariaDB-server-10.1.34-1.el6.x86_64
2. PHP:
- Installed:
- Branch: php56u-cli-5.6.36-1.ius.centos6.x86_64
- Used: --PHP Branch--
- Multiple: disable
3. Web Used: apache
- Hiawatha: hiawatha-10.6.0-f.1.mr.el6.x86_64
- Lighttpd: --uninstalled--
- Nginx: --uninstalled--
- Apache: --uninstalled--
- PHP Type: php-fpm_event (default)
- Secondary PHP: off
4. WebCache: none
- ATS: --uninstalled--
- Squid: --uninstalled--
- Varnish: --uninstalled--
5. Dns: bind
- Bind: bind-9.9.9-1.mr.el6.x86_64
- DJBDns: --uninstalled--
- NSD: --uninstalled--
- PowerDNS: --uninstalled--
- Yadifa: --uninstalled--
6. Mail: qmail-toaster-1.03-1.3.57.mr.el6.x86_64
- with: dovecot-2.2.18-1.mr.el6.x86_64
- pop3/imap4: none
- smtp: qmail-toaster-1.03-1.3.57.mr.el6.x86_64
- spam: bogofilter-1.2.4-1.el6.x86_64
7. FTP: pure-ftpd
- pure-ftpd: pure-ftpd-1.0.37-1.mr.el6.x86_64
8. Stats: awstats
- awstats: kloxomr-stats-awstats-7.6-1.mr.noarch
Thank U
-
I doubt. admin account is disabled in kloxo database.
check client table of db kloxo.
If status field is off, please set to on.
-
Please please please tell me how to get there man
|Path|
-
install phpmyadmin and it.
-
kloxomr7-thirdparty-phpmyadmin-4.6.6-1.mr.noarch already installed and latest version
I cant access PhpMyAdmin via browser ,is there a way to do it SSH way?
I remember you can check tables on PhpMyAdmin ,never did it via ssh
Are you sure it aint the fact kloxo aint master?
Thank you
-
you can install it your account.
download phpmyadmin and upload to your acct by ftp.
-
How do I access that table via ssh?
Please tell me how to find path to make kloxo master I guess it is in slave mode
phpMy Admin is already installed by default I just showed you but I told you I cant access it via browser I need my badge men ,please tell me how to access ssh
thanks
-
run mysql via ssh
MariaDB [(none)]> use kloxo
MariaDB [(none)]>select cpstatus,status from client where nname = 'admin';
-
MariaDB [(none)]> use kloxo
-bash: syntax error near unexpected token `('
MariaDB [(none)]>select cpstatus,status from client where nname = 'admin';
-bash: syntax error near unexpected token `('
-
[root@SERVER ~]# sh /script/make-master
* Already as master
[root@SERVER ~]# sh /script/restart-all
Shutting down system logger: [ OK ]
Starting system logger: [ OK ]
-------------------------------------------------------------------
Stopping httpry: [ OK ]
Starting httpry: [ OK ]
-------------------------------------------------------------------
*** Process for MYSQL/MARIADB service ***
- Process: restart
Shutting down MariaDB. SUCCESS!
Starting MariaDB.180912 14:13:45 mysqld_safe Logging to '/var/lib/mysql/SERVER.NAILS.COM.err'.
180912 14:13:45 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
SUCCESS!
-------------------------------------------------------------------
*** Process for MYSQL/MARIADB service ***
- Process: restart
Shutting down MariaDB. SUCCESS!
Starting MariaDB.180912 14:13:49 mysqld_safe Logging to '/var/lib/mysql/SERVER.NAILS.COM.err'.
180912 14:13:49 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
SUCCESS!
-------------------------------------------------------------------
Stopping php-fpm: [FAILED]
Starting php-fpm: [12-Sep-2018 14:13:50] ERROR: [pool php-default] cannot get uid for user 'apache'
[12-Sep-2018 14:13:50] ERROR: FPM initialization failed
[FAILED]
-------------------------------------------------------------------
*** Process for HTTPD service ***
- Process: restart
Stopping httpd: [FAILED]
Starting httpd: /bin/bash: /usr/sbin/httpd.event: No such file or directory
[FAILED]
-------------------------------------------------------------------
*** Process for QMAIL service ***
Stopping qmail-toaster: svscan qmail logging.
Starting qmail-toaster: svscan.
-------------------------------------------------------------------
./run: line 4: /usr/bin/envconv: No such file or directory
Starting kloxo-hiawatha: [ OK ]
-------------------------------------------------------------------
Stopping kloxo-phpcgi: [ OK ]
Starting kloxo-phpcgi ('php56s' in 'fpm' mode): [ OK ]
-------------------------------------------------------------------
Kloxo Wrapper -> STOP
Kloxo Wrapper -> START
-------------------------------------------------------------------
- For help, type '/script/restart-all [--help|-h]'
sh /script/restart-web
root@SERVER ~]# sh /script/restart-web
Stopping php-fpm: [FAILED]
Starting php-fpm: [12-Sep-2018 14:18:33] ERROR: [pool php-default] cannot get ud for user 'apache'
[12-Sep-2018 14:18:33] ERROR: FPM initialization failed
[FAILED]
-------------------------------------------------------------------
*** Process for HTTPD service ***
- Process: restart
Stopping httpd: [FAILED]
Starting httpd: /bin/bash: /usr/sbin/httpd.event: No such file or directory
[FAILED]
-------------------------------------------------------------------
- For help, type '/script/restart-web [--help|-h]'
-
Did u run cleanup?
-
Please run /script/upcp -y
and cleanup
-
ls /var/lib/mysql/*
Please check kloxo db
-
Please provide exact path of kloxo db file
Please provide file name and extension so I can find if is set to off
var/lib/mysql ?
script upcp
Script started, file is upcp
thank u
-
From pid file
[ERROR] mysqld: Can't create/write to file '/usr/local/lxlabs/kloxo/serverfile/reset-mysql-password.sql' (Errcode: 2 "No such file or directory")
[ERROR] mysqld: Can't create/write to file '/usr/local/lxlabs/kloxo/serverfile/reset-mysql-password.sql' (Errcode: 2 "No such file or directory")
db.frm on var/lib/mysql/mysql cant open that file
-
Please list
ls /var/lib/mysql/*
if u have kloxo
ls /var/lib/mysql/kloxo/*
-
Hello on var/lib/mysql/kloxo I have the following files
client.frm
domain.frm
web.frm
mmail.frm
mailaccount.frm
pserver.frm
servermail.frm
ftpuser.frm
uuser.frm
davuser.frm
mailinglist.frm
auxiliary.frm
lxbackup.frm
ticket.frm
ipaddress.frm
service.MYI
domaintraffic.MYI
mysqldb.frm
mssqldb.frm
cron.frm
installsoft.frm
domaintemplate.frm
anonftpipaddress.frm
anonftpipaddress.frm
anonftpipaddress.frm
,,,,,and many more
Which is the particular file here_?
Also how to edit it via ssh ,I cant open frm and MYI ,maybe I need a new Text editor on centos 7 to open this particular files thank you
-
your kloxo database was broken. all table need MYI.
actionlog.MYD blockedip.MYI dbadmin.MYI domainipaddress.frm hostdeny.MYD loginattempt.MYI mailfilter.frm mysqldb.MYD proxy.MYI sendmailban.frm sp_childspecialplay.MYD sslipaddress.MYI watchdog.frm
actionlog.MYI blockedip.frm dbadmin.frm domaintemplate.MYD hostdeny.MYI loginattempt.frm mailforward.MYD mysqldb.MYI proxy.frm serverftp.MYD sp_childspecialplay.MYI sslipaddress.frm web.MYD
actionlog.frm client.MYD dirprotect.MYD domaintemplate.MYI hostdeny.frm lxbackup.MYD mailforward.MYI mysqldb.frm proxyacl.MYD serverftp.MYI sp_childspecialplay.frm ticket.MYD web.MYI
addondomain.MYD client.MYI dirprotect.MYI domaintemplate.frm installsoft.MYD lxbackup.MYI mailforward.frm mysqldbuser.MYD proxyacl.MYI serverftp.frm sp_lstclass.MYD ticket.MYI web.frm
addondomain.MYI client.frm dirprotect.frm domaintraffic.MYD installsoft.MYI lxbackup.frm mailinglist.MYD mysqldbuser.MYI proxyacl.frm servermail.MYD sp_lstclass.MYI ticket.frm webhandler.MYD
addondomain.frm clienttemplate.MYD dns.MYD domaintraffic.MYI installsoft.frm lxguard.MYD mailinglist.MYI mysqldbuser.frm pserver.MYD servermail.MYI sp_lstclass.frm ticketconfig.MYD webhandler.MYI
allowedip.MYD clienttemplate.MYI dns.MYI domaintraffic.frm interface_template.MYD lxguard.MYI mailinglist.frm ndskshortcut.MYD pserver.MYI servermail.frm sp_specialplay.MYD ticketconfig.MYI webhandler.frm
allowedip.MYI clienttemplate.frm dns.frm driver.MYD interface_template.MYI lxguard.frm mimetype.MYD ndskshortcut.MYI pserver.frm serverspam.MYD sp_specialplay.MYI ticketconfig.frm webmimetype.MYD
allowedip.frm cron.MYD dnsslave.MYD driver.MYI interface_template.frm lxguardhit.MYD mimetype.MYI ndskshortcut.frm rdnsrange.MYD serverspam.MYI sp_specialplay.frm tickethistory.MYD webmimetype.MYI
anonftpipaddress.MYD cron.MYI dnsslave.MYI driver.frm ipaddress.MYD lxguardhit.MYI mimetype.frm ndsktoolbar.MYD rdnsrange.MYI serverspam.frm spam.MYD tickethistory.MYI webmimetype.frm
anonftpipaddress.MYI cron.frm dnsslave.frm firewall.MYD ipaddress.MYI lxguardhit.frm mmail.MYD ndsktoolbar.MYI rdnsrange.frm serverweb.MYD spam.MYI tickethistory.frm
anonftpipaddress.frm customaction.MYD dnstemplate.MYD firewall.MYI ipaddress.frm lxguardwhitelist.MYD mmail.MYI ndsktoolbar.frm resourceplan.MYD serverweb.MYI spam.frm utmp.MYD
aspnet.MYD customaction.MYI dnstemplate.MYI firewall.frm jailed.MYD lxguardwhitelist.MYI mmail.frm notification.MYD resourceplan.MYI serverweb.frm ssession.MYD utmp.MYI
aspnet.MYI customaction.frm dnstemplate.frm ftpuser.MYD jailed.MYI lxguardwhitelist.frm module.MYD notification.MYI resourceplan.frm service.MYD ssession.MYI utmp.frm
aspnet.frm custombutton.MYD domain.MYD ftpuser.MYI jailed.frm lxupdate.MYD module.MYI notification.frm reversedns.MYD service.MYI ssession.frm uuser.MYD
autoresponder.MYD custombutton.MYI domain.MYI ftpuser.frm license.MYD lxupdate.MYI module.frm odbc.MYD reversedns.MYI service.frm sshconfig.MYD uuser.MYI
autoresponder.MYI custombutton.frm domain.frm general.MYD license.MYI lxupdate.frm mssqldb.MYD odbc.MYI reversedns.frm skipbackup.MYD sshconfig.MYI uuser.frm
autoresponder.frm davuser.MYD domaindefault.MYD general.MYI license.frm mailaccount.MYD mssqldb.MYI odbc.frm rubyrails.MYD skipbackup.MYI sshconfig.frm version.MYD
auxiliary.MYD davuser.MYI domaindefault.MYI general.frm llog.MYD mailaccount.MYI mssqldb.frm phpini.MYD rubyrails.MYI skipbackup.frm sslcert.MYD version.MYI
auxiliary.MYI davuser.frm domaindefault.frm genlist.MYD llog.MYI mailaccount.frm mssqldbuser.MYD phpini.MYI rubyrails.frm smessage.MYD sslcert.MYI version.frm
auxiliary.frm db.opt domainipaddress.MYD genlist.MYI llog.frm mailfilter.MYD mssqldbuser.MYI phpini.frm sendmailban.MYD smessage.MYI sslcert.frm watchdog.MYD
blockedip.MYD dbadmin.MYD domainipaddress.MYI genlist.frm loginattempt.MYD mailfilter.MYI mssqldbuser.frm proxy.MYD sendmailban.MYI smessage.frm sslipaddress.MYD watchdog.MYI
-
So please reinstall mysql.
yum remove mratwork-* -y
yum removekloxomr7 -y
yum remove Maria*
rm -rvf /var/lib/mysql
rm -rvf /etc/init.d/mysql
killall -9 mysql*
try step by new installation.
when u enter upcp -y intead of upcp
-
Yes papi but you are communicating in missled way
1-You depict the need of mysql re install
,then
2-You depict the needage of KloxoMR re install
Now wouldnt it be better to remove mysql,then reinstall mysql server?
I guess this wouldnt fix the kloxo database aint it?
much greatfull thanks have nice day
-
i tried many times to reinstall for fixing the same problem.
-
Ok we gonna try thank youvery much for your support eventough reinstall of kloxo may be a little bit sujective and might or might not work but Im gonna try for sure
You say on kloxo installation use upcp -y to do the final move and that it?
-
Hello hello
We followed every instruction
this
killall -9 mysql*
syntax wrong ,apart from this issue we used everything installation asked for a password
we just hit enter
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
chown: invalid user: `apache:apache'
Enter password:
We restarted everything and it seems fine but it dont restart with httpd
still cant login with using admin admin as first login
It seemed that CWP could live in harmony along with kloxoMR7 the way that kloxoMR7 does with Webmin
however thanks for helping me,since CWP has this PHP and mysql switcher it makes seem that restoring my kloxo files is easier since it dont have prohibitions to old mysql versions or php versions you just can bring anything you can and having kloxo along it seemed like a freaky little friendship that could turn in to something else,well maybe it could.