Jump to content

Fully untouched 34083 server files & DB


Rumor

Recommended Posts

  • Former Staff

 

iptocountry table seems to be working right now. I'm not sure, how it got repaired, but I'm happy that now I have been able to re-create it.

 

Item_proto and other tables are still empty though...

Here is screen:

 

hWKqE.png

 

Maybe your game core isn't using the txt-based proto files?

INTERNAL_IP: 192.168.1.105 interface em0
Can not get public ip address
INTERNAL_IP: 192.168.1.105 interface em0
Can not get public ip address
INTERNAL_IP: 192.168.1.105 interface em0
Can not get public ip address
INTERNAL_IP: 192.168.1.105 interface em0
Can not get public ip address
INTERNAL_IP: 192.168.1.105 interface em0
Can not get public ip address
INTERNAL_IP: 192.168.1.105 interface em0
Can not get public ip address
INTERNAL_IP: 192.168.1.105 interface em0
Can not get public ip address
INTERNAL_IP: 192.168.1.105 interface em0
Can not get public ip address
INTERNAL_IP: 192.168.1.105 interface em0
Can not get public ip address
INTERNAL_IP: 192.168.1.105 interface em0
Can not get public ip address
INTERNAL_IP: 192.168.1.105 interface em0
Can not get public ip address
INTERNAL_IP: 192.168.1.105 interface em0
Can not get public ip address
INTERNAL_IP: 192.168.1.105 interface em0
Can not get public ip address
INTERNAL_IP: 192.168.1.105 interface em0
Can not get public ip address
INTERNAL_IP: 192.168.1.105 interface em0
Can not get public ip address
INTERNAL_IP: 192.168.1.105 interface em0
Can not get public ip address
INTERNAL_IP: 192.168.1.105 interface em0
Can not get public ip address

now this is what i got in autorun.log

 

and client doesn't work

 

btw how to open the sql database with navicat ??

 

Best Regrades

      FlyGun

 

 

in CONFIG add this line:

PUBLIC_IP: x.x.x.x

Only belongs in channels and auth. The x's represent the public IP on your server.

 

thanks but.... same problem >.<

Edited by Metin2 Dev
Core X - External 2 Internal
Link to comment
Share on other sites

  • Former Staff

 

INTERNAL_IP: 192.168.1.105 interface em0
Can not get public ip address
INTERNAL_IP: 192.168.1.105 interface em0
Can not get public ip address
INTERNAL_IP: 192.168.1.105 interface em0
Can not get public ip address
INTERNAL_IP: 192.168.1.105 interface em0
Can not get public ip address
INTERNAL_IP: 192.168.1.105 interface em0
Can not get public ip address
INTERNAL_IP: 192.168.1.105 interface em0
Can not get public ip address
INTERNAL_IP: 192.168.1.105 interface em0
Can not get public ip address
INTERNAL_IP: 192.168.1.105 interface em0
Can not get public ip address
INTERNAL_IP: 192.168.1.105 interface em0
Can not get public ip address
INTERNAL_IP: 192.168.1.105 interface em0
Can not get public ip address
INTERNAL_IP: 192.168.1.105 interface em0
Can not get public ip address
INTERNAL_IP: 192.168.1.105 interface em0
Can not get public ip address
INTERNAL_IP: 192.168.1.105 interface em0
Can not get public ip address
INTERNAL_IP: 192.168.1.105 interface em0
Can not get public ip address
INTERNAL_IP: 192.168.1.105 interface em0
Can not get public ip address
INTERNAL_IP: 192.168.1.105 interface em0
Can not get public ip address
INTERNAL_IP: 192.168.1.105 interface em0
Can not get public ip address

now this is what i got in autorun.log

 

and client doesn't work

 

btw how to open the sql database with navicat ??

 

Best Regrades

      FlyGun

 

 

in CONFIG add this line:

PUBLIC_IP: x.x.x.x

Only belongs in channels and auth. The x's represent the public IP on your server.

 

thanks but.... same problem >.<

 

 

fixed

i'm using source : this is the fix

Open config.cpp and replace 192.168 with 999.999 in the GetIPInfo event.

 

