Start Services Automatically in Linux

• add the script to be executed at startup to /etc/rc.d/rc.local
• if you dont want to follow the symlinks in /etc/rc.d/* directories you can use the graphical interface to configure
• The following cli commands will also make services start automatically
• chkconfig snmpd --list
• chkconfig snmpd on

Create Mysql Trigger

• Connect to mysql server
• mysql --password=******
•  Select Database
• use [database name] 
• Create Trigger
• DELIMITER //
  CREATE TRIGGER add_mediatrix_ports after insert on mediatrix_boxes
  FOR EACH ROW BEGIN
  declare l_loop int default 1;
  while l_loop
  insert into mediatrix_ports (mediatrix_boxid, port, operational, date_created, created_userid, date_modified, modified_userid) VALUES (new.id, l_loop, 1, "2009-07-07", 1, "2009-07-07 16:20:23", 1);
  set l_loop := l_loop + 1;
  end while//
• DELIMITER //
  create trigger insert_tut_line after insert on tut_slots for each row
  begin
  declare l_loop int default 1;
  while l_loop < 9 do
  INSERT INTO `tut_lines` (tut_slotid, line, date_created, created_userid, date_modified, modified_userid, operational) VALUES (new.id, l_loop, '2007-05-24', 1, '2009-07-07 13:39:32', 1, 1);
  set l_loop := l_loop + 1;
  end while;
  end;

Setting up X-Lite Softphone with Broadsoft

• Configuring Broadosoft
• Create a device profile using the "Generic SIP Phone" template
• Create and assign a user profile to newly created device
• Configuring X-lite
• Display Name: Can be anything
• Username:User profile line/portid
• Password: authentication password in Broadsoft
• Authorization username: authentication username in Broadsoft
• Domain: mars.pbx-change.com
• Use a proxy: sbc.pbx-change.com