app_cbmysql.so on TB 2.8

wil

Posts: 2
Member Since:
2009-07-16

Submitted by wil on Thu, 07/16/2009 - 3:30pm.

Trying to get WebmeetMe to work in trixbox 2.8

I've went through the steps of creating a custom destination, created a custom application and assigned a feature code.

Now, whenever I dial the feature code it, it exit non-zeros when it reaches the cbmysql stage (as outlined in my extensions.conf file)

Here is my CLI output:

Connected to Asterisk 1.6.0.9-samy-r27 currently running on lltrixbox (pid = 16541)
Verbosity is at least 3
  == Using SIP RTP TOS bits 184
  == Using SIP RTP CoS mark 5
  == Using SIP VRTP TOS bits 136
  == Using SIP VRTP CoS mark 6
    -- Executing [*13@from-internal:1] NoOp("SIP/503-b79caad8", "Running miscapp 1: Webmeetme Conference") in new stack
    -- Executing [*13@from-internal:2] Goto("SIP/503-b79caad8", "custom-meetme3,s,1") in new stack
    -- Goto (custom-meetme3,s,1)
    -- Executing [s@custom-meetme3:1] Answer("SIP/503-b79caad8", "") in new stack
    -- Executing [s@custom-meetme3:2] Wait("SIP/503-b79caad8", "3") in new stack
  == Spawn extension (custom-meetme3, s, 3) exited non-zero on 'SIP/503-b79caad8'
lltrixbox*CLI>

Here is the custom destination set in the extensions_custom.conf

[custom-meetme3]
exten => s,1,Answer
exten => s,n,Wait(3)
exten => s,n,CBMysql()
exten => s,n,Hangup

My /var/log/asterisk/full log shows the following:

