Topic: V3.0

[SARK devs]

what is in /home/sark/db?

is sark.db is there then email it to admin@aelintra.com

Thanks

S

[guest22]

sark.db is there but....

zero size, owned by root:admin, permissions 100644

[SARK devs]

OK - we've changed the initial file tests - you'll find 3.0.0-30 up on our server.

At first install, and ONLY at first install, if /home/sark/db/sark.db does not exist then it will be created with default settings.  So.... to install -30 as if it were your first install of V3.0, you must do the following

Code: [Select]

[root@test25 ~]# rpm -e sail --nodeps
[root@test25 ~]# rm -rf /home/sark/db
[root@test25 ~]# yum localinstall /home/e-smith/files/primary/files/sail-3.0.0-30.noarch.rpm --enablerepo=base
[root@test25 ~]# signal-event post-upgrade
[root@test25 ~]# signal-event reboot

You should then be good to go

If you have a spare minute, please try the database conversion routine against your existing database.  It shouldn't do any harm to your old format selintra database but you should back it up just in case.     It should just convert the rows and load them into the new SQLite db.

Kind Regards

S

[guest22]

V3.0 now installs correctly on SME7.5 and the default Sail dial plan is loaded into asterisk. I have no previous config for it's a test VM 7.5

- SME Server 7.5 (VirtualBox)
- Asterisk 1.4.32 + Dahdi (Source)
- Sail V3.0.0-30

Main differences from default Sail install on SME8:

Use this package instead of the el5 version in the Sail V3 download directory:
http://dag.wieers.com/rpm/packages/perl-DBD-SQLite/perl-DBD-SQLite-1.14-1.el4.rf.i386.rpm

Yum localinstall these packages before installing Sail V3:
xinetd.i386 2:2.3.13-4.5.el4
tftp-server.i386 0.39-3.el4
nmap.i386 2:3.70-1
perl-Date-Calc.i386 5.3-9
perl-Bit-Vector.i386 6.3-3

and you have SME 7.5 running with asterisk and Sail V3 (See sarkpbx.com for details)

[SARK devs]

Hi there

Glad you got it to run on 7.5.   Just one thing....

Yum localinstall these packages before installing Sail V3:
xinetd.i386 2:2.3.13-4.5.el4
tftp-server.i386 0.39-3.el4
nmap.i386 2:3.70-1
perl-Date-Calc.i386 5.3-9
perl-Bit-Vector.i386 6.3-3

Shouldn't be necessary just --enablerepo=base and yum will do it for you.

Nice work - let us know how you get on with 3.0.

Kind Regards

S

[guest22]

Shouldn't be necessary just --enablerepo=base and yum will do it for you.

and there's the catch... In a previous thread I referred to the 'default sme way' by using Yum. However the dependency check of Sail for checking the asterisk version fails, even though I have a => .29 asterisk install. (Does it check for an asterisk RPM only, I compiled from source?)

Only option left is using rpm --nodeps and that does not resolve the dependencies. Hence my question about the usage of 'asterisk -V' in the Sail RPM.

One more thing, the default install of asterisk and sail delivers this section in asterisk.conf: (Don't know if it's stock asterisk or Sail mod)
[directories]
astetcdir => /etc/asterisk
astmoddir => /usr/lib/asterisk/modules
astvarlibdir => /var/lib/asterisk
astdatadir => /var/lib/asterisk
astagidir => /var/lib/asterisk/agi-bin
astspooldir => /var/spool/asterisk
astrundir => /var/run
astlogdir => /var/log/asterisk

Whilst the Sail agi is in /usr/share/asterisk/agi-bin
 

[SARK devs]

Hi

RPM dependencies check rpms, so it won't see your manual install.  I may have to remove this dependency anyway, beacuse now there are two rpm sources (ATrpms and Digium) and each uses a different naming convention.  We'll just have to inform people I think.

Re /etc/asterisk/asterisk.conf  - yes our rpm-installed Asterisk 1.4.29 version looks the same as yours.  We don't touch this file so I don't know the answer to your question, except to say that Asterisk looks for the  agi modules and its sound in the /usr/share directory leg when it is running.

Kind Regards

S

[SARK devs]

The dependency will be removed in today's build (-32 or 33 )

