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, 19:59:07

Author Topic: No panel Crossover  (Read 7209 times)

0 Members and 1 Guest are viewing this topic.

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: No panel Crossover
« Reply #15 on: 2019-07-07, 02:22:02 »
1. Modified '/etc/my.cnf.d/server.cnf' where change 'socket=' to '#socket=' and then run 'sh /script/restart-mysql'
2. And then run 'sh /script/cleanup'.

Some servers (maybe OpenVZ) may trouble if mysql using socket for running.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline South

  • Valuable Member
  • *
  • Posts: 108
  • Karma: +0/-0
    • View Profile
Re: No panel Crossover
« Reply #16 on: 2019-07-07, 05:41:33 »
Hello the action taken tthat you actually depict is uncomment the mysqld as a whole or just the path to socket file please do clarify


[mysqld]
#socket=/var/lib/mysql/mysql.sock
max-allowed-packet=256M
performance-schema=on
default-storage-engine=myisam
skip-innodb
#OpenVZ AIO bug fix
innodb-use-native-aio=0
#OpenVZ AIO bug fix
innodb_use_native_aio=0

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: No panel Crossover
« Reply #17 on: 2019-07-07, 06:00:50 »
It's right.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline South

  • Valuable Member
  • *
  • Posts: 108
  • Karma: +0/-0
    • View Profile
Re: No panel Crossover
« Reply #18 on: 2019-07-07, 07:17:46 »
I did accordingly
then


*** Process for MYSQL/MARIADB service ***
Starting MariaDB.190706 23:51:55 mysqld_safe Logging to '/var/lib/mysql/SERVER.MYSERV.COM.err'.
190706 23:51:55 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
/etc/init.d/mysql: line 260: kill: (2896) - No such process
 ERROR!
  - Process: restart
 ERROR! MariaDB server PID file could not be found!
Starting MariaDB.190706 23:51:57 mysqld_safe Logging to '/var/lib/mysql/SERVER.MYSERV.COM.err'.
190706 23:51:57 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
/etc/init.d/mysql: line 260: kill: (3061) - No such process
 ERROR!
-------------------------------------------------------------------


then





-------------------------------------------------------------------

