Author Topic: ERRORS INSTALLING  (Read 1112 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
ERRORS INSTALLING
« on: December 16, 2019, 01:34:14 AM »
These are the steps I take to install:
Fresh install of Centos 7 minimul
install wget
install updates
install mariadb-server mariadb-libs mariadb-client
enable mariadb.service
set root mysql password
then sh cwp-el7-latest
enter my mysql password
CWP installer does its thing but towards the end of the installation I'm promoted multiple times to enter my password..
I enter the mysql password for each prompt
when it's all done I reboot

but when I try to log in to CWP to setup everything else I get this:

Warning: mysqli_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: NO) in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0

Warning: mysqli_connect(): (HY000/1045): Access denied for user 'postfix'@'localhost' (using password: YES) in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0

Warning: mysqli_connect(): (HY000/1045): Access denied for user 'postfix'@'localhost' (using password: YES) in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0

Warning: mysqli_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: NO) 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:


AND IDEAS????

Offline
*
Re: ERRORS INSTALLING
« Reply #1 on: December 16, 2019, 10:23:06 AM »
did you *start* the mysql? 

systemctl start mariadb

also, the only mysql cfg file you should need is at

/root/.my.cnf
(note the "." 's )

mine is simple as:

[client]
password=YOUR_MYSQL_PASS
user=YOUR_USERNAME

before i run the install i would check to log in with mysql:

just type "mysql"
you should be able to log in..

THEN run the installer...
---------------------------------------

i have in the past used this once i could log in to mysql:

$ mysql
use mysql;
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('YOUR_PASSWORD');
flush privileges;
exit

--------------------------------------------------------------

log out.
THEN try loging back in.. with "mysql".
it should (especially with your .my.cnf file valid
log you straight in.

try the first..


Cheers,
X


Oh, and also, just as the 'error' shows..
/usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php

nano, or EDIT "db_conn.php"

/* MySQL database password */
   $db_pass = 'YOUR_PASSWORD';
   

DO NOT CHANGE THIS:
   //Password used for encryptions (don't change)
   $crypt_pwd = 'blahblahblah8279789122h3jhjkh2';
« Last Edit: December 16, 2019, 10:25:56 AM by x1705 »