Author Topic: Login after installation  (Read 2686 times)

0 Members and 2 Guests are viewing this topic.

Offline
*
Login after installation
« on: March 14, 2023, 07:12:52 PM »
Hello dear people,

I have a slight problem, installed the CWPpro normally and succeded to go to the loginpage of the admin.
BUT
i cant log in as root, it keeps giving me wrong password, although i changed the password after several attempts in Mysql.
I noticed after the installation was done, there was no password for root user.
and i get an error after several attempts loging in cwppro panel


and


Is there something wrong wtih mysql?

Offline
*****
Re: Login after installation
« Reply #1 on: March 15, 2023, 01:39:14 AM »
CWP uses the system root account, so it's password isn't stored on MariaDB.

Now MariaDB does store it's own maser password.

If you can login to the terminal and with ssh, using the root credentials, then you should be able to access the CWP admin panel with those same ones.

Offline
*****
Re: Login after installation
« Reply #2 on: March 15, 2023, 12:00:19 PM »
run the following script, this will solve your problem

Code: [Select]
sh /scripts/mysql_pwd_reset

Offline
*
Re: Login after installation
« Reply #3 on: March 15, 2023, 05:37:50 PM »
I resetted the password, and even reinstalled everything
I still get the same error,
i checked the passwords on my.cnf and db_conn and they match.
I still get login failed

Offline
*****
Re: Login after installation
« Reply #4 on: March 15, 2023, 07:39:45 PM »
what is the error it shows?

Offline
*
Re: Login after installation
« Reply #5 on: March 16, 2023, 01:09:50 PM »
what is the error it shows?

I reinstalled, i get no error now
but i still cant log in.
The passwords in db_conn and my.cnf match but i still cant log in.
when the setup ended where it says mysql password was blank.
i had to use pwd_reset to put in a password

Offline
*
Re: Login after installation
« Reply #6 on: March 16, 2023, 01:30:47 PM »
what is the error it shows?

I reinstalled, i get no error now
but i still cant log in.
The passwords in db_conn and my.cnf match but i still cant log in.
when the setup ended where it says mysql password was blank.
i had to use pwd_reset to put in a password

So i logged in the mysql
and asked for the User database, and then wanted to see the users i got Empty..
maybe the root user is not in the database?

Offline
*****
Re: Login after installation
« Reply #7 on: March 18, 2023, 02:48:42 AM »
Are you able to SSH into the server? Try running
Code: [Select]
sudo passed rootand change the roott password to the same as the MySQL root password. This will also have the positive effect of allowing you to login to phpMyAdmin without a password from the CWP Admin panel.

Offline
*
Re: Login after installation
« Reply #8 on: March 22, 2023, 12:14:34 AM »
I asked the support; and i made a mistake.
I was installing mysql before i installed the CWP. I did not need to install anything, that is why i had a problem with the SQL database.
Thanks everyone, but now i have an issue with WHMCS and CWp, in the cwp api section.
Help would be great!