Kind Regards

S

[guest22]

I can confirm that the latest SailV3 installs on SME7.5 (as per instructions on sarkpbx.com) using yum localinstall. Dependencies will automatically be resolved.

Asterisk is running with the Sail default dialplan loaded, and providing dialtone to a sample (SIP) extension.

Only difference remaining between installing on SME8b5 and SME7.5 is:
http://dag.wieers.com/rpm/packages/perl-DBD-SQLite/perl-DBD-SQLite-1.14-1.el4.rf.i386.rpm

[SARK devs]

Cool 

Now we know it will run on 7.5 (EL4)  as well as 8.0 (EL5).

Thanks for your help

Best

S

[Teviot]

Hi S

I followed the instructions found at http://forums.contribs.org/index.php/topic,46173.0.html to install on to SME 7.5 then installed 2.5.1.

Upon seeing this post about v3.0 SAIL I then did the upgrade to v3.0.

I got the following error

Code: [Select]

DBD::SQLite::db prepare failed: no such table: tt_help_user(1) at dbdimp.c line 271 at /usr/lib/perl5/site_perl/sark/SarkSubs.pm line 1047.

Install procedure was as follows

Code: [Select]

[root@saint ~]# yum localinstall sail-3.0.0-32.noarch.rpm
Loading "fastestmirror" plugin
Loading "smeserver" plugin
Loading "installonlyn" plugin
Loading "protect-packages" plugin
Setting up Local Package Process
Examining sail-3.0.0-32.noarch.rpm: sail - 3.0.0-32.noarch
Marking sail-3.0.0-32.noarch.rpm as an update to sail - 2.5.1-10.noarch
Resolving Dependencies
--> Populating transaction set with selected packages. Please wait.
---> Package sail.noarch 0:3.0.0-32 set to be updated
--> Running transaction check
Setting up repositories
Loading mirror speeds from cached hostfile
Reading repository metadata in from local files
Excluding Packages from CentOS - os
Finished
Excluding Packages from CentOS - updates
Finished
Excluding Packages from CentOS - os
Finished
Excluding Packages from CentOS - updates
Finished
--> Processing Dependency: perl-DBD-SQLite for package: sail
--> Finished Dependency Resolution
Error: Missing Dependency: perl-DBD-SQLite is needed by package sail
[root@saint ~]# yum localinstall perl-DBD-SQLite-1.14-1.el4.rf.i386.rpm
Loading "fastestmirror" plugin
Loading "smeserver" plugin
Loading "installonlyn" plugin
Loading "protect-packages" plugin
Setting up Local Package Process
Examining perl-DBD-SQLite-1.14-1.el4.rf.i386.rpm: perl-DBD-SQLite - 1.14-1.el4.rf.i386
Marking perl-DBD-SQLite-1.14-1.el4.rf.i386.rpm to be installed
Resolving Dependencies
--> Populating transaction set with selected packages. Please wait.
---> Package perl-DBD-SQLite.i386 0:1.14-1.el4.rf set to be updated
--> Running transaction check

Dependencies Resolved

=============================================================================
 Package                 Arch       Version          Repository        Size
=============================================================================
Installing:
 perl-DBD-SQLite         i386       1.14-1.el4.rf    perl-DBD-SQLite-1.14-1.el4.rf.i386.rpm  1.6 M

Transaction Summary
=============================================================================
Install      1 Package(s)         
Update       0 Package(s)         
Remove       0 Package(s)         
Total download size: 1.6 M
Is this ok [y/N]: y
Downloading Packages:
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing: perl-DBD-SQLite              ######################### [1/1]

Installed: perl-DBD-SQLite.i386 0:1.14-1.el4.rf
Complete!
[root@saint ~]# yum localinstall sail-3.0.0-32.noarch.rpm
Loading "fastestmirror" plugin
Loading "smeserver" plugin
Loading "installonlyn" plugin
Loading "protect-packages" plugin
Setting up Local Package Process
Examining sail-3.0.0-32.noarch.rpm: sail - 3.0.0-32.noarch
Marking sail-3.0.0-32.noarch.rpm as an update to sail - 2.5.1-10.noarch
Resolving Dependencies
--> Populating transaction set with selected packages. Please wait.
---> Package sail.noarch 0:3.0.0-32 set to be updated
--> Running transaction check

