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

Title: Fresh install cant access control panel
Post 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
Title: Re: Fresh install cant access control panel
Post by: azzureal on 2018-07-11, 09:02:44
Try this  in /root/.my.cnf

user=root
password="pass"
Title: Re: Fresh install cant access control panel
Post by: South on 2018-07-29, 05:41:51
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


Title: Re: Fresh install cant access control panel
Post by: azzureal on 2018-08-03, 13:04:37
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
Title: Re: Fresh install cant access control panel
Post by: South on 2018-08-06, 05:48:02
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
Title: Re: Fresh install cant access control panel
Post by: azzureal on 2018-08-10, 12:29:34
please twice sh /script/reset-mysql-kloxo-password wiggypop and then reset pasword again
Title: Re: Fresh install cant access control panel
Post by: azzureal on 2018-08-12, 05:53:41
Try 'sh /script/fix-missing-admin'
Title: Re: Fresh install cant access control panel
Post by: South on 2018-08-15, 03:27:41
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
Title: Re: Fresh install cant access control panel
Post by: azzureal on 2018-08-16, 12:36:16
In my case, I uninstalled klox and reinstall.

yum remove kloxomr7 ,mratwork-*

and reinstall
Title: Re: Fresh install cant access control panel
Post by: South on 2018-08-17, 19:33:52
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
Title: Re: Fresh install cant access control panel
Post by: azzureal on 2018-08-25, 04:59:58
Please list sh /script/sysinfo
Title: Re: Fresh install cant access control panel
Post by: South on 2018-08-28, 03:27:50

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
Title: Re: Fresh install cant access control panel
Post by: azzureal on 2018-09-01, 05:17:04
I doubt. admin account is disabled in kloxo database.

check client table of db kloxo.

If status field is off, please set to on.
Title: Re: Fresh install cant access control panel
Post by: South on 2018-09-02, 04:07:01
Please please please tell me how to get there man

|Path|
Title: Re: Fresh install cant access control panel
Post by: azzureal on 2018-09-02, 05:07:34
install phpmyadmin and it.
Title: Re: Fresh install cant access control panel
Post by: South on 2018-09-05, 02:14:55
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
Title: Re: Fresh install cant access control panel
Post by: azzureal on 2018-09-08, 12:57:52
you can install it your account.

download phpmyadmin and upload to your acct by ftp.


Title: Re: Fresh install cant access control panel
Post by: South on 2018-09-09, 19:36:26
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
Title: Re: Fresh install cant access control panel
Post by: azzureal on 2018-09-10, 09:07:37
run mysql via ssh

MariaDB [(none)]> use kloxo
MariaDB [(none)]>select cpstatus,status from client  where nname = 'admin';
Title: Re: Fresh install cant access control panel
Post by: South on 2018-09-12, 20:00:13
 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 `('
Title: Re: Fresh install cant access control panel
Post by: South on 2018-09-12, 20:17:44
[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]'
Title: Re: Fresh install cant access control panel
Post by: azzureal on 2018-09-13, 05:09:10
Did u run cleanup?
Title: Re: Fresh install cant access control panel
Post by: azzureal on 2018-09-13, 05:10:40
Please run /script/upcp -y
and cleanup

Title: Re: Fresh install cant access control panel
Post by: azzureal on 2018-09-13, 05:11:09
ls /var/lib/mysql/*

Please check kloxo db
Title: Re: Fresh install cant access control panel
Post by: South on 2018-09-14, 01:33:03
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
Title: Re: Fresh install cant access control panel
Post by: South on 2018-09-14, 01:55:01
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
Title: Re: Fresh install cant access control panel
Post by: azzureal on 2018-09-15, 03:04:36
Please list

ls /var/lib/mysql/*

if u have kloxo

ls /var/lib/mysql/kloxo/*
Title: Re: Fresh install cant access control panel
Post by: South on 2018-09-19, 03:45:40
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
Title: Re: Fresh install cant access control panel
Post by: azzureal on 2018-09-19, 06:46:51
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
Title: Re: Fresh install cant access control panel
Post by: azzureal on 2018-09-19, 06:50:07
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


Title: Re: Fresh install cant access control panel
Post by: South on 2018-09-20, 02:11:05
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
Title: Re: Fresh install cant access control panel
Post by: azzureal on 2018-09-20, 09:00:07
i tried  many times to reinstall  for fixing the same problem.
Title: Re: Fresh install cant access control panel
Post by: South on 2018-09-24, 23:41:20
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?
Title: Re: Fresh install cant access control panel
Post by: South on 2018-09-25, 01:37:39
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.