[Help]Account Server

[wtvelocity]

Ok, I accidentally posted this question 2x, and now BOTH of them are gone, and I've not received and answer.


I'm running Win7, and my Account Server crashes as well. I run it as admin, have root@ODBC set for all priv, and have set the 2 ini files to "localhost". Proshell.exe gives a popup box when I click the button on the bottom, don't know if its supposed to or not...

Client:
[Content]
server start...

kernel init ok...

(crash)
[Window Title]
蓝天网络 ServerShell Microsoft 基础类应用程序

[Main Instruction]
蓝天网络 ServerShell Microsoft 基础类应用程序 has stopped working



---Update: I have tried deleting my.ini as said at and now get this error log, no others in the folder:

error.log
////////////////////////////////////////////////////////////////////////// -- Fri Dec 17 12:22:49 2010

AccountServer Start up: 12:22, December 17, 2010 -- Fri Dec 17 12:22:49 2010

////////////////////////////////////////////////////////////////////////// -- Fri Dec 17 12:22:49 2010

[cyberghoser1]

In the ini files you set it to 127.0.0.1, if accserver is crashing it means it cannot connect to mysql, re-check your configs, and yes proshell is acting like that so that's normal.

[wtvelocity]

Ok, down to my current, and hopefully last problem.
All files are set for localhost with "test" password. Checked 49 times or so lol.
Also, have ODBC@localhost set for all privs.

AccountServer STILL crashes!

I have tried WinMySQLAdmin, it's a green light, and still AS crashes.
I have been using WAMPServer, which i prefer, as others can connect to my pages on my computer.
Still no luck on either one I try.

I run my client, I click "test", then I click "Texas"(my server name). When I try to login, it says something about unable to connect, maintenance, exc.

If my database couldn't be accessed, my pages wouldn't be viewable via WAMP, nor would I be able to see my server name in the client, am I correct?

Win7 User here, btw
And yes, A.S. is being run as Admin.

Help please? @_@

[King_Arthur]

Originally Posted by wtvelocity

Ok, I accidentally posted this question 2x, and now BOTH of them are gone, and I've not received and answer.

Because you are not supposed to hijack another member's help thread if it's still in progress with your own problems.

#ThreadSplit

[wtvelocity]

Sorry, I thought they may have a similar or same issue. And were both hi-jacks?

And even though I seemingly did something wrong, could I please still get some help?

[cyberghoser1]

Just follow the guides, there are very nice ones and clean in the releases subforum, you can't miss it.

[wtvelocity]

I have followed 3 different guides in a row, and have been trying for 5 days now...

Ill paste my current files. If you could figure it out, I'd be very thankful

------
Error.log:
////////////////////////////////////////////////////////////////////////// -- Sat Dec 18 12:52:32 2010

AccountServer Start up: 12:52, December 18, 2010 -- Sat Dec 18 12:52:32 2010

////////////////////////////////////////////////////////////////////////// -- Sat Dec 18 12:52:32 2010

--------
Account.ini:
[Account1]
SERVERNAME=Texas
LOGINNAME=root
PASSWORD=test
FREE_DEBUG=3

-------------
AccServ/Config.ini
[System]
LOGINLISTENPORT = 9958
POINTLISTENPORT = 9870
SERVER_FULL_DELAY_SECS = 5000
SERVER_BUSY_DELAY_SECS = 3000
SERVERTITLE = Texas
SERVERNAME = Texas
LOGINNAME = root
PASSWORD = test
SERVERIP = 127.0.0.1

[Database]
DBHOSTNAME=127.0.0.1
DATABASENAME=my
DBUSER=root
DBPASSWORD=test

--------
Gameserver/config.ini
; ÅäÖÃÎļþ


[System]
SERVERNAME = 51ħÓò
MONSTER_ACTIVE_LIMIT = 4000

ONLINETABLESIZE=600
ONLINEHEARTBEATSECS=600
HEARTBEATKICKSECS=1500
REJOINTIMEWAITSECS=0


[GameServer]
GAMESERVER_IP = 127.0.0.1
GAMESERVER_PORT = 5816
SND_SIZE = 64000
RCV_SIZE = 16000


[Database]
DB_IP = 127.0.0.1
DB_USER = root
DB_PW = test
DB_NAME = my

LOGIN_KEY = dfkKO23k'[cvK934

[InternetPort]
MASTER_IP = 127.0.0.1
MASTER_PORT = 8653
PORT_SIZE = 53
CURRENT_PORTID = 2


[BusySleep]
LEVEL1 = 20 ; > 1000 sleep 20%
LEVEL2 = 30 ; > 2000
LEVEL3 = 40 ; > 3000
LEVEL4 = 50 ; > 4000
LEVEL5 = 60 ; > 5000

