{PLUS} Fast food server

[Bekmezci]

Hey guys ,

I have an error 'too many connections' when i try to start the game
Maybe any help ?

ULR :

You must be registered for see links

Thanks anyway

 

[Berk]

You might be having DDoS'ed, are you on localhost?

 

[Bekmezci]

I am sure i am not getting ddosed tho

 

[Berk]

I am sure i am not getting ddosed tho

Thats odd. Do you use MySQLi or MySQL ?

 

[Bekmezci]

MySQLI
 
When i change the port of the game config my CMS reports a too many connections also

 

[Berk]

Alright, can you send me configuration file of fastfood emulator please? also the emulators.

 

[Bekmezci]

## Fast Food Coded by Carlos D.
## Please, don't delete this notes.

## MySql Configuration
db.host=localhost
db.port=3306
db.username=root
db.password=dunneeddis
db.dbname=dunneeddiseither

## MySql Extra Info
db.pool.size=100
db.client.amount=200

## Sockets Configuration ##
game.tcp.conlimit=11000
game.tcp.conperip=100
game.tcp.enablenagles=True

#FastFood info
swfs.site=https://www.hibbohotel.nl/game/swf/games
init.port=4445

 ## PlusEmulator System Configuration File
## Must be edited for the server to work

## MySQL Configuration
db.hostname=localhost
db.port=3306
db.username=root
db.password=DUNNEEDDIS
db.name=DUNNEEDTHISEITHER

## MySQL pooling setup (controls amount of connections)
db.pool.minsize=100
db.pool.maxsize=2500

## Game TCP/IP Configuration
game.tcp.bindip=IPWASHERE
game.tcp.port=4444
game.tcp.conlimit=1000000
game.tcp.conperip=1000
game.tcp.enablenagles=true

## MUS TCP/IP Configuration
mus.tcp.bindip=IPWASHERE
mus.tcp.port=30001
mus.tcp.allowedaddr=IPWASHERE

## Client configuration
client.ping.enabled=1
client.ping.interval=20000
client.maxrequests=300

fast.food.enabled=1
food.url=https://www.hibbohotel.nl/games/gamecenter_basejump/
food.ip=localhost
food.port=4445
food.habboUrl=http://fuseus-private-httpd-fe-1
snow.url=http://xx/gamecenter/gamecenter_snowwar/
slotcar.url=http://xx/gamecenter/gamecenter_slotcar/
republic.url=http://xx/gamecenter/ChatRepublic_ssk/
sudoku.url=http://xx/gamecenter/gamecenter_sudoku/

SQL SETUP :

You must be registered for see images attach

 

[Berk]

This is odd. Passing to @Sledmore

 

[Bekmezci]

After connection failed since too many connections, also this :

You must be registered for see links

 

[Berk]

Check your mysql configuration file, look for max connections and set it to 600 or whatever.

 

[Bekmezci]

Set it to 10k , still the same ;/

 

[Sledmore]

The only logical thing I could think of is the poolsize is far too high.

## MySql Extra Info
db.pool.size=100
db.client.amount=200

That is absolutely fucking insane?! Try...

## MySql Extra Info
db.pool.size=5
db.client.amount=50

 

[Bekmezci]

The only logical thing I could think of is the poolsize is far too high.

## MySql Extra Info
db.pool.size=100
db.client.amount=200

That is absolutely fucking insane?! Try...

## MySql Extra Info
db.pool.size=5
db.client.amount=50

Much love, gave me a new error (so up a step in my opinion)

You must be registered for see images attach

What i can see is data too long for ssoticket ;?
 
Changed auth_ticket to varchar 999
Before :

CALL dofastfoodlogin(@sso)
MySql.Data.MySqlClient.MySqlException (0x80004005): Data too long for column 'sso_ticket' at row 1
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()

After :

CALL dofastfoodlogin(@sso)
MySql.Data.MySqlClient.MySqlException (0x80004005): Data too long for column 'sso_ticket' at row 235
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()

But what i do not understand the error says Column sso_ticket while on the plus structure it is auth_ticket, no ?
 
Bump?

 

[yoyok]

This is not for Plusemu, just a fastfood for another emulator.
Don't use this with your PlusEmu, it's not 100% stable.

 

[Hobtel]

I can probably help you, can you upload your sql and basejump.swf?

 

[Bekmezci]

What do you exactly need from my sql?

 

[Hobtel]

What do you exactly need from my sql?

Nothing, nvm.
Did you get it working`?

 

[Cen0n]

Much love, gave me a new error (so up a step in my opinion)

You must be registered for see images attach

What i can see is data too long for ssoticket ;?
 
Changed auth_ticket to varchar 999
Before :

CALL dofastfoodlogin(@sso)
MySql.Data.MySqlClient.MySqlException (0x80004005): Data too long for column 'sso_ticket' at row 1
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()

After :

CALL dofastfoodlogin(@sso)
MySql.Data.MySqlClient.MySqlException (0x80004005): Data too long for column 'sso_ticket' at row 235
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()

But what i do not understand the error says Column sso_ticket while on the plus structure it is auth_ticket, no ?
 
Bump?

You have to increase the size of this '' sso_ticket '' table, this means that the Sso Fastfood ticket does not fit into the db plus this will not allow fastfood to work because other packages are needed that no one else has now.

 

[Bekmezci]

So what's the problem now, missing packets ? And as i might have mentioned before : it's closed source and on the plus structure it is auth_ticket while here it is sso_ticket

 

[Cen0n]

So what's the problem now, missing packets ? And as i might have mentioned before : it's closed source and on the plus structure it is auth_ticket while here it is sso_ticket

Yes, as I said it will not be worth anything to try to connect the emulator, I've already seen Spanish selling the fastfood code in operation, but in case that turn on this emulator will only stay on black screen I've made several attempts ..