Page 1 of 1
CSWEB Configuration on WAMP Sever successfully running on Windows 10 failed!! Urgent Help needed!!!
Posted: September 3rd, 2017, 5:25 pm
by gbos
I am looking for any urgent assistance to help me complete my CSWEB configuration setup. I have successfully installed WAMP Server on windows 10 laptop. The server is running Apache version 2.4.23, php 5.6.25 and mysql 5.7.14. Having successfully created a new user cspro using phpmyadmin, after CSWEB configuration I get these error:
Failed to connect to database. SQLSTATE[HY000] [1045] Access denied for user 'admin'@'localhost' (using password: YES). The details you view in the attachment.
Re: CSWEB Configuration on WAMP Sever successfully running on Windows 10 failed!! Urgent Help needed!!!
Posted: September 3rd, 2017, 10:29 pm
by josh
Looks like you have the wrong MySQL username/password. Before running setup you need to create a database and database user in MySQL. The
"database username" and "database password" you enter in setup need to match the username/password you created in MySQL.
Re: CSWEB Configuration on WAMP Sever successfully running on Windows 10 failed!! Urgent Help needed!!!
Posted: September 4th, 2017, 2:52 pm
by gbos
Thanks Josh for your prompt response coming to my aid. However, I progressed as you suggested but still the CSWEB configuration couldn't proceed due to this error:
Failed to connect to database. SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'created_time'
I tried correcting this line from mySQL ini file from:
;sql-mode="STRICT_ALL_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ZERO_DATE,NO_ZERO_IN_DATE,NO_AUTO_CREATE_USER"
To:
;sql-mode="NO_ZERO_DATE,NO_ZERO_IN_DATE,NO_AUTO_CREATE_USER"
Save
ini file and restarting all the services but still got the same error. Attached is the detailed configuration steps I tried to follow to ensure that I didn't miss anything. I await for your prompt response to enable me proceed, asap.
Re: CSWEB Configuration on WAMP Sever successfully running on Windows 10 failed!! Urgent Help needed!!!
Posted: September 4th, 2017, 10:02 pm
by josh
Make sure you get the correct config file. Some setups have multiple mysql config files in different folders and it is easy to edit the wrong one. I haven't used WAMP server so I'm not sure where the config file is for it. Maybe someone else on the forum has experience with WAMP server and can help.
Re: CSWEB Configuration on WAMP Sever successfully running on Windows 10 failed!! Urgent Help needed!!!
Posted: September 4th, 2017, 11:57 pm
by gbos
Thanks Josh, the issues have been unable to change passwords. The passwords for the root and created cspro user couldn't change with the usual wampserver phpmyadmin login. However, I was able to change them from the MySQL console using the following commands
SET PASSWORD FOR cspro@localhost=PASSWORD('pwd');`
SET PASSWORD FOR root@localhost=PASSWORD('pwd');`
pwd = the desired new password.
Now am able to log in as admin with the newly created password.
Thanks Josh for the support.