Messages

226

MySQL / Re: CWP Painel Root - MySQL Error Connection

« on: November 16, 2021, 11:18:51 PM »

will be fixed in new version

1100 did not fix the create new user in mysql manager.

227

MySQL / CSF port 3306

« on: November 13, 2021, 11:22:21 PM »

Curious.....firewall does not list port 3306 for tcp connections.   Is that okay?

228

MySQL / Re: CWP Painel Root - MySQL Error Connection

« on: November 12, 2021, 11:18:18 PM »

will be fixed in new version

And when ?

Patience grasshopper.

229

MySQL / Re: CWP Painel Root - MySQL Error Connection

« on: November 11, 2021, 12:07:37 PM »

Thanks!

230

MySQL / Re: service cwpsrv status

« on: November 07, 2021, 07:47:22 PM »

My new install on centos 7 was successful but as soon as I hit restart mysql the server crashed.

Output for service cwpsrv status:

Nov 07 13:41:58 170-187-156-90.ip.linodeusercontent.com systemd[1]: Starting CentOS Web Panel service (daemon)...
Nov 07 13:41:58 170-187-156-90.ip.linodeusercontent.com cwpsrv[807]: cwpsrv:the configuration file /usr/local/cwpsrv/conf/c                           wpsrv.conf syntax is ok
Nov 07 13:41:58 170-187-156-90.ip.linodeusercontent.com cwpsrv[807]: cwpsrv:configuration file /usr/local/cwpsrv/conf/cwpsr                           v.conf test is successful
Nov 07 13:41:58 170-187-156-90.ip.linodeusercontent.com systemd[1]: Failed to parse PID from file /usr/local/cwpsrv/var/run                           /nginx.pid: Invalid argument

Nov 07 13:41:58 170-187-156-90.ip.linodeusercontent.com systemd[1]: Starting CentOS Web Panel service (daemon)...
Nov 07 13:41:58 170-187-156-90.ip.linodeusercontent.com cwpsrv[807]: cwpsrv:the configuration file /usr/local/cwpsrv/conf/cwsrv.conf syntax is ok
Nov 07 13:41:58 170-187-156-90.ip.linodeusercontent.com cwpsrv[807]: cwpsrv:configuration file /usr/local/cwpsrv/conf/cwpsrv.conf test is successful
Nov 07 13:41:58 170-187-156-90.ip.linodeusercontent.com systemd[1]: Failed to parse PID from file /usr/local/cwpsrv/var/run/nginx.pid: Invalid argument

231

MySQL / Re: db_conn.php is bad

« on: November 07, 2021, 07:44:57 PM »

I thought there might be a problem with single quotes and double quotes.  But apparently you can use either.  I think one has to do with escape keys.

232

MySQL / db_conn.php is bad

« on: November 07, 2021, 02:33:49 PM »

Anyone see any problems with the db_conn.php file

<?php

   /* MySQL hostname [ localhost (127.0.0.1 via TCP/IP) ] */
   $db_host = "localhost";

   /* The name of the database */
   $db_name = "root_cwp";

   /* MySQL database username */
   $db_user = "root";

   /* MySQL database password */
   $db_pass = 'j0vlRr5NbeQFm';
   
   //Password used for encryptions (don't change)
   $crypt_pwd = 'J0dQ36A4qpXEB';

233

MySQL / service cwpsrv status

« on: November 07, 2021, 02:23:31 PM »

My new install on centos 7 was successful but as soon as I hit restart mysql the server crashed.

Output for service cwpsrv status:

Nov 07 13:41:58 170-187-156-90.ip.linodeusercontent.com systemd[1]: Starting CentOS Web Panel service (daemon)...
Nov 07 13:41:58 170-187-156-90.ip.linodeusercontent.com cwpsrv[807]: cwpsrv:the configuration file /usr/local/cwpsrv/conf/c                           wpsrv.conf syntax is ok
Nov 07 13:41:58 170-187-156-90.ip.linodeusercontent.com cwpsrv[807]: cwpsrv:configuration file /usr/local/cwpsrv/conf/cwpsr                           v.conf test is successful
Nov 07 13:41:58 170-187-156-90.ip.linodeusercontent.com systemd[1]: Failed to parse PID from file /usr/local/cwpsrv/var/run                           /nginx.pid: Invalid argument

234

MySQL / Re: Database Fail new server

« on: November 07, 2021, 11:49:21 AM »

Change log Oct 7 2021 (.1087)

– Fix for MySQL Manager under MariaDB 10.3.x -------Not working for 10.4.x on existing servers

Change log Oct 19 2021 (.1094)

– Fix Mysql Manager module: add user-------------------Cannot add user after this change.

235

MySQL / Re: CWP Painel Root - MySQL Error Connection

« on: November 05, 2021, 09:48:59 PM »

first, check if MySQL is running and if it's working ok then only the password is an issue which you can fix by running this command

Code: [Select]

/scripts/mysql_pwd_reset

Resetting password is not going to fix the inability for user creation.

236

MySQL / Re: CWP Painel Root - MySQL Error Connection

« on: November 05, 2021, 08:11:26 PM »

Cant we go back to the original mysql manager where everything worked PERFECTLY?

237

MySQL / Re: CWP Painel Root - MySQL Error Connection

« on: November 05, 2021, 08:09:05 PM »

Oddly, the User Tab on mysql manager DOES NOT EVEN OFFER A CREATE USER.   That sounds like total insanity to me. 

238

MySQL / Re: CWP Painel Root - MySQL Error Connection

« on: November 05, 2021, 07:53:48 PM »

first, check if MySQL is running and if it's working ok then only the password is an issue which you can fix by running this command

Code: [Select]

/scripts/mysql_pwd_reset

You are missing the entire point.  This is a system wide failure.  Has nothing to do with me or you.

239

Installation / Re: NEW INSTALL CENT7 DATABASE FAIL...AGAIN

« on: November 05, 2021, 07:51:46 PM »

you should contact cwp support to check that

I sent you an instant message last week and you never replied.

I contacted support and gave them my login details.

They never did anything about it.

I also told Sandeep about it and he said he would look into it. 

A normal install with out of the box settings will crash the instant you try to restart mysql.   And amazingly no one cares or can duplicate it.

240

Installation / Re: NEW INSTALL CENT7 DATABASE FAIL...AGAIN

« on: November 04, 2021, 09:33:07 PM »

Hi,

I have tried to replicate your problem and its just not possible.

What are your steps when installing CWP.
Did you update CentOS 7 before installing CWP ?

I installed following instructions from centos-webpanel.com.

I can install correctly and create new user.  But stopping mysql causing mysql crash and resulting loss of cwp panel.

Two of my existing long time servers just spontaneously stopped allowing create users after CWP updated the Mysql manager user interface.  And both of those servers will crash if I stop mysql form control panel and try to start.