Dependencies Resolved

=============================================================================
 Package                 Arch       Version          Repository        Size
=============================================================================
Updating:
 sail                    noarch     3.0.0-32         sail-3.0.0-32.noarch.rpm  5.3 M

Transaction Summary
=============================================================================
Install      0 Package(s)         
Update       1 Package(s)         
Remove       0 Package(s)         
Total download size: 5.3 M
Is this ok [y/N]: y
Downloading Packages:
Running Transaction Test
warning: only V3 signatures can be verified, skipping V4 signature
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
warning: only V3 signatures can be verified, skipping V4 signature
  Updating  : sail                         ######################### [1/2]
  Cleanup   : sail                         ######################### [2/2]

Updated: sail.noarch 0:3.0.0-32
Complete!
[root@saint ~]#
A reboot & reconfigure comand was then issued.

the command

Code: [Select]

perl /etc/sark/scripts/srkinsertdbdata.pl was then issued

and a call attempted from an exsisting SARK SAIL pbx to an extension on the new server.

Code: [Select]

saint*CLI>
    -- Accepting AUTHENTICATED call from 192.168.76.2:
       > requested format = g729,
       > requested prefs = (g729|alaw|ulaw),
       > actual format = alaw,
       > host prefs = (),
       > priority = caller
    -- Executing [2000@internal:1] AGI("IAX2/sailsaint-1092", "sarkhpe|OutCluster|2000") in new stack
    -- Launched AGI Script /usr/share/asterisk/agi-bin/sarkhpe
    -- AGI Script Executing Application: (Set) Options: (CDR(accountcode)=)
    -- AGI Script sarkhpe completed, returning 0
    -- Executing [2000@qrxvtmny:1] AGI("IAX2/sailsaint-1092", "sarkhpe|OutRoute|All Calls") in new stack
    -- Launched AGI Script /usr/share/asterisk/agi-bin/sarkhpe
    -- AGI Script Executing Application: (Set) Options: (TIMEOUT(absolute)=3600)
    -- Channel will hangup at 2010-06-24 17:56:10 UTC.
    -- AGI Script Executing Application: (Dial) Options: (IAX2/saintsail@sailsaint/2000||)
    -- Called saintsail@sailsaint/2000
    -- Call accepted by 192.168.76.2 (format g729)
    -- Format for call is g729
[Jun 25 02:56:10] WARNING[5152]: channel.c:3124 set_format: Unable to find a codec translation path from 0x100 (g729) to 0x8 (alaw)
[Jun 25 02:56:10] WARNING[5152]: channel.c:3124 set_format: Unable to find a codec translation path from 0x100 (g729) to 0x8 (alaw)
    -- Accepting AUTHENTICATED call from 192.168.76.2:
       > requested format = g729,
       > requested prefs = (g729|alaw|ulaw),
       > actual format = alaw,
       > host prefs = (),
       > priority = caller
    -- Executing [2000@internal:1] AGI("IAX2/sailsaint-4830", "sarkhpe|OutCluster|2000") in new stack
    -- Launched AGI Script /usr/share/asterisk/agi-bin/sarkhpe
    -- AGI Script Executing Application: (Set) Options: (CDR(accountcode)=)
    -- AGI Script sarkhpe completed, returning 0
    -- Executing [2000@qrxvtmny:1] AGI("IAX2/sailsaint-4830", "sarkhpe|OutRoute|All Calls") in new stack
    -- Launched AGI Script /usr/share/asterisk/agi-bin/sarkhpe
    -- AGI Script Executing Application: (Set) Options: (TIMEOUT(absolute)=3600)
    -- Channel will hangup at 2010-06-24 17:56:10 UTC.
    -- AGI Script Executing Application: (Dial) Options: (IAX2/saintsail@sailsaint/2000||)
    -- Called saintsail@sailsaint/2000
    -- Call accepted by 192.168.76.2 (format g729)
    -- Format for call is g729