Link to comment
Share on other sites

  • 2 weeks later...

i start sh instal.sh ok   = chmod: cores: Operation not permitted
 

look symlink its okay next step sh run.sh   i look in top no have process game and db -.-

 

 

hmm what this vrunner ?all in one ?

 

i have problem serwer start

 

ch1 port 13000

auth port 11000

 

and not work please help me in teamviewer : (

Link to comment
Share on other sites

  • 2 weeks later...
  • Premium

http://eterhost.net/knowledgebase.php?action=displayarticle&id=12

 

and:

 

portsnap fetch update

cd /usr/ports/misc/compat7x

make install clean

 

Those should be all the libs you need, and you should get them from authorized sources as shown here, not some random zip which might not work on your OS version at all and in thre worst case, leave your server unbootable.

  • Love 1
Link to comment
Share on other sites

  • Premium

http://eterhost.net/knowledgebase.php?action=displayarticle&id=12

 

and:

 

portsnap fetch update

cd /usr/ports/misc/compat7x

make install clean

 

Those should be all the libs you need, and you should get them from authorized sources as shown here, not some random zip which might not work on your OS version at all and in thre worst case, leave your server unbootable.

 

Thanks so much. But i have a little problem. When i write the command "fetch ftp://ftp.freebsd.org/pub/FreeBSD/releases/amd64/9.3-RELEASE/lib32.txz"it says this - No route to host. Where can be the problem?

Link to comment
Share on other sites

  • 2 weeks later...
  • 4 weeks later...
  • Former Staff

ch1 syserr, keeps spamming this

SYSERR: Feb 17 01:59:54 :: SetMaxSpareItemID: ItemIDRange: FATAL ERROR!!! Spare ITEM ID RANGE is not set
SYSERR: Feb 17 01:59:54 :: SetMaxSpareItemID: ItemIDRange: FATAL ERROR!!! Spare ITEM ID RANGE is not set
SYSERR: Feb 17 01:59:54 :: SetMaxSpareItemID: ItemIDRange: FATAL ERROR!!! Spare ITEM ID RANGE is not set
SYSERR: Feb 17 01:59:54 :: SetMaxSpareItemID: ItemIDRange: FATAL ERROR!!! Spare ITEM ID RANGE is not set
SYSERR: Feb 17 01:59:54 :: SetMaxSpareItemID: ItemIDRange: FATAL ERROR!!! Spare ITEM ID RANGE is not set
SYSERR: Feb 17 01:59:54 :: SetMaxSpareItemID: ItemIDRange: FATAL ERROR!!! Spare ITEM ID RANGE is not set
SYSERR: Feb 17 01:59:54 :: SetMaxSpareItemID: ItemIDRange: FATAL ERROR!!! Spare ITEM ID RANGE is not set
SYSERR: Feb 17 01:59:54 :: SetMaxSpareItemID: ItemIDRange: FATAL ERROR!!! Spare ITEM ID RANGE is not set
SYSERR: Feb 17 01:59:54 :: SetMaxSpareItemID: ItemIDRange: FATAL ERROR!!! Spare ITEM ID RANGE is not set
SYSERR: Feb 17 01:59:54 :: SetMaxSpareItemID: ItemIDRange: FATAL ERROR!!! Spare ITEM ID RANGE is not set
SYSERR: Feb 17 01:59:54 :: Boot: not enough item id for spare contact your administrator!
SYSERR: Feb 17 01:59:54 :: pid_deinit: 
End of pid

 

db syserr, keeps spamming this

SYSERR: Feb 17 02:01:48 :: __GetHostInfo: __GetHostInfo() ==> DirectQuery failed(SELECT mIP FROM gmhost)
SYSERR: Feb 17 02:01:48 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='192.168.1.87')
SYSERR: Feb 17 02:01:48 :: GetRange: ItemIDRange: NO MORE ITEM ID RANGE
SYSERR: Feb 17 02:01:48 :: GetRange: ItemIDRange: NO MORE ITEM ID RANGE
SYSERR: Feb 17 02:01:48 :: GetRange: ItemIDRange: NO MORE ITEM ID RANGE
SYSERR: Feb 17 02:01:48 :: GetRange: ItemIDRange: NO MORE ITEM ID RANGE
SYSERR: Feb 17 02:01:48 :: GetRange: ItemIDRange: NO MORE ITEM ID RANGE
SYSERR: Feb 17 02:01:48 :: GetRange: ItemIDRange: NO MORE ITEM ID RANGE
SYSERR: Feb 17 02:01:48 :: GetRange: ItemIDRange: NO MORE ITEM ID RANGE
SYSERR: Feb 17 02:01:48 :: GetRange: ItemIDRange: NO MORE ITEM ID RANGE
SYSERR: Feb 17 02:01:48 :: GetRange: ItemIDRange: NO MORE ITEM ID RANGE
SYSERR: Feb 17 02:01:48 :: GetRange: ItemIDRange: NO MORE ITEM ID RANGE
SYSERR: Feb 17 02:01:48 :: GetRange: ItemIDRange: NO MORE ITEM ID RANGE
SYSERR: Feb 17 02:01:48 :: GetRange: ItemIDRange: NO MORE ITEM ID RANGE
SYSERR: Feb 17 02:01:48 :: GetRange: ItemIDRange: NO MORE ITEM ID RANGE
SYSERR: Feb 17 02:01:48 :: GetRange: ItemIDRange: NO MORE ITEM ID RANGE
SYSERR: Feb 17 02:01:48 :: GetRange: ItemIDRange: NO MORE ITEM ID RANGE
SYSERR: Feb 17 02:01:48 :: GetRange: ItemIDRange: NO MORE ITEM ID RANGE
SYSERR: Feb 17 02:01:48 :: GetRange: ItemIDRange: NO MORE ITEM ID RANGE
SYSERR: Feb 17 02:01:48 :: GetRange: ItemIDRange: NO MORE ITEM ID RANGE
SYSERR: Feb 17 02:01:48 :: GetRange: ItemIDRange: NO MORE ITEM ID RANGE
SYSERR: Feb 17 02:01:48 :: GetRange: ItemIDRange: NO MORE ITEM ID RANGE
SYSERR: Feb 17 02:01:49 :: Process: FDWATCH: peer null in event: ident 23
SYSERR: Feb 17 02:01:49 :: Process: FDWATCH: peer null in event: ident 23
SYSERR: Feb 17 02:01:49 :: Process: FDWATCH: peer null in event: ident 23
SYSERR: Feb 17 02:01:50 :: Process: FDWATCH: peer null in event: ident 20
SYSERR: Feb 17 02:01:50 :: Process: FDWATCH: peer null in event: ident 21

