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']?>
<?
}
Member Since:
2009-04-05