Alright I fixed that problem, As always theres another problem after that.
[[email protected] freepbx-2.1.1]# ./install_amp
Checking for PEAR DB..OK
Checking for PEAR Console::Getopt..OK
Checking for /etc/amportal.conf..OK
Checking for /etc/asterisk/asterisk.conf..OK
Checking for Asterisk 1.2..OK
Checking for selinux..OK
Connecting to database..FAILED
Try running ./install_amp --username=user --password=pass* (using your own user and pass)
[FATAL] Cannot connect to database
I've tried using the password setup for mySQL when I set the root pass but that doesn't work.
What control panel are you using? Stupid question, but it does actually matter.
For DirectAdmin, you need to use the DA u/p (admin/somethingelse)
For CPanel, you can use root.
For others, make the necessary adjustments (not sure what they would be off hand).
Also, make SURE that the password is correct. Remember, your "root" password isn't going to (necessarily) be your master mysql password. Did you set one up? If not, do so.
If all else fails, and you just for the life of you can't get the root password out, well, there's no need to panic, it CAN be reset. Follow these very simple instructions (inside the shell) and it will be done (as taken from the MySQL lists)
service mysql stop
wait until MySQL shuts down. Then run
mysqld_safe --skip-grant-tables &
then you will be able to login as root with no password.
mysql -uroot mysql
In MySQL command line prompt issue the following command:
UPDATE user SET password=PASSWORD("abcd") WHERE user="root";
At this time your root password is reset to "abcd" and MySQL will now
know the privileges and you'll be able to login with your new password:
mysql -uroot -pabcd mysql
WHMCS Guru - WHMCS addons, management, support and more. WHMCS Notifications Extended - Add slack, hipchat, SMS, pushover to WHMCS !!
Linux Problems? WHMCS Issues? +1-866-546-8914 (linux-14) or @whmcsguru on twitter!