support

Where should I leave?

kjdx
Posts: 5
Member Since:
2008-08-02

I installed trixbox but I do not understand how to change the pass mysql and then starting from where to begin to use someone I know if there is some help?



netsysllc
Posts: 16
Member Since:
2007-11-27
Try this link

Try this link, it is accessible through a link in the Wiki http://josephades1.googlepages.com/gen_securetb



kjdx
Posts: 5
Member Since:
2008-08-02
When I write the command to

When I write the command to change the pass tells me this:
mysqladmin: Can't turn off logging; error: 'Access denied; you need the SUPER privilege for this operation'



SkykingOH
Posts: 3560
Member Since:
2007-12-17
Are you logged on as root or

Are you logged on as root or used sudo for root privileges?

--

Scott

aka "Skyking"



kjdx
Posts: 5
Member Since:
2008-08-02
I usually use debian ubuntu

I usually use debian ubuntu and when I have # root on centos I directly # qando by then I thought to be already root or we must give sudo su to become root



SkykingOH
Posts: 3560
Member Since:
2007-12-17
No, if you have # prompt you

No, if you have # prompt you are root. You can make a user account then sudo for root for additional security.

None of this solves your problem, and I don't have an answer to it.

--

Scott

aka "Skyking"



kjdx
Posts: 5
Member Since:
2008-08-02
I am following this link

I am following this link http://josephades1.googlepages.com/gen_securetb change mysql pass as written but I can not find the file and the "dbpass" line in / etc / asterisk / res_mysql.conf and if I try to enter into setting pbx I wrote FATAL ERROR
DB Error: connect failed HELP HELP Please :|



bhughesiii
Posts: 43
Member Since:
2007-01-04
Yes, please someone post a

Yes, please someone post a solution. Have noticed this with 2.6.1 that cannot change the default sql password for asteriskuser. Needs to be done.



percykwong
Posts: 753
Member Since:
2007-04-30
I haven't installed 2.6.1,

I haven't installed 2.6.1, but you could always grant the user superuser access then just modify it in mysql directly.

--

-----------------------------------------------
Percy Kwong
www.swimminginthought.com
www.iphonebounties.com



csierra
Posts: 78
Member Since:
2008-02-22
Is there a Wiki page

With instructions on how to change MySQL default passwords in Trixbox 2.6.1 wich actually work?

Thank you

VOIP Newbie

--

VOIP Newbie



Schwood
Posts: 229
Member Since:
2006-06-23
The above link wasn't

The above link wasn't working for me with a clean install of 2.6.1, however, after speaking with Kerry G, I have the solution:
asteriskuser mysql password:

(from the Linux CLI):

mysql -u root -p
(enter mysql root password, default is passw0rd (with a zero))
mysql> use mysql;
mysql> update user set password=PASSWORD("new_pass_here") where User='asteriskuser';
mysql> flush privileges;
mysql> quit

Now change to the new password in these files:

/etc/amportal.conf (AMPDBPASS towards the bottom of the file)
/etc/asterisk/cdr_mysql.conf (password field)
Once done, run these commands from the Linux CLI:

service mysqld restart
amportal restart

That should do it. To change the mysql root password, the old way still seemed to work.

mysqladmin -u root -p password new_pass_here
(prompted for old mysql root password - default is 'passw0rd' - no quotes, with a zero)

Now change the password in this file:

/etc/asterisk/cbmysql.conf (password field)

Thanks Kerry for the info!

--

Chris Sherwood
FtOCC Admin and Tech Certified
Fonality Channel Sales Engineer



ja133
Posts: 2111
Member Since:
2006-11-26
I will test Schwood's post

I will test Schwood's post right now and upon success I will post special 2.6.1 instructions on this same link above



ja133
Posts: 2111
Member Since:
2006-11-26
Website updated Use the same

Website updated
Use the same link



Comment viewing options

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