Koozali.org: home of the SME Server

Obsolete Releases => SME VoIP (Asterisk, SAIL etc) => Topic started by: compsos on February 11, 2010, 09:45:17 AM

Title: Asterisk14, Dahdi 2.1.2 and Sail2.4.7 on SME8.0b4
Post by: compsos on February 11, 2010, 09:45:17 AM
Due to a change in hardware and chipsets etc, we have found upgraded to ver8 and this is how we got here with asterisk
Firstly found a huge resource of rpms at the digium sites but in the end too many and not enough information of what goes with what. Basically could not get all the components to function together, so we have gone down the compiling route with almost total success.

This is very similar to http://forums.contribs.org/index.php?topic=44375.0 (http://forums.contribs.org/index.php?topic=44375.0) except it is for asterisk 14

Quote
yum install gcc gcc-c++ ncurses-devel kernel-PAE-devel <- get the right devel

cd /usr/src
wget http://downloads.asterisk.org/pub/telephony/asterisk/releases/asterisk-1.4.29.tar.gz
wget http://downloads.asterisk.org/pub/telephony/asterisk/releases/asterisk-addons-1.4.10.tar.gz
wget http://downloads.asterisk.org/pub/telephony/dahdi-linux-complete/dahdi-linux-complete-2.2.1+2.2.1.tar.gz
tar xzvf asterisk-1.4.29.tar.gz
tar xzvf dahdi-linux-complete-2.2.1+2.2.1.tar.gz
tar xzvf asterisk-addons-1.4.10.tar.g   
ln -s /usr/src/kernels/2.6.18-164.11.1.el5PAE linux
cd /usr/src/dahdi-linux-complete-2.2.1+2.2.1
make all
make install
make config
cd /usr/src/asterisk-1.4.29
./configure
make menuselect
make; make install
make samples
make config
cd /usr/src/asterisk-addons-1.4.10
./configure
make menuselect
make
wget http://sarkpbx.com/sail/sail-2.4.1/sail-2.4.1-7.noarch.rpm
yum localinstall sail-2.4.1-7.noarch.rpm --enablerepo=base

(Note Recording a greeting etc did not work until I added this file)
http://sarkpbx.com/sail/languagepack/sme-ast-en-uk-gpl-sounds-1.0.0-3.noarch.rpm
yum localinstall sme-ast-en-uk-gpl-sounds-1.0.0-3.noarch.rpm

/etc/init.d/sark stop
/etc/init.d/sark start
/etc/init.d/sark stop

reboot

The only problem we have left is the recording to the MYSQL CDR is not working. When compiling the addons in the Menuselect the cdr_addon__mysql was XXX as it is looking for mysqlclient. Does anyone know a workaround to get a cdr_addon_mysql.so suitable for this kernel? Or is there an edit in the construction files so that it sees the mysql server? Tried using the old ver7.4 file but that just gets spat out.
Title: Re: Asterisk14, Dahdi 2.1.2 and Sail2.4.7 on SME8.0b4
Post by: SARK devs on February 11, 2010, 10:56:02 AM
Nice work -  are you running sail with this?  Which release?

Can't you just yum install mysqlclient?

Best

S

Title: Re: Asterisk14, Dahdi 2.1.2 and Sail2.4.7 on SME8.0b4
Post by: compsos on February 11, 2010, 01:51:05 PM
No tried the straight yum cmd. From what I have read the addons in the configure stage should see mysql and allow the feature to be added. Mysqlclient rpm clashes with Mysql installation.

Apart from all that so far it seems to be doing all that it should.
Title: Re: Asterisk14, Dahdi 2.1.2 and Sail2.4.7 on SME8.0b4
Post by: compsos on February 13, 2010, 05:01:24 AM
To get the CDR working to MYSQL
Code: [Select]
yum install mysql-devel
cd /usr/src/asterisk-addons-1.4.10
nano cdr_addon_mysql.c
Change Line 132 "localtime_r(&cdr->start.tv_sec, &tm);"
to "ast_localtime(&cdr->start.tv_sec, &tm,NULL);" (without quotes)
./configure
make menuselect
Click right Arrow and deselect  app_saycountpl and chan_ooh323
make
make install
If the new files cdr_addon_mysql.so and app_addon_sql_mysql.so are not in the /usr/lib/asterisk/modules directory copy them in and then restart asterisk
To check if working
asterisk -rvvv
module show like cdr_addon_mysql
it should respond with something like
Module                         Description                              Use Count
cdr_addon_mysql.so             MySQL CDR Backend                        0
1 modules loaded
also
cdr status
CDR logging: enabled
CDR mode: simple
CDR output unanswered calls: no
CDR registered backend: csv
CDR registered backend: cdr-custom
CDR registered backend: cdr_manager
CDR registered backend: mysql
 

Good luck.
Title: Re: Asterisk14, Dahdi 2.1.2 and Sail2.4.7 on SME8.0b4
Post by: SARK devs on February 14, 2010, 08:52:15 PM
wow

Impressive work Gordon

May I put your work  into the wiki?

Kind Regards

Jeff
Title: Re: Asterisk14, Dahdi 2.1.2 and Sail2.4.7 on SME8.0b4
Post by: compsos on February 14, 2010, 10:28:40 PM
Jeff no problem.
Do you want copies of the so files produced?
Title: Re: Asterisk14, Dahdi 2.1.2 and Sail2.4.7 on SME8.0b4
Post by: SARK devs on February 15, 2010, 08:53:35 PM
No need for so files.

I'll just lift the words

Thanks again