ERROR: socket_connect: HOST localhost:15000, could not connect. help please

[silence22 0]

i have problem with my server.
When i see in [auth]-syserr. i see this :
socket_connect: HOST localhost:15000, could not connect.
in [auth]-syslog:
Feb 23 14:38:22 :: SYSTEM: Trying to connect to localhost:15000
SYSERR: Feb 23 14:38:22 :: socket_connect: HOST localhost:15000, could not connect.
Feb 23 14:38:25 :: SYSTEM: Trying to connect to localhost:15000

all syserr and syslog in other cores works normal ony AUTH

Can some one help me?

[Aveline™ 718]

Change port 15000. Sometime system doesn't work with offical port.

 

Regards.

[silence22 0]

i tryed with 16000 port and same problem only say
socket_connect: HOST localhost:16000, could not connect.

[Remix 46]

Is the db core started?

[Aveline™ 718]

Your mysql files maybe crashed. First check it after tell us.

 

Regards.

[silence22 0]

Core is started ..
how i can see my mysql is crashed or not ??

[Yoshix3 9]

tip in 

"ps aux | grep db"

so you can see, if youre core is running.

Looks like your core isn't running.

[Shogun 5778]

Show us db/syserr and stdout

[silence22 0]

db/syserr :
SYSERR: Mar 10 17:28:53 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Mar 10 17:29:06 :: Load:  DirectQuery failed(SELECT login FROM block_exception)
SYSERR: Mar 10 17:35:44 :: heart_idle: losing 49 seconds. (lag occured)

 

[silence22 0]

uppp

 

[silence22 0]

Show us db/syserr and stdout

db/syserr :

SYSERR: Mar 10 17:28:53 :: Start: TABLE_POSTFIX not configured use default

SYSERR: Mar 10 17:29:06 :: Load:  DirectQuery failed(SELECT login FROM block_exception)

SYSERR: Mar 10 17:35:44 :: heart_idle: losing 49 seconds. (lag occured)

[Yoshix3 9]

Run this Query in your account database

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `block_exception`
-- ----------------------------
DROP TABLE IF EXISTS `block_exception`;
CREATE TABLE `block_exception` (
  `login` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=big5;

-- ----------------------------
-- Records of block_exception
-- ----------------------------
INSERT INTO block_exception VALUES ('38393938');

[Necro 100]

Sometime i have this problem when i change something what is wrong in item_proto.txt in server. You try check it..and what do you change last?

[silence22 0]

no i dont have changed anything but i try to install Invoicev3 2013 sf
i installed on daroo sf
only mysql.tar.gz and game.tar.gz

install is succes but i cant login
some idea how to install or ac anyone who know how to log in my computer with Team Viewer...

[mentalu94 52]

i have the same problem

[Germais 16]

This problem that you are facing acually has to do with the speed of your machine. If you say that all the other cores do not show any errors then asuming that the database starts first from the start script, you should use a sleep delay after the core startup, for example, ./db & sleep 2.

[Kaptan Yosun 873]

On 5/29/2017 at 4:46 AM, Germais said:

This problem that you are facing acually has to do with the speed of your machine. If you say that all the other cores do not show any errors then asuming that the database starts first from the start script, you should use a sleep delay after the core startup, for example, ./db & sleep 2.

That's it. That's the solution that I have been looking for all day. Increasing the sleep to 10 from 5 solved it.

[CristalForce 0]

On 5/29/2017 at 12:46 AM, Germais said:

This problem that you are facing acually has to do with the speed of your machine. If you say that all the other cores do not show any errors then asuming that the database starts first from the start script, you should use a sleep delay after the core startup, for example, ./db & sleep 2.

Surely this might be the solution to the problem, try and try 6 or 8 sleep.