Show Posts

Profile Info
- Summary
- Show Stats
- Show Posts...

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Messages - hankf

Pages: [1]

SSL / Re: Letsencrypt SSL Certificate issue in Hosted domain names

« on: October 05, 2021, 02:50:21 PM »

Hi, having similar issue, did you solve? Thanks.

CentOS 7 Problems / Re: Can't start Mysql Server

« on: August 17, 2020, 06:27:19 PM »

Quote from: hankf on August 17, 2020, 06:23:47 PM

Good day my problem occurred recently. I changed my password via admin panel after which I wasn't able to log back in I got this:

Code: [Select]
"Warning: mysqli_connect(): (HY000/2002): No such file or directory in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0 Warning: mysqli_connect(): (HY000/2002): No such file or directory in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0 Warning: mysqli_connect(): (HY000/2002): No such file or directory in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0 Warning: mysqli_connect(): (HY000/2002): No such file or directory in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0 Trying to start mysql server, please wait! Try to restart CentOS Web Panel with command: sh /scripts/restart_cwpsrv **Check your MySQL root password in: /usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php and /root/.my.cnf Warning: mysqli_error() expects exactly 1 parameter, 0 given in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0 Could not connect:"
I followed theses instructions but nothing

At this point it was suggested that I changed password via command line I did that, but that made no difference I still couldn't log in to the admin panel.

The random generated password would NOT work anywhere, it was automatically updated in the db_conn.php and my.cnf and they both matched.

I also tried "sh /scripts/cwpsrv_rebuild_user_conf" but I think it once again gives access denied for root error

Throughout it all I could still access mysql using third party app using the custom password I chose within the admin panel, NOT random generated one.

I tried some suggestions on here but not seems like mysql server won't start anymore. I get the following error when I check status:
Code: [Select]
[root@srv1 ~]# Aug 17 13:53:38 myserver.com mysqld[3167]: 2020-08-17 13:53:38 139631234808064 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and... -bash: Aug: command not found [root@srv1 ~]# Aug 17 13:53:38 myserver.com mysqld[3167]: 2020-08-17 13:53:38 139631234808064 [ERROR] Plugin 'InnoDB' init function returned error. -bash: Aug: command not found [root@srv1 ~]# Aug 17 13:53:38 myserver.com mysqld[3167]: 2020-08-17 13:53:38 139631234808064 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. -bash: Aug: command not found [root@srv1 ~]# Aug 17 13:53:38 myserver.com mysqld[3167]: 2020-08-17 13:53:38 139631234808064 [Note] Plugin 'FEEDBACK' is disabled. -bash: Aug: command not found [root@srv1 ~]# Aug 17 13:53:38 myserver.com mysqld[3167]: 2020-08-17 13:53:38 139631234808064 [ERROR] Unknown/unsupported storage engine: InnoDB -bash: Aug: command not found [root@srv1 ~]# Aug 17 13:53:38 myserver.com mysqld[3167]: 2020-08-17 13:53:38 139631234808064 [ERROR] Aborting -bash: Aug: command not found [root@srv1 ~]# Aug 17 13:53:38 myserver.com systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE -bash: Aug: command not found [root@srv1 ~]# Aug 17 13:53:38 myserver.com systemd[1]: Failed to start MariaDB 10.1.44 database server. -bash: Aug: command not found [root@srv1 ~]# Aug 17 13:53:38 myserver.com systemd[1]: Unit mariadb.service entered failed state. -bash: Aug: command not found [root@srv1 ~]# Aug 17 13:53:38 myserver.com systemd[1]: mariadb.service failed.
Can anyone help please and thankyou!

CentOS 7 Problems / Can't start Mysql Server

« on: August 17, 2020, 06:23:47 PM »

Good day my problem occurred recently. I couldn't access the client panel it would load open but nothing would load, giving me this error:

Code: [Select]

"Warning: mysqli_connect(): (HY000/2002): No such file or directory in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0

Warning: mysqli_connect(): (HY000/2002): No such file or directory in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0

Warning: mysqli_connect(): (HY000/2002): No such file or directory in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0

Warning: mysqli_connect(): (HY000/2002): No such file or directory in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0


Trying to start mysql server, please wait!
Try to restart CentOS Web Panel with command: sh /scripts/restart_cwpsrv

**Check your MySQL root password in: /usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php and /root/.my.cnf


Warning: mysqli_error() expects exactly 1 parameter, 0 given in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0
Could not connect:"

I followed theses instructions but nothing

At this point it was suggested that I changed password via command line I did that, but that made no difference I still couldn't log in to the admin panel.

The random generated password would NOT work anywhere, it was automatically updated in the db_conn.php and my.cnf and they both matched.

I also tried "sh /scripts/cwpsrv_rebuild_user_conf" but I think it once again gives access denied for root error

Throughout it all I could still access mysql using third party app using the custom password I chose within the admin panel, NOT random generated one.

I tried some suggestions on here but not seems like mysql server won't start anymore. I get the following error when I check status: