How to set up Aura Kingdom Server on CentOS

[Myrio0212]

I did that but that's what it shows ... Eperty123

 

[NetTrodon]

@Eperty123
Tutorial Make Account ID Please

Sorry my bad english

There is not Web/Control panel at this moment. Althoug you can use SQL.

1st step: Create user in FFMember database

INSERT INTO tb_user(
            mid, password, pwd)
    VALUES ('testuser', 'testpassword', MD5('testpassword'));

2nd step: Retrieve <user_id> for user in FFMember database

select idnum from tb_user where tb_user.mid = 'testuser';

3rd step: Create user in FFAccount database

INSERT INTO accounts(
            id, username, password)
    VALUES (<user_id>, 'testuser', 'testpassword');

 

[Myrio0212]

*_* I need help can anyone help me on atleast putting the server database functioning?

 

[EvilPdor]

Somebody is already hosting Aura in public servers?

i'm hosting, not publit yet (check bugs and some db fix), but i hope soon

 

[dyinginside]

i'm hosting, not publit yet (check bugs and some db fix), but i hope soon

i will definitely be waiting for this. Getting tired of .to tbh. Hope you get it public soon man!

 

[editorzone]

Login Code

       1,2015/11/02 19:29:25,[EVENT] Connected to database[103.253.73.106].     2,2015/11/02 19:29:25,[EVENT] Get 2 world servers from DB.     3,2015/11/02 19:29:25,[EVENT] Load 1 records of AccountID from database.     4,2015/11/02 19:29:25,[EVENT] Load login_version: [1-6-7-VIP (Login)] from database done.     5,2015/11/02 19:29:26,RSA size(n) = 256 size(e) = 2     6,2015/11/02 19:29:26,RSA size(n) = 256 size(e) = 2     7,2015/11/02 19:29:26,Server is rolling on TCP 0.0.0.0:6543.     8,2015/11/02 19:29:26,Connect to 103.253.73.106<0xC95380:9>:18624.     9,2015/11/02 19:29:26,Connect to 103.253.73.106<0xCB1EC0:10>:5560.    10,2015/11/02 19:29:26,Connect to 103.253.73.106<0xCB4B30:11>:5560.    11,2015/11/02 19:29:26,[EVENT] LoginServer (with BillingGateway support) booting...    12,2015/11/02 19:29:26,[EVENT] EventUpdatePopulation constructed.    13,2015/11/02 19:29:26,Add New Epoll 8    14,2015/11/02 19:29:26,Add New Epoll 9    15,2015/11/02 19:29:26,Add New Epoll 10    16,2015/11/02 19:29:26,Add New Epoll 11    17,2015/11/02 19:29:26,[EVENT] Update world: [1010] state: [0] ver: [Unknown_Version] successful.    18,2015/11/02 19:29:26,[EVENT] Update world: [1020] state: [0] ver: [Unknown_Version] successful.    19,2015/11/02 19:29:32,EVAL(5.903033 secs): {Network I/O}    20,2015/11/02 19:29:32,EVAL(5.906960 secs): {Main Loop}    21,2015/11/02 19:29:32,[EVENT] Update population of 2 servers.    22,2015/11/02 19:29:36,EVAL(4.308835 secs): {Network I/O}    23,2015/11/02 19:29:36,EVAL(4.309312 secs): {Main Loop}    24,2015/11/02 19:29:36,[EVENT] Update world: [1010] state: [1] ver: [003.005.01.04] successful.    25,2015/11/02 19:29:36,[EVENT] Update world: [1020] state: [0] ver: [Unknown_Version] successful.    26,2015/11/02 19:29:36,[EVENT] Update world: [1010] state: [1] ver: [003.005.01.04] successful.    27,2015/11/02 19:29:36,[EVENT] Update world: [1020] state: [0] ver: [Unknown_Version] successful.    28,2015/11/02 19:29:38,EVAL(1.689789 secs): {Network I/O}    29,2015/11/02 19:29:38,EVAL(1.691020 secs): {Main Loop}    30,2015/11/02 19:29:38,[EVENT] Update population of 2 servers.    31,2015/11/02 19:29:44,EVAL(6.002616 secs): {Network I/O}    32,2015/11/02 19:29:44,EVAL(6.003407 secs): {Main Loop}    33,2015/11/02 19:29:44,[EVENT] Update population of 2 servers.    34,2015/11/02 19:29:50,EVAL(6.005400 secs): {Network I/O}    35,2015/11/02 19:29:50,EVAL(6.005969 secs): {Main Loop}    36,2015/11/02 19:29:50,[EVENT] Update population of 2 servers.    37,2015/11/02 19:29:56,EVAL(6.006079 secs): {Network I/O}    38,2015/11/02 19:29:56,EVAL(6.007055 secs): {Main Loop}    39,2015/11/02 19:29:56,[EVENT] Update population of 2 servers.    40,2015/11/02 19:29:59,SOCKET 12: accepted by 8    41,2015/11/02 19:29:59,TCP <0xCB87A0:12>: connected from (null) [49.229.110.132].    42,2015/11/02 19:29:59,EVAL(2.805586 secs): {Network I/O}    43,2015/11/02 19:29:59,EVAL(2.806112 secs): {Main Loop}    44,2015/11/02 19:29:59,Add New Epoll 12    45,2015/11/02 19:29:59,TCP <0xCB87A0:12>: connection from '49.229.110.132' encrypted.    46,2015/11/02 19:29:59,[EVENT] Bind AccountName: [editor] with SessionID: [1] in NE_CL_ServerLoginAccount.    47,2015/11/02 19:29:59,[EVENT] CheckSendCount: [1] SendCnt[0] < SendMaxCnt[10]    48,2015/11/02 19:29:59,[EVENT] Send AccountLogin AccountName: [editor] SendCnt[1] with SessionID: [1] Queue[0] in NE_CL_ServerLoginAccount.    49,2015/11/02 19:29:59,[NE_CL_ServerLoginAccount.cc:86],[DEBUG] [ 49.229.110.132:(null) ] Name: [editor], Version: [003.005.01.04]

    50,2015/11/02 19:29:59,[NC_G_ClientAccountLogin.cc:10],CNE_G_ClientAccountLogin ReturnCode=1    51,2015/11/02 19:29:59,[EVENT] Account ID: [2418]'s world servers' states generated.    52,2015/11/02 19:29:59,[EVENT] ReturnCode: [1], AccountID: [2418], LastWorld: [1010]    53,2015/11/02 19:29:59,[EVENT] CheckLoginQueue: SendCnt[0]    54,2015/11/02 19:30:02,EVAL(2.330099 secs): {Network I/O}    55,2015/11/02 19:30:02,EVAL(2.330189 secs): {Main Loop}    56,2015/11/02 19:30:02,[NE_CL_ServerLoginWorld.cc:67],[DEBUG] [ 49.229.110.132:(null) ] Name = 'editor'
    57,2015/11/02 19:30:02,[EVENT] Ticket 2418, 0x846EE531, 0x6A49FD67, 0x15BF Sent    58,2015/11/02 19:30:02,[EVENT] Update population of 2 servers.    59,2015/11/02 19:30:06,EVAL(3.634459 secs): {Network I/O}    60,2015/11/02 19:30:06,EVAL(3.635056 secs): {Main Loop}    61,2015/11/02 19:30:06,[NE_CL_ServerLoginWorld.cc:67],[DEBUG] [ 49.229.110.132:(null) ] Name = 'editor'
    62,2015/11/02 19:30:06,[EVENT] Ticket 2418, 0x846EE531, 0x6A49FD67, 0x15BF Sent    63,2015/11/02 19:30:08,EVAL(2.365506 secs): {Network I/O}    64,2015/11/02 19:30:08,EVAL(2.365570 secs): {Main Loop}    65,2015/11/02 19:30:08,[EVENT] Update population of 2 servers.    66,2015/11/02 19:30:14,EVAL(6.006221 secs): {Network I/O}    67,2015/11/02 19:30:14,EVAL(6.006841 secs): {Main Loop}    68,2015/11/02 19:30:14,[EVENT] Update population of 2 servers.    69,2015/11/02 19:30:20,EVAL(6.006209 secs): {Network I/O}    70,2015/11/02 19:30:20,EVAL(6.006765 secs): {Main Loop}    71,2015/11/02 19:30:20,[EVENT] Update population of 2 servers.    72,2015/11/02 19:30:26,EVAL(6.006186 secs): {Network I/O}    73,2015/11/02 19:30:26,EVAL(6.006802 secs): {Main Loop}    74,2015/11/02 19:30:26,[EVENT] Update population of 2 servers.    75,2015/11/02 19:30:32,EVAL(6.000015 secs): {Network I/O}    76,2015/11/02 19:30:32,EVAL(6.000596 secs): {Main Loop}    77,2015/11/02 19:30:32,[EVENT] Update population of 2 servers.    78,2015/11/02 19:30:38,EVAL(6.000058 secs): {Network I/O}    79,2015/11/02 19:30:38,EVAL(6.000573 secs): {Main Loop}    80,2015/11/02 19:30:38,[EVENT] Update population of 2 servers.    81,2015/11/02 19:30:44,EVAL(6.002895 secs): {Network I/O}    82,2015/11/02 19:30:44,EVAL(6.003671 secs): {Main Loop}    83,2015/11/02 19:30:44,[EVENT] Update population of 2 servers.    84,2015/11/02 19:30:50,EVAL(6.006199 secs): {Network I/O}    85,2015/11/02 19:30:50,EVAL(6.006753 secs): {Main Loop}    86,2015/11/02 19:30:50,[EVENT] Update population of 2 servers.    87,2015/11/02 19:30:56,EVAL(6.006186 secs): {Network I/O}    88,2015/11/02 19:30:56,EVAL(6.006788 secs): {Main Loop}    89,2015/11/02 19:30:56,[EVENT] Update population of 2 servers.    90,2015/11/02 19:31:02,EVAL(6.005261 secs): {Network I/O}    91,2015/11/02 19:31:02,EVAL(6.005877 secs): {Main Loop}    92,2015/11/02 19:31:02,[EVENT] Update population of 2 servers.    93,2015/11/02 19:31:08,EVAL(6.006119 secs): {Network I/O}    94,2015/11/02 19:31:08,EVAL(6.006701 secs): {Main Loop}    95,2015/11/02 19:31:08,[EVENT] Update population of 2 servers.    96,2015/11/02 19:31:14,EVAL(6.006065 secs): {Network I/O}    97,2015/11/02 19:31:14,EVAL(6.006614 secs): {Main Loop}    98,2015/11/02 19:31:14,[EVENT] Update population of 2 servers.    99,2015/11/02 19:31:20,EVAL(6.006064 secs): {Network I/O}   100,2015/11/02 19:31:20,EVAL(6.006664 secs): {Main Loop}   101,2015/11/02 19:31:20,[EVENT] Update population of 2 servers.   102,2015/11/02 19:31:26,EVAL(6.006084 secs): {Network I/O}   103,2015/11/02 19:31:26,EVAL(6.006645 secs): {Main Loop}   104,2015/11/02 19:31:26,[EVENT] Update population of 2 servers.   105,2015/11/02 19:31:32,EVAL(6.000028 secs): {Network I/O}   106,2015/11/02 19:31:32,EVAL(6.000853 secs): {Main Loop}   107,2015/11/02 19:31:32,[EVENT] Update population of 2 servers.   108,2015/11/02 19:31:38,EVAL(6.006151 secs): {Network I/O}   109,2015/11/02 19:31:38,EVAL(6.006696 secs): {Main Loop}   110,2015/11/02 19:31:38,[EVENT] Update population of 2 servers.   111,2015/11/02 19:31:44,EVAL(6.006166 secs): {Network I/O}   112,2015/11/02 19:31:44,EVAL(6.006655 secs): {Main Loop}   113,2015/11/02 19:31:44,[EVENT] Update population of 2 servers.   114,2015/11/02 19:31:50,EVAL(6.006171 secs): {Network I/O}   115,2015/11/02 19:31:50,EVAL(6.006810 secs): {Main Loop}   116,2015/11/02 19:31:50,[EVENT] Update population of 2 servers.   117,2015/11/02 19:31:56,EVAL(6.006089 secs): {Network I/O}   118,2015/11/02 19:31:56,EVAL(6.006671 secs): {Main Loop}   119,2015/11/02 19:31:56,[EVENT] Update population of 2 servers.   120,2015/11/02 19:32:02,EVAL(6.002413 secs): {Network I/O}   121,2015/11/02 19:32:02,EVAL(6.003004 secs): {Main Loop}   122,2015/11/02 19:32:02,[EVENT] Update population of 2 servers.   123,2015/11/02 19:32:08,EVAL(6.006169 secs): {Network I/O}   124,2015/11/02 19:32:08,EVAL(6.006790 secs): {Main Loop}   125,2015/11/02 19:32:08,[EVENT] Update population of 2 servers.   126,2015/11/02 19:32:14,EVAL(6.000681 secs): {Network I/O}   127,2015/11/02 19:32:14,EVAL(6.001232 secs): {Main Loop}   128,2015/11/02 19:32:14,[EVENT] Update population of 2 servers.   129,2015/11/02 19:32:20,EVAL(6.000088 secs): {Network I/O}   130,2015/11/02 19:32:20,EVAL(6.000673 secs): {Main Loop}   131,2015/11/02 19:32:20,[EVENT] Update population of 2 servers.   132,2015/11/02 19:32:26,EVAL(6.000095 secs): {Network I/O}   133,2015/11/02 19:32:26,EVAL(6.000649 secs): {Main Loop}   134,2015/11/02 19:32:26,[EVENT] Update population of 2 servers.   135,2015/11/02 19:32:32,EVAL(6.000048 secs): {Network I/O}   136,2015/11/02 19:32:32,EVAL(6.000630 secs): {Main Loop}   137,2015/11/02 19:32:32,[EVENT] Update population of 2 servers.   138,2015/11/02 19:32:38,EVAL(6.001546 secs): {Network I/O}   139,2015/11/02 19:32:38,EVAL(6.002118 secs): {Main Loop}   140,2015/11/02 19:32:38,[EVENT] Update population of 2 servers.   141,2015/11/02 19:32:44,EVAL(6.006093 secs): {Network I/O}   142,2015/11/02 19:32:44,EVAL(6.006928 secs): {Main Loop}   143,2015/11/02 19:32:44,[EVENT] Update population of 2 servers.   144,2015/11/02 19:32:50,EVAL(6.006074 secs): {Network I/O}   145,2015/11/02 19:32:50,EVAL(6.006820 secs): {Main Loop}   146,2015/11/02 19:32:50,[EVENT] Update population of 2 servers.   147,2015/11/02 19:32:56,EVAL(6.006058 secs): {Network I/O}   148,2015/11/02 19:32:56,EVAL(6.006627 secs): {Main Loop}   149,2015/11/02 19:32:56,[EVENT] Update population of 2 servers.   150,2015/11/02 19:33:02,EVAL(6.006042 secs): {Network I/O}   151,2015/11/02 19:33:02,EVAL(6.006637 secs): {Main Loop}   152,2015/11/02 19:33:02,[EVENT] Update population of 2 servers.   153,2015/11/02 19:33:08,EVAL(6.006096 secs): {Network I/O}   154,2015/11/02 19:33:08,EVAL(6.006672 secs): {Main Loop}   155,2015/11/02 19:33:08,[EVENT] Update population of 2 servers.   156,2015/11/02 19:33:14,EVAL(6.000083 secs): {Network I/O}   157,2015/11/02 19:33:14,EVAL(6.000828 secs): {Main Loop}   158,2015/11/02 19:33:14,[EVENT] Update population of 2 servers.   159,2015/11/02 19:33:20,EVAL(6.006075 secs): {Network I/O}   160,2015/11/02 19:33:20,EVAL(6.006598 secs): {Main Loop}   161,2015/11/02 19:33:20,[EVENT] Update population of 2 servers.   162,2015/11/02 19:33:26,EVAL(6.002856 secs): {Network I/O}   163,2015/11/02 19:33:26,EVAL(6.003479 secs): {Main Loop}   164,2015/11/02 19:33:26,[EVENT] Update population of 2 servers.   165,2015/11/02 19:33:32,EVAL(6.000078 secs): {Network I/O}   166,2015/11/02 19:33:32,EVAL(6.000801 secs): {Main Loop}   167,2015/11/02 19:33:32,[EVENT] Update population of 2 servers.   168,2015/11/02 19:33:38,EVAL(6.000096 secs): {Network I/O}   169,2015/11/02 19:33:38,EVAL(6.000728 secs): {Main Loop}   170,2015/11/02 19:33:38,[EVENT] Update population of 2 servers.   171,2015/11/02 19:33:44,EVAL(6.000068 secs): {Network I/O}   172,2015/11/02 19:33:44,EVAL(6.000669 secs): {Main Loop}   173,2015/11/02 19:33:44,[EVENT] Update population of 2 servers.   174,2015/11/02 19:33:50,EVAL(6.006063 secs): {Network I/O}   175,2015/11/02 19:33:50,EVAL(6.006707 secs): {Main Loop}   176,2015/11/02 19:33:50,[EVENT] Update population of 2 servers.   177,2015/11/02 19:33:56,EVAL(6.006084 secs): {Network I/O}   178,2015/11/02 19:33:56,EVAL(6.006771 secs): {Main Loop}   179,2015/11/02 19:33:56,[EVENT] Update population of 2 servers.   180,2015/11/02 19:34:02,EVAL(6.000032 secs): {Network I/O}   181,2015/11/02 19:34:02,EVAL(6.000964 secs): {Main Loop}   182,2015/11/02 19:34:02,[EVENT] Update population of 2 servers.   183,2015/11/02 19:34:08,EVAL(6.000090 secs): {Network I/O}   184,2015/11/02 19:34:08,EVAL(6.000856 secs): {Main Loop}   185,2015/11/02 19:34:08,[EVENT] Update population of 2 servers.   186,2015/11/02 19:34:14,EVAL(6.006069 secs): {Network I/O}   187,2015/11/02 19:34:14,EVAL(6.006957 secs): {Main Loop}   188,2015/11/02 19:34:14,[EVENT] Update population of 2 servers.   189,2015/11/02 19:34:20,EVAL(6.000105 secs): {Network I/O}   190,2015/11/02 19:34:20,EVAL(6.000878 secs): {Main Loop}   191,2015/11/02 19:34:20,[EVENT] Update population of 2 servers.   192,2015/11/02 19:34:26,EVAL(6.006060 secs): {Network I/O}   193,2015/11/02 19:34:26,EVAL(6.006993 secs): {Main Loop}   194,2015/11/02 19:34:26,[EVENT] Update population of 2 servers.   195,2015/11/02 19:34:32,EVAL(6.006060 secs): {Network I/O}   196,2015/11/02 19:34:32,EVAL(6.006608 secs): {Main Loop}   197,2015/11/02 19:34:32,[EVENT] Update population of 2 servers.   198,2015/11/02 19:34:38,EVAL(6.006043 secs): {Network I/O}   199,2015/11/02 19:34:38,EVAL(6.006675 secs): {Main Loop}   200,2015/11/02 19:34:38,[EVENT] Update population of 2 servers.   201,2015/11/02 19:34:40,TCP <0xCB87A0:12>: FillBuffer (49.229.110.132 recv 0)   202,2015/11/02 19:34:40,TCP <0xCB87A0:12>: FillState = LP_READ_ERROR.   203,2015/11/02 19:34:40,TCP <0xCB87A0:12>: (null) [49.229.110.132] lost link.   204,2015/11/02 19:34:40,[Session.cc:149],Call Interface.Get (0xCB76D0)->Lost ()
   205,2015/11/02 19:34:40,EVAL(1.392497 secs): {Network I/O}   206,2015/11/02 19:34:40,EVAL(1.393029 secs): {Main Loop}   207,2015/11/02 19:34:40,Erase Socket 12   208,2015/11/02 19:34:40,TCP <0xCB87A0:12>: connection real-closed.   209,2015/11/02 19:34:40,SOCKET 12: closed.   210,2015/11/02 19:34:40,Clean Session 0xC7F690   211,2015/11/02 19:34:41,SOCKET 12: accepted by 8   212,2015/11/02 19:34:41,TCP <0xCB8500:12>: connected from (null) [49.229.110.132].   213,2015/11/02 19:34:41,EVAL(1.654210 secs): {Network I/O}   214,2015/11/02 19:34:41,EVAL(1.654236 secs): {Main Loop}   215,2015/11/02 19:34:41,Add New Epoll 12   216,2015/11/02 19:34:42,TCP <0xCB8500:12>: connection from '49.229.110.132' encrypted.   217,2015/11/02 19:34:43,[EVENT] Bind AccountName: [editor] with SessionID: [4] in NE_CL_ServerLoginAccount.   218,2015/11/02 19:34:43,[EVENT] CheckSendCount: [4] SendCnt[0] < SendMaxCnt[10]   219,2015/11/02 19:34:43,[EVENT] Send AccountLogin AccountName: [editor] SendCnt[1] with SessionID: [4] Queue[0] in NE_CL_ServerLoginAccount.   220,2015/11/02 19:34:43,[NE_CL_ServerLoginAccount.cc:86],[DEBUG] [ 49.229.110.132:(null) ] Name: [editor], Version: [003.005.01.04]

   221,2015/11/02 19:34:43,[NC_G_ClientAccountLogin.cc:10],CNE_G_ClientAccountLogin ReturnCode=1   222,2015/11/02 19:34:43,[EVENT] Account ID: [2418]'s world servers' states generated.   223,2015/11/02 19:34:43,[EVENT] ReturnCode: [1], AccountID: [2418], LastWorld: [1010]   224,2015/11/02 19:34:43,[EVENT] CheckLoginQueue: SendCnt[0]   225,2015/11/02 19:34:44,EVAL(1.762833 secs): {Network I/O}   226,2015/11/02 19:34:44,EVAL(1.762896 secs): {Main Loop}   227,2015/11/02 19:34:44,[EVENT] Update population of 2 servers.   228,2015/11/02 19:34:49,TCP <0xCB8500:12>: FillBuffer (49.229.110.132 recv 0)   229,2015/11/02 19:34:49,TCP <0xCB8500:12>: FillState = LP_READ_ERROR.   230,2015/11/02 19:34:49,TCP <0xCB8500:12>: (null) [49.229.110.132] lost link.   231,2015/11/02 19:34:49,[Session.cc:149],Call Interface.Get (0xCAF910)->Lost ()
   232,2015/11/02 19:34:49,EVAL(5.059020 secs): {Network I/O}   233,2015/11/02 19:34:49,EVAL(5.059717 secs): {Main Loop}   234,2015/11/02 19:34:49,Erase Socket 12   235,2015/11/02 19:34:49,TCP <0xCB8500:12>: connection real-closed.   236,2015/11/02 19:34:49,SOCKET 12: closed.   237,2015/11/02 19:34:49,Clean Session 0xC949F0   238,2015/11/02 19:34:50,[EVENT] Update population of 2 servers.   239,2015/11/02 19:34:56,EVAL(6.000093 secs): {Network I/O}   240,2015/11/02 19:34:56,EVAL(6.000907 secs): {Main Loop}   241,2015/11/02 19:34:56,[EVENT] Update population of 2 servers.   242,2015/11/02 19:34:59,EVAL(2.595060 secs): {Network I/O}   243,2015/11/02 19:34:59,EVAL(2.595626 secs): {Main Loop}   244,2015/11/02 19:35:02,EVAL(3.404092 secs): {Network I/O}   245,2015/11/02 19:35:02,EVAL(3.404222 secs): {Main Loop}   246,2015/11/02 19:35:02,[EVENT] Update population of 2 servers.   247,2015/11/02 19:35:08,EVAL(6.000084 secs): {Network I/O}   248,2015/11/02 19:35:08,EVAL(6.000586 secs): {Main Loop}   249,2015/11/02 19:35:08,[EVENT] Update population of 2 servers.   250,2015/11/02 19:35:14,EVAL(6.000034 secs): {Network I/O}   251,2015/11/02 19:35:14,EVAL(6.000718 secs): {Main Loop}   252,2015/11/02 19:35:14,[EVENT] Update population of 2 servers.   253,2015/11/02 19:35:20,EVAL(6.006202 secs): {Network I/O}   254,2015/11/02 19:35:20,EVAL(6.006974 secs): {Main Loop}   255,2015/11/02 19:35:20,[EVENT] Update population of 2 servers.   256,2015/11/02 19:35:21,SOCKET 12: accepted by 8   257,2015/11/02 19:35:21,TCP <0xCB7CC0:12>: connected from (null) [49.229.110.132].   258,2015/11/02 19:35:21,Add New Epoll 12   259,2015/11/02 19:35:21,TCP <0xCB7CC0:12>: connection from '49.229.110.132' encrypted.   260,2015/11/02 19:35:21,[EVENT] Bind AccountName: [editor] with SessionID: [5] in NE_CL_ServerLoginAccount.   261,2015/11/02 19:35:21,[EVENT] CheckSendCount: [5] SendCnt[0] < SendMaxCnt[10]   262,2015/11/02 19:35:21,[EVENT] Send AccountLogin AccountName: [editor] SendCnt[1] with SessionID: [5] Queue[0] in NE_CL_ServerLoginAccount.   263,2015/11/02 19:35:21,[NE_CL_ServerLoginAccount.cc:86],[DEBUG] [ 49.229.110.132:(null) ] Name: [editor], Version: [003.005.01.04]

   264,2015/11/02 19:35:21,[NC_G_ClientAccountLogin.cc:10],CNE_G_ClientAccountLogin ReturnCode=1   265,2015/11/02 19:35:21,[EVENT] Account ID: [2418]'s world servers' states generated.   266,2015/11/02 19:35:21,[EVENT] ReturnCode: [1], AccountID: [2418], LastWorld: [1010]   267,2015/11/02 19:35:21,[EVENT] CheckLoginQueue: SendCnt[0]   268,2015/11/02 19:35:23,EVAL(1.997242 secs): {Network I/O}   269,2015/11/02 19:35:23,EVAL(1.997317 secs): {Main Loop}   270,2015/11/02 19:35:23,[NE_CL_ServerLoginWorld.cc:67],[DEBUG] [ 49.229.110.132:(null) ] Name = 'editor'
   271,2015/11/02 19:35:23,[EVENT] Ticket 2418, 0x846EE531, 0x6A49FD67, 0x15C0 Sent   272,2015/11/02 19:35:26,EVAL(3.338072 secs): {Network I/O}   273,2015/11/02 19:35:26,EVAL(3.338127 secs): {Main Loop}   274,2015/11/02 19:35:26,[EVENT] Update population of 2 servers.   275,2015/11/02 19:35:32,EVAL(6.006093 secs): {Network I/O}   276,2015/11/02 19:35:32,EVAL(6.006842 secs): {Main Loop}   277,2015/11/02 19:35:32,[EVENT] Update population of 2 servers.   278,2015/11/02 19:35:38,EVAL(6.000083 secs): {Network I/O}   279,2015/11/02 19:35:38,EVAL(6.000759 secs): {Main Loop}   280,2015/11/02 19:35:38,[EVENT] Update population of 2 servers.   281,2015/11/02 19:35:44,EVAL(6.004388 secs): {Network I/O}   282,2015/11/02 19:35:44,EVAL(6.004968 secs): {Main Loop}   283,2015/11/02 19:35:44,[EVENT] Update population of 2 servers.   284,2015/11/02 19:35:50,EVAL(6.000411 secs): {Network I/O}   285,2015/11/02 19:35:50,EVAL(6.001020 secs): {Main Loop}   286,2015/11/02 19:35:50,[EVENT] Update population of 2 servers.   287,2015/11/02 19:35:56,EVAL(6.006064 secs): {Network I/O}   288,2015/11/02 19:35:56,EVAL(6.006765 secs): {Main Loop}   289,2015/11/02 19:35:56,[EVENT] Update population of 2 servers.   290,2015/11/02 19:36:02,EVAL(6.005758 secs): {Network I/O}   291,2015/11/02 19:36:02,EVAL(6.006337 secs): {Main Loop}   292,2015/11/02 19:36:02,[EVENT] Update population of 2 servers.   293,2015/11/02 19:36:08,EVAL(6.000185 secs): {Network I/O}   294,2015/11/02 19:36:08,EVAL(6.000758 secs): {Main Loop}   295,2015/11/02 19:36:08,[EVENT] Update population of 2 servers.   296,2015/11/02 19:36:14,TCP <0xCB7CC0:12>: FillBuffer (49.229.110.132 recv 0)   297,2015/11/02 19:36:14,TCP <0xCB7CC0:12>: FillState = LP_READ_ERROR.   298,2015/11/02 19:36:14,TCP <0xCB7CC0:12>: (null) [49.229.110.132] lost link.   299,2015/11/02 19:36:14,[Session.cc:149],Call Interface.Get (0xC8B670)->Lost ()
   300,2015/11/02 19:36:14,EVAL(5.282887 secs): {Network I/O}   301,2015/11/02 19:36:14,EVAL(5.283584 secs): {Main Loop}   302,2015/11/02 19:36:14,Erase Socket 12   303,2015/11/02 19:36:14,TCP <0xCB7CC0:12>: connection real-closed.   304,2015/11/02 19:36:14,SOCKET 12: closed.   305,2015/11/02 19:36:14,Clean Session 0xC8B320   306,2015/11/02 19:36:14,[EVENT] Update population of 2 servers.   307,2015/11/02 19:36:20,EVAL(6.001939 secs): {Network I/O}   308,2015/11/02 19:36:20,EVAL(6.002748 secs): {Main Loop}   309,2015/11/02 19:36:20,[EVENT] Update population of 2 servers.   310,2015/11/02 19:36:26,EVAL(6.000102 secs): {Network I/O}   311,2015/11/02 19:36:26,EVAL(6.000724 secs): {Main Loop}   312,2015/11/02 19:36:26,[EVENT] Update population of 2 servers.   313,2015/11/02 19:36:32,EVAL(6.002796 secs): {Network I/O}   314,2015/11/02 19:36:32,EVAL(6.003432 secs): {Main Loop}   315,2015/11/02 19:36:32,[EVENT] Update population of 2 servers.   316,2015/11/02 19:36:38,EVAL(6.000060 secs): {Network I/O}   317,2015/11/02 19:36:38,EVAL(6.000796 secs): {Main Loop}   318,2015/11/02 19:36:38,[EVENT] Update population of 2 servers.   319,2015/11/02 19:36:44,EVAL(6.001202 secs): {Network I/O}   320,2015/11/02 19:36:44,EVAL(6.001785 secs): {Main Loop}   321,2015/11/02 19:36:44,[EVENT] Update population of 2 servers.   322,2015/11/02 19:36:50,EVAL(6.001727 secs): {Network I/O}   323,2015/11/02 19:36:50,EVAL(6.002511 secs): {Main Loop}   324,2015/11/02 19:36:50,[EVENT] Update population of 2 servers.   325,2015/11/02 19:36:56,EVAL(6.001600 secs): {Network I/O}   326,2015/11/02 19:36:56,EVAL(6.002436 secs): {Main Loop}   327,2015/11/02 19:36:56,[EVENT] Update population of 2 servers.   328,2015/11/02 19:37:02,EVAL(6.005256 secs): {Network I/O}   329,2015/11/02 19:37:02,EVAL(6.006105 secs): {Main Loop}   330,2015/11/02 19:37:02,[EVENT] Update population of 2 servers.   331,2015/11/02 19:37:08,EVAL(6.000053 secs): {Network I/O}   332,2015/11/02 19:37:08,EVAL(6.000838 secs): {Main Loop}   333,2015/11/02 19:37:08,[EVENT] Update population of 2 servers.   334,2015/11/02 19:37:14,EVAL(6.002219 secs): {Network I/O}   335,2015/11/02 19:37:14,EVAL(6.002802 secs): {Main Loop}   336,2015/11/02 19:37:14,[EVENT] Update population of 2 servers.   337,2015/11/02 19:37:20,EVAL(6.000184 secs): {Network I/O}   338,2015/11/02 19:37:20,EVAL(6.000813 secs): {Main Loop}   339,2015/11/02 19:37:20,[EVENT] Update population of 2 servers.   340,2015/11/02 19:37:26,EVAL(6.001035 secs): {Network I/O}   341,2015/11/02 19:37:26,EVAL(6.002134 secs): {Main Loop}   342,2015/11/02 19:37:26,[EVENT] Update population of 2 servers.   343,2015/11/02 19:37:32,EVAL(6.004643 secs): {Network I/O}   344,2015/11/02 19:37:32,EVAL(6.005171 secs): {Main Loop}   345,2015/11/02 19:37:32,[EVENT] Update population of 2 servers.   346,2015/11/02 19:37:38,EVAL(6.000098 secs): {Network I/O}   347,2015/11/02 19:37:38,EVAL(6.000673 secs): {Main Loop}   348,2015/11/02 19:37:38,[EVENT] Update population of 2 servers.   349,2015/11/02 19:37:44,EVAL(6.000080 secs): {Network I/O}   350,2015/11/02 19:37:44,EVAL(6.000912 secs): {Main Loop}   351,2015/11/02 19:37:44,[EVENT] Update population of 2 servers.   352,2015/11/02 19:37:50,EVAL(6.000052 secs): {Network I/O}   353,2015/11/02 19:37:50,EVAL(6.000589 secs): {Main Loop}   354,2015/11/02 19:37:50,[EVENT] Update population of 2 servers.   355,2015/11/02 19:37:56,EVAL(6.006056 secs): {Network I/O}   356,2015/11/02 19:37:56,EVAL(6.006679 secs): {Main Loop}   357,2015/11/02 19:37:56,[EVENT] Update population of 2 servers.   358,2015/11/02 19:38:02,EVAL(6.000033 secs): {Network I/O}   359,2015/11/02 19:38:02,EVAL(6.000673 secs): {Main Loop}   360,2015/11/02 19:38:02,[EVENT] Update population of 2 servers.   361,2015/11/02 19:38:08,EVAL(6.000045 secs): {Network I/O}   362,2015/11/02 19:38:08,EVAL(6.000806 secs): {Main Loop}   363,2015/11/02 19:38:08,[EVENT] Update population of 2 servers.   364,2015/11/02 19:38:14,EVAL(6.005423 secs): {Network I/O}   365,2015/11/02 19:38:14,EVAL(6.005989 secs): {Main Loop}   366,2015/11/02 19:38:14,[EVENT] Update population of 2 servers.   367,2015/11/02 19:38:20,EVAL(6.006080 secs): {Network I/O}   368,2015/11/02 19:38:20,EVAL(6.006837 secs): {Main Loop}   369,2015/11/02 19:38:20,[EVENT] Update population of 2 servers.   370,2015/11/02 19:38:26,EVAL(6.000032 secs): {Network I/O}   371,2015/11/02 19:38:26,EVAL(6.000703 secs): {Main Loop}   372,2015/11/02 19:38:26,[EVENT] Update population of 2 servers.   373,2015/11/02 19:38:32,EVAL(6.006073 secs): {Network I/O}   374,2015/11/02 19:38:32,EVAL(6.006653 secs): {Main Loop}   375,2015/11/02 19:38:32,[EVENT] Update population of 2 servers.   376,2015/11/02 19:38:38,EVAL(6.000056 secs): {Network I/O}   377,2015/11/02 19:38:38,EVAL(6.000690 secs): {Main Loop}   378,2015/11/02 19:38:38,[EVENT] Update population of 2 servers.   379,2015/11/02 19:38:44,EVAL(6.000040 secs): {Network I/O}   380,2015/11/02 19:38:44,EVAL(6.000809 secs): {Main Loop}   381,2015/11/02 19:38:44,[EVENT] Update population of 2 servers.   382,2015/11/02 19:38:50,EVAL(6.000065 secs): {Network I/O}   383,2015/11/02 19:38:50,EVAL(6.000642 secs): {Main Loop}   384,2015/11/02 19:38:50,[EVENT] Update population of 2 servers.   385,2015/11/02 19:38:56,EVAL(6.006102 secs): {Network I/O}   386,2015/11/02 19:38:56,EVAL(6.006690 secs): {Main Loop}   387,2015/11/02 19:38:56,[EVENT] Update population of 2 servers.   388,2015/11/02 19:39:02,EVAL(6.006061 secs): {Network I/O}   389,2015/11/02 19:39:02,EVAL(6.006875 secs): {Main Loop}   390,2015/11/02 19:39:02,[EVENT] Update population of 2 servers.   391,2015/11/02 19:39:08,EVAL(6.004865 secs): {Network I/O}   392,2015/11/02 19:39:08,EVAL(6.005446 secs): {Main Loop}   393,2015/11/02 19:39:08,[EVENT] Update population of 2 servers.   394,2015/11/02 19:39:14,EVAL(6.001216 secs): {Network I/O}   395,2015/11/02 19:39:14,EVAL(6.001937 secs): {Main Loop}   396,2015/11/02 19:39:14,[EVENT] Update population of 2 servers.   397,2015/11/02 19:39:20,EVAL(6.001046 secs): {Network I/O}   398,2015/11/02 19:39:20,EVAL(6.002230 secs): {Main Loop}   399,2015/11/02 19:39:20,[EVENT] Update population of 2 servers.   400,2015/11/02 19:39:26,EVAL(6.006074 secs): {Network I/O}   401,2015/11/02 19:39:26,EVAL(6.006688 secs): {Main Loop}   402,2015/11/02 19:39:26,[EVENT] Update population of 2 servers.   403,2015/11/02 19:39:32,EVAL(6.006072 secs): {Network I/O}   404,2015/11/02 19:39:32,EVAL(6.006774 secs): {Main Loop}   405,2015/11/02 19:39:32,[EVENT] Update population of 2 servers.   406,2015/11/02 19:39:38,EVAL(6.000086 secs): {Network I/O}   407,2015/11/02 19:39:38,EVAL(6.000804 secs): {Main Loop}   408,2015/11/02 19:39:38,[EVENT] Update population of 2 servers.   409,2015/11/02 19:39:41,EVAL(2.903097 secs): {Network I/O}   410,2015/11/02 19:39:41,EVAL(2.903714 secs): {Main Loop}   411,2015/11/02 19:39:44,EVAL(3.099188 secs): {Network I/O}   412,2015/11/02 19:39:44,EVAL(3.099282 secs): {Main Loop}   413,2015/11/02 19:39:44,[EVENT] Update population of 2 servers.   414,2015/11/02 19:39:50,EVAL(6.000209 secs): {Network I/O}   415,2015/11/02 19:39:50,EVAL(6.000833 secs): {Main Loop}   416,2015/11/02 19:39:50,[EVENT] Update population of 2 servers.   417,2015/11/02 19:39:56,EVAL(6.006758 secs): {Network I/O}   418,2015/11/02 19:39:56,EVAL(6.007839 secs): {Main Loop}   419,2015/11/02 19:39:56,[EVENT] Update population of 2 servers.   420,2015/11/02 19:40:02,EVAL(6.000059 secs): {Network I/O}   421,2015/11/02 19:40:02,EVAL(6.000905 secs): {Main Loop}   422,2015/11/02 19:40:02,[EVENT] Update population of 2 servers.   423,2015/11/02 19:40:08,EVAL(6.000083 secs): {Network I/O}   424,2015/11/02 19:40:08,EVAL(6.000686 secs): {Main Loop}   425,2015/11/02 19:40:08,[EVENT] Update population of 2 servers.   426,2015/11/02 19:40:14,EVAL(6.005943 secs): {Network I/O}   427,2015/11/02 19:40:14,EVAL(6.006798 secs): {Main Loop}   428,2015/11/02 19:40:14,[EVENT] Update population of 2 servers.   429,2015/11/02 19:40:20,EVAL(6.006086 secs): {Network I/O}   430,2015/11/02 19:40:20,EVAL(6.006960 secs): {Main Loop}   431,2015/11/02 19:40:20,[EVENT] Update population of 2 servers.   432,2015/11/02 19:40:26,EVAL(5.758102 secs): {Network I/O}   433,2015/11/02 19:40:26,EVAL(5.758218 secs): {Main Loop}   434,2015/11/02 19:40:26,[EVENT] Update population of 2 servers.   435,2015/11/02 19:40:32,EVAL(6.000053 secs): {Network I/O}   436,2015/11/02 19:40:32,EVAL(6.000645 secs): {Main Loop}   437,2015/11/02 19:40:32,[EVENT] Update population of 2 servers.   438,2015/11/02 19:40:38,EVAL(6.000607 secs): {Network I/O}   439,2015/11/02 19:40:38,EVAL(6.001217 secs): {Main Loop}   440,2015/11/02 19:40:38,[EVENT] Update population of 2 servers.   441,2015/11/02 19:40:44,EVAL(6.006067 secs): {Network I/O}   442,2015/11/02 19:40:44,EVAL(6.006648 secs): {Main Loop}   443,2015/11/02 19:40:44,[EVENT] Update population of 2 servers.   444,2015/11/02 19:40:50,EVAL(6.002445 secs): {Network I/O}   445,2015/11/02 19:40:50,EVAL(6.003109 secs): {Main Loop}   446,2015/11/02 19:40:50,[EVENT] Update population of 2 servers.   447,2015/11/02 19:40:56,EVAL(6.003236 secs): {Network I/O}   448,2015/11/02 19:40:56,EVAL(6.004015 secs): {Main Loop}   449,2015/11/02 19:40:56,[EVENT] Update population of 2 servers.   450,2015/11/02 19:41:03,EVAL(6.006067 secs): {Network I/O}   451,2015/11/02 19:41:03,EVAL(6.006850 secs): {Main Loop}   452,2015/11/02 19:41:03,[EVENT] Update population of 2 servers.   453,2015/11/02 19:41:09,EVAL(6.006073 secs): {Network I/O}   454,2015/11/02 19:41:09,EVAL(6.006816 secs): {Main Loop}   455,2015/11/02 19:41:09,[EVENT] Update population of 2 servers.   456,2015/11/02 19:41:15,EVAL(6.004967 secs): {Network I/O}   457,2015/11/02 19:41:15,EVAL(6.005828 secs): {Main Loop}   458,2015/11/02 19:41:15,[EVENT] Update population of 2 servers.   459,2015/11/02 19:41:21,EVAL(6.000075 secs): {Network I/O}   460,2015/11/02 19:41:21,EVAL(6.000688 secs): {Main Loop}   461,2015/11/02 19:41:21,[EVENT] Update population of 2 servers.   462,2015/11/02 19:41:27,EVAL(6.001612 secs): {Network I/O}   463,2015/11/02 19:41:27,EVAL(6.002207 secs): {Main Loop}   464,2015/11/02 19:41:27,[EVENT] Update population of 2 servers.   465,2015/11/02 19:41:33,EVAL(6.000042 secs): {Network I/O}   466,2015/11/02 19:41:33,EVAL(6.000746 secs): {Main Loop}   467,2015/11/02 19:41:33,[EVENT] Update population of 2 servers.   468,2015/11/02 19:41:39,EVAL(6.004587 secs): {Network I/O}   469,2015/11/02 19:41:39,EVAL(6.005087 secs): {Main Loop}   470,2015/11/02 19:41:39,[EVENT] Update population of 2 servers.   471,2015/11/02 19:41:45,EVAL(6.000106 secs): {Network I/O}   472,2015/11/02 19:41:45,EVAL(6.000703 secs): {Main Loop}   473,2015/11/02 19:41:45,[EVENT] Update population of 2 servers.   474,2015/11/02 19:41:51,EVAL(6.000052 secs): {Network I/O}   475,2015/11/02 19:41:51,EVAL(6.000772 secs): {Main Loop}   476,2015/11/02 19:41:51,[EVENT] Update population of 2 servers.   477,2015/11/02 19:41:57,EVAL(6.000044 secs): {Network I/O}   478,2015/11/02 19:41:57,EVAL(6.000675 secs): {Main Loop}   479,2015/11/02 19:41:57,[EVENT] Update population of 2 servers.   480,2015/11/02 19:42:03,EVAL(6.001406 secs): {Network I/O}   481,2015/11/02 19:42:03,EVAL(6.002008 secs): {Main Loop}   482,2015/11/02 19:42:03,[EVENT] Update population of 2 servers.   483,2015/11/02 19:42:09,EVAL(6.000097 secs): {Network I/O}   484,2015/11/02 19:42:09,EVAL(6.000678 secs): {Main Loop}   485,2015/11/02 19:42:09,[EVENT] Update population of 2 servers.   486,2015/11/02 19:42:15,EVAL(6.000289 secs): {Network I/O}   487,2015/11/02 19:42:15,EVAL(6.000851 secs): {Main Loop}   488,2015/11/02 19:42:15,[EVENT] Update population of 2 servers.   489,2015/11/02 19:42:21,EVAL(6.001339 secs): {Network I/O}   490,2015/11/02 19:42:21,EVAL(6.001893 secs): {Main Loop}   491,2015/11/02 19:42:21,[EVENT] Update population of 2 servers.   492,2015/11/02 19:42:27,EVAL(6.006083 secs): {Network I/O}   493,2015/11/02 19:42:27,EVAL(6.006702 secs): {Main Loop}   494,2015/11/02 19:42:27,[EVENT] Update population of 2 servers.   495,2015/11/02 19:42:33,EVAL(6.000044 secs): {Network I/O}   496,2015/11/02 19:42:33,EVAL(6.000644 secs): {Main Loop}   497,2015/11/02 19:42:33,[EVENT] Update population of 2 servers.   498,2015/11/02 19:42:39,EVAL(6.005099 secs): {Network I/O}   499,2015/11/02 19:42:39,EVAL(6.005698 secs): {Main Loop}   500,2015/11/02 19:42:39,[EVENT] Update population of 2 servers.   501,2015/11/02 19:42:45,EVAL(6.000094 secs): {Network I/O}   502,2015/11/02 19:42:45,EVAL(6.000846 secs): {Main Loop}   503,2015/11/02 19:42:45,[EVENT] Update population of 2 servers.   504,2015/11/02 19:42:51,EVAL(6.000060 secs): {Network I/O}   505,2015/11/02 19:42:51,EVAL(6.000659 secs): {Main Loop}   506,2015/11/02 19:42:51,[EVENT] Update population of 2 servers.   507,2015/11/02 19:42:57,EVAL(6.006061 secs): {Network I/O}   508,2015/11/02 19:42:57,EVAL(6.006576 secs): {Main Loop}   509,2015/11/02 19:42:57,[EVENT] Update population of 2 servers.   510,2015/11/02 19:43:03,EVAL(6.006080 secs): {Network I/O}   511,2015/11/02 19:43:03,EVAL(6.006786 secs): {Main Loop}   512,2015/11/02 19:43:03,[EVENT] Update population of 2 servers.   513,2015/11/02 19:43:09,EVAL(6.006133 secs): {Network I/O}   514,2015/11/02 19:43:09,EVAL(6.006725 secs): {Main Loop}   515,2015/11/02 19:43:09,[EVENT] Update population of 2 servers.   516,2015/11/02 19:43:15,EVAL(6.018320 secs): {Network I/O}   517,2015/11/02 19:43:15,EVAL(6.031578 secs): {Main Loop}   518,2015/11/02 19:43:15,[EVENT] Update population of 2 servers.

