Web-MeetMe Requesting Multiple Logins on 2.8.0.4 - Not Displaying Data

diamedic
Posts: 3
Member Since:
2009-04-05

On an installation of 2.8.0.4, repeated logins are being requested, and the "logged in" user (an admin) cannot see any conferences, change conferences, etc. The only data being shown is in the reports section (number of conferences graph). Conferences can be scheduled with the web interface and will show in MySQL (with a select * from booking;), but they cannot be seen from Delete / Past / Current / Future Conferences. Users are not showing up in the Update user section either. Finally, calling the custom destination and putting in an active conference number will give an "invalid conference number" message.

This happens on an out of box install on 2.8.0.4, which shows a version of 3.0.4-37 in the packages section. On 2.8.0.3, which also shows a version of 3.0.4-37, it works without problems. I've also attempted to install Web-MeetMe 4.0.2 with the same problems on 2.8.0.4.

On both 2.8.0.4 and 2.8.0.3, a number of errors are showing in the /var/log/httpd/error_log, most of which are common between versions. The unique error for 2.8.0.4 is:
PHP Notice: session_start() [function.session-start]: Server localhost (tcp 11211) failed with: Connection refused (111) in /var/www/html/web-meetme/meetme_control.php on line 27, referer: http://10.21.4.42/web-meetme/meetme_control.php?s=2&t=4

A comparison of the two machines is virtually identical, outside of the kernel and Asterisk version:
2.8.0.4:
Linux trixbox1.test.local 2.6.18-164.11.1.el5 #1 SMP Wed Jan 20 07:39:04 EST 2010 i686 i686 i386 GNU/Linux
Asterisk 1.6.0.26-FONCORE-r78
Trixbox 2.8.0.4
Server version: Apache/2.2.3
mysql Ver 14.12 Distrib 5.0.77, for redhat-linux-gnu (i686) using readline 5.1
PHP 5.2.5 (cli) (built: Nov 19 2008 15:18:12)
Copyright (c) 1997-2007 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2007 Zend Technologies

2.8.0.3:
Linux asterisk 2.6.18-128.1.10.el5 #1 SMP Thu May 7 10:39:21 EDT 2009 i686 i686 i386 GNU/Linux
Asterisk 1.6.0.10-FONCORE-r40
Trixbox 2.8.0.3
Server version: Apache/2.2.3
mysql Ver 14.12 Distrib 5.0.77, for redhat-linux-gnu (i686) using readline 5.1
PHP 5.2.5 (cli) (built: Nov 19 2008 15:18:12)
Copyright (c) 1997-2007 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2007 Zend Technologies

A diff of php.ini, httpd.conf, my.cnf, /etc/trixbox/httpdconf/trixbox.conf, and /etc/httpd/conf.d files between 2.8.0.4 and 2.8.0.3 shows no differences. The files in /etc/php.d are the same between trixbox versions.

On both trixbox versions, I have verified MySQL access with "mysql -u root -p(password from database.php)".

I have also attempted to remove and re-install the module on 2.8.0.4, remove the /var/www/html/web-meetme folder and replace it with the one from 2.8.0.3 (verifying identical permissions) and dropping the db and replacing it with the 2.8.0.3 meetme db.

Any help would be greatly appreciated. database.php and defines.php below.

database.php:
<?php
include_once 'DB.php';
$database = 'meetme';
$host = 'localhost';
$username = 'root';
$password = 'passw0rd';
$dsn = "mysql://$username:$password@$host/$database";
$db = DB::connect($dsn);
if (DB::isError($db))
{
die ($db->getMessage());
}
?>

defines.php:
<?php

define ("WEBROOT", "http://localhost/");
define ("FSROOT", "/var/www/html/web-meetme/");
define ("LIBDIR", FSROOT."lib/");

//GUI title
define("GUI_TITLE", "Web-MeetMe");
define("GUI_ICON", "asterisk.gif");
define("GUI_VER", "3.0");
define("GUI_SRC", "http://sourceforge.net/projects/web-meetme/");

//Email Variables - Support contacts, Call in numbers and other spit and polish for the about page.
/*
define("LOCAL_SUPPORT", "Support Department");
define("LOCAL_PHONE", "800-123-4567");
define ("PHONENUM", "800-858-4032");
define("PBX_ICON", "asterisk.gif");
*/
// THIS VARIABLE DEFINE THE COLOR OF THE HEAD TABLE
$FG_TABLE_HEAD_COLOR = "#D1D9E7";
$FG_TABLE_EXTERN_COLOR = "#7F99CC"; //#CC0033 (Rouge)
$FG_TABLE_INTERN_COLOR = "#EDF3FF"; //#FFEAFF (Rose)

