I wanted to write my own PHP script to get CDR information out of Trixbox’s Mysql database. Find out a handy command that lets me define a user to login remotely to Trixbox’s Mysql specifying an IP Address. The command is
GRANT ALL PRIVILEGES ON *.* TO USERNAME@IP IDENTIFIED BY “PASSWORD”
Got this information from this website
http://help.hardhathosting.com/question.php/87
Hope this helps someone!
Two resources which helped me set up Raid Rebuild, Raid Email Monitoring and to simulate a Raid Failure to get an Email Notification are the following websites:-
1. http://ubuntuforums.org/showthread.php?t=1185134
2. http://linux-raid.osdl.org/index.php/Detecting,_querying_and_testing
For my Trixbox 2.8.0.2 these are the general steps that I took:-
Made sure there was my ISP’s SMTP server in Settings -> General Settings
Opened up the file /etc/mdadm.conf using vi /etc/mdadm.conf
Then I modified the line MAILADDR root to MAILADDR my@email.com
Then I added the line MAILFROM fromemail@email.com
Save and close mdadm.conf
run
mdadm --monitor --scan --test --oneshot
You should get an email with a subject that says Test Message Event on /dev/something
Then I ran
mdadm --monitor --scan --daemonize --test --syslog
and that was it!! Now whenever there is a failure of any one of the drives in my trixbox I get an email telling me so!!
To simulate a failure to test it out follow the instructions on the second link I provided at the top. It has detailed instructions on how to do a software raid failure test!
Hope this helps someone!
Very interesting discussion which also lists how to use YUM
http://www.fedoraforum.org/forum/showthread.php?t=25880
Love this website…shows so many commands that you need from day to day when administrating a trixbox!
http://myspacefears.com/trixbox/
To install using software raid you need two sata drives. Start the install by doing sataraid at the install prompt. Command to see how raid is working you need to enter cat /proc/mdstat at the command prompt once the install is done.
Various raid commands can be figured out using mdadm –help at the command prompt
Couldn’t figure this one out till I actually logged of the Admin Website. Every time an update was displayed on the webpage I would get
== Manager ‘admin’ logged on from 127.0.0.1
== Manager ‘admin’ logged off from 127.0.0.1
in the Asterisk CLI. Very annoying. Now I just keep my browser pointed to extensions where there are no updates.
Interesting but dated article on how to provision Polycom IP Phones. Explains how to set up an ftp with all the appropriate files.
http://www.sureteq.com/asterisk/polycom.htm
Good article on gauging how much bandwidth and cpu cycles you need
http://www.thrallingpenguin.com/articles/voip-dimensioning-and-bandwidth.htm
I thought I had to install Speex in order to use it but it turns out that Trixbox 2.8.0.2 already has it installed. The following link has instructions on how to install and then on how to configure it properly.
http://www.trixbox.org/forums/trixbox-forums/trixbox-projects/howto-install-speex-codec
Came across a quick and informational blog on the different codecs used in Trixbox.