- For help, type '/script/restart-mysql [--help|-h]'
Execute fixlxphpexe for php56s...
*** Execute Update (cleanup) - BEGIN ***
>>> Execute fixDataBaseIssues() <<<
Fix Database Issues
- Fix admin account database settings
- Set default database settings
- Fix resourceplan settings in database
- Alter some database tables to fit that of Kloxo
- Set default welcome text at Kloxo login page
- Remove default db password if exists
>>> Execute doUpdates() <<<
- Create flag dir
Fix IP Address
- Fix process
Create domain backup dirs
- Create process
- Create OS system user admin
- User admin exists
Fix php.ini
- Fix process
Fix MySQL root password
- Fix process
Set admin contact email
- Set process
Get Kloxo License info
- Get process
- Create database interface template (Forced)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2 "No such file or directory")
>>> Execute driverload.php <<<
>>> Execute update_all_slave() <<<
>>> Execute cp_dbfile() <<<
>>> Execute updatecleanup() <<<
Prepare for Kloxo
- OS Create Kloxo init.d service file
- OS Fix programroot path permissions
- OS Restart Kloxo service
Remove Old dirs
- Remove process
Initialize Some Binary files
- Symlink /usr/local/bin/php already exists
Remove lighttpd errorlog
- Remove process
Fix the secure logfile
- Fix process
Clean hosts.deny
- Clean process
Synchronize driver between table and slavedb
- Synchronize for 'web' to 'apache'
- Synchronize for 'webcache' to 'none'
- Synchronize for 'dns' to 'bind'
- Synchronize for 'pop3' to 'courier'
- Synchronize for 'smtp' to 'qmail'
- Synchronize for 'spam' to 'bogofilter'
Update Services Branch List
- Wait to process...
Check for rpm packages
- autorespond-toaster package already installed
- courier-imap-toaster package already installed
- dovecot-toaster package already installed
- daemontools-toaster package already installed
- ezmlm-toaster package already installed
- libdomainkeys-toaster package already installed
- libsrs2-toaster package already installed
- maildrop-toaster package already installed
- qmail-toaster package already installed
- ripmime package already installed
- ucspi-tcp-toaster package already installed
- vpopmail-toaster package already installed
- fetchmail package already installed
- bogofilter package already installed
- spamdyke package already installed
- pure-ftpd package already installed
- webalizer package already installed
- dos2unix package already installed
- rrdtool package already installed
- xinetd package already installed
- lxjailshell package already installed
Initialize /script/ dir
- Initialize processes
Install jailshell to system
- Already exists
Set /home permission to 0755
- Set process
- chown apache:apache FOR /home/kloxo/httpd/ AND INSIDE
- chmod 644 FOR *.php* INSIDE /home/kloxo/httpd/
- chmod 755 FOR *.pl/cgi/py/rb INSIDE /home/kloxo/httpd/
- chmod 755 FOR /home/kloxo/httpd/ AND INSIDE
- chmod 771 FOR /home/kloxo/httpd/
Fix suexec
- Fix process
Install/Fix Services/Permissions/Configfiles
- Set permissions for /usr/bin/php-cgi
- Set permissions for closeinput binary
- Set permissions for phpsuexec.sh script
- Set permissions for /var/lib/php/session/ dir
chmod: cannot access `/var/lib/php/session/': No such file or directory
- Set permissions for /var/bogofilter/ dir
- Kill sisinfoc system process
Execute/remove/initialize/install script
- Execute vpopmail.sh
- Initialize /home/kloxo/httpd/script dir
- Remove /home/kloxo/httpd/script dir
- Set ownership apache:apache for /home/kloxo/httpd/script dir
- Install phpinfo.php into /home/kloxo/httpd/script dir
Remove cache dir
- Remove process
Initialize awstats dirdata
- Initialize process
Update Kloxo database
- Update process
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2 "No such file or directory")
Remove old lxlabs ssh key
- Remove process
Prepare MySQL/MariaDB service
- MariaDB activated
- Updating Main services
Update All packages
- WAIT to process...
- No update found/not installed
Remove /home/httpd/*/httpdocs
- Remove process
Add 'hostname' information to '/etc/hosts'
Initialize some skeletons
- Php files for default web page
- Skeleton for default web page
- robots.txt for default web page
- Php files for disable web page
- Skeleton for disable web page
- robots.txt for disable web page
- Php files for webmail web page
- Skeleton for webmail web page
- robots.txt for webmail web page
- Php files for cp web page
- Skeleton for cp web page
- robots.txt for cp web page
- Skeleton for error web page
- robots.txt for error web page
- chown apache:apache FOR /home/kloxo/httpd/ AND INSIDE
- chmod 644 FOR *.php* INSIDE /home/kloxo/httpd/
- chmod 755 FOR *.pl/cgi/py/rb INSIDE /home/kloxo/httpd/
- chmod 755 FOR /home/kloxo/httpd/ AND INSIDE
- chmod 771 FOR /home/kloxo/httpd/
- Php files for login web page
- Skeleton for panel login web page
- Skeleton for panel root web page
- Files for error web pages
- Skeleton for error web pages
- Copy error web pages to '/home/kloxo/httpd/error'
- No exists user-skeleton
- No exists user-logo
Initialize phpMyAdmin configfile
- phpMyAdmin: Set db password in configfile
Initialize OS admin account description
- Initialize process
Copy all contents from ../file/bind
- Copy to /opt/configs/bind
- Copy etc/named.conf to /etc/named.conf
Copy all contents from ../file/djbdns
- Copy to /opt/configs/djbdns
Copy all contents from ../file/pdns
- Copy to /opt/configs/pdns
- Copy etc/conf/pdns.conf to /etc/pdns/pdns.conf
Prepare PowerDNS database
- Install MySQL and Geo Backend
- Fix MySQL commands in import files
- Generate password
- Add Password to configuration file
Copy all contents from ../file/nsd
- Copy to /opt/configs/nsd
- Copy etc/conf/nsd4.conf to /etc/nsd/nsd.conf
Copy all contents from ../file/yadifa
- Copy to /opt/configs/yadifa
- Copy etc/yadifad.conf to /etc/yadifad.conf
Initialize apache config
- /etc/httpd/conf.d dir already exists
- /opt/configs/apache/tpl dir already exists
- /opt/configs/apache/conf dir already exists
- /opt/configs/apache/etc dir already exists
- /opt/configs/apache/etc/conf dir already exists
- /opt/configs/apache/etc/conf.d dir already exists
Copy all contents from ../file/apache
- Copy to /opt/configs/apache
- Copy etc/conf/httpd.conf to /etc/httpd/conf/httpd.conf
- chown root:root FOR /opt/configs/apache/ AND INSIDE
- chmod 755 FOR *.sh INSIDE /opt/configs/apache/
Initialize lighttpd config
- /etc/lighttpd/conf.d dir already exists
- /opt/configs/lighttpd/tpl dir already exists
- /opt/configs/lighttpd/conf dir already exists
- /opt/configs/lighttpd/etc dir already exists
- /opt/configs/lighttpd/etc/conf dir already exists
- /opt/configs/lighttpd/etc/conf.d dir already exists
Copy all contents from ../file/lighttpd
- Copy to /opt/configs/lighttpd
- Copy etc/conf/lighttpd.conf to /etc/lighttpd/lighttpd.conf
- chown root:root FOR /opt/configs/lighttpd/ AND INSIDE
- chmod 755 FOR *.sh INSIDE /opt/configs/lighttpd/
Initialize nginx config
- /etc/nginx/conf.d dir already exists
- /opt/configs/nginx/tpl dir already exists
- /opt/configs/nginx/conf dir already exists
- /opt/configs/nginx/etc dir already exists
- /opt/configs/nginx/etc/conf dir already exists
- /opt/configs/nginx/etc/conf.d dir already exists
Copy all contents from ../file/nginx
- Copy to /opt/configs/nginx
- Copy etc/conf/nginx.conf to /etc/nginx/nginx.conf
- chown root:root FOR /opt/configs/nginx/ AND INSIDE
- chmod 755 FOR *.sh INSIDE /opt/configs/nginx/
Initialize hiawatha config
- /etc/hiawatha/conf.d dir already exists
- /opt/configs/hiawatha/tpl dir already exists
- /opt/configs/hiawatha/conf dir already exists
- /opt/configs/hiawatha/etc dir already exists
- /opt/configs/hiawatha/etc/conf dir already exists
- /opt/configs/hiawatha/etc/conf.d dir already exists
Copy all contents from ../file/hiawatha
- Copy to /opt/configs/hiawatha
- Copy etc/conf/hiawatha_standard.conf to /etc/hiawatha/hiawatha.conf
- chown root:root FOR /opt/configs/hiawatha/ AND INSIDE
- chmod 755 FOR *.sh INSIDE /opt/configs/hiawatha/
Copy all contents from ../file/varnish
- Copy to /opt/configs/varnish
Copy all contents from ../file/trafficserver
- Copy to /opt/configs/trafficserver
Copy all contents from ../file/squid
- Copy to /opt/configs/squid
Install All Dns servers
- No process for 'bind'
- No process for 'djbdns'
- No process for 'pdns'
- No process for 'nsd'
- No process for 'yadifa'
Inactivate DNS servers
- Inactivate 'bind'
- Inactivate 'djbdns'
- Inactivate 'pdns'
- Inactivate 'nsd'
- Inactivate 'yadifa'
Activate Dns servers
- Activate 'bind' as Dns server
Install All Web servers
- No process for 'apache' ('httpd')
- No process for 'lighttpd'
- No process for 'nginx'
- No process for 'hiawatha'
Inactivate Web servers
- Inactivate 'apache'
- Inactivate 'lighttpd'
- Inactivate 'nginx'
- Inactivate 'hiawatha'
Activate Web servers
- Activate 'apache' as Web server
Update All Php (branch and multiple)
- Update process
Initialize PureFtp service
- Initialize process
- Restart pure-ftpd service
Initialize logrotates
- Initialize process
Copy awstats_index.php to /home/kloxo/httpd/awstats/wwwroot/cgi-bin
Install Webmail chooser
- Install process
Initialize Mail service
- Initialize process
Set All SSL Portions
- Copy 'openssl' config Files
Copy all contents from ../file/openssl
- Copy to /opt/configs/openssl
- Copy 'acme.sh' config Files
Copy all contents from ../file/acme.sh
- Copy to /opt/configs/acme.sh
- Install acme.sh
- Fix SSL path
- Copy 'httpry' config Files
Copy all contents from ../file/httpry
- Copy to /opt/configs/httpry
- Install httpry
- Fix 'Cron Backup' Files
Set Watchdog defaults
- Set process
Fix services
- Fix dns services
- Fix webcache services
- Fix ssl services
- Fix php services
- Fix web services
- Fix mail-all services
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2 "No such file or directory")
Enter password:
Enter password:
Enter password:
Enter password:
Enter password:
Enter password:
Enter password:
Enter password:
Enter password:
Enter password:
Enter password:
Enter password:
Enter password:
Enter password:
Enter password:
Enter password:
Enter password:
Enter password:
Enter password:
Enter password:
Enter password:
Enter password:
Enter password:
Enter password:
Enter password:
Enter password:



Enter password:


- Fix ftp-all services
- Fix skeleton services
- Fix Hiawatha service
*** Execute Update (cleanup) - END ***

*** Restart services - BEGIN ***

MariaDB server PID file could not be found!                [FAILED]
Starting MariaDB.190706 23:58:53 mysqld_safe Logging to '/var/lib/mysql/SERVER.MYSERV.COM.err'.
190706 23:58:53 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
/etc/init.d/mysql: line 260: kill: (16599) - No such process
                                                           [FAILED]
-------------------------------------------------------------------

Stopping named: .                                          [  OK  ]
Starting named:                                            [  OK  ]
-------------------------------------------------------------------

Stopping php-fpm (PHP Used):                               [FAILED]
Starting php-fpm (PHP Used): [06-Jul-2019 23:58:57] NOTICE: PHP message: PHP Warning:  Module 'curl' already loaded in Unknown on line 0
[06-Jul-2019 23:58:57] NOTICE: PHP message: PHP Warning:  Module 'fileinfo' already loaded in Unknown on line 0
[06-Jul-2019 23:58:57] NOTICE: PHP message: PHP Warning:  Module 'json' already loaded in Unknown on line 0
[06-Jul-2019 23:58:57] NOTICE: PHP message: PHP Warning:  Module 'Phar' already loaded in Unknown on line 0
[06-Jul-2019 23:58:57] NOTICE: PHP message: PHP Warning:  Module 'zip' already loaded in Unknown on line 0
[06-Jul-2019 23:58:57] ERROR: unable to bind listening socket for address '/opt/configs/php-fpm/sock/php-apache.sock': No such file or directory (2)
[06-Jul-2019 23:58:57] ERROR: FPM initialization failed
                                                           [FAILED]
-------------------------------------------------------------------

Stopping httpd:                                            [  OK  ]
Starting httpd:                                            [  OK  ]
-------------------------------------------------------------------


*** Process for QMAIL service ***
Stopping qmail-toaster: svscan qmail logging.
qmail-send: no process killed
Starting qmail-toaster: svscan.
-------------------------------------------------------------------

- For help, type '/script/restart-mail [--help|-h]'
-------------------------------------------------------------------

Stopping pure-ftpd:                                        [  OK  ]
Starting pure-ftpd:                                        [  OK  ]
-------------------------------------------------------------------
*** Restart services - END ***


*** Process Time: 00:00:04:04.244896 (dd:hh:mm:ss:xxxxxx) ***


REMARK:
 - run 'sh /script/fixdnsaddstatsrecord' to make sure dns records including
   'A record' for 'stats'
 - 'http://domain.com/stats' will be redirect to 'http://stats.domain.com'







then I
sh /script/clearallowedblockedip --class=client --name=admin
sh /script/resetpassword master mysupposedadmin password
sh /script/restart

Still could not login to control panel then I edited my.cnf this way


#
# This group is read both both by the client and the server
# use it for options that affect everything
#
[client-server]
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
password=MYROOTPASS
port            = 3306
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /tmp
language        = /usr/share/mysql/english
skip-external-locking
old_passwords   = 1
bind-address            = 127.0.0.1
key_buffer              = 16M
key_buffer_size         = 32M
max_allowed_packet      = 16M
thread_stack            = 128K
thread_cache_size       = 64
query_cache_limit       = 8M
query_cache_size        = 64M
query_cache_type        = 1
join_buffer_size        = 512K
max_connections         = 150
log_slow_queries        = /var/log/mysql/mysql-slow.log
skip-bdb
skip-innodb

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

[client]
default-character-set=utf8
socket=/var/lib/mysql/mysql.sock

[mysqld_safe]
socket          = /var/lib/mysql/mysql.sock
nice            = 0


#
# include all files from the config directory
#
!includedir /etc/my.cnf.d

After this it was the same no control panel login thanks

Offline South

  • Valuable Member
  • *
  • Posts: 108
  • Karma: +0/-0
    • View Profile
Re: No panel Crossover
« Reply #19 on: 2019-07-09, 05:29:44 »
 Process for MYSQL/MARIADB service ***
Starting MariaDB.190706 23:51:55 mysqld_safe Logging to '/var/lib/mysql/SERVER.MYSERV.COM.err'.
190706 23:51:55 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql


~~~~~~~~~~
here var/lib/mysql      NO SOCKET FILE

Maybe I need a socket file for mysql-MariaDB MR or find where its allocated in kloxo dont you think?

Where I find mariaDB socket in kloxo?
« Last Edit: 2019-07-09, 05:31:19 by South »

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: No panel Crossover
« Reply #20 on: 2019-07-09, 10:17:45 »
Socket create by Apps automatically.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline South

  • Valuable Member
  • *
  • Posts: 108
  • Karma: +0/-0
    • View Profile
Re: No panel Crossover
« Reply #21 on: 2019-07-10, 07:25:24 »
Yes thank you but somehow its visible somewhere,it also aint present at var/run/mysql

Do you know where it should be MariaDB socket;?

Also can you please tell me how my.cnf should be configured please?

Offline azzureal

  • Master
  • **
  • Posts: 420
  • Karma: +1/-0
    • View Profile
Re: No panel Crossover
« Reply #22 on: 2019-07-10, 07:47:11 »
Where I find mariaDB socket in kloxo?

1. it is located in /var/lib/mysql.

if u got a socket error  message, please check tmp folder.

If u can find it, let's do it.

ln -s /var/lib/mysql/mysql.sock in tmp folder.

2. if u can't find sock in mysql folder

please reset your mysql root password

sh /script/reset-mysql-root-password password

3. u may meet passwrd error.

Please make .my.cnf in root folder

write
[client]
user="root"
pass="mysql root passwrd"


« Last Edit: 2019-07-10, 07:52:13 by azzureal »

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: No panel Crossover
« Reply #23 on: 2019-07-10, 10:50:56 »
Reset mysql root password have trouble because missing certain dir. Run 'mkdir /usr/local/lxlabs/kloxo/serverfile' to fix this issue.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline South

  • Valuable Member
  • *
  • Posts: 108
  • Karma: +0/-0
    • View Profile
Re: No panel Crossover
« Reply #24 on: 2019-07-10, 11:42:10 »
i did all the steps you mentioned azzureal also my.cnf was already configured like that and I added the dir that MR just told us and resetted mysql password via sh /script and no process ,also via ssh mysql dont restart

service mysql restart
MariaDB server PID file could not be found!                [FAILED]
Starting MariaDB.190710 05:31:37 mysqld_safe Logging to '/var/lib/mysql/SERVER.MYSERV.COM.err'.
190710 05:31:37 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
/etc/init.d/mysql: line 260: kill: (2741) - No such process
                                                           [FAILED]

Stop MySQL service...
MySQL ROOT password reset...
Start MySQL service...
/etc/init.d/mysql: line 260: kill: (3413) - No such process
Connect failed: No such file or directory


Thank you for taking the time to read God bless everybody
« Last Edit: 2019-07-10, 11:44:46 by South »

Offline South

  • Valuable Member
  • *
  • Posts: 108
  • Karma: +0/-0
    • View Profile
Re: No panel Crossover
« Reply #25 on: 2019-07-18, 17:12:22 »
I have to thank you oh so much lovely azzureal,I rebooted my server did a yum clean all and re do all your steps reseted password and voila Im back again accesing into my control panel kloxo as admin ,I can login thank you very much the only think for me is that I got some bunch of glamurous guys waiting for me that need to log as users of my server and they can not login since kloxo dont allow users setted via ssh and this guys are programing workers that need to meet schedulle they access my server via ssh and ftp .Please tell me how to make kloxo allow wheel users from ssh?
« Last Edit: 2019-07-18, 17:15:38 by South »

 


Top 10 Social Networking:    Facebook    Twitter    LinkedIn    Pinterest    Google Plus    Tumblr    Instagram    VK    Flickr    Vine
Click Here

Page created in 0.042 seconds with 21 queries.

web stats analysis