provided by Star2Billing S.L.

Hi
I have upgraded my trixbox2.0 to have Mysql5 and php-5.1.6 but now I cant find php-pcntl-5 to avoid issue with simultaneous calls... please someone send this file to the forum, thanks
rafael

Hi

Are you using FC5 or later? PHP5 has the pcntl module built in. I would suggest a yum install php-pcntl so you can see 1st hand nothing loads. A2B works properly with FC5 and PHP5. However you might try to yum install php-gd*

Joe

Rafo, what did it take to upgrade your trixbox like that ? Do you have a nice list of instructions ??

Hi Krzykat
I needed to upgrade trixbox box to integrate asterisk using openser as a sip registrar and proxy and just use asterisk as a suplementary services and billing system with a2billing, this integration needs mysql "View" function so you really need mysql 5.

I dont have a good list of instructions but can give you some tips:

To Upgrade mysql5 and php5:

yum --enablerepo=centosplus --exclude=kernel* update

successfully install this packages:
==============================================
Package Arch Version Repository Size
==============================================
Updating:
mysql i386 5.0.22-1.centos.1 centosplus 3.0 M
mysql-devel i386 5.0.22-1.centos.1 centosplus 2.3 M
mysql-server i386 5.0.22-1.centos.1 centosplus 9.7 M
php i386 5.1.6-1.2.1.centos centosplus 3.3 M
php-gd i386 5.1.6-1.2.1.centos centosplus 101 k
php-imap i386 5.1.6-1.2.1.centos centosplus 47 k
php-mbstring i386 5.1.6-1.2.1.centos centosplus 968 k
php-mysql i386 5.1.6-1.2.1.centos centosplus 75 k
php-pear noarch 1:1.4.9-1.2.centos centosplus 342 k
php-snmp i386 5.1.6-1.2.1.centos centosplus 24 k
postgresql-libs i386 8.1.4-1.centos.1 centosplus 180 k
tbm-javassh noarch 1.0.1-1 trixbox 235 k
Installing for dependencies:
mysqlclient14 i386 4.1.14-4.2.c4.1 centosplus 1.1 M
php-pdo i386 5.1.6-1.2.1.centos centosplus 60 k
==============================================

cp /usr/lib/php/modules/* /usr/lib/php4/
pear install DB

finally edit /etc/httpd/conf.d/php.conf to check this lines:
----->
#LoadModule php4_module modules/libphp4.so
# Use for PHP 4.x
#AddHandler php-script php

# Use for PHP 5.x:
LoadModule php5_module modules/libphp5.so
AddHandler php5-script php
----->
reboot trixbox.

To integrate Openser/Asterisk you can use this excellent tutorial:

http://www.voip-info.org/wiki/view/Real ... th+OpenSER

To use a2billing as a billing (not calling card) just disable all IVR capabilities and use Caller-id authentication for calls comming from openser users to PSTN:

extensions.conf example:
[from-sip-proxy]
; #########################################
; ;::... Contexto para accesos desde Sip Ser Proxy:
; #########################################
; AGI-1 hace authentication by caller-id

exten => _1NXXNXXXXXX,1,DeadAGI(a2billing.php|1)
exten => _1NXXNXXXXXX,2,Hangup
...

For calls coming from PSTN to Sip users you can use "accountcode" authentication to this pstn sip-peer and also use DID feature if you want:

extension.conf example:
; #########################################
; Contexto para facturar las llamadas provenientes del AS5350
; agi|2 hace authentication by accountcode

[from-gw-pstn]
exten => _511888XXXX,1,DeadAGI(a2billing.php|2)
exten => _511888XXXX,2,Hangup

Sip.conf example:
###########
[sip_proxy]
type=friend
host=w.x.y.z ; Your Openser SIP proxy IP address
canreinvite=no
context = from-sip-proxy ; a este contexto en extensions.conf
insecure=very
nat=yes
disallow=all
allow=g729
allow=alaw
allow=ulaw
allow=gsm


;; Para llamadas desde PSTN hacia A2billing (accountcode auth.)
;; Account code 1234098765
[Cisco_AS5350]
type=friend
username=1234098765
accountcode=1234098765
regexten=1234098765
amaflags=billing
dtmfmode=RFC2833
regseconds=0
host=a.b.c.d ; Your PSTN GW IP address
canreinvite=yes
context=from-gw-pstn ; Llamada se envia a este contexto en extensions.conf
insecure=very
nat=no
disallow=all
allow=g729
allow=alaw
allow=ulaw
allow=gsm
############

hope it helps

rafael

Thanks joe
I think you are right, I dont have any issue with simultaneous calls until now after upgrade mysql and php to version 5.

rafael

Hi can you please give me openser.cfg i have installed Openser but the call is unable to passthru if you can give me the openser.cfg file that should help me.

regards
surender

I tried to upgrade to mysql 5 3 times, I screwed up 3 times. Is there any good way of installing this mysql5? without screwing up.