Edit:

Forget about the errors.

Now it says the id/pw are wrong when I try to login the client.

Link to comment
Share on other sites

  • Premium

ch1 syserr, keeps spamming this

SYSERR: Feb 17 01:59:54 :: SetMaxSpareItemID: ItemIDRange: FATAL ERROR!!! Spare ITEM ID RANGE is not set
SYSERR: Feb 17 01:59:54 :: SetMaxSpareItemID: ItemIDRange: FATAL ERROR!!! Spare ITEM ID RANGE is not set
SYSERR: Feb 17 01:59:54 :: SetMaxSpareItemID: ItemIDRange: FATAL ERROR!!! Spare ITEM ID RANGE is not set
SYSERR: Feb 17 01:59:54 :: SetMaxSpareItemID: ItemIDRange: FATAL ERROR!!! Spare ITEM ID RANGE is not set
SYSERR: Feb 17 01:59:54 :: SetMaxSpareItemID: ItemIDRange: FATAL ERROR!!! Spare ITEM ID RANGE is not set
SYSERR: Feb 17 01:59:54 :: SetMaxSpareItemID: ItemIDRange: FATAL ERROR!!! Spare ITEM ID RANGE is not set
SYSERR: Feb 17 01:59:54 :: SetMaxSpareItemID: ItemIDRange: FATAL ERROR!!! Spare ITEM ID RANGE is not set
SYSERR: Feb 17 01:59:54 :: SetMaxSpareItemID: ItemIDRange: FATAL ERROR!!! Spare ITEM ID RANGE is not set
SYSERR: Feb 17 01:59:54 :: SetMaxSpareItemID: ItemIDRange: FATAL ERROR!!! Spare ITEM ID RANGE is not set
SYSERR: Feb 17 01:59:54 :: SetMaxSpareItemID: ItemIDRange: FATAL ERROR!!! Spare ITEM ID RANGE is not set
SYSERR: Feb 17 01:59:54 :: Boot: not enough item id for spare contact your administrator!
SYSERR: Feb 17 01:59:54 :: pid_deinit: 
End of pid

 

