-
Re: [REL] Project Cold Coffeee ~ Jeax Server [C#, MySQL, Source, Executable]
Ok Jeax, I just have a question for you.
I'm not very familiar with MySQL, but I've already made a database on my personal server and I have already imported the MySQL file you included with your server. Now, I've created the user+pass for my SQL database and I've edited the settings.ini file
Code:
[database]
host=localhost
port=3306
db=rocky_server
username=rocky_server
password=*removed*
Now, I know I'm missing something in there.. lmao, mind helping me out?
-
Re: [REL] Project Cold Coffeee ~ Jeax Server [C#, MySQL, Source, Executable]
hmm.. well if its on the same machine as the server itself then it all looks fine.
if not then the host will need to be changed obviously :p
-
Re: [REL] Project Cold Coffeee ~ Jeax Server [C#, MySQL, Source, Executable]
Yeah, It's hosted on a different machine, nevermind now. I got it. Thanks. :P
-
Re: [REL] Project Cold Coffeee ~ Jeax Server [C#, MySQL, Source, Executable]
It is necessary to transfer config.ini on the basis from MySQL data?
-
Re: [REL] Project Cold Coffeee ~ Jeax Server [C#, MySQL, Source, Executable]
What port should I use in the loader?
-
Re: [REL] Project Cold Coffeee ~ Jeax Server [C#, MySQL, Source, Executable]
-
Re: [REL] Project Cold Coffeee ~ Jeax Server [C#, MySQL, Source, Executable]
Jeax i need some help... The server connects to my SQL .... but when i try to register ... it does this.
Quote:
(7/24/2007 - 6:18 PM) -- Connected to MySQL
(7/24/2007 - 6:18 PM) -- Error with running query 'SELECT `text` FROM `static` WHERE `value` = 'dcmessage'' Error Returned: ERROR [HY000] [MySQL][ODBC 3.51 Driver][mysqld-4.1.21-standard]MySQL server has gone away
(7/24/2007 - 6:18 PM) -- Error with running query 'UPDATE `public` SET `CurIn` = '0'' Error Returned: ERROR [HY000] [MySQL][ODBC 3.51 Driver][mysqld-4.1.21-standard]MySQL server has gone away
(7/24/2007 - 6:18 PM) -- Error with running query 'UPDATE `private` SET `CurIn` = '0'' Error Returned: ERROR [HY000] [MySQL][ODBC 3.51 Driver][mysqld-4.1.21-standard]MySQL server has gone away
(7/24/2007 - 6:18 PM) -- Started listening for connection requests on port '1337'
(7/24/2007 - 6:22 PM) -- New connection established {1}
(7/24/2007 - 6:22 PM) -- @@BCN
(7/24/2007 - 6:22 PM) -- @@BCJ
(7/24/2007 - 6:22 PM) -- Error with running query 'SELECT `ip` FROM `bans` WHERE `ip` = '127.0.0.1'' Error Returned: ERROR [HY000] [MySQL][ODBC 3.51 Driver][mysqld-4.1.21-standard]MySQL server has gone away
(7/24/2007 - 6:22 PM) -- @@w@EYdA@A2@mhttp://www.hablink.net/data/external/vars.txt
(7/24/2007 - 6:22 PM) -- @@X@F@T89049778811486222007
(7/24/2007 - 6:22 PM) -- Error with running query 'SELECT `shockwave` FROM `bans` WHERE `shockwave` = '89049778811486222007'' Error Returned: ERROR [HY000] [MySQL][ODBC 3.51 Driver][mysqld-4.1.21-standard]MySQL server has gone away
(7/24/2007 - 6:22 PM) -- @@BBu
(7/24/2007 - 6:22 PM) -- @@B@q
(7/24/2007 - 6:22 PM) -- @@B@I
(7/24/2007 - 6:24 PM) -- Client Disconnected
(7/24/2007 - 6:24 PM) -- Client Disconnected
(7/24/2007 - 6:24 PM) -- New connection established {1}
(7/24/2007 - 6:24 PM) -- @@BCN
(7/24/2007 - 6:24 PM) -- @@BCJ
(7/24/2007 - 6:24 PM) -- Error with running query 'SELECT `ip` FROM `bans` WHERE `ip` = '127.0.0.1'' Error Returned: ERROR [HY000] [MySQL][ODBC 3.51 Driver][mysqld-4.1.21-standard]MySQL server has gone away
(7/24/2007 - 6:24 PM) -- @@w@EYdA@A2@mhttp://www.hablink.net/data/external/vars.txt
(7/24/2007 - 6:24 PM) -- @@X@F@T89049778811486222007
(7/24/2007 - 6:24 PM) -- Error with running query 'SELECT `shockwave` FROM `bans` WHERE `shockwave` = '89049778811486222007'' Error Returned: ERROR [HY000] [MySQL][ODBC 3.51 Driver][mysqld-4.1.21-standard]MySQL server has gone away
(7/24/2007 - 6:24 PM) -- @@BBu
(7/24/2007 - 6:24 PM) -- @@B@q
(7/24/2007 - 6:24 PM) -- @@B@I
-
Re: [REL] Project Cold Coffeee ~ Jeax Server [C#, MySQL, Source, Executable]
Best server yet I would think... Considering its got MySQL and it isnt vb I would start my retro up again if it had more updated features (trax, diving, etc.) Otherwise... Kick ass start.
-
Re: [REL] Project Cold Coffeee ~ Jeax Server [C#, MySQL, Source, Executable]
ty DylLazy :)
Qurb: that error means that the MySQL Server has disconnected for some reason or another, either your host refused the connection or it just dropped it.
Either re-try re-opening the app which might fix it. Or check your mysql settings to see if its allowing the connection.
-
Re: [REL] Project Cold Coffeee ~ Jeax Server [C#, MySQL, Source, Executable]
Quote:
Originally Posted by
MrGiMmE
jeax ur server is noob becuz u dont have battleball!
Can U tell us what server has got battleball
-
Re: [REL] Project Cold Coffeee ~ Jeax Server [C#, MySQL, Source, Executable]
@ kuidjesjors - None have battle ball ... and if they clame to .... they making up shit... or their server is shit.
@ Jeax - Thanks for the help. I restarted the server and now it does this:
Quote:
(7/24/2007 - 6:53 PM) -- Connected to MySQL
(7/24/2007 - 6:53 PM) -- Started listening for connection requests on port '1337'
(7/24/2007 - 6:55 PM) -- New connection established {1}
(7/24/2007 - 6:55 PM) -- @@BCN
(7/24/2007 - 6:55 PM) -- @@BCJ
(7/24/2007 - 6:55 PM) -- @@w@EYdA@A2@mhttp://www.hablink.net/data/external/vars.txt
(7/24/2007 - 6:55 PM) -- @@X@F@T89049778811486222007
(7/24/2007 - 6:55 PM) -- @@BBu
(7/24/2007 - 6:55 PM) -- @@B@q
(7/24/2007 - 6:55 PM) -- @@B@I
It is connecting to my database ... but not starting or stuff. Any help?
-
Re: [REL] Project Cold Coffeee ~ Jeax Server [C#, MySQL, Source, Executable]
-
Re: [REL] Project Cold Coffeee ~ Jeax Server [C#, MySQL, Source, Executable]
Quote:
Originally Posted by
Qurb
@ kuidjesjors - None have battle ball ... and if they clame to .... they making up shit... or their server is shit.
@ Jeax - Thanks for the help. I restarted the server and now it does this:
It is connecting to my database ... but not starting or stuff. Any help?
That's all perfectly fine, thats just the incoming packetlog. i forgot to disable it :p Feel free to edit the source and stop it from showing all incoming packets if you know any c# :)
The reason it wont login for you if it doesn't is due to the fact it doesn't use the v9 version of logging in and uses SSO instead.
like this: http://ijeax.com/habbo/index.php?client=go2&id=local
-
Re: [REL] Project Cold Coffeee ~ Jeax Server [C#, MySQL, Source, Executable]
Doo Not Spam On This Thread I Report It !
-
Re: [REL] Project Cold Coffeee ~ Jeax Server [C#, MySQL, Source, Executable]
Yea lol... but it dosen't let me register. am i able to use V15/V14 DCR's ??? and ... are you able to use the normal registration on the DCR's or can you only use a SSL loader? If only SSL can you supply one :D
-
Re: [REL] Project Cold Coffeee ~ Jeax Server [C#, MySQL, Source, Executable]
i become to an error xD can u post a tut? xD
-
Re: [REL] Project Cold Coffeee ~ Jeax Server [C#, MySQL, Source, Executable]
only allows SSL Login.
and you'll have to code your own i'm afraid.
its pretty simple though, the logic is just
-- Check password of username = the password in table users
-- Create a random string and put it into the field ssoticket in the table users
-- Echo it into the loader
ta-da.
For an example:
iJeax.com ~ Login
username: jeax
password: irpr0
-
Re: [REL] Project Cold Coffeee ~ Jeax Server [C#, MySQL, Source, Executable]
Quote:
Originally Posted by
HabbAHotel
Doo Not Spam On This Thread I Report It !
Learn English And Stop Beginning Every Word With A Capital Letter.
You think you aren't annoying? If you are such a safety noob fuck off to a habbo.co.uk and keep away from retro.
-
Re: [REL] Project Cold Coffeee ~ Jeax Server [C#, MySQL, Source, Executable]
What about the registration? Can I use the one in the DCR?
-
Re: [REL] Project Cold Coffeee ~ Jeax Server [C#, MySQL, Source, Executable]
no. Registration & login = SSL :)
-
Re: [REL] Project Cold Coffeee ~ Jeax Server [C#, MySQL, Source, Executable]
WTF ???
Wheres the server?
Theres only one server-program and the name of that program is warlord :S
I've been sick of it...
Sorry for my English , im Dutch
[url=http://www.djhabbohotel.nl.tt]Patrick en Tom Productions
-
Re: [REL] Project Cold Coffeee ~ Jeax Server [C#, MySQL, Source, Executable]
[quote=patje007;2478475]WTF ???
Wheres the server?
Theres only one server-program and the name of that program is warlord :S
I've been sick of it...
Sorry for my English , im Dutch
[URL="http://www.djhabbohotel.nl.tt"]Patrick en Tom Productions
-
Re: [REL] Project Cold Coffeee ~ Jeax Server [C#, MySQL, Source, Executable]
ye, but its says error, because its the old version of .net framework
-
Re: [REL] Project Cold Coffeee ~ Jeax Server [C#, MySQL, Source, Executable]
-
Re: [REL] Project Cold Coffeee ~ Jeax Server [C#, MySQL, Source, Executable]
Quote:
Originally Posted by
patje007
ye, but its says error
Because, either, you don't have NET Framework 2.0 installed or you have not configured your settings.ini file correctly.