[Ascent Guide] 2realms, DynDNS, LAN, ..... all in here !

[Fenarth]

I can use MySQL 6.0 ? Well nice guide im trying it right now. =)

[latruwski]

I can use MySQL 6.0 ? Well nice guide im trying it right now. =)

ye you can use that

grtz

[thebat]

I have been messing with this for use on a LAN and once I get everything I want configured I would go public.

I have set up the server all the way to the include the LAN part and stopped there.

My questions is why if I log on to the server with another machine am I stuck at the realm selection? I select the realm and it does nothing.

[latruwski]

I have been messing with this for use on a LAN and once I get everything I want configured I would go public.

I have set up the server all the way to the include the LAN part and stopped there.

My questions is why if I log on to the server with another machine am I stuck at the realm selection? I select the realm and it does nothing.

if u wnt to go public make sure you use the dynDNS host or your IP (not 127.0.0.1 or localhost)
then everything should be working fine... so i guess you did not use the correct IPs maybe..

grtz

[thebat]

I am thinking it's a port issue. I am going to open a few up and see if that will fix the problem.

[latruwski]

I am thinking it's a port issue. I am going to open a few up and see if that will fix the problem.

that could also be the problem...

[thebat]

It was a port issue . Your guide and db editor rocks!

[latruwski]

It was a port issue . Your guide and db editor rocks!

hehe thx, always nice to see good comments

grtz

[dreed9191]

hey,i got a problem when trying to extract the character sql,it says Error occured at:2007-12-18 20:48:23
Line no.:0
Error Code: 1049 - Unknown database 'character',any ideas?Oh and btw great guide!

[latruwski]

hey,i got a problem when trying to extract the character sql,it says Error occured at:2007-12-18 20:48:23
Line no.:0
Error Code: 1049 - Unknown database 'character',any ideas?Oh and btw great guide!

you execute a batch file right? that is becuz you dont have a database called character... what is your database name? are the world - character and logon databases split up or all in 1 database?

just right click the batch file => edit (with notepad)
then you should find lines like this:

############################################################################
REM #
REM #      B A S I C   U S E R   C O N F I G U R A T I O N   A R E A
REM #
REM ############################################################################
set user=root
set pass=root
REM  WorldDB  -  is the World Database
REM If you do not have them seperated then set them to the same values
set WorldDB=ascentDB
REM

the red parts you must edit... user = your database username, pass = your database pass
the last thing could be different... it can be something like CharDB or something... just check and it has to have the same name as the database you created

NOTE: instead of importing the DB with the tool.bat you could also use navicat or some other SQLmanager....
(right click your DB => import => select the SQL file )

grtz

[dreed9191]

thats kinda clear but i still have the problems,i edited the tools.exe and it was correct,this is the 1st time i use SQLylog im more used to navicat,i think i made 2 different DB's but cant be shure,if u can pls post some pics on how 2 DB's should look in SQLylog,or if u have Y!M or Xfire pls give ur id it would be best to chat live,oh and btw got another problem starting the server it says connecting to logon server on "127.0.0.0:8093" => Authenticating => Authentication failed.

[latruwski]

thats kinda clear but i still have the problems,i edited the tools.exe and it was correct,this is the 1st time i use SQLylog im more used to navicat,i think i made 2 different DB's but cant be shure,if u can pls post some pics on how 2 DB's should look in SQLylog,or if u have Y!M or Xfire pls give ur id it would be best to chat live,oh and btw got another problem starting the server it says connecting to logon server on "127.0.0.0:8093" => Authenticating => Authentication failed.

msn: [email protected]

well i use navicat too :P but tell me what DB are u using?
you dont have to seperate char/world and logon DB if you only have 1 realm you know... so you can put them all in 1 DB...

about the authentication failed: did you make sure remotepassword in both config files are same?
logonserver.conf:

<LogonServer RemotePassword = "yourpassword">

ascent.conf:

<LogonServer DisablePings = "0"
             RemotePassword = "yourpassword">

grtz

[Gorrak94]

Hey good guide man would +rep but...lost my main account (gorrak) so i cant +rep anymore but ya good guide.

Have a problem tho my router is d link and i can logon to my server but my downstairs computer and my friend cant (used dynamic dns) there both stuck at "Connecting...Connecting...Connecting...Unable to Connect"

[maridest]

I do not get the hole port forwading thing. Can you help me out?

[latruwski]

I do not get the hole port forwading thing. Can you help me out?

you mean you dont know how to forward ports?