[Jun 25 02:56:10] WARNING[5150]: channel.c:3124 set_format: Unable to find a codec translation path from 0x100 (g729) to 0x8 (alaw)
[Jun 25 02:56:10] WARNING[5150]: channel.c:3124 set_format: Unable to find a codec translation path from 0x100 (g729) to 0x8 (alaw)
    -- IAX2/sailsaint-19118 answered IAX2/sailsaint-4830
    -- Operating with different codecs 8[0x8 (alaw)] 256[0x100 (g729)] , can't native bridge...
    -- IAX2/sailsaint-17427 answered IAX2/sailsaint-1092
    -- Operating with different codecs 8[0x8 (alaw)] 256[0x100 (g729)] , can't native bridge...
    -- Operating with different codecs 8[0x8 (alaw)] 256[0x100 (g729)] , can't native bridge...
[Jun 25 02:56:10] WARNING[5146]: channel.c:3124 set_format: Unable to find a codec translation path from 0x100 (g729) to 0x8 (alaw)
    -- Executing [h@qrxvtmny:1] Hangup("IAX2/sailsaint-4830", "") in new stack
  == Spawn h extension (qrxvtmny, h, 1) exited non-zero on 'IAX2/sailsaint-4830'
    -- Hungup 'IAX2/sailsaint-19118'
    -- AGI Script sarkhpe completed, returning 0
  == Auto fallthrough, channel 'IAX2/sailsaint-4830' status is 'ANSWER'
    -- Executing [h@qrxvtmny:1] Hangup("IAX2/sailsaint-4830", "") in new stack
  == Spawn extension (qrxvtmny, h, 1) exited non-zero on 'IAX2/sailsaint-4830'
    -- Hungup 'IAX2/sailsaint-4830'
    -- Executing [h@qrxvtmny:1] Hangup("IAX2/sailsaint-1092", "") in new stack
  == Spawn h extension (qrxvtmny, h, 1) exited non-zero on 'IAX2/sailsaint-1092'
    -- Hungup 'IAX2/sailsaint-17427'
    -- AGI Script sarkhpe completed, returning 0
  == Auto fallthrough, channel 'IAX2/sailsaint-1092' status is 'ANSWER'
    -- Executing [h@qrxvtmny:1] Hangup("IAX2/sailsaint-1092", "") in new stack
  == Spawn extension (qrxvtmny, h, 1) exited non-zero on 'IAX2/sailsaint-1092'
    -- Hungup 'IAX2/sailsaint-1092'
saint*CLI>
What am I missing? I have looked that the console and can't find anything that I could change. I will admit that it is 3.30am when I trying to do this.

Thanks in Advance

[SARK devs]

Chris's instructions are for 2.5.  3.0 is a little different; you can finds instructions here

http://sarkpbx.com/twiki/bin/view/Main/DocChapter03f

The main thing you didn't do was to issue a signal-event post-upgrade at the end if the sail install. This causes the database to be initialized.  As a result, your database will be incomplete.

Fortunately, it isn't too difficult to correct (as long as you still have the V2 database - /home/e-smith/db/selintra).

First of all remove V3 and the incomplete V3 database

Code: [Select]

rpm -e sail
rm -rf /home/sark/db

Now follow the instructions on the sark wiki (see above) to install V3 correctly.

Lastly, the reason your call in didn't work was that you sent in a G729 call to an Asterisk system that does not have G729 codec installed.  It's in the logs you posted

Code: [Select]

[Jun 25 02:56:10] WARNING[5150]: channel.c:3124 set_format: Unable to find a codec translation path from 0x100 (g729) to 0x8 (alaw)
[Jun 25 02:56:10] WARNING[5150]: channel.c:3124 set_format: Unable to find a codec translation path from 0x100 (g729) to 0x8 (alaw)
    -- IAX2/sailsaint-19118 answered IAX2/sailsaint-4830
    -- Operating with different codecs 8[0x8 (alaw)] 256[0x100 (g729)] , can't native bridge...
    -- IAX2/sailsaint-17427 answered IAX2/sailsaint-1092
    -- Operating with different codecs 8[0x8 (alaw)] 256[0x100 (g729)] , can't native bridge...
    -- Operating with different codecs 8[0x8 (alaw)] 256[0x100 (g729)] , can't native bridge...
[Jun 25 02:56:10] WARNING[5146]: channel.c:3124 set_format: Unable to find a codec translation path from 0x100 (g729) to 0x8 (alaw)
    -- Executing [h@qrxvtmny:1] Hangup("IAX2/sailsaint-4830", "") in new stack