db syserr, keeps spamming this

SYSERR: Feb 17 02:01:48 :: __GetHostInfo: __GetHostInfo() ==> DirectQuery failed(SELECT mIP FROM gmhost)
SYSERR: Feb 17 02:01:48 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='192.168.1.87')
SYSERR: Feb 17 02:01:48 :: GetRange: ItemIDRange: NO MORE ITEM ID RANGE
SYSERR: Feb 17 02:01:48 :: GetRange: ItemIDRange: NO MORE ITEM ID RANGE
SYSERR: Feb 17 02:01:48 :: GetRange: ItemIDRange: NO MORE ITEM ID RANGE
SYSERR: Feb 17 02:01:48 :: GetRange: ItemIDRange: NO MORE ITEM ID RANGE
SYSERR: Feb 17 02:01:48 :: GetRange: ItemIDRange: NO MORE ITEM ID RANGE
SYSERR: Feb 17 02:01:48 :: GetRange: ItemIDRange: NO MORE ITEM ID RANGE
SYSERR: Feb 17 02:01:48 :: GetRange: ItemIDRange: NO MORE ITEM ID RANGE
SYSERR: Feb 17 02:01:48 :: GetRange: ItemIDRange: NO MORE ITEM ID RANGE
SYSERR: Feb 17 02:01:48 :: GetRange: ItemIDRange: NO MORE ITEM ID RANGE
SYSERR: Feb 17 02:01:48 :: GetRange: ItemIDRange: NO MORE ITEM ID RANGE
SYSERR: Feb 17 02:01:48 :: GetRange: ItemIDRange: NO MORE ITEM ID RANGE
SYSERR: Feb 17 02:01:48 :: GetRange: ItemIDRange: NO MORE ITEM ID RANGE
SYSERR: Feb 17 02:01:48 :: GetRange: ItemIDRange: NO MORE ITEM ID RANGE
SYSERR: Feb 17 02:01:48 :: GetRange: ItemIDRange: NO MORE ITEM ID RANGE
SYSERR: Feb 17 02:01:48 :: GetRange: ItemIDRange: NO MORE ITEM ID RANGE
SYSERR: Feb 17 02:01:48 :: GetRange: ItemIDRange: NO MORE ITEM ID RANGE
SYSERR: Feb 17 02:01:48 :: GetRange: ItemIDRange: NO MORE ITEM ID RANGE
SYSERR: Feb 17 02:01:48 :: GetRange: ItemIDRange: NO MORE ITEM ID RANGE
SYSERR: Feb 17 02:01:48 :: GetRange: ItemIDRange: NO MORE ITEM ID RANGE
SYSERR: Feb 17 02:01:48 :: GetRange: ItemIDRange: NO MORE ITEM ID RANGE
SYSERR: Feb 17 02:01:49 :: Process: FDWATCH: peer null in event: ident 23
SYSERR: Feb 17 02:01:49 :: Process: FDWATCH: peer null in event: ident 23
SYSERR: Feb 17 02:01:49 :: Process: FDWATCH: peer null in event: ident 23
SYSERR: Feb 17 02:01:50 :: Process: FDWATCH: peer null in event: ident 20
SYSERR: Feb 17 02:01:50 :: Process: FDWATCH: peer null in event: ident 21

Edit:

Forget about the errors.

Now it says the id/pw are wrong when I try to login the client.

 

 

put this in conf.txt in your DB

ITEM_ID_RANGE = 2000000000 2100000000
Link to comment
Share on other sites

  • Former Staff

put this in conf.txt in your DB

ITEM_ID_RANGE = 2000000000 2100000000

syserr db

