I’m glad you enjoyed the documentation. Please check http://sureteq.com/asterisk for the latest version of the trixbox CE Complete Setup Guide for Small Business. All of the new password changes are in the security chapter.

Thanks,
-Chris

just wanted to let you know that after several attempts it seems I managed almost everything.

I am experiencing the same as comment #7

Next, change your asteriskuser password for mysql CDR’s (Call Detail Records):

nano /var/www/html/maint/modules/cdrreport/config/database.php

Find the line that says:

‘connection’ => ‘mysqli://asteriskuser:amp109@localhost/asteriskcdrdb’,

Change the ‘amp109′ (in red above) to the asteriskuser password you set. CTRL+X followed by ‘Y’ to save and exit.

However, when I tried this, there was no such file in that directory, and it created a new file.

and I ignored it as you suggested

I guess I should be fine now
thank you sooooo much once again
if you have a paypal account let me know I’ll buy you a drink

good luck with everything!

thank you so much for making this info available, I am still puzzled as to why trixbox does have a comprehensive install tutorial.

then I am running into some problems following the instrucitons I got stuck at “Update the MySQL asteriskuser password”

I used the following command: ” mysqladmin -u asteriskuser -p password newpass” as shown above
and got the following error:
mysqladmin: Can’t turn off logging; error: ‘Access denied; you need the SUPER privilege for this operation’

I also tried to follow comment #3

by using
update user set password=PASSWORD(”new_pass_here”) where User=’asteriskuser’;

and got the following error:
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘) where User=.asteriskuser.’ at line 1

I am using trixbox 2.6.1 on centos

thank you so much anyway for sharing and helping!

Your best bet is to download and install the latest and greatest, or to simply ignore that step…if it doesn’t appear to be affecting anything, then you should be OK.

Thanks for the advice.

Actually, I ran into another issue with my installation and am doing a fresh install. In doing so, I am following your guide for installing Trixbox v 2.6.2 (although I am installing v2.6.1), and ran into a problem in changing the cdr report password. In your guide you recommended:

Next, change your asteriskuser password for mysql CDR’s (Call Detail Records):

nano /var/www/html/maint/modules/cdrreport/config/database.php

Find the line that says:

‘connection’ => ‘mysqli://asteriskuser:amp109@localhost/asteriskcdrdb’,

Change the ‘amp109′ (in red above) to the asteriskuser password you set. CTRL+X followed by ‘Y’ to save and exit.

However, when I tried this, there was no such file in that directory, and it created a new file. Is there a variation between 2.6.1 and 2.6.2 that is causing this?

Thanks!

In the line,
mysql> update user set password=PASSWORD(”new_pass_here”) where User=’asteriskuser’;
Is the part “where User=’asteriskuser’ meant to be parenthetical, or is there an ‘asteriskuser’ ID that we should enter. If there is an asteriskuser ID that we should enter, should that be “maint” or am I missing something.

Thanks,

Michael Cole