Kind Regards

S
 

[Teviot]

Hi S

Got those issues sorted.  But still can't get a call into the pbx.  Outgoing work with no problem.

Code: [Select]

saint*CLI>
    -- Accepting AUTHENTICATED call from 192.168.76.2:
       > requested format = g729,
       > requested prefs = (g729|gsm|ulaw|alaw),
       > actual format = g729,
       > host prefs = (),
       > priority = caller
    -- Executing [2000@internal:1] AGI("IAX2/sailsaint-1785", "sarkhpe|OutCluster|2000") in new stack
    -- Launched AGI Script /usr/share/asterisk/agi-bin/sarkhpe
    -- AGI Script Executing Application: (Set) Options: (CDR(accountcode)=)
    -- AGI Script sarkhpe completed, returning 0
    -- Executing [2000@qrxvtmny:1] AGI("IAX2/sailsaint-1785", "sarkhpe|OutRoute|All Calls") in new stack
    -- Launched AGI Script /usr/share/asterisk/agi-bin/sarkhpe
    -- AGI Script Executing Application: (Set) Options: (TIMEOUT(absolute)=3600)
    -- Channel will hangup at 2010-06-25 04:38:06 UTC.
    -- AGI Script Executing Application: (Dial) Options: (IAX2/saintsail@sailsaint/2000||)
    -- Called saintsail@sailsaint/2000
    -- Call accepted by 192.168.76.2 (format g729)
    -- Format for call is g729
    -- Accepting AUTHENTICATED call from 192.168.76.2:
       > requested format = g729,
       > requested prefs = (g729|gsm|ulaw|alaw),
       > actual format = g729,
       > host prefs = (),
       > priority = caller
    -- Executing [2000@internal:1] AGI("IAX2/sailsaint-1471", "sarkhpe|OutCluster|2000") in new stack
    -- Launched AGI Script /usr/share/asterisk/agi-bin/sarkhpe
    -- AGI Script Executing Application: (Set) Options: (CDR(accountcode)=)
    -- AGI Script sarkhpe completed, returning 0
    -- Executing [2000@qrxvtmny:1] AGI("IAX2/sailsaint-1471", "sarkhpe|OutRoute|All Calls") in new stack
    -- Launched AGI Script /usr/share/asterisk/agi-bin/sarkhpe
    -- AGI Script Executing Application: (Set) Options: (TIMEOUT(absolute)=3600)
    -- Channel will hangup at 2010-06-25 04:38:06 UTC.
    -- AGI Script Executing Application: (Dial) Options: (IAX2/saintsail@sailsaint/2000||)
    -- Called saintsail@sailsaint/2000
    -- Call accepted by 192.168.76.2 (format g729)
    -- Format for call is g729
    -- IAX2/sailsaint-19994 answered IAX2/sailsaint-1471
    -- IAX2/sailsaint-26387 answered IAX2/sailsaint-1785
    -- Channel 'IAX2/sailsaint-19994' ready to transfer
    -- Channel 'IAX2/sailsaint-26387' ready to transfer
    -- Channel 'IAX2/sailsaint-1471' ready to transfer
    -- Releasing IAX2/sailsaint-1471 and IAX2/sailsaint-19994
    -- Channel 'IAX2/sailsaint-1785' ready to transfer
    -- Releasing IAX2/sailsaint-1785 and IAX2/sailsaint-26387
saint*CLI>

[SARK devs]

what did you dial on the sending machine? 

I see 2000 - what is that?  Is it an extension?  a ring group?

S

[Teviot]

2000 is an extension and the trunk has been set to route directly to ext2000.

here is the latest console output

Code: [Select]

