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]
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.

2
CentOS 7 Problems / Re: Can't start Mysql Server
« on: August 17, 2020, 06:27:19 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!

3
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:
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!

Pages: [1]