[HELP] Client exit to menu when choosing character

02/01/2013 14:19 Xploitz86#1
Dear Community!

I have a big problem! I've downloaded Signe's serverfiles and client. My server is behind a router on windows7 operating system, with VirtualBox. My problem is, if i try to connect at my friend, when i choose my character, te client exit to the login scren. I tried many ways to setting up the server, Lopback adapter, using my pc as DHCP, tried portmap, but still the same. Webpage, MySqL, SSH works fine at my friend. Maybe some ports are missing? In my router i setted all the ports i think. PLEASE somebody help me! I'm very frustrating becouse this!!

Thanks: Xploitz

Sorry for my bad english!
02/01/2013 15:16 [SA]ChilleXx#2
syserr ?
02/01/2013 16:03 Xploitz86#3
In the syserr.txt there is only one line:

0201 13:36:42461 :: invalid idx 0

Thanks: Xploitz
02/01/2013 16:24 stσям™#4
What did you last edit?

Greetings
stσям™
02/01/2013 16:34 Xploitz86#5
Not edit anything. I've downloaded the client and the serverfiles. Setted up the server connection, and set the server address in the client. Nothing else. The server syserr contains this:

SYSERR: Feb 1 12:21:09 :: Load: DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)
SYSERR: Feb 1 13:17:35 :: ChildLoop: AsyncSQL: query failed: Query execution was interrupted (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,w hy FROM item_award WHERE taken_time IS NULL errno: 1317)
SYSERR: Feb 1 13:17:40 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,w hy FROM item_award WHERE taken_time IS NULL errno: 2002)
SYSERR: Feb 1 13:17:40 :: ChildLoop: AsyncSQL: retrying
SYSERR: Feb 1 13:17:40 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Feb 1 13:29:51 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Feb 1 13:29:51 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous
query: SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id
SYSERR: Feb 1 13:29:51 :: Load: DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)

If i connect from my own computer, using the server LAN address, then everything is OK. Another computer is problem.
02/01/2013 16:53 stσям™#6
Ah i know this problem, but not sure how to fix it, It's Hamachi right?

You can login and everything but if another person logs in from a different ip, it kicks after character.. Hmm does the other person have the full ip in the client?
02/01/2013 16:56 Xploitz86#7
No, its not hamachi server, and i am behind a router.

Psl if anybody know something about this tell me :(
02/03/2013 21:01 stσям™#8
It's a client problem. Hamachi/router = mc sura client.
10/05/2013 16:45 popaalexandrualbert#9
i have the same problemmm :((( how i repair it?