$FG_TABLE_ALTERNATE_ROW_COLOR[] = "#1FFFFF";
$FG_TABLE_ALTERNATE_ROW_COLOR[] = "#F2F8FF";

// THIS VARIABLE DEFINE THE COLOR OF THE ADMIN ROW
$FG_TABLE_ROW_COLOR_ADMIN = "#FCCDCA";

define ("HOST", "localhost");
define ("PORT", "3306");
define ("USER", "root");
define ("PASS", "passw0rd");
define ("DBNAME", "asterisk");
define ("DB_TYPE", "mysql"); // mysql or postgres

// Comment out the following lines to disable authentication
define ("AUTH_TYPE", "sqldb"); // adLDAP or sqldb
define ("ADMIN_GROUP", "Domain Admins");
define ("AUTH_TIMEOUT", "3"); //Hours
include (LIBDIR.AUTH_TYPE.".php");

//Database tables
define ("DB_TABLECDR", "cdr");
define ("DB_TABLESCHED", "booking");
define ("DB_TABLEUSERS","user");

define ("SERVER_TZ", "PST/PDT");

//Outcall defaults
define ("CHAN_TYPE", "Local"); //Use Local to let dialplan decide which chan
define ("OUT_CONTEXT", "default"); //Select a context to place the call from
define ("OUT_PEER", ""); // Use this if not using CHAN_TYPE Local
define ("OUT_CALL_CID", "Parlez <1996>"); // Caller ID for Invites

//Standard flags for Users and Admins
define ("SAFLAGS", "asdA");
define ("SUFLAGS", "d");
$Mod_Options = array(array("Announce", "i"), array("Record", "r"));
$User_Options = array(array("Announce", "i"), array("Listen Only", "m"), array("Wait for Leader", "w"));

//Require conference PIN (passwords)
define ("PASSWORD_OPTION", "NO");

//Change conference End Time on a 'End Now' click
define ("FORCE_END", "NO");

//Mailer type:
// CLIENT to use mailto: and default user mail client
// SERVER to use the server's mailer
define ("MAILER", "CLIENT");
include ("email_body.php");

//Avatar definitions
$icons_list['0'] = "./images/icons/Darth Vader.GIF";
$icons_list['1'] = "./images/icons/Anakin.GIF";
$icons_list['2'] = "./images/icons/Scout Trooper.GIF";
$icons_list['3'] = "./images/icons/Hoth Soldier.GIF";
$icons_list['4'] = "./images/icons/Major Matt Mason.GIF";
$icons_list['5'] = "./images/icons/Landspeeder Ben.GIF";
$icons_list['6'] = "./images/icons/Obi Wan With Hood.GIF";
$icons_list['7'] = "./images/icons/Wedge.GIF";
$icons_list['8'] = "./images/icons/Rebel Tech.GIF";
$icons_list['9'] = "./images/icons/Larry the Lobster.GIF";

$months = array("January","February","March","April","May","June","July","August","September","October","November","December");

$days = array("31","28","31","30","31","30","31","31","30","31","30","31");

$recurLabel = array("Daily", "Weekly", "Bi-weekly");
$recurInterval = array("86400", "604800", "1209600");
$recurPeriod = array("14", "26", "13");

function contact(){
?>

Support Team ...

Contact: <?php echo LOCAL_SUPPORT ?>
Phone: <?php echo LOCAL_PHONE ?>

Developer Team ...

">Arezqui Belaïd
: areski (no@spam) gmail (dot) com
Dan Austin

Last update: <?php echo GUI_VER ?>
Developer Website: ">Web-MeetMe

">

User details ...

Currently logged on as <?php echo $_SESSION['userid']?> a <?php echo $_SESSION['privilege']?> and a member of <?php echo $_SESSION['groups']?>

<?
}



obeliks
Posts: 877
Member Since:
2010-03-14
you need to start memcached

you need to start memcached



diamedic
Posts: 3
Member Since:
2009-04-05
Thanks very much - that

Thanks very much - that fixes the web interface problem.
I am still getting the "invalid conference number" issue when calling.

extensions_custom.conf has this:
[custom-meetme3]
exten => s,1,Answer
exten => s,n,Wait(3)
exten => s,n,MeetMe()
exten => s,n,Hangup

