Mysql 5.5.8 and murmur problem

[bagu]

Hello,

I upgrade mysql 5.1.54 to mysql 5.5.8 and i got an error message witch say me that there is a mysql syntaxt error...

 

Prepare Error [CREATE TABLE IF NOT EXISTS `murmur_meta`(`keystring` varchar(255) PRIMARY KEY, `value` varchar(255)) Type=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin]: You have an error in your SQL syntax;

 

I've tried murmur 1.2.2 and murmur 1.2.3 : same problem... So, how can i make it working ? Thanks

[kissaki]

Please also paste the next line as it points to where the syntax error supposedly actually is.

Upgrading mysql alone shouldn't update the db structure. Did you also update murmur?

Did you restart murmur?

Does the mysql update also clone the databses, or sth?

[hacst]

This issue has been fixed in the repository (Type=InnoDB has to be ENGINE=InnoDB iirc for newer mysqls). Don't know if there's a new server snapshot for linux yet though.

[bagu]

With the new version, it work without error.

But there is a small question. With php 5.2, ice 3.3 and mumble 1.2, i use to get the list of mumble users by using this :

function loadUser($iceUser)
{
$user = array();
$user['session']     = $iceUser->session;
//$user['id']          = $iceUser->playerid;
$user['mute']        = $iceUser->mute;
$user['deaf']        = $iceUser->deaf;
//$user['suppressed']  = $iceUser->suppressed;
$user['selfMute']    = $iceUser->selfMute;
$user['selfDeaf']    = $iceUser->selfDeaf;
$user['channel']     = $iceUser->channel;
$user['name']        = $iceUser->name;
$user['onlinesecs']  = $iceUser->onlinesecs;
$user['bytespersec'] = $iceUser->bytespersec;
return $user;
}

function get_mumble_users()
{
$tableau=array();
Ice_loadProfile();
global $ICE;
try
{
	$base = $ICE->stringToProxy("Meta:tcp -h 127.0.0.1 -p 6502");
	$meta = $base->ice_checkedCast("::Murmur::Meta");
	$servers = $meta->getBootedServers();
	$players = $servers[0]->getUsers();
	foreach($players as $player)
	{
		$tableau[]=loadUser($player);
	}
}
catch (Ice_Exception $ex)
{
	echo $lang_index['noone'];
}
return $tableau;
}

 

I have read that there is a new method to make the same thing with php 5.3 + ice 3.4 and mumble 1.2.3...

I have generate Murmur.php and put ice.php and others lib in my php path.

I have make the folowing modification :

function loadUser($iceUser)
{
$user = array();
$user['session']     = $iceUser->session;
$user['id']          = $iceUser->playerid;
$user['mute']        = $iceUser->mute;
$user['deaf']        = $iceUser->deaf;
$user['suppressed']  = $iceUser->suppressed;
$user['selfMute']    = $iceUser->selfMute;
$user['selfDeaf']    = $iceUser->selfDeaf;
$user['channel']     = $iceUser->channel;
$user['name']        = $iceUser->name;
$user['onlinesecs']  = $iceUser->onlinesecs;
$user['bytespersec'] = $iceUser->bytespersec;
return $user;
}

function get_mumble_users()
{
$tableau=array();
try
{
	require_once 'Ice.php';
	require_once 'Murmur.php';
	$ICE = Ice_initialize();
	$meta = Murmur_MetaPrxHelper::checkedCast($ICE->stringToProxy('Meta:tcp -h 127.0.0.1 -p 6502'));
	$servers = $meta->getBootedServers();
	$players = $servers[0]->getUsers();
	foreach($players as $player)
	{
		$tableau[]=loadUser($player);
	}
}
catch (Ice_Exception $ex)
{
	echo 'Erreur : '.$e->getMessage().'<br />';
	echo 'N° : '.$e->getCode();
	die();
}
return $tableau;
}

 

But $tableau is always empty (and php error logs too)...Where is my mistake ?

Can you help me please ?

[pcgod]

Make sure that you're using the 1.2.3 slice file on the client otherwise it won't work, but it should throw an exception somewhere if it's the wrong slice file...

[bagu]

I use the 1.2.3 slice...So there is no exception...I really don't understand...

And MUMPI work well and show my users...So it's not the mumble installation :S

EDIT : i have now many error message since i don't forget to call the function (don't laught too high please ^^)

Here are the error messages :

[29-Dec-2010 00:56:42] PHP Warning:  IcePHP_defineSequence() expects parameter 2 to be object, null given in D:\Ice\php\Ice\BuiltinSequences.php on line 24

