Fiesta Private Server 90% Finished but need a little help (Quickly)

[tyler1986]

Hey guys, Okay i've been working on making a Fiesta Private Server, I got SQL Setup, Databases setup, Server Files setup, But there is 2 problems that i really need help with i spent 6 hours trying to fix them but no luck, if someone would be nice enough i would be very thankful,
First problem, When i try to start the services>
_Account DB Server
_AccountLog DB Server
_Login Server
_World00 Character
_World00 GameLog

Each one of these when i "Right Click">"Start" I get the following Error Message>>>>
The _Account DB Server service on Local Computer started and then stopped. Some services stop automatically if they are not in use by other services or programs.

I get this Error and i cannot fix it no matter what i do....

The one other Error is when i start the Client it says "Connection to Server has failed" (I'm guessing because i cannot start the services)

I'm Running WIndows 7, 64b
SQL Server 2008 R2

If more Info is needed please ask i really need help.

Thanks!
Best Regards,
PhoenixTeam!

[MentaL]

[Crystalz]

Did you change the ip's in config.txt?

[tyler1986]

Yes i did. But i changed to 127.0.0.1 for now.
Main problem at the moment and that is needed to be fixed first is the Services.

Did you change the ip's in config.txt?

is there something else i need to start or a program i need to open before i can start the services?

[Crystalz]

Yes i did. But i changed to 127.0.0.1 for now.
Main problem at the moment and that is needed to be fixed first is the Services.

is there something else i need to start or a program i need to open before i can start the services?

Did you setup the Odbc?
Also,
Try to turn off the firewall.

[tyler1986]

Odbc-Yes
And Firewall is the first thing i tried, no luck...

Did you setup the Odbc?
Also,
Try to turn off the firewall.

[Crystalz]

Odbc-Yes
And Firewall is the first thing i tried, no luck...

PM me your skype name.

[Wolfy5079]

You're running windows 64 bit. You should try setting up your ODBC in both System32 and SysWOW64. One of them will allow this to work, I just can't remember which one.

--------------------------------------------------------------------------------------------------

When setting up the IP Addresses in your config, make sure it looks like this.

; DB Login server ------------------------------------------------------------
SERVER_INFO "PG_Account_DB", 0, 0, 0, 0, "Your IP", 9000, 1, 100 ; From ALL
SERVER_INFO "PG_AccountLog_DB", 1, 0, 0, 0, "Your IP", 9005, 1, 100 ; From ALL
SERVER_INFO "PG_Login_Server", 4, 0, 0,20, "Your IP", 9010, 10, 2000 ; From Client
SERVER_INFO "PG_Login_Server", 4, 0, 0, 5, "Your IP", 9015, 1, 50 ; From World manager
SERVER_INFO "PG_Login_Server", 4, 0, 0, 8, "127.0.0.1", 9016, 1, 30 ; From OPTOOL

; World #0 -------------------------------------------------------------------
SERVER_INFO "PG_Char_DB", 2, 0, 0, 0, "Your IP", 9100, 1, 100 ; From ALL
SERVER_INFO "PG_GameLog_DB", 3, 0, 0, 0, "Your IP", 9101, 1, 100 ; From ALL

SERVER_INFO "PG_World_Manager_Server", 5, 0, 0,20, "Your IP", 9110, 10, 2000 ; From Client
SERVER_INFO "PG_World_Manager_Server", 5, 0, 0, 6, "Your IP", 9115, 1, 100 ; From Zone
SERVER_INFO "PG_World_Manager_Server", 5, 0, 0, 8, "127.0.0.1", 9116, 1, 30 ; From OPTOOL

SERVER_INFO "PG_Zone_00", 6, 0, 0,20, "Your IP", 9120, 10, 2000 ; From Client
SERVER_INFO "PG_Zone_00", 6, 0, 0, 8, "127.0.0.1", 9121, 1, 30 ; From OPTOOL

SERVER_INFO "PG_Zone_01", 6, 0, 1,20, "Your Ip", 9122, 10, 2000 ; From Client
SERVER_INFO "PG_Zone_01", 6, 0, 1, 8, "127.0.0.1", 9123, 1, 30 ; From OPTOOL

SERVER_INFO "PG_Zone_02", 6, 0, 2,20, "Your IP", 9124, 10, 2000 ; From Client
SERVER_INFO "PG_Zone_02", 6, 0, 2, 8, "127.0.0.1", 9125, 1, 30 ; From OPTOOL

Configuring it like that has always worked for me. I never used OPTOOL so I always left them as 127.0.0.1

-----------------------------------------------------------------------------------------------------

If you're still having problems after that it could be that you haven't hex edited your client. A good editor I've found is HxD Editor. You'll be looking for the offset number 00353190. Change the IP there (ALWAYS SAVE AS A NEW FILE... Doing this may screw it up and you may have to experiment with the dots at the end of your IP Address to get it right. Saving it as a new file means that you still have a back up of the original). This will most likely only work if you have used the Gameguardless.exe file that was released here. If you're using someone else's client, chance are they've made it so you can't access that offset number. Thus you use the option below.

An easier way is to just make a .Bat file. Open notepad and add this to it.

YourClient'sName.exe -i Your IP

Save it as a .bat file and move it into your Game's folder. Click on it and it will load up the client and hopefully get you into server select.

Hope all of this helps.

[tyler1986]

gmscared1

PM me your skype name.

I am not sure exactly how to setup in both... i'm a learning noob :P

You're running windows 64 bit. You should try setting up your ODBC in both System32 and SysWOW64. One of them will allow this to work, I just can't remember which one.

[Crystalz]

gmscared1

I am not sure exactly how to setup in both... i'm a learning noob :P

Skypename doesn't work.

Edit:
Umm scratch that, now it works.

[Wolfy5079]

gmscared1

I am not sure exactly how to setup in both... i'm a learning noob :P

Basically just do what you did in the first one (whether it be the ODBC in system 32 or the ODBC in SysWOW64) in the other one.

[Crystalz]

Basically just do what you did in the first one (whether it be the ODBC in system 32 or the ODBC in SysWOW64) in the other one.

Turned out he used the wrong tab in Odbc. But you were still right, had to use both of them.

[hamisgood87]

i bet he didnt edit his hosts.

[Crystalz]

i bet he didnt edit his hosts.

No need for it on old files. :P

[hamisgood87]

i didnt read the post xD.
I just went back to read it again.

[Lugapha]

how can a server be 90% finished if you haven't even got in yet?