Which results in this when called:
[Aug 29 15:54:55] VERBOSE[19589] logger.c: -- Executing [3987@from-internal:1] NoOp("SIP/ATLMAR-00000000", "Running miscapp 4: ConferenceCenter") in new stack
[Aug 29 15:54:55] VERBOSE[19589] logger.c: -- Executing [3987@from-internal:2] Goto("SIP/ATLMAR-00000000", "custom-meetme3,s,1") in new stack
[Aug 29 15:54:55] VERBOSE[19589] logger.c: -- Goto (custom-meetme3,s,1)
[Aug 29 15:54:55] VERBOSE[19589] logger.c: -- Executing [s@custom-meetme3:1] Answer("SIP/ATLMAR-00000000", "") in new stack
[Aug 29 15:54:55] VERBOSE[19589] logger.c: -- Executing [s@custom-meetme3:2] Wait("SIP/ATLMAR-00000000", "3") in new stack
[Aug 29 15:54:58] VERBOSE[19589] logger.c: -- Executing [s@custom-meetme3:3] MeetMe("SIP/ATLMAR-00000000", "") in new stack
[Aug 29 15:54:58] VERBOSE[19589] logger.c: -- Playing 'conf-getconfno.gsm' (language 'en')
[Aug 29 15:55:06] VERBOSE[19589] logger.c: == Parsing '/etc/asterisk/meetme.conf': [Aug 29 15:55:06] VERBOSE[19589] logger.c: == Found
[Aug 29 15:55:06] VERBOSE[19589] logger.c: == Parsing '/etc/asterisk/meetme_additional.conf': [Aug 29 15:55:06] VERBOSE[19589] logger.c: == Found
[Aug 29 15:55:06] VERBOSE[19589] logger.c: -- Playing 'conf-invalid.gsm' (language 'en')
[Aug 29 15:55:10] VERBOSE[19589] logger.c: -- Playing 'conf-getconfno.gsm' (language 'en')
[Aug 29 15:55:12] VERBOSE[19589] logger.c: == Parsing '/etc/asterisk/meetme.conf': [Aug 29 15:55:12] VERBOSE[19589] logger.c: == Found
[Aug 29 15:55:12] VERBOSE[19589] logger.c: == Parsing '/etc/asterisk/meetme_additional.conf': [Aug 29 15:55:12] VERBOSE[19589] logger.c: == Found
[Aug 29 15:55:12] VERBOSE[19589] logger.c: -- Playing 'conf-invalid.gsm' (language 'en')
[Aug 29 15:55:14] WARNING[19589] file.c: Failed to write frame
[Aug 29 15:55:14] VERBOSE[19589] logger.c: -- Playing 'conf-getconfno.gsm' (language 'en')
[Aug 29 15:55:14] VERBOSE[19589] logger.c: == Spawn extension (custom-meetme3, s, 3) exited non-zero on 'SIP/ATLMAR-00000000'

I have tried doing a load / unload of app_cbmysql.so (which fails) as described in various articles and tried the steps at http://fonality.com/trixbox/forums/trixbox-forums/help/appcbmysql... and it's accompanying sourceforge articles.

I have tried both the out of box app_cbmysql and the sourceforge one (size 34,058).
If I could get cb_mysql to load, I would change the info in extensions_custom.conf.
Any further ideas?
Thank you.



diamedic
Posts: 3
Member Since:
2009-04-05
Fixed

So Dan said this at web-meetme at Sourceforge:
Someone in the TB community needs to rebuild app_cbmysql before blindly including it in their packages. Until the Asterisk version in TB is upgraded to 1.6.2.7 or higher, you have to use app_cbmysql, and any dialplan code needs to call cbmysql in place of meetme-

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

If you downloaded and installed 4.0.3, that package has the app_cbmysql source in ./cbmysql. If you install the TB Asterisk development packages you should be able to just use 'make;make install' to get a working app_cbmysql. You may need to tweak the line-
CFLAGS+=-I/usr/src/asterisk to point to the location TB installs the Asterisk source.

So then I did this:
yum remove asterisk-devel
yum install asterisk16-devel
yum install mysql-devel
changed the Makefile (for app_cbmysql as downloaded from the 4.02 version) to CFLAGS+=-I/usr/include
make
make install
module unload / load
changed call in [custom-meetme3] from MeetMe() to cbmysql()
amportal restart

As an interesting side note, we have a bunch of Aastras that were giving the "No conference room has been configured on this platform" configuration error immediately after joining the conference. As we have no static conference rooms to be concerned with, I renamed meetme.php in /var/www/html/aastra/asterisk and the error went away.

Thanks for all the help.



Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.