saint*CLI>
    -- Accepting AUTHENTICATED call from 192.168.76.2:
       > requested format = g729,
       > requested prefs = (g729|gsm|ulaw|alaw),
       > actual format = g729,
       > host prefs = (),
       > priority = caller
    -- Executing [2000@internal:1] AGI("IAX2/sailsaint-6793", "sarkhpe|OutCluster|2000") in new stack
    -- Launched AGI Script /usr/share/asterisk/agi-bin/sarkhpe
    -- AGI Script Executing Application: (Set) Options: (CDR(accountcode)=)
    -- AGI Script sarkhpe completed, returning 0
    -- Executing [2000@qrxvtmny:1] AGI("IAX2/sailsaint-6793", "sarkhpe|OutRoute|All Calls") in new stack
    -- Launched AGI Script /usr/share/asterisk/agi-bin/sarkhpe
    -- AGI Script Executing Application: (Set) Options: (TIMEOUT(absolute)=3600)
    -- Channel will hangup at 2010-06-27 05:46:56 UTC.
    -- AGI Script Executing Application: (Dial) Options: (IAX2/saintsail@sailsaint/2000||)
    -- Called saintsail@sailsaint/2000
    -- Call accepted by 192.168.76.2 (format g729)
    -- Format for call is g729
    -- Accepting AUTHENTICATED call from 192.168.76.2:
       > requested format = g729,
       > requested prefs = (g729|gsm|ulaw|alaw),
       > actual format = g729,
       > host prefs = (),
       > priority = caller
    -- Executing [2000@internal:1] AGI("IAX2/sailsaint-181", "sarkhpe|OutCluster|2000") in new stack
    -- Launched AGI Script /usr/share/asterisk/agi-bin/sarkhpe
    -- AGI Script Executing Application: (Set) Options: (CDR(accountcode)=)
    -- AGI Script sarkhpe completed, returning 0
    -- Executing [2000@qrxvtmny:1] AGI("IAX2/sailsaint-181", "sarkhpe|OutRoute|All Calls") in new stack
    -- Launched AGI Script /usr/share/asterisk/agi-bin/sarkhpe
    -- AGI Script Executing Application: (Set) Options: (TIMEOUT(absolute)=3600)
    -- Channel will hangup at 2010-06-27 05:46:56 UTC.
    -- AGI Script Executing Application: (Dial) Options: (IAX2/saintsail@sailsaint/2000||)
    -- Called saintsail@sailsaint/2000
    -- Call accepted by 192.168.76.2 (format g729)
    -- Format for call is g729
    -- IAX2/sailsaint-20010 answered IAX2/sailsaint-181
    -- IAX2/sailsaint-16509 answered IAX2/sailsaint-6793
    -- Channel 'IAX2/sailsaint-181' ready to transfer
    -- Channel 'IAX2/sailsaint-20010' ready to transfer
    -- Releasing IAX2/sailsaint-20010 and IAX2/sailsaint-181
    -- Executing [h@qrxvtmny:1] Hangup("IAX2/sailsaint-181", "") in new stack
  == Spawn h extension (qrxvtmny, h, 1) exited non-zero on 'IAX2/sailsaint-181'
    -- Channel 'IAX2/sailsaint-16509' ready to transfer
    -- Channel 'IAX2/sailsaint-6793' ready to transfer
    -- Releasing IAX2/sailsaint-6793 and IAX2/sailsaint-16509
    -- Hungup 'IAX2/sailsaint-20010'
    -- AGI Script sarkhpe completed, returning 0
  == Auto fallthrough, channel 'IAX2/sailsaint-181' status is 'ANSWER'
    -- Executing [h@qrxvtmny:1] Hangup("IAX2/sailsaint-181", "") in new stack
  == Spawn extension (qrxvtmny, h, 1) exited non-zero on 'IAX2/sailsaint-181'
    -- Hungup 'IAX2/sailsaint-181'
    -- Executing [h@qrxvtmny:1] Hangup("IAX2/sailsaint-6793", "") in new stack
  == Spawn h extension (qrxvtmny, h, 1) exited non-zero on 'IAX2/sailsaint-6793'
    -- Hungup 'IAX2/sailsaint-16509'
    -- AGI Script sarkhpe completed, returning 0
  == Auto fallthrough, channel 'IAX2/sailsaint-6793' status is 'ANSWER'
    -- Executing [h@qrxvtmny:1] Hangup("IAX2/sailsaint-6793", "") in new stack
  == Spawn extension (qrxvtmny, h, 1) exited non-zero on 'IAX2/sailsaint-6793'
    -- Hungup 'IAX2/sailsaint-6793'
saint*CLI>

still doesn't ring ext2000 on inbound.  Outgoing works no problem.