New MiniLogin Release!

[image]

Yea you can ignore those, thats new MySQL stuff, don't ask me what for. You just need the default tables anyway.

[Aergad]

Just a side note you have to put the minilogin server into a seperate directory from your main eqemu server with all the files included in the zip file for it to work

[warhawk]

I'm having trouble sourcing the SQL. This bit seems to cause a 1064 error:-

DROP TABLE IF EXISTS `variables`;
CREATE TABLE `variables` (
  `varname` varchar(25) NOT NULL default '',
  `value` text NOT NULL,
  `information` text NOT NULL,
  `ts` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`varname`)
) ENGINE=MyISAM DEFAULT;

Any Ideas?

[image]

DROP TABLE IF EXISTS `variables`;
CREATE TABLE `variables` (
`varname` varchar(25) NOT NULL default '',
`value` text NOT NULL,
`information` text NOT NULL,
`ts` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (`varname`)
) ENGINE=MyISAM;

Remove " DEFAULT"

[warhawk]

Bah, simple when you know how

Thanks Image!

[warhawk]

Hi again

I'm still struggling to get this working.

I'm getting the following error on the minilogin shell.

Error in CheckWorldVerAuth query `SELECT approval From login_versions Where version=`0.7.0`;`
#1146: Table `peq.login_versions` does not exist
Bad Version <soft>: #1 192.168.11.53:4972

World.exe shows

[WORLD__LS] Connecting to login server...
[WORLD__LS] Setting World to MiniLogin Server type
[WORLD__LS] Connected to Loginserver: 192.168.11.53:5999
[WORLD__LS_ERR] Login server responded with FatalError. Disabling reconnect.
[WORLD__LS_ERR]      Incorrect version

I`ve ran in the loginserver.sql and configured the db.ini. Also ensuring that the its set to minilogin in the variables DB.

Any help would be great.

Thanks

War

[Angelox]

[WORLD__LS] Setting World to MiniLogin Server type

You gotta set it to Public, not MiniLogin (it's in Variables)