[29-Dec-2010 00:56:42] PHP Warning:  IcePHP_defineSequence() expects parameter 2 to be object, null given in D:\Ice\php\Ice\BuiltinSequences.php on line 29

[29-Dec-2010 00:56:42] PHP Warning:  IcePHP_defineSequence() expects parameter 2 to be object, null given in D:\Ice\php\Ice\BuiltinSequences.php on line 34

[29-Dec-2010 00:56:42] PHP Warning:  IcePHP_defineSequence() expects parameter 2 to be object, null given in D:\Ice\php\Ice\BuiltinSequences.php on line 39

[29-Dec-2010 00:56:42] PHP Warning:  IcePHP_defineSequence() expects parameter 2 to be object, null given in D:\Ice\php\Ice\BuiltinSequences.php on line 44

[29-Dec-2010 00:56:42] PHP Warning:  IcePHP_defineSequence() expects parameter 2 to be object, null given in D:\Ice\php\Ice\BuiltinSequences.php on line 49

[29-Dec-2010 00:56:42] PHP Warning:  IcePHP_defineSequence() expects parameter 2 to be object, null given in D:\Ice\php\Ice\BuiltinSequences.php on line 54

[29-Dec-2010 00:56:42] PHP Warning:  IcePHP_defineSequence() expects parameter 2 to be object, null given in D:\Ice\php\Ice\BuiltinSequences.php on line 59

[29-Dec-2010 00:56:42] PHP Warning:  IcePHP_defineSequence() expects parameter 2 to be object, null given in D:\Ice\php\Ice\BuiltinSequences.php on line 24

[29-Dec-2010 00:56:42] PHP Warning:  IcePHP_defineSequence() expects parameter 2 to be object, null given in D:\Ice\php\Ice\BuiltinSequences.php on line 29

[29-Dec-2010 00:56:42] PHP Warning:  IcePHP_defineSequence() expects parameter 2 to be object, null given in D:\Ice\php\Ice\BuiltinSequences.php on line 34

[29-Dec-2010 00:56:42] PHP Warning:  IcePHP_defineSequence() expects parameter 2 to be object, null given in D:\Ice\php\Ice\BuiltinSequences.php on line 39

[29-Dec-2010 00:56:42] PHP Warning:  IcePHP_defineSequence() expects parameter 2 to be object, null given in D:\Ice\php\Ice\BuiltinSequences.php on line 44

[29-Dec-2010 00:56:42] PHP Warning:  IcePHP_defineSequence() expects parameter 2 to be object, null given in D:\Ice\php\Ice\BuiltinSequences.php on line 49

[29-Dec-2010 00:56:42] PHP Warning:  IcePHP_defineSequence() expects parameter 2 to be object, null given in D:\Ice\php\Ice\BuiltinSequences.php on line 54

[29-Dec-2010 00:56:42] PHP Warning:  IcePHP_defineSequence() expects parameter 2 to be object, null given in D:\Ice\php\Ice\BuiltinSequences.php on line 59

[29-Dec-2010 00:56:42] PHP Fatal error:  Uncaught exception 'RuntimeException' with message 'no object found in IcePHP_defineStruct()' in D:\Ice\php\Ice\Identity.php:44
Stack trace:
#0 D:\Ice\php\Ice\Identity.php(44): IcePHP_defineStruct('::Ice::Identity', 'Ice_Identity', Array)
#1 D:\Ice\php\Ice\LocalException.php(21): require('D:\Ice\php\Ice\...')
#2 D:\Ice\php\Ice.php(108): require('D:\Ice\php\Ice\...')
#3 E:\www\wwwbagubiz\html\test\index.php(30): require_once('D:\Ice\php\Ice....')
#4 E:\www\wwwbagubiz\html\test\index.php(53): get_mumble_users()
#5 {main}

Next exception 'RuntimeException' in D:\Ice\php\Ice\Identity.php:44
Stack trace:
#0 D:\Ice\php\Ice\Identity.php(0): IcePHP_defineStruct()
#1 D:\Ice\php\Ice\LocalException.php(21): require('D:\Ice\php\Ice\...')
#2 D:\Ice\php\Ice.php(108): require('D:\Ice\php\Ice\...')
#3 E:\www\wwwbagubiz\html\test\index.php(30): require_once('D:\Ice\php\Ice....')
#4 E:\www\wwwbagubiz\html\test\index.php(53): get_mumble_users()
#5 {main}
 thrown in D:\Ice\php\Ice\Identity.php on line 44

 

EDIT2 : PROBLEM SOLVED !

require_once 'Ice.php';

require_once 'Murmur.php';

Must be out of the function (please don't throw me stones ;) )

Everything work fine now : Long life to mumble !