Author Topic: mysqli_error()  (Read 87686 times)

0 Members and 1 Guest are viewing this topic.

Offline
*****
Re: mysqli_error()
« Reply #15 on: June 18, 2020, 08:25:18 AM »
Are you serious? NEVER delete anything you do not understand!
I hope everybody understands you kidding
You can ask me to solve any problem with your server for some money in pm  ;)
Services Monitoring & RBL Monitoring
http://centos-webpanel.com/services-monitor
Join our Development Team and get paid !
http://centos-webpanel.com/develope-modules-for-cwp

Installation Instructions
http://centos-webpanel.com/installation-instructions
Get Fast Support Here
http://centos-webpanel.com/support-services

Offline
*
Re: mysqli_error()
« Reply #16 on: July 14, 2020, 09:00:09 AM »
One can try "yum install mariadb-server" and see what happens. Your database is affected or deleted by / var / lib / mysql, so we hope you didn't miss anything. Anyway, it was a big mistake and I hope you get your backup.
Marth Neilson

Offline
*
Re: mysqli_error()
« Reply #17 on: November 12, 2020, 07:43:26 AM »
 /etc/systemd/system/mariadb.service.d
           `-migrated-from-my.cnf-settings.conf
   Active: activating (start) since Thu 2020-11-12 02:42:09 EST; 173ms ago
     Docs: man:mariadbd(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 17985 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
  Process: 17982 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
 Main PID: 17996 ((mariadbd))
   CGroup: /system.slice/mariadb.service
           `-17996 (mar

Offline
*****
Re: mysqli_error()
« Reply #18 on: November 22, 2020, 05:58:08 AM »
/etc/systemd/system/mariadb.service.d
           `-migrated-from-my.cnf-settings.conf
   Active: activating (start) since Thu 2020-11-12 02:42:09 EST; 173ms ago
     Docs: man:mariadbd(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 17985 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
  Process: 17982 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
 Main PID: 17996 ((mariadbd))
   CGroup: /system.slice/mariadb.service
           `-17996 (mar

And what do you think we can see there? :D
You can ask me to solve any problem with your server for some money in pm  ;)
Services Monitoring & RBL Monitoring
http://centos-webpanel.com/services-monitor
Join our Development Team and get paid !
http://centos-webpanel.com/develope-modules-for-cwp

Installation Instructions
http://centos-webpanel.com/installation-instructions
Get Fast Support Here
http://centos-webpanel.com/support-services

Re: mysqli_error()
« Reply #19 on: November 22, 2020, 11:23:29 AM »
And what do you think we can see there? :D
LOL  ;D
Someone who doesn't wrap code in tags, is the only error that I can spot.  ;)

Offline
*****
Re: mysqli_error()
« Reply #20 on: November 24, 2020, 09:28:30 AM »
@cynique do not advise if you do not understand what are you talking about!
You can ask me to solve any problem with your server for some money in pm  ;)
Services Monitoring & RBL Monitoring
http://centos-webpanel.com/services-monitor
Join our Development Team and get paid !
http://centos-webpanel.com/develope-modules-for-cwp

Installation Instructions
http://centos-webpanel.com/installation-instructions
Get Fast Support Here
http://centos-webpanel.com/support-services

Re: mysqli_error()
« Reply #21 on: November 24, 2020, 10:36:39 AM »
Igor S.
You are normally one of the better ones here - you're beginning to sound like one of the other members of the Team. :(
I was actually complimenting you, on your reply.

Offline
*
Re: mysqli_error()
« Reply #22 on: February 26, 2021, 07:48:45 PM »
i checked my passwords and there the same?

1) You must restart mariadb server with the mariadb unit.
The command is:
(for CentOS7):
Code: [Select]
# systemctl restart mariadb

or
(for CentOS6):
Code: [Select]
# service mariadb restart

2) ** Important (as your error message itself):
===========================================================================================
**Check your MySQL root password in: /usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php and /root/.my.cnf
===========================================================================================

This means the root password in file:
     /usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php
and in the file:
     /root/.my.cnf
must be exactly the same.

Regards,
Netino

Offline
*****
Re: mysqli_error()
« Reply #23 on: March 08, 2021, 06:11:08 AM »
> i checked my passwords and there the same?

Then check if you are able to connect as root to MySQL with the password.
Make sure you have enough disk space also.
You can ask me to solve any problem with your server for some money in pm  ;)
Services Monitoring & RBL Monitoring
http://centos-webpanel.com/services-monitor
Join our Development Team and get paid !
http://centos-webpanel.com/develope-modules-for-cwp

Installation Instructions
http://centos-webpanel.com/installation-instructions
Get Fast Support Here
http://centos-webpanel.com/support-services

Offline
*
Re: mysqli_error()
« Reply #24 on: July 28, 2023, 05:43:54 PM »
I solved the problem.
Thank you all.
Now everything works.

Can you tell me how you solved the problem ?

Offline
*
Re: mysqli_error()
« Reply #25 on: August 18, 2023, 12:52:48 PM »
I am getting the issue today and mariadb is not starting, upon investigating the issue I was getting mariadb corrupt table, so I insert
Code: [Select]
innodb_force_recovery = 5into the my.cnf file. what it did was, all my site are up.

but now, I am getting issue with cwp admin login. so I reset the mysql root password, it was successfully reset, and also change the root password, but still getting the above message

Offline
*
Re: mysqli_error()
« Reply #26 on: August 18, 2023, 01:02:25 PM »
when I insert
Code: [Select]
innodb_force_recovery = 5in configuration file of mysql, all the websites get up and databases get up, but cwp admin panel login doesn't work after that and getting error.

Offline
*****
Re: mysqli_error()
« Reply #27 on: August 19, 2023, 02:38:32 AM »
You need to get mariadb fully functional before CWP will function properly. You may need to repair your tables, delete your log files (ib_logfile0 and ib_logfile1), or roll back to a backup (or recreate the root_cwp database) in order to get fully stabilized.