[Jul 16 17:28:36] VERBOSE[20102] logger.c:     -- Executing [*13@from-internal:1] ^[[1;36;40mNoOp^[[0;37;40m("^[[1;35;40mSIP/503-b79caad8^[[0;37;40m", "^[[1;$
[Jul 16 17:28:36] VERBOSE[20102] logger.c:     -- Executing [*13@from-internal:2] ^[[1;36;40mGoto^[[0;37;40m("^[[1;35;40mSIP/503-b79caad8^[[0;37;40m", "^[[1;$
[Jul 16 17:28:36] VERBOSE[20102] logger.c:     -- Goto (custom-meetme3,s,1)
[Jul 16 17:28:36] VERBOSE[20102] logger.c:     -- Executing [s@custom-meetme3:1] ^[[1;36;40mAnswer^[[0;37;40m("^[[1;35;40mSIP/503-b79caad8^[[0;37;40m", "^[[1$
[Jul 16 17:28:36] VERBOSE[20102] logger.c:     -- Executing [s@custom-meetme3:2] ^[[1;36;40mWait^[[0;37;40m("^[[1;35;40mSIP/503-b79caad8^[[0;37;40m", "^[[1;3$
[Jul 16 17:28:39] WARNING[20102] pbx.c: No application 'CBMysql' for extension (custom-meetme3, s, 3)

I guess my question is - how do I install cbmysql on trixbox 2.8

I see the module is loaded in /usr/lib/asterisk/modules/app_cbmysql.so, but when I try to run module load app_cbmysql.so it says the module cannot be loaded.

lltrixbox*CLI> module load app_cbmysql.so
Unable to load module app_cbmysql.so
Command 'module load app_cbmysql.so' failed.
lltrixbox*CLI>

Any help would be great.

Additional Info:

This is a Trixbox Enterprise Appliance, I installed trixbox 2.8, it has a Sangoma a101de card, connected to a 16 Channel PRI.

Everything else works great, just starting to tweak little things here and there, and this was one of the problems I came across.

Thanks!

Will

&nbsp

Maatj

Posts: 3
Member Since:
2009-06-03

Same error...

Tue, 08/11/2009 - 4:36am

Hi Wil, I got the same error, did you find a solution for this issue already?

&nbsp

stevenl0002003

Posts: 1
Member Since:
2009-08-12

Same error ....

Wed, 08/12/2009 - 3:28am

Exactly the same issue here. I'd also be grateful for any advice!

&nbsp

santinelli

Posts: 21
Member Since:
2008-11-14

Yeah.... Same here...

Fri, 08/14/2009 - 9:04am

Been working this for the last hour. Have all my extensions up and running, SIP Trunk running.... Thought life was good till I then turned to Conferencing.... Ugh. I remember this working in 2.6.... I THINK I had to modify something in the cbmysql config file, but can't remember.....

Steve

&nbsp

santinelli

Posts: 21
Member Since:
2008-11-14

Found the problem....

Fri, 08/14/2009 - 9:30am

The problem is with the compiled module app_cbmysql.so. It wasn't compiled with the same version of asterisk:

Module 'app_cbmysql.so' was not compiled with the same compile-time options as this version of Asterisk.
Module 'app_cbmysql.so' will not be initialized as it may cause instability.

SO.... Next is to figure out how to rebuild app_cbmysql.so....

&nbsp

SkykingOH

Posts: 9675
Member Since:
2007-12-17

It would be as easy to

Fri, 08/14/2009 - 11:10am

It would be as easy to rebuild Asterisk and Asterisk add-on than to try and get a single module running.

Scott

aka "Skyking"

&nbsp

santinelli

Posts: 21
Member Since:
2008-11-14

Developer...

Fri, 08/14/2009 - 11:26am

Well, I posted over on sourceforge with the guy that wrote web meetme to see if he's built one up yet, worst case, I build a VM with asterisk, and mysql and build from scratch. Guess I'm more surprised that it wasn't fixed before 2.8 shipped... This is a pretty big part of the entire system for us....

&nbsp

gigacon

Posts: 4
Member Since:
2009-09-03

same problem

Thu, 09/03/2009 - 3:22am

has anyone just solved the problem? it would be very important for me to get meetme to run!

&nbsp

tomhiggins

Posts: 18
Member Since:
2009-08-17

Similar issue

Thu, 09/03/2009 - 3:35am

I had a similar issue with the asterisk addon... i ran the following code.

yum install asterisk16-addon-mysql

I am not sure if it is in the same package or not, but that may bring it to life... it did for the standard mysql asterisk app

cheers
Tom

-------------------------
Tom Higgins
Practical Applications
open source your life
w: www.pracapps.com.au
p: +61 3 8678 3641

&nbsp

gigacon

Posts: 4
Member Since:
2009-09-03

when i tried installing it,

Thu, 09/03/2009 - 4:03am

when i tried installing it, i only got the message:
Package asterisk16-addons-mysql-1.6.0.2-3_trixbox.i386 already installed and latest version

what else can i do?

&nbsp

wil

Posts: 2
Member Since:
2009-07-16

I've still not found a

Thu, 09/10/2009 - 7:35am

I've still not found a solution to this yet. I'm hesitant to do any kind of recompiling on this box now as it is in production (without webmeetme :( )

I'll have to ghost the box and put it on a virtual box or something and see what I can do.

&nbsp

jhainsworth

Posts: 6
Member Since:
2009-10-23

Did you ever get this to

Mon, 11/09/2009 - 10:54am

Did you ever get this to work. I would hate to have to go back to 2.6 to get this working.

Is there any way to find out what options Asterisk way complied with to make TB 2.8, so we can re-compile cbmysql.so with the right options?

If not, what is the hope of getting a new ISO loaded to the site with the correct cbmysql.so?

Or, can someone tell me where to get the complete source for TB 2.8 including Meetme3 and cbmysql so I can compile everything?

I really need this to work.

&nbsp

jhainsworth

Posts: 6
Member Since:
2009-10-23

Bug Logged

Mon, 11/09/2009 - 1:35pm

I have logged this as a bug with the trixbox development project on sourceforge.

I will post any solution they provide.

&nbsp

jhainsworth

Posts: 6
Member Since:
2009-10-23

Solution

Tue, 11/10/2009 - 9:04am

I have worked with Dan Austin, the developer of WMM to get a new version of the app_cbmysql.so file that works correctly this Trixbox 2.8/Asterisk 1.6.

Many, many thanks go out to Dan. His help and support has been extrodanary.

The new file can be found at the Trixbox source respository on Source Forge
https://sourceforge.net/tracker/index.php?func=detail&aid=2894784...

Hope the helps everyone.

&nbsp

cmslaght

Posts: 4
Member Since:
2007-09-26

Worked: WebMeetme on Trixbox 2.8

Wed, 11/11/2009 - 2:12pm

Adding that new version of app_cbmysql.so worked for me!
Thanks much! I was scratching my head thinking "What doesn't Fonality test this stuff!"

&nbsp

dwant

Posts: 1
Member Since:
2009-11-12

Should I have to unload MeetMe in order to use CBMySQL

Thu, 11/12/2009 - 10:18am

I found where to install the application but it would not let me load until I had unloaded Meetme. Isn't the Meetme app newer?
Do I need to upgrade to meetme 4.0 in order to use meetme app or should I be using the CBMySQL?
Will I need to unload MeetMe and reload CBMysql everytime I reboot?

Thanks for the help!

&nbsp

cmslaght

Posts: 4
Member Since:
2007-09-26

ok.. didnt work

Thu, 11/12/2009 - 10:19am

I was able to load the module after replacing the file from the one posted above. At the asterisk console, if I execute load app_cbmysql, it load and seems happy. When I try to jump into a conference, it segfaults my server! I tested it on another trixbox 2.8 server with same result.
I found a doc that basically says that WebMeetme v3 is for asterisk 1.4 and webmeetme v4 is for asterisk 1.6.. so I think I am going to give up and install WebMeetMe v.4 on my trixbox.

&nbsp

jhainsworth

Posts: 6
Member Since:
2009-10-23

Found more bugs in app_cbmysql

Thu, 11/12/2009 - 3:25pm

Working with Dan Austin at Web-MeetMe, we found additional bugs in app_cbmysql.

The latest version is available at https://sourceforge.net/tracker/?func=detail&aid=2896876&group_id...
I wish there were a way to post files here so I didn't have to send you to another site to get the file. Maybe it just me, but I can't find a to do that.

cmslaght:
This is the same issue that I found, Dan fix and I debuged on Trixbox. He is not a Trixbox guy, uses straight Asterisk.
If you go to v4 you will need to make major changes to your meetme database as the column names have been standardized to be compatible with the meetme application included in Asterisk 1.6.

dwant:
Yes, if you want to you the new meetme and web-meetme both you need to upgrade to web-meetme 4.0. Check out the instructions in the readme on getting the two to work with each other.

&nbsp

jhainsworth

Posts: 6
Member Since:
2009-10-23

Finally a fully functional conferencing system.

Wed, 11/18/2009 - 10:43am

The following are additional steps and files that need to be modified to
get Web-MeetMe to work in version 2.8 for Trixbox CE

Be sure to copy the sound files in /var/www/html/web-mettme/sounds to
/var/lib/asterisk/sounds.

Replace /etc/asterisk/extensions_custom.conf, /etc/asterisk/phpagi.conf and
/etc/asterisk/manager.conf with the attached files.

Replace the /var/www/html/web-meetme/cbmysql/cbmysql.conf file with the
attached file.

Use mysql console to execute the following, as this columns are not used.

alter table cdr drop jointime;
alter table cdr drop leavetime;

Replace the play.php and meetme_control.php files in
/var/www/html/web-meetme with the attached versions.

Replace the cbEnd.php and defines.php files in /var/www/html/web-meetme/lib
with the attached versions.

Edit the defines.php and change the Email Variables as appropriate for your
site.

Add cbEnd.php to the /etc/init.d/asterisk file as in the attached file.

All files can be downloaded from the link below.

https://sourceforge.net/tracker/index.php?func=detail&aid=2899946...

&nbsp

uweis

Posts: 11
Member Since:
2006-12-11

Web-MeetMe in version 2.8 for Trixbox CE

Wed, 11/25/2009 - 8:31am

Clean install of Trixbox CE version 2.8.02, installed app_cbmysql, applied 10 changes from jhainsworth

still crashing asterisk when connect to conference.

/usr/sbin/safe_asterisk: line 148: 3917 Segmentation fault nice -n $PRIORITY ${ASTSBINDIR}/asterisk -f ${CLIARGS} ${ASTARGS} >&/dev/${TTY} Asterisk ended with exit status 139
Asterisk exited on signal 11.
Automatically restarting Asterisk.
/usr/sbin/safe_asterisk: line 148: 3917 Segmentation fault
-bash: /usr/sbin/safe_asterisk:: No such file or directory

&nbsp

JaneSmith7175

Posts: 2
Member Since:
2009-12-07

Close...?

Mon, 12/07/2009 - 9:51am

Hello everyone,

Thanks for the useful information so far getting Web-MeetMe to work properly, but I have one last annoying hurdle in the way. Maybe someone could advise me?

I'm using Trixbox CE v2.8.0.1 and have performed all the updates and tweaks I can find to get Web-MeetMe to work.

Here's what I've done:

- Custom destination, custom application, feature code setup
- Fixed the typos for null passwords etc
- Updated app_cbmysql.so (thanks, jhainsworth)

At this point, I can setup up conferences etc with no problems via the wmm interface, but once a user has entered the conference number and pin, instead of continuing to record announce names, the system plays 'ZERO'. Asterisk says (via asterisk -r):

-- Playing 'conf-getconfno.alaw' (language 'en')
-- Playing 'agent-pass.alaw' (language 'en')
== Parsing '/etc/asterisk/meetme.conf': == Found
== Parsing '/etc/asterisk/meetme_additional.conf': == Found
-- Playing 'digits/0.alaw' (language 'en')

Then kicks the user with 'Disconnected from Asterisk server'

I've subsequently followed the steps by jhainsworth to update confs etc from the files at sourceforge, but after entering conference number and pin, the 'ZERO' digit plays and Asterisk then segfaults and restarts, killing all calls in the process :(

For information, setting up specific conferences in the gui as maint outside of wmm works without any problem at all - numerous callers, pins, name announcements etc all fine. The problem seems to be specifically with conferences that have been setup via wmm, at the point where the user has just validated successfully with pin.

If anyone has any clues or ideas on what to try next I'd be really grateful!

Thanks,

Jane

&nbsp

uweis

Posts: 11
Member Since:
2006-12-11

app_cbmysql.so on TB 2.8

Mon, 12/07/2009 - 1:29pm

make sure you are using app_cbmysql.so from http://sourceforge.net/tracker/?func=detail&aid=2896876&group_id=...

File from 11/12/2009 and not the earlier one from 11/10/2009 - it did not work for me till i used this latest file.

&nbsp

JaneSmith7175

Posts: 2
Member Since:
2009-12-07

app_cbmysql.so on TB 2.8

Tue, 12/08/2009 - 4:16am

Uweis - I think you found my problem :)

I went through the same steps again making sure I used the app_cbmysql.so from your link and now no 'ZERO' sample and no asterisk segfault - it's working!

Thanks,

Jane

&nbsp

Maximk

Posts: 1
Member Since:
2007-06-18

Web-MeetMe in version 2.8.0.3 didnt work app_cbmysql.so TB 2.8

Wed, 02/17/2010 - 5:01am

Make sure you are using app_cbmysql.so from http://sourceforge.net/tracker/?func=detail&aid=2896876&group_id=...
ING[3696] loader.c: Error loading module 'app_cbmysql.so': /usr/lib/asterisk/modules/app_cbmysql.so: undefined symbol: __ast_malloc
ING[3696] loader.c: Module 'app_cbmysql.so' could not be loaded.

&nbsp

bac522

Posts: 6
Member Since:
2009-10-27

Your link is not valid, can

Fri, 02/19/2010 - 4:57am

Maximk Your link is not valid, can you repost?

Otherwise after using the version of app_cbmysql.so from 2009-11-12 22:09, I'm still seeing "loader.c: Error loading module 'app_cbmysql.so': /usr/lib/asterisk/modules/app_cbmysql.so: undefined symbol: __ast_malloc"

&nbsp

Vitalich

Posts: 5
Member Since:
2009-12-16

The same error after Trixbox 2.8 update to Asterisk 1.6.0.22

Wed, 02/24/2010 - 9:35am

Error loading module 'app_cbmysql.so': /usr/lib/asterisk/modules/app_cbmysql.so: undefined symbol: __ast_malloc

&nbsp

rhobson1975

Posts: 2
Member Since:
2009-12-08

Upgrade to 1.6.0.22 - same issue...

Mon, 03/01/2010 - 3:21pm

Anyone have a fix for this?

WARNING[3328] loader.c: Error loading module 'app_cbmysql.so':
/usr/lib/asterisk/modules/app_cbmysql.so: undefined symbol: __ast_malloc

&nbsp

digitalexpl0it

Posts: 1
Member Since:
2010-05-03

TrixBox 2.8

Mon, 05/03/2010 - 2:13pm

Also getting the same error as above

WARNING[3328] loader.c: Error loading module 'app_cbmysql.so':
/usr/lib/asterisk/modules/app_cbmysql.so: undefined symbol: __ast_malloc

I installed the latest app_cbmysql.so file, it will not load via cli.

[trixbox1.localdomain asterisk]# asterisk -r
Asterisk 1.6.0.22-samy-r60, Copyright (C) 1999 - 2009 Digium, Inc. and others.
Created by Mark Spencer
Asterisk comes with ABSOLUTELY NO WARRANTY; type 'core show warranty' for details.
This is free software, with components licensed under the GNU General Public
License version 2 and other licenses; you are welcome to redistribute it under
certain conditions. Type 'core show license' for details.
=========================================================================
Connected to Asterisk 1.6.0.22-samy-r60 currently running on trixbox1 (pid = 5817)
Verbosity is at least 3
trixbox1*CLI> module load app_cbmysql.so
Unable to load module app_cbmysql.so
Command 'module load app_cbmysql.so' failed.
trixbox1*CLI> exit

&nbsp

anishp55

Posts: 2
Member Since:
2010-05-13

whats the deal

Thu, 06/03/2010 - 2:30pm

so whats the deal with this??? this issue has been around since nov, its now june....
6 months, and ~ 2 point relases, and you guys are telling me you still haven't gotten the app_cbmysql.so integrated in to the build env?
i downloaded 2.8.0.3 and the app_cbmysql.so wont load... seriously wtf.....

&nbsp

jervin

Posts: 89
Member Since:
2007-01-07

sigh..

Fri, 06/25/2010 - 10:15pm

loader.c: Error loading module 'app_cbmysql.so': /usr/lib/asterisk/modules/app_cbmysql.so: undefined symbol: __ast_malloc

&nbsp

Shmaya

Posts: 5
Member Since:
2010-05-11

Same Here, any progress?

Mon, 06/28/2010 - 12:47am

I am trying to get web-meetme to work on TB 2.8.0.4, but still:
Error loading module 'app_cbmysql.so': /usr/lib/asterisk/modules/app_cbmysql.so: undefined symbol: __ast_malloc

Thanks!

&nbsp

obeliks

Posts: 878
Member Since:
2010-03-14

From

Mon, 06/28/2010 - 9:45am

From http://sourceforge.net/projects/web-meetme :

** Using Web-MeetMe with Asterisk 1.6 or newer

Starting with Asterisk 1.6, the logic to enforce
conference start times, end times and resource limits have
been moved into app_meetme. This means that this package
no longer needs app_cbmysql, however an updated verion
is included for sites that already use WMM and cannot
convert to using RealTime. It is highly recommended that
new installations use RealTime and not app_cbmysql.

&nbsp

andrew

Posts: 1472
Member Since:
2006-05-30

Thanks for the update. If

Mon, 06/28/2010 - 2:36pm

Thanks for the update. If you find any more problems please post a bug report. Thanks.

&nbsp

app_cbmysql.so on TB 2.8

Comment viewing options

Search

Main

User login

Who's online