Home » Forums » Community Edition » Help

Access denied for user 'asteriskuser'@'localhost'

bimo_c
Posts: 5
 Member Since:
2007-12-04
Submitted by bimo_c on Wed, 12/12/2007 - 10:22am.

Hi There !

Got this message [nativecode=Access denied for user 'asteriskuser'@'localhost' (using password: NO)] ** mysql://asteriskuser:@localhost/asterisk after changing the "mysql" password and the and the user manager password, when I try to login the asterisk admin page, anyone seen this before?

I followed these steps:

Verifying the password

If you want to be sure that the password has been changed, run:

mysql -u asteriskuser -p

amportal.conf, cdr_mysql.conf, res_mysql.conf

Once the password works, you need to update three files:

* /etc/amportal.conf:

AMPDBUSER=asteriskuser
AMPDBPASS=mypass

* /etc/asterisk/cdr_mysql.conf:

password=mypass
user=asteriskuser

* /etc/asterisk/res_mysql.conf:

dbuser = asteriskuser
dbpass = mypass

still no luck, can someone point me the right direction??

I am using Trixbox V2.2.3 and the latest version on Asterisk.

Many thanks!!!

‹ Bulk extensions: How to install this module (TrixBox v2.2.4)? Update error ›

&nbsp

karl
Posts: 9
 Member Since:
2007-10-03
Me too
Thu, 01/17/2008 - 5:54am

I'm getting this message too.
My root password still works but I can no longer sign in anywhere using asteriskuser and the password that is in all the conf files.

My install has been working for months using these details. What happened was I am having some trouble with the "packages" tab, it keeps failing to update and giving me a message about timing out instead of the list of packages.

I decided to bring everything up to date to see if that helped (I'm learning as I go...so this might not, in hindsight, have been the best idea :P ). I ran yum update on the server, it updated and everything seemed fine. I opened the packages screen and in a matter of seconds there was a list of all the updates/installed components. There wasn't really anything there that needed updating so that was it.

Then I tried to open freepbx and I got the above message. I tried the trixbox tabs to see if anything else had stopped working and the packages tab had gone back to timing out.

I tried running /usr/src/freepbx-2.3.1/apply_conf.sh, it ran ok, no errors, but no change to the problems either.


&nbsp

boomastk
Posts: 3
 Member Since:
2007-07-23
This is what I did to fix it
Thu, 01/24/2008 - 7:21pm

I updated to latest Trixbox version and it reset the ampdbuser (asteriskuser) password back to it's default just like when it was first installed (amp109), here is what I had to do to resolve the problem:

mysqladmin -u asteriskuser -p password newpassword

password is the word password
newpassword is the actual new password

You will be prompted for the old password: amp109


&nbsp

karl
Posts: 9
 Member Since:
2007-10-03
That worked for me too
Fri, 01/25/2008 - 4:58am

That worked for me too thanks.


&nbsp

dstroot
Posts: 148
 Member Since:
2006-06-01
awesome - worked for me as
Tue, 07/01/2008 - 1:11am

awesome - worked for me as well


&nbsp

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.