----------
Shell.ini

; Íâ¿ÇÅäÖÃÎļþ
; 2007.10.21

[System]
MAPGROUP_SIZE = 1
ACCEPT_MS = 500

[StreamType]
TYPE = 0 ;0=Õý³£´ÓSOCKET£¬1=SOCKET¼Ç¼µ½Îļþ, 2=´ÓÎļþ¶Á(³ÌÐòµ÷ÊÔÓÃ)

[Database]
DB_IP = 127.0.0.1
DB_USER = root
DB_PW = test
DB_DB = my


[AccountServer]
ACCOUNT_IP = 127.0.0.1
ACCOUNT_PORT = 9870
SERVERNAME = Texas
LOGINNAME = root
PASSWORD = test
; µÇ¼±í³ß´ç, 10-5000
MAXLOGINTABLESIZE=5000
; µÇ¼±í³¬Ê±ÃëÊý£¬0-86400
LOGINOVERTIMESECS=120

LOGIN_KEY = dfkKO23k'[cvK934

[InternetPort]
MASTER_IP = 127.0.0.1
MASTER_PORT = 8653
PORT_SIZE = 53
CURRENT_PORTID = 1


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


I am still mostly a noob to mysql, so I may be overlooking something. Please tell me with these settings, what names and passwords I need where in my database or something that may be common?

Again, I've been trying for 5 days when I'm off work, but am still lost, overlooking something I assume.


Thanks!

[cyberghoser1]

Gameserver/config.ini
; ÅäÖÃÎļþ


[System]
SERVERNAME = 51ħÓò

change:

Gameserver/config.ini
; ÅäÖÃÎļþ


[System]
SERVERNAME = Texas

and in shell.dat aswell.

[wtvelocity]

Thanks, I had missed the config.ini file there, but don't have a shell.dat. I checked shell.ini and it all seemed fine, if that's what you meant...

The fact still stands though, that AccountServer crashes...
I'm thinking it's not connecting to the database because a lack of permissions to login to it, I know my tables and SQL work, it's just not connecting it seems.

Can someone please clarify exactly what I need set in the database to allow accountserver to run without crashing?

I've looked online and gotten mixed messages...
I know I need to allow ODBC@localhost, do i need any table values set a certain way in the databases to let it connect?

[AziQ]

did mysql opened correctly .?

[wtvelocity]

I have been able to access mysql via navicat and mysql tools for 5.0
problem is getting account server to run.

The client will run, and see the server I made (texas), so that means the client is connecting to the database, right?

If so, why isn't accountserver working, if I've checked its settings 30+ times? -.-;

And may I ask: what walkthrough would be most recommended for installing the Revo server, which is what i've downloaded? I'm using after having tried others...

[cyberghoser1]

All my releases are ready to use unless you change server name and ip's, if accountserver is not working its because you are doing something wrong, check and make sure all the ip's, server name and mysql login/pass are correct in all the ini files, and check again your shell.dat in /gameserver folder.

[wtvelocity]

Yeah, I had the link wrong, this is what I'm using:


How do I need to have my databases set to do this? I mean, I already have mysql installed under program files, so I copy the "my" and "account" folders into my data dir, right? There was no specific clarification on that...
I'm a noob to mySQL still, but it wouldn't run the files in the mysql folder from the desktop, would it? Or am I missing something?

After that, I need ODBC@localhost set with all privileges, I read on something else.
Do I need anything set inside my database besides that?

And thanks so much for your responses

[cyberghoser1]

If you are using the revo server or any other release from here there is already a mysql included, if you have a second instance of mysql it will conflict, get rid of the mysql you got in program files, use the one that comes with the specific release.

[wtvelocity]

Ok thanks! That was one major point I was going wrong, something I knew was missing.

Now, probably my last problem: after running all the programs in the mysql/bin folder, mysqladmin still wont turn green?

When I look at it, Under ODBC, it says:
Not Found
Driver 3.51 Not Found

Also, even after trying to run those bats as admin, they still aren't showing up under processes (win7), so I'm assuming that explains the above code. But I don't know why they wouldn't run:
I uninstalled the old MySQL...

Sorry to ask for every little thing, but my brain is now fried from working on this for almost a week now. Been neglecting my wife, and preoccupied at work, because I'm stubborn! XD

In other words: Thanks for your help, I've been to ignorant to figure this out on my own, and I would greatly appreciate if you help me finish this so I can get on...

Edit: I finally got it!!! I had uninstalled MySQL, but it still leaves registry traces around, so the one in the folder couldn't start...

I was able to remove it by running the command prompt as admin, and typing
"sc delete mysql"

Ran it again, and BOOM!

Thought this might help someone else with the problem in the future!

And thanks guys for the help!