MRatWork Forum by Mustafa Ramadhan

Sawo Project - Kloxo-MR Discussions => Kloxo-MR Technical Helps => Topic started by: South on 2019-05-17, 04:21:10

Title: No panel Crossover
Post by: South on 2019-05-17, 04:21:10
Hello I actually got the configuration of old kloxo 32 bit but on a centos 6x machine and my apache works good my question is about installing kloxo mr7 on top of actual configuration might end up loosing all of my achievement since klxo uses MariaDB as default and nginx so I preety much figure out it might erase or uninstall my previous configuration.How can I know if installing kloxoMR7 on top will allow me to switch to my pre existing config please let me know
Title: Re: No panel Crossover
Post by: MRatWork on 2019-05-17, 04:39:05
Please read https://github.com/mustafaramadhan/kloxo/blob/dev/how-to-install.txt about it.
Title: Re: No panel Crossover
Post by: South on 2019-05-19, 00:27:01
Welcome back to the sattle of pawer Mustafa,I hadnt seen a so in dept guide for Kloxo Official users ,it truly seems things are gonna keep on work but..................in a slight diferent manner for example mysql is gonna be mysql 5.1and I dont really know if this guide will allow me to keep previous lamp config starring apache 2.2 ,I dont know if it will remove it but it sounds like apache is gonna keep hanging on thank you
Title: Re: No panel Crossover
Post by: South on 2019-05-27, 04:10:18
Im seeing this guide will prepare mysql 5.0 to 5.5 which is far ahead for me ,indeed is gonna prepare for MariaDB
event  that comes with nginx by default,the cool thing is that it has the potential to make my databases available for other latest new stufff ,the problem I see is that it might not be able to use mysqld with it anymore or switch in programme manager neither httpd because it might be interesting to try if MariaDB can actually work with my actual web server that is apache 2.2 ...as well
Title: Re: No panel Crossover
Post by: MRatWork on 2019-05-27, 04:20:16
Use 'sh /script/mariadb-to-mysql' and otherwise use 'sh /script/mysql-to-mariadb'. But, better use mariadb instead mysql.

Why using Apache 2.2 instead 2.4?.
Title: Re: No panel Crossover
Post by: South on 2019-05-27, 08:51:00
Im telling you Im actually no panel naked like with apache 2.2 fully functional on my machine centos 6x  could MariaDB work along with it?
Is there any coding you could provide so installation dont delete apache 2.2?



Thank you
Title: Re: No panel Crossover
Post by: South on 2019-05-29, 08:29:42
The coding you provided switches MariaDB to mysql since it upgraded to mysql 5.5 ,itd be equal to service restart mysql knowing that on official it was mysqld so all in all there is no mysqld anymore.I bet you have got under your belt of tricks another coding like that in order to switch from nginx to apache and from this  like I also have succesfully installed on my machine php5.2.17 all ala 32 bit ,I wonder if installation did something so kloxo works with it since some fpm, versions might not work.

What would be cool would be that installation dont delete httpd 2.2 then I just turn MariaDB to mysql and maybe switch for an fpm  to php52.17 or choose compatible fpm and just switch nginx to apache that would keep my 2.2,and I say this lo because in the past on kloxoMR7 switching from nginx to apache truly didnt brought me to anything real
Title: Re: No panel Crossover
Post by: MRatWork on 2019-05-29, 12:54:32
MariaDB is MySQL 5.6 compatible and no reason to use MySQL.

Php-fpm for php 5.2 use spawn-fcgi for loading in memory. It's different with php-fpm in php 5.3 or more.

If you install 'multiple php' and then choose php-fpm_event for 'php-type', it's possible use php 5.2 running in certain domain with enable it in .htaccess. But, need enable 'Enable Multiple PHP As Secondary PHP (for Apache)'.
Title: Re: No panel Crossover
Post by: South on 2019-07-05, 08:13:41
Hello installing kloxo with a pre configured server really didnt turn bad for me,I actually have a web server httpd running on port 80 that somehow is not mad at MariaDB or phpfpm 56 so for me Im enthusiast about kloxo on working on ala 32 bit config with apache 2.2.If it still work why dont give it a try

The only thing is that my admin login is disabled and I cant use control panel but kloxo works good restarting ok ,please tell me how to enable admin login