SYSERR: Feb 17 03:45:25 :: __GetHostInfo: __GetHostInfo() ==> DirectQuery failed(SELECT mIP FROM gmhost)
SYSERR: Feb 17 03:45:25 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='192.168.1.87')

syserr ch1

SYSERR: Feb 17 03:48:06 :: pid_init: 
Start of pid: 1177

SYSERR: Feb 17 03:48:10 :: ReadSpecialDropItemFile: ReadSpecialDropItemFile : there is no item 71164 : node µ¿¹°_»óÀÚ_ij½Ã
SYSERR: Feb 17 03:48:10 :: Boot: cannot load SpecialItemGroup: locale/singapore/special_item_group.txt
SYSERR: Feb 17 03:48:11 :: pid_deinit: 
End of pid

Link to comment
Share on other sites

  • Premium

Thank you for Posting it ^_^

Butter I have a little Problem

I took the game and the db file.

And i put them on my Server ^_^

But when I tried to Start it, it sayed "Connection refused"

It was from the db file

The syserr sais:

SYSERR: Feb 17 15:22:39 :: Start: TABLE_POSTFIX not configured use default

SYSERR: Feb 17 15:22:39 :: InitializeTables: InitializeMobTable FAILED

SYSERR: Feb 17 15:22:39 :: Initialize: Table Initialize FAILED

SYSERR: Feb 17 15:22:39 :: pid_deinit:

End of pid

SYSERR: Feb 17 15:30:29 :: Start: TABLE_POSTFIX not configured use default

SYSERR: Feb 17 15:30:29 :: 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 17 15:30:29 :: Load: DirectQuery failed(SELECT login FROM block_exception)

What Do I have to put also so that it works ^_^

Cause I don't wann to install the whole sf :s

Link to comment
Share on other sites

  • Premium

 

put this in conf.txt in your DB

ITEM_ID_RANGE = 2000000000 2100000000

syserr db

SYSERR: Feb 17 03:45:25 :: __GetHostInfo: __GetHostInfo() ==> DirectQuery failed(SELECT mIP FROM gmhost)
SYSERR: Feb 17 03:45:25 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='192.168.1.87')

syserr ch1

SYSERR: Feb 17 03:48:06 :: pid_init: 
Start of pid: 1177

SYSERR: Feb 17 03:48:10 :: ReadSpecialDropItemFile: ReadSpecialDropItemFile : there is no item 71164 : node µ¿¹°_»óÀÚ_ij½Ã
SYSERR: Feb 17 03:48:10 :: Boot: cannot load SpecialItemGroup: locale/singapore/special_item_group.txt
SYSERR: Feb 17 03:48:11 :: pid_deinit: 
End of pid

 

 

check if localhost user got " select"  privilege :D , i mean

mt2@localhost

or whatever you got

Link to comment
Share on other sites

  • Former Staff

db

SYSERR: Feb 17 18:56:13 :: __GetHostInfo: __GetHostInfo() ==> DirectQuery failed(SELECT mIP FROM gmhost)
SYSERR: Feb 17 18:56:13 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='192.168.5.100')
SYSERR: Feb 17 18:56:16 :: Process: FDWATCH: peer null in event: ident 22
SYSERR: Feb 17 18:56:17 :: Process: FDWATCH: peer null in event: ident 21
SYSERR: Feb 17 18:56:17 :: Process: FDWATCH: peer null in event: ident 20

ch1

SYSERR: Feb 17 18:57:28 :: ChildLoop: AsyncSQL: query failed: Table 'account.string' doesn't exist (query: SELECT name, text FROM string errno: 1146)
SYSERR: Feb 17 18:57:28 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'account.guild' doesn't exist
query: SELECT id FROM guild
SYSERR: Feb 17 18:57:32 :: ReadSpecialDropItemFile: ReadSpecialDropItemFile : there is no item 71164 : node µ¿¹°_»óÀÚ_ij½Ã
SYSERR: Feb 17 18:57:32 :: Boot: cannot load SpecialItemGroup: locale/singapore/special_item_group.txt
SYSERR: Feb 17 18:57:33 :: pid_deinit: 
End of pid

Link to comment
Share on other sites

Announcements



×
×
  • Create New...

Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.