Help me please I'm Can't Select server

 

[Hycker]

maybe i did something wrong.... any1 seen this error before? its from gateway server log

  4813,2015/11/02 19:27:10,EVAL(1.001124 secs): {Main Loop}
  4814,2015/11/02 19:27:10,[NE_G_ServerAccountLogin.cc:15],CNE_G_ServerAccountLogin lofasz 0x976ab00
  4815,2015/11/02 19:27:10,[DATABASE][ERROR] EXEC: {SELECT account_login('lofasz','f5227287ef4dcf4a95b18efd29815f59','MY IP HERE');}
            -RETURNS: ERROR:  function account_login(unknown, unknown, unknown) does not exist
LINE 1: SELECT account_login('lofasz','f5227287ef4dcf4a95b18efd29815...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

  4816,2015/11/02 19:27:10,[PGAccountDBO.cc:77],[FATAL] Load AccountLogin failed. ERROR:  function account_login(unknown, unknown, unknown) does not exist
LINE 1: SELECT account_login('lofasz','f5227287ef4dcf4a95b18efd29815...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.


  4817,2015/11/02 19:27:11,EVAL(1.000554 secs): {Network I/O}

Client gives System error while login

looks like account_login function missing, while i imported three of sql (except itemshop) files.
or im just noobed something?

rest things: im on WAN connection settings, looks like all service up and running well

 

[Myrio0212]

i'm hosting, not publit yet (check bugs and some db fix), but i hope soon

Please help me to get my server working master XD I really need help would you please be my lord and savior XD



Is showing "could not change directory to "/root": Permission denied" When I try to create a super user for postgres but after I try it again it shows again but it says that it already exists and I have the same problem when I try to do \i <File Path> it shows that it doesn't has permission to do so.

 

[evestu]

maybe i did something wrong.... any1 seen this error before? its from gateway server log

  4813,2015/11/02 19:27:10,EVAL(1.001124 secs): {Main Loop}
  4814,2015/11/02 19:27:10,[NE_G_ServerAccountLogin.cc:15],CNE_G_ServerAccountLogin lofasz 0x976ab00
  4815,2015/11/02 19:27:10,[DATABASE][ERROR] EXEC: {SELECT account_login('lofasz','f5227287ef4dcf4a95b18efd29815f59','MY IP HERE');}
            -RETURNS: ERROR:  function account_login(unknown, unknown, unknown) does not exist
LINE 1: SELECT account_login('lofasz','f5227287ef4dcf4a95b18efd29815...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

  4816,2015/11/02 19:27:10,[PGAccountDBO.cc:77],[FATAL] Load AccountLogin failed. ERROR:  function account_login(unknown, unknown, unknown) does not exist
LINE 1: SELECT account_login('lofasz','f5227287ef4dcf4a95b18efd29815...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.


  4817,2015/11/02 19:27:11,EVAL(1.000554 secs): {Network I/O}

Client gives System error while login

looks like account_login function missing, while i imported three of sql (except itemshop) files.
or im just noobed something?

rest things: im on WAN connection settings, looks like all service up and running well

FFmember > Functions Make sure > account_login(varchar, varchar, varchar)

And remember to have the right info in TB_USER from my instructions.

Note: Sometimes the Sql corrupts when using navicat to make changes i have found.

And i have found that World-server can cause this if it is overwritten best to rename the old one then copy new one to folder and set to chmod 777.

 

[Hycker]

So far i remember i havent any functions there. Can ya dump ur sql maybe? Thx for info

Tapatalk-kal küldve az én GT-I9300-el

 

[Eperty123]

So far i remember i havent any functions there. Can ya dump ur sql maybe? Thx for info

Tapatalk-kal küldve az én GT-I9300-el

Or use the ones included in the server files. They are working as they should.

 

[Hycker]

well im not a psql expert but in the FFMember.sql file there is nothing declared account_login function which cames with serverfiles linked in first post.
View attachment FFMember.rar

 

[WireShark]

well im not a psql expert but in the FFMember.sql file there is nothing declared account_login function which cames with serverfiles linked in first post.
View attachment 154206

Its on the 1st page Look change YourPostgreSQLUSER into your account for PostgreSQL

[COLOR=#008000]--[/COLOR]
[COLOR=#008000]-- Name: account_login(character varying, character varying, character varying); Type: FUNCTION; Schema: public; Owner: [/COLOR][COLOR=#0000ff]YourPostgreSQLUSER[/COLOR]
[COLOR=#008000]--[/COLOR]


CREATE FUNCTION account_login(character varying, character varying, character varying) RETURNS res_set
    LANGUAGE plpgsql
    AS $_$declare
ppAccountID ALIAS FOR $1;
pPassword ALIAS FOR $2;
pClientIP ALIAS FOR $3;
pAccountID varchar(20);
pcount int;
pPwd char(32) default null;
pBAuthority int2 default 0;
pGMIP varchar(15) default null;


res res_set;


BEGIN
pAccountID = lower(ppAccountID);
res.nRet=-1;


SELECT INTO pcount count(mid) FROM "tb_user" WHERE mid=pAccountID;
IF pcount =0 THEN --This Account is not exist
res.pIdNum= -1;
res.nRet = 2;
RETURN res;
END IF;


SELECT INTO pPwd,pBAuthority,res.pIdNum pwd,byAuthority,idnum FROM "tb_user" WHERE mid=pAccountID;


IF pPwd IS null THEN
res.nRet = 2;
RETURN res;
ELSEIF pPwd <> pPassword THEN
res.nRet = 3;
RETURN res;
END IF;


IF pBAuthority = 255 THEN   [COLOR=#008000]--This Account was locked[/COLOR]
res.nRet = 5;
RETURN res;
END IF;
[COLOR=#008000]
[/COLOR]
[COLOR=#008000]--IF pBAuthority = 1 THEN   --gmAccount  Check ip (0-->User, 1-->GM, 255-->Locked)[/COLOR]
[COLOR=#008000]--SELECT INTO pGMIP ip FROM gmip WHERE ip=pClientIP;[/COLOR]
[COLOR=#008000]--IF pGMIP IS NULL THEN[/COLOR]
[COLOR=#008000]--res.nRet = 4;[/COLOR]
[COLOR=#008000]--RETURN res;[/COLOR]
[COLOR=#008000]--END IF;[/COLOR]
[COLOR=#008000]--END IF;[/COLOR]


res.nRet = 1;
RETURN res;
END;
$_$;




ALTER FUNCTION public.account_login(character varying, character varying, character varying) OWNER TO [COLOR=#0000FF]YourPostgreSQLUSER[/COLOR];

PS: dont just run Script! It was necessary to check it. Goodluck

 

[Hycker]

Thx so much. I gonna test when reach home.

Tapatalk-kal küldve az én GT-I9300-el

 

[Myrio0212]

Okay I just nearly got scammed by dncragezonedev he is claiming that he sells files for 50 $ but guys is a scam his grammar is terrible and tried to say that he will offer the files if I purchase from gameservers.com and then he sent a fake email with terrible grammar and this is the email "Hello sir this is Myrio from brazil because one of my customer ask me to email you about our customer service skype.Yes we have it i thought you are random people message on our contact service email and tripping for it.DNC is our customer on gameserver to confirm he is the one of our customer.Please add us on our customer skype.

Skype: gameserver.customer

Thank You"

Be aware of this guys.



Okay I really need someone who can help me through the process as it just says <Directory> : Permissions Denied when I try to do \i

 

[Hycker]

used other database, now i can login, but after server selection i'll getting server connection fail.

probably im on ONLY WAN, so my server LAN IP is only 127.0.0.1 but i cannot use twice coz its goes on error as ip already in use.
tried to use localhost instead of, but no success. there is any solution for WAN only connection without LAN IP?

PS: DNC dont use skype. He communicate here or over e-mail.

 

[editorzone]

Tutorial Repack Pkg.idx Please

 

[Hycker]

looks like i need to merge two different SQLs for troubleshouting since there is no answer on my question >.>

 

[st-m4il]

@Eperty123 Looks like a nice release, you should have more likes for this. I'm going to install and test. I will report back how long the process took. I have so far read Page 1 to Page 20 so I don't expect many problems.

 

[st-m4il]

Got server running in exactly 2 hours 8:30pm start ~ 10:30pm finish full install from zero. Up and running with only missing 'GMOnce.ini' file error. So it's up and listening.

Only error (did not try to fix yet):

"GMCmd.ini" is loaded.
The file "GMCmdOnce.ini" is not found.

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
2259 root 20 0 211m 952 636 S 3.7 0.0 0:04.61 WorldServer
2250 root 20 0 275m 948 636 S 2.3 0.0 0:04.32 WorldServer
2268 root 20 0 586m 425m 1716 S 1.0 22.7 0:06.52 ZoneServer
2273 root 20 0 1172m 1.1g 1880 R 1.0 60.0 0:06.79 ZoneServer

However Client is the problem! Silly error on client statup: "Please update your graphics card driver to DirectX 9.0c" Problem is I have this! Looks like a common issue:

You must be registered to see links

You must be registered to see links

Official Specification are all met and well beyond:

You must be registered to see links

I am troubleshooting the client problem, maybe just drivers? I will test on another system as well.

You must be registered to see links