Forgot dont have phpmyadmin so I cant try by fix table there
Title: Re: No panel Crossover
Post by: MRatWork on 2019-07-05, 08:22:38
You can use httpd 2.2 under CentOS 6. If you choose CentOS 6 32bit, need modified '/etc/repos.d/mratwork.repo'.
Title: Re: No panel Crossover
Post by: South on 2019-07-05, 08:26:36
Im on a 64 bit machine centos 6,10 just emulating 32 bit ambiance ,please tell me how to enable admin login mustafa thank you
Title: Re: No panel Crossover
Post by: MRatWork on 2019-07-05, 10:16:57
Inform 'sh /script/sysinfo'.
Title: Re: No panel Crossover
Post by: South on 2019-07-06, 11:35:56
A. Control Panel:
   - Kloxo-MR: 7.0.0.c-2019062801
   - Web: hiawatha-10.9.0-f.2.mr.el6.x86_64
   - PHP: php56s - 5.6.40-1.ius.el6 (fpm mode)
B. Plateform:
   - OS: CentOS release 6.10 (Final) x86_64
   - Hostname: SERVER.myserv.COM
C. Services:
   1. MySQL: MariaDB-server-10.0.38-1.el6.x86_64
   2. PHP:
      - Installed:
        - Branch: php56u-cli-5.6.40-1.ius.el6.x86_64
      - Used: --PHP Branch--
      - Multiple: disable
   3. Web Used: apache
     - Hiawatha: hiawatha-10.9.0-f.2.mr.el6.x86_64
     - Lighttpd: lighttpd-1.4.47-2.el6.x86_64
     - Nginx: nginx-1.17.1-1.el6.ngx.x86_64
     - Apache: httpd-2.2.31-1.mr.el6.x86_64
       - 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: djbdns-1.05-17.4.mr.el6.x86_64
     - NSD: nsd-4.1.27-1.mr.el6.x86_64
     - PowerDNS: pdns-4.1.8-1.el6.MIND.x86_64
     - Yadifa: yadifa-2.2.5-1.mr.el6.x86_64
   6. Mail: qmail-toaster-1.03-1.3.57.mr.el6.x86_64
      - pop3/imap4: courier-imap-toaster-4.1.2-1.3.20.mr.el6.x86_64
      - 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.7-1.mr.noarch
Title: Re: No panel Crossover
Post by: MRatWork on 2019-07-06, 13:19:19
Did you run 'sh /script/upcp' after installed Kloxo-MR?. After run this script, you can login via 'http://YourIP:7778' with username and password as admin.
Title: Re: No panel Crossover
Post by: South on 2019-07-06, 23:42:44
Yes ,it got stuck here



Enter password:
Enter password:
Enter password:
- Fix ftp-all services


- Fix skeleton services
- Fix Hiawatha service
*** Execute Update (cleanup) - END ***
>>> Create slavedb_driver <<<
>>> Creating Vpopmail database <<<
Using qmail-toaster - fix '/home/vpopmail/etc/vpopmail.mysql'
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2 "No such file or directory")
>>> Fix Vpopmail settings <<<
>>> Prepare 'defaults' paths <<<
>>> Setup default configure for Webserver <<<

... Wait until finished (restart services) ...


Helloi MR i also ran
sh /script/fix-missing-admin
and got

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'

It seems MariaDB is working other wise myip:7778 wouldnt show or apache would not be alife and kicking,there is something that stops me from enter panel as admin thank you very much
Title: Re: No panel Crossover
Post by: MRatWork 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.
Title: Re: No panel Crossover
Post by: South 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
Title: Re: No panel Crossover
Post by: MRatWork on 2019-07-07, 06:00:50
It's right.
Title: Re: No panel Crossover
Post by: South 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
Title: Re: No panel Crossover
Post by: South 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?
Title: Re: No panel Crossover
Post by: MRatWork on 2019-07-09, 10:17:45
Socket create by Apps automatically.
Title: Re: No panel Crossover
Post by: South 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?
Title: Re: No panel Crossover
Post by: azzureal 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"


Title: Re: No panel Crossover
Post by: MRatWork 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.
Title: Re: No panel Crossover
Post by: South 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
Title: Re: No panel Crossover
Post by: South 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?