MySQL connect ERROR right after a clean install???

[fastlane101]

Ok, so it seems the install went smoothly, in the end of the installation it said install was successfull, and gave a user name and password to log in from a web browser to the box.


when i attempted to log in to: http://192.168.1.80/vicidial/admin.php from a different pc in the same network, i recieve the following error messege:


Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'cron'@'localhost' (using password: YES) in /var/www/vicidial/dbconnect.php on line 42
MySQL connect ERROR: Access denied for user 'cron'@'localhost' (using password: YES)


it goes to this error screen, and i cannot log in to the box, can any one help??

Thank you again, in advance..

[williamconley]

Do the installation over and pay attention to your passwords. You could try to troubleshoot it BUT it is very possible that was not the only issue and you could end up troubleshooting a dozen issues. Also be sure you do not have a corrupted .iso download.

alternately you can check your astguiclient.conf for mysql user/pwd and verify that they are valid within mysql (try to log in as that user and see).

mysql -u USER -p

[fastlane101]

Do the installation over and pay attention to your passwords.

What do you mean pay attention to your passwords? i created a password, and noted it for future refferance, if i am to re install from the cd once more, what should i pay attention to as it seemed to install everything smoothly..

[williamconley]

so you have your mysql password and you know where the astguiclient.conf is. if there's an error something went wrong. reinstall after verifying your .iso is clean and see if some other error occurs and then validate the mysql password by logging in as root and logging in again as the user from your astguiclient.conf file to see if you can diagnose why the system is having an issue. IF it has the issue on the second install, which it may not.

never fear "reinstall" when setting up a system like this. i actually recommend reinstalling several times, breaking a few things between reinstalls, just to get a good feel for the system and become familiar with an EASY fix.

but then again i used to "get lost" in every new neighborhood i moved into just so i could find my way again and in the meantime get the feel for the neighborhood ... so maybe i'm weird.

[fastlane101]

never fear "reinstall" when setting up a system like this. i actually recommend reinstalling several times, breaking a few things between reinstalls, just to get a good feel for the system and become familiar with an EASY fix.

but then again i used to "get lost" in every new neighborhood i moved into just so i could find my way again and in the meantime get the feel for the neighborhood ... so maybe i'm weird.

lol, thank u kindly for the advice. i will be reinstalling the machine tommorow morning. i also second the fact that the best learning experience comes from trial & error..

I will be posting a conclusion tommorow, hopefully a successfull 1!

Thanks again for the advice...

[fastlane101]

Did a new install from the cd, and again, all steps seemed to perform correctly, i created a mysql password when instructed, and it continued all the way to PHASE 4 - COMPLETE then i attempted to log into the machine from a web browser with: http://192.168.1.80/vicidial/admin.php
and get the same error messege as before:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'cron'@'localhost' (using password: YES) in /var/www/vicidial/dbconnect.php on line 42
MySQL connect ERROR: Access denied for user 'cron'@'localhost' (using password: YES)

if i go to http://192.168.1.80/vicidial/welcome.php i see the welcome screen, and if i click on administration then redirects me to the same error page...

Kinda going crazy, i guess the next step is to download a new iso from the website and burn it, and try this ALL OVER AGAIN? is this the only correct way to try to resolve this issue, really strange that i am getting the same error messege on mysql right after a clean install..

Please, if i can try to fix this let me know how before i re install again..

Thank you again, in advance...

[williamconley]

there are several methods to finding out why this install is failing, all of which require a certain amount of knowledge of Vicidial Ubuntu and/or MySQL. You COULD try VicidialNOW and see if it does not have the same issue. Remember that CentOS is not "supported" itself, but it installs the same Vicidial and may not have what is apparently a compatibility issue (or a package has been upgraded and altered something in the install detrimentally).

That would be the simplest "learning curve" for a solution.

Otherwise, you'll have to begin with finding out what user is failing to fire up mysql and then why it is failing.

[mcargile]

There is a log file from the installation in the /var/log/astguiclient directory called ubuntu-vici-install.log. Please read through it and look for errors connecting to mysql and post those errors here. Make sure to include about 10 lines from before the error too so that I can get an idea as to where in the install process it screwed up.

I have already found one error in the installer because of this here:
http://www.vicidial.org/VICIDIALforum/v ... php?t=7908