Categories

Archives

Install OpenSIPS on CentOS 5.2 with MySQL

How to install opensips in a Red Hat Enterprise Linux 5 server with mysql
How to install opensips 1.5 in a Red Hat Enterprise Linux 5
platform with Mysql Support.

The following document will guide you thru the installation
of the newly released opensips vesion 1.5 in Red Hat Enterprise
Linux 5.3 along with mysql. I will divide this process in 2 phases
1.- Installation of Red Hat Enterprise Linux 5.3
2.- Installation and configuration of Opensips, webmin and mysql

The following components and paramenters will be used for the purpose
of this installation guide, securing your opensips environment is
beyond this installation guide,

-Red Hat Enterprise Linux Server release 5.3 (Tikanga), 2.6.18-128.1.6.el5
-mysql-server-5.0.45-7.el5.i386
-An HP DL380 3.20 2gb of RAM
-Fully Qualified Domain Name of the server will be simulacro.sipcorner.com
-IP address of the server 10.10.10.101

1.-Installation of Red Hat Enterprise Linux 5 (Phase 1)

Let’s Proceed to install Red Hat Enterprise Linux 5
-Proceed to Insert the RHEL 5 DVD in your server
At the RHEL boot screen “press enter”
The system will ask you to either test the media or skip the media test,
I personally choose to skip the media since I know the integrity of the DVD
is good, but if you have doubts about the integrity of your media I will
suggest you to continue with the media test.
-At the RED HAT ENTERPRISE LINUX 5 initial Install screen select NEXT
-Proceed to select the language, I selected English(English)
-Proceed to select the appropriate keyboard for the System, I selected
U.S. English
-Proceed to enter the Red Hat installation number and select OK
-Select to Install Red Hat Enterprise Linux Server, then select OK
-Because I have RHEL 5 currently installed in my Hard Drive, and I
want to install a new copy of RHEL 5, the system will now asked me if
I want to remove all linux partitions on the selected drives and create a default
layot, since I want to do this, I will simply select the NEXT button
-As a precaution, the system will asked me if I really want to remove all the
existing Linux partitions in the Hard Drive, Since i want to do this I select
the Yes button.
-The system will now asked to configure the ethernet0 interface, since I want
the system to have an static IP address, I select the eth0 interface and I
select EDIT.
-The EDIT Interface screen will open, and I will now proceed to enter my network
information manually, then select OK, next I proceed to enter the FQDN for this
server, for example simulacro.sipcorner.com, next I will proceed to continue
entering my network information, such as my gateway, primary DNS and Secondar
DNS servers, then I will proceed to select the NEXT button
-Proceed to select your timezone accordinally
-Proceed to enter a Password for the Root Account
-Red Hat Enterprise Linux 5 default installation includes a set of software
applicable for general internet usage, although you can choose to install
additional components, such as servers and others, for the purposes of this
document, I will proceed to check the Web Server option and also I will proceed
to check the Customize now option, then I will select NEXT.
-Because I checked the customize option, I am now being presented with [...]

Misc FreePBX Tricks

Following instructions are only for the truly advanced users.

FreePBX is a wonderful GUI for Asterisk, and an unlimited number of people have learned asterisk thanks to FreePBX. In fact many people think that FreePBX IS asterisk. If someone could move it to realtime architecture and make it multi-tenant, it’ll just be super wonderful.

FreePBX has some limitations when it comes to deal with a larger number of extensions. So for those who are comfortable with tweaking its database, I’ll be adding some material here.

This happened to me lately that on a Trixbox server I had to remove one 4xT1 card, meaning all the timeslots (or zap channels) had to move down by 96. Changing all the timeslots manually in the GUI was a painful thing to do. But I knew that if I changed it in two tables, namely `zap` and `zapchandids`, all will be good. So I opened my favourite SQLYog, connected to the Trixbox server, opened the database named `asterisk`, selected table `zap`, and ran the following two queries:
UPDATE zap SET data = CONCAT(‘ZAP/’,right(data,3)-96) where keyword = ‘dial’;
UPDATE zap SET data = zapdata-96 WHERE keyword = ‘channel’

UPDATE zapchandids SET channel = channel-96

The first query seems a little complicated, but rest of the two are very simple. All they did was that they reduced the timeslot number by 96. Once done, I needed to do a Submit via FreePBX GUI, so I went to the Extensions section, and clicked on Submit, Apply Configuration Changes, Continue with Reload, and that was it, all the zap extensions were now assigned the correct time slots.
to be continued

Like
Unlike