efa-project.org

What are the Default MYSQL credentials that comes with the build?

for some reason i have the wrong credentials in webmin >servers > MySql Database Server. i keep seen this error "he full MySQL error message was : DBI connect failed : Access denied for user 'whadmin'@'localhost' (using password: YES)"

Also for MailWatch i cant log in because i do not have the right credentials in SQL.
I get the same error witch i think it could be related "Could not connect to database: Access denied for user 'mailwatch'@'localhost' (using password: YES)"

Please let me know.

Take a peek in /etc/EFA-Config

Hmm i tried those long string PW but i still cant log in.

anyway to change the config file and rerun the config?

sorry, im just new at this.

whadmin is not a SQL user in EFA...

This may help

Here are the SQL user accounts:

root and sa-user -- all databases
mailwatch -- mailwatch database only
sqlgrey -- sqlgrey database only
efa -- efa database only

I just tried using the sa-user with the SAUSERSQLPWD and it does not let me in.


I also tried with root and the mysqlrootpwd

Please post the command you are trying to execute without the password.

what i did was recreate the appliance. i did not upgrade to latest version of EFA-3.0.0.2. i was able to log into mysql server from webmin. this allowed me to create a user that will allow me to log into mailwatch.

maybe i bombed my first install of EFA but the second one works great. or maybe the upgrade had something to do with it. would it? Should i upgrade to EFA-3.0.0.2?

let me know.

curibe wrote:what i did was recreate the appliance. i did not upgrade to latest version of EFA-3.0.0.2. i was able to log into mysql server from webmin. this allowed me to create a user that will allow me to log into mailwatch.

Firstly, EFA-Init should have created a MailWatch user for you. That user would be the non-root user. Did it not create the user?

I would hold of on applying 3.0.0.2. We are close to releasing 3.0.0.3 which includes fixes after 3.0.0.2 was released.