Sponsor:

Server and Web Integrator
Link:
Kloxo-MR logo
6.5.0 or 7.0.0
Click for "How to install"
Donation/Sponsorship:
Kloxo-MR is open-source.
Donate and or Sponsorship always welcome.
Click to:
Click Here
Please login or register. 2024-03-28, 18:23:28

Author Topic: Fresh install cant access control panel  (Read 28308 times)

0 Members and 3 Guests are viewing this topic.

Offline South

  • Valuable Member
  • *
  • Posts: 108
  • Karma: +0/-0
    • View Profile
Re: Fresh install cant access control panel
« Reply #15 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

Offline azzureal

  • Master
  • **
  • Posts: 420
  • Karma: +1/-0
    • View Profile
Re: Fresh install cant access control panel
« Reply #16 on: 2018-09-08, 12:57:52 »
you can install it your account.

download phpmyadmin and upload to your acct by ftp.



Offline South

  • Valuable Member
  • *
  • Posts: 108
  • Karma: +0/-0
    • View Profile
Re: Fresh install cant access control panel
« Reply #17 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

Offline azzureal

  • Master
  • **
  • Posts: 420
  • Karma: +1/-0
    • View Profile
Re: Fresh install cant access control panel
« Reply #18 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';

Offline South

  • Valuable Member
  • *
  • Posts: 108
  • Karma: +0/-0
    • View Profile
Re: Fresh install cant access control panel
« Reply #19 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 `('

Offline South

  • Valuable Member
  • *
  • Posts: 108
  • Karma: +0/-0
    • View Profile
Re: Fresh install cant access control panel
« Reply #20 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]'
« Last Edit: 2018-09-12, 20:21:53 by South »

Offline azzureal

  • Master
  • **
  • Posts: 420
  • Karma: +1/-0
    • View Profile
Re: Fresh install cant access control panel
« Reply #21 on: 2018-09-13, 05:09:10 »
Did u run cleanup?

Offline azzureal

  • Master
  • **
  • Posts: 420
  • Karma: +1/-0
    • View Profile
Re: Fresh install cant access control panel
« Reply #22 on: 2018-09-13, 05:10:40 »
Please run /script/upcp -y
and cleanup


Offline azzureal

  • Master
  • **
  • Posts: 420
  • Karma: +1/-0
    • View Profile
Re: Fresh install cant access control panel
« Reply #23 on: 2018-09-13, 05:11:09 »
ls /var/lib/mysql/*

Please check kloxo db

Offline South

  • Valuable Member
  • *
  • Posts: 108
  • Karma: +0/-0
    • View Profile
Re: Fresh install cant access control panel
« Reply #24 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

Offline South

  • Valuable Member
  • *
  • Posts: 108
  • Karma: +0/-0
    • View Profile
Re: Fresh install cant access control panel
« Reply #25 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

Offline azzureal

  • Master
  • **
  • Posts: 420
  • Karma: +1/-0
    • View Profile
Re: Fresh install cant access control panel
« Reply #26 on: 2018-09-15, 03:04:36 »
Please list

ls /var/lib/mysql/*

if u have kloxo

ls /var/lib/mysql/kloxo/*

Offline South

  • Valuable Member
  • *
  • Posts: 108
  • Karma: +0/-0
    • View Profile
Re: Fresh install cant access control panel
« Reply #27 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

Offline azzureal

  • Master
  • **
  • Posts: 420
  • Karma: +1/-0
    • View Profile
Re: Fresh install cant access control panel
« Reply #28 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

Offline azzureal

  • Master
  • **
  • Posts: 420
  • Karma: +1/-0
    • View Profile
Re: Fresh install cant access control panel
« Reply #29 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



 


MRatWork Affiliates:    BIGRAF(R) Inc.    House of LMAR    EFARgrafix
Click Here

Page created in 0.06 seconds with 22 queries.

web stats analysis