Topic: Asterisk14, Dahdi 2.1.2 and Sail2.4.7 on SME8.0b4

[compsos]

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 except it is for asterisk 14

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.

[SARK devs]

Nice work -  are you running sail with this?  Which release?

Can't you just yum install mysqlclient?

Best

S

[compsos]

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.

[compsos]

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.

[SARK devs]

wow

Impressive work Gordon

May I put your work  into the wiki?

Kind Regards

Jeff

[compsos]

Jeff no problem.
Do you want copies of the so files produced?

[SARK devs]

No need for so files.

I'll just lift the words

Thanks again