Serverul nu porneste

Metin2Moon · 02 Iun 2021, 10:43

*Problemă/Întrebare:
Salut, ma poate ajuta cineva sa rezolv erorile legate de db?

Nu reusesc sa-l pornesc, am instalata versiunea mysql 5.6

Tipologie server:
*Resursă folosită:
*ServerFiles utilizat:svf-pentru-resurse/serverfiles-complet-surs-t83151.html
*Syserr:

Auth

SYSERR: Jun  1 23:48:30 :: pid_init: 
Start of pid: 1097

SYSERR: Jun  1 23:48:48 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: SELECT '*4ACFE3202A5FF5CF467898FC58AAB1D615029441',password,securitycode,social_id,id,status,availDt - NOW() > 0,UNIX_TIMESTAMP(silver_expire),UNIX_TIMESTAMP(gold_expire),UNIX_TIMESTAMP(safebox_expire),UNIX_TIMESTAMP(autoloot_expire),UNIX_TIMESTAMP(fish_mind_expire),UNIX_TIMESTAMP(marriage_fast_expire),UNIX_TIMESTAMP(money_drop_rate_expire),UNIX_TIMESTAMP(create_time) FROM account WHERE login='vaynz' errno: 2002)
SYSERR: Jun  1 23:48:48 :: ChildLoop: AsyncSQL: retrying

Ch1

SYSERR: Jun  1 23:48:32 :: pid_init: 
Start of pid: 1107

SYSERR: Jun  1 23:48:33 :: SetShopItems: Shop: no item table by item vnum #51004
SYSERR: Jun  1 23:50:24 :: pid_init: 
Start of pid: 1362

SYSERR: Jun  1 23:50:25 :: SetShopItems: Shop: no item table by item vnum #51004

S_Ch1

SYSERR: Jun  1 23:48:34 :: pid_init: 
Start of pid: 1115

SYSERR: Jun  1 23:48:35 :: SetShopItems: Shop: no item table by item vnum #51004
SYSERR: Jun  1 23:48:55 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
query: SELECT id,map_index from player_shop WHERE channel=1 and status='OK' and exists(select name from player where id=player_id)
SYSERR: Jun  1 23:48:55 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
query: SELECT ps.id,ps.player_id,REPLACE('#PLAYER_NAME# Shop','#PLAYER_NAME#',p.name),ps.vnum,ps.count,ps.look,ps.price,ps.socket0,ps.socket1,ps.socket2,ps.attrtype0,attrvalue0,ps.attrtype1,attrvalue1,ps.attrtype2,attrvalue2,ps.attrtype3,attrvalue3,ps.attrtype4,attrvalue4,ps.attrtype5,attrvalue5,ps.attrtype6,attrvalue6 FROM `player_shop_items` ps LEFT JOIN player p ON p.id=ps.player_id where not EXISTS(select name from player_shop WHERE id=ps.shop_id) and not ISNULL(p.name)

Ch99

SYSERR: Jun  1 23:48:36 :: pid_init: 
Start of pid: 1125

SYSERR: Jun  1 23:48:37 :: SetShopItems: Shop: no item table by item vnum #51004
SYSERR: Jun  1 23:48:49 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
query: SELECT id,map_index from player_shop WHERE channel=99 and status='OK' and exists(select name from player where id=player_id)
SYSERR: Jun  1 23:48:49 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
query: SELECT ps.id,ps.player_id,REPLACE('#PLAYER_NAME# Shop','#PLAYER_NAME#',p.name),ps.vnum,ps.count,ps.look,ps.price,ps.socket0,ps.socket1,ps.socket2,ps.attrtype0,attrvalue0,ps.attrtype1,attrvalue1,ps.attrtype2,attrvalue2,ps.attrtype3,attrvalue3,ps.attrtype4,attrvalue4,ps.attrtype5,attrvalue5,ps.attrtype6,attrvalue6 FROM `player_shop_items` ps LEFT JOIN player p ON p.id=ps.player_id where not EXISTS(select name from player_shop WHERE id=ps.shop_id) and not ISNULL(p.name)

DB

SYSERR: Jun  1 23:48:28 :: pid_init: 
Start of pid: 1089

SYSERR: Jun  1 23:48:53 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
query: SELECT MAX(id) FROM item  WHERE id >= 10000001 and id <= 20000000
SYSERR: Jun  1 23:48:53 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
query: SELECT COUNT(*) FROM item  WHERE id >= 10000001 AND id <= 20000000
SYSERR: Jun  1 23:48:53 :: Process: FDWATCH: peer null in event: ident 21
SYSERR: Jun  1 23:50:24 :: DirectQuery: MySQL connection was reconnected. querying locale set

Mysql.err

210601 23:48:48 mysqld_safe mysqld from pid file /var/db/mysql/vps-9a14cb60.vps.ovh.net.pid ended
210601 23:50:19 mysqld_safe Logging to '/var/db/mysql/vps-9a14cb60.vps.ovh.net.err'.
210601 23:50:19 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
2021-06-01 23:50:19 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2021-06-01 23:50:19 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.51) starting as process 1360 ...
2021-06-01 23:50:19 1360 [Note] Plugin 'FEDERATED' is disabled.
2021-06-01 23:50:19 1360 [Note] InnoDB: Using atomics to ref count buffer pool pages
2021-06-01 23:50:19 1360 [Note] InnoDB: The InnoDB memory heap is disabled
2021-06-01 23:50:19 1360 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-06-01 23:50:19 1360 [Note] InnoDB: Memory barrier is not used
2021-06-01 23:50:19 1360 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-06-01 23:50:19 1360 [Note] InnoDB: Using CPU crc32 instructions
2021-06-01 23:50:19 1360 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2021-06-01 23:50:19 1360 [Note] InnoDB: Completed initialization of buffer pool
2021-06-01 23:50:19 1360 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
2021-06-01 23:50:19 1360 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
2021-06-01 23:50:19 1360 [Note] InnoDB: Database physically writes the file full: wait...
2021-06-01 23:50:19 1360 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2021-06-01 23:50:19 1360 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2021-06-01 23:50:19 1360 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2021-06-01 23:50:19 1360 [Warning] InnoDB: New log files created, LSN=45781
2021-06-01 23:50:19 1360 [Note] InnoDB: Doublewrite buffer not found: creating new
2021-06-01 23:50:19 1360 [Note] InnoDB: Doublewrite buffer created
2021-06-01 23:50:19 1360 [Note] InnoDB: 128 rollback segment(s) are active.
2021-06-01 23:50:19 1360 [Warning] InnoDB: Creating foreign key constraint system tables.
2021-06-01 23:50:19 1360 [Note] InnoDB: Foreign key constraint system tables created
2021-06-01 23:50:19 1360 [Note] InnoDB: Creating tablespace and datafile system tables.
2021-06-01 23:50:19 1360 [Note] InnoDB: Tablespace and datafile system tables created.
2021-06-01 23:50:19 1360 [Note] InnoDB: Waiting for purge to start
2021-06-01 23:50:19 1360 [Note] InnoDB: 5.6.51 started; log sequence number 0
2021-06-01 23:50:19 1360 [Note] RSA private key file not found: /var/db/mysql//private_key.pem. Some authentication plugins will not work.
2021-06-01 23:50:19 1360 [Note] RSA public key file not found: /var/db/mysql//public_key.pem. Some authentication plugins will not work.
2021-06-01 23:50:19 1360 [Note] Server hostname (bind-address): '*'; port: 3306
2021-06-01 23:50:19 1360 [Note] IPv6 is available.
2021-06-01 23:50:19 1360 [Note]   - '::' resolves to '::';
2021-06-01 23:50:19 1360 [Note] Server socket created on IP: '::'.
2021-06-01 23:50:19 1360 [Note] Event Scheduler: Loaded 0 events
2021-06-01 23:50:19 1360 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.6.51'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
210601 23:52:11 mysqld_safe Logging to '/var/db/mysql/vps-9a14cb60.vps.ovh.net.err'.
210601 23:52:11 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
2021-06-01 23:52:12 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2021-06-01 23:52:12 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.51) starting as process 829 ...
2021-06-01 23:52:12 829 [Note] Plugin 'FEDERATED' is disabled.
2021-06-01 23:52:12 829 [Note] InnoDB: Using atomics to ref count buffer pool pages
2021-06-01 23:52:12 829 [Note] InnoDB: The InnoDB memory heap is disabled
2021-06-01 23:52:12 829 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-06-01 23:52:12 829 [Note] InnoDB: Memory barrier is not used
2021-06-01 23:52:12 829 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-06-01 23:52:12 829 [Note] InnoDB: Using CPU crc32 instructions
2021-06-01 23:52:12 829 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2021-06-01 23:52:12 829 [Note] InnoDB: Completed initialization of buffer pool
2021-06-01 23:52:12 829 [Note] InnoDB: Highest supported file format is Barracuda.
2021-06-01 23:52:12 829 [Note] InnoDB: The log sequence numbers 0 and 0 in ibdata files do not match the log sequence number 1600607 in the ib_logfiles!
2021-06-01 23:52:12 829 [Note] InnoDB: Database was not shutdown normally!
2021-06-01 23:52:12 829 [Note] InnoDB: Starting crash recovery.
2021-06-01 23:52:12 829 [Note] InnoDB: Reading tablespace information from the .ibd files...
2021-06-01 23:52:12 829 [Note] InnoDB: Restoring possible half-written data pages 
2021-06-01 23:52:12 829 [Note] InnoDB: from the doublewrite buffer...
2021-06-01 23:52:12 829 [Note] InnoDB: 128 rollback segment(s) are active.
2021-06-01 23:52:12 829 [Note] InnoDB: Waiting for purge to start
2021-06-01 23:52:12 829 [Note] InnoDB: 5.6.51 started; log sequence number 1600607
2021-06-01 23:52:12 829 [Note] RSA private key file not found: /var/db/mysql//private_key.pem. Some authentication plugins will not work.
2021-06-01 23:52:12 829 [Note] RSA public key file not found: /var/db/mysql//public_key.pem. Some authentication plugins will not work.
2021-06-01 23:52:12 829 [Note] Server hostname (bind-address): '*'; port: 3306
2021-06-01 23:52:12 829 [Note] IPv6 is available.
2021-06-01 23:52:12 829 [Note]   - '::' resolves to '::';
2021-06-01 23:52:12 829 [Note] Server socket created on IP: '::'.
2021-06-01 23:52:13 829 [Note] Event Scheduler: Loaded 0 events
2021-06-01 23:52:13 829 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.6.51'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution

Pornesc serverul, dupa 10 secunde pica tot...si navicat...si ftp. Trebuie sa-i dau reboot din panoul ovh.
Poză:
*Detalii suplimentare:
Pornesc serverul, dupa 10 secunde pica tot...si navicat...si ftp. Trebuie sa-i dau reboot din panoul ovh.

Fubuki.Atsuya · 02 Iun 2021, 12:24

'' SetShopItems: Shop: no item table by item vnum #51004 ''
Daca nu exista pe joc itemul 51004, intra in shop_item si cauti acest cod folosind ctrl+f !
Daca il ai acolo,şterge-l.

Metin2Moon · 03 Iun 2021, 01:58

banuliciraul123 scrie: ↑02 Iun 2021, 12:24 '' SetShopItems: Shop: no item table by item vnum #51004 ''
Daca nu exista pe joc itemul 51004, intra in shop_item si cauti acest cod folosind ctrl+f !
Daca il ai acolo,şterge-l.

Am reusit sa mai rezolv din erori.
Apoi m-am putut loga pana cand a ramas caracterul cu mana in sus, si s-a oprit serverul...

Auth:

SYSERR: Jun  2 23:41:31 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: SELECT '*6E1C***********************parola',password,securitycode,social_id,id,status,availDt - NOW() > 0,UNIX_TIMESTAMP(silver_expire),UNIX_TIMESTAMP(gold_expire),UNIX_TIMESTAMP(safebox_expire),UNIX_TIMESTAMP(autoloot_expire),UNIX_TIMESTAMP(fish_mind_expire),UNIX_TIMESTAMP(marriage_fast_expire),UNIX_TIMESTAMP(money_drop_rate_expire),UNIX_TIMESTAMP(create_time) FROM account WHERE login='test' errno: 2002)

Autorunlog CH1

PUBLIC_IP: 141.95.19.230 interface vtnet0
PLAYER_MAX_LEVEL: 127
PK_PROTECT_LEVEL: 15LocaleService locale/romania/locale_string.txt
HOSTNAME: channel1
AsyncSQL: connected to localhost (reconnect 1)
CommonSQL connected
Setting Locale "romania" (Path: locale/romania)
Setting DB to locale latin2
AsyncSQL: connected to localhost (reconnect 1)
PlayerSQL connected
LogSQL connected
SKILL_POWER_BY_LEVEL 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 130 140 150 160 170 180 190 200 210 220 230 240
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
SKILL_POWER_BY_JOB 0 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 130 140 150 160 170 180 190 200 210 220 230 240
SKILL_POWER_BY_JOB 1 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 130 140 150 160 170 180 190 200 210 220 230 240
AsyncSQL: connected to localhost (reconnect 1)
SKILL_POWER_BY_JOB 2 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 130 140 150 160 170 180 190 200 210 220 230 240
SKILL_POWER_BY_JOB 3 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 130 140 150 160 170 180 190 200 210 220 230 240
SKILL_POWER_BY_JOB 4 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 130 140 150 160 170 180 190 200 210 220 230 240
SKILL_POWER_BY_JOB 5 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 130 140 150 160 170 180 190 200 210 220 230 240
SKILL_POWER_BY_JOB 6 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 130 140 150 160 170 180 190 200 210 220 230 240
SKILL_POWER_BY_JOB 7 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 130 140 150 160 170 180 190 200 210 220 230 240
MAP ALLOW 1
MAP ALLOW 3
MAP ALLOW 7
MAP ALLOW 12
MAP ALLOW 13
MAP ALLOW 21
MAP ALLOW 23
MAP ALLOW 25
MAP ALLOW 27
MAP ALLOW 28
MAP ALLOW 41
MAP ALLOW 43
MAP ALLOW 45
MAP ALLOW 47
MAP ALLOW 63
MAP ALLOW 64
MAP ALLOW 65
MAP ALLOW 66
MAP ALLOW 67
MAP ALLOW 68
MAP ALLOW 81
MAP ALLOW 201
MAP ALLOW 202
MAP ALLOW 213
MAP ALLOW 217
STATUS_POINT_SET_MAX_VALUE: 90
SHOUT_LIMIT_LEVEL: 15

log_file_delete_old: stat: No such file or directory
PUBLIC_IP: 141.95.19.230 interface vtnet0
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
cannot open direct sql connection to host: localhost user: root db: common
cannot start server while no common sql connected
HOSTNAME: channel1
PUBLIC_IP: 141.95.19.230 interface vtnet0
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
cannot open direct sql connection to host: localhost user: root db: common
cannot start server while no common sql connected
HOSTNAME: channel1
PUBLIC_IP: 141.95.19.230 interface vtnet0
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
cannot open direct sql connection to host: localhost user: root db: common
cannot start server while no common sql connected
HOSTNAME: channel1
PUBLIC_IP: 141.95.19.230 interface vtnet0
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
cannot open direct sql connection to host: localhost user: root db: common
cannot start server while no common sql connected
HOSTNAME: channel1
PUBLIC_IP: 141.95.19.230 interface vtnet0
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
cannot open direct sql connection to host: localhost user: root db: common
cannot start server while no common sql connected
HOSTNAME: channel1
PUBLIC_IP: 141.95.19.230 interface vtnet0
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
cannot open direct sql connection to host: localhost user: root db: common
cannot start server while no common sql connected
HOSTNAME: channel1
PUBLIC_IP: 141.95.19.230 interface vtnet0
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
cannot open direct sql connection to host: localhost user: root db: common
cannot start server while no common sql connected
HOSTNAME: channel1
PUBLIC_IP: 141.95.19.230 interface vtnet0
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
cannot open direct sql connection to host: localhost user: root db: common
cannot start server while no common sql connected
HOSTNAME: channel1
PUBLIC_IP: 141.95.19.230 interface vtnet0
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
cannot open direct sql connection to host: localhost user: root db: common
cannot start server while no common sql connected
HOSTNAME: channel1
PUBLIC_IP: 141.95.19.230 interface vtnet0
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
cannot open direct sql connection to host: localhost user: root db: common
cannot start server while no common sql connected
HOSTNAME: channel1
PUBLIC_IP: 141.95.19.230 interface vtnet0
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
cannot open direct sql connection to host: localhost user: root db: common
cannot start server while no common sql connected
HOSTNAME: channel1
PUBLIC_IP: 141.95.19.230 interface vtnet0
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
cannot open direct sql connection to host: localhost user: root db: common
cannot start server while no common sql connected
HOSTNAME: channel1
PUBLIC_IP: 141.95.19.230 interface vtnet0
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
cannot open direct sql connection to host: localhost user: root db: common
cannot start server while no common sql connected
HOSTNAME: channel1
PUBLIC_IP: 141.95.19.230 interface vtnet0
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
cannot open direct sql connection to host: localhost user: root db: common
cannot start server while no common sql connected
HOSTNAME: channel1
PUBLIC_IP: 141.95.19.230 interface vtnet0
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
cannot open direct sql connection to host: localhost user: root db: common
cannot start server while no common sql connected
HOSTNAME: channel1
PUBLIC_IP: 141.95.19.230 interface vtnet0
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
cannot open direct sql connection to host: localhost user: root db: common
cannot start server while no common sql connected
HOSTNAME: channel1
PUBLIC_IP: 141.95.19.230 interface vtnet0
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
cannot open direct sql connection to host: localhost user: root db: common
cannot start server while no common sql connected
HOSTNAME: channel1
PUBLIC_IP: 141.95.19.230 interface vtnet0
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
cannot open direct sql connection to host: localhost user: root db: common
cannot start server while no common sql connected
HOSTNAME: channel1
PUBLIC_IP: 141.95.19.230 interface vtnet0
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
cannot open direct sql connection to host: localhost user: root db: common
cannot start server while no common sql connected
HOSTNAME: channel1
PUBLIC_IP: 141.95.19.230 interface vtnet0
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
cannot open direct sql connection to host: localhost user: root db: common
cannot start server while no common sql connected
HOSTNAME: channel1
PUBLIC_IP: 141.95.19.230 interface vtnet0
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
cannot open direct sql connection to host: localhost user: root db: common
cannot start server while no common sql connected
HOSTNAME: channel1
VRunner 0.6 -- Simple daemon
Managed process was killed by signal 9
Managed process exited with 1
Managed process exited with 1
Managed process exited with 1
Managed process exited with 1
Managed process exited with 1
Managed process exited with 1
Managed process exited with 1
Managed process exited with 1
Managed process exited with 1
Managed process exited with 1
Managed process exited with 1
Managed process exited with 1
Managed process exited with 1
Managed process exited with 1
Managed process exited with 1
Managed process exited with 1
Managed process exited with 1
Managed process exited with 1
Managed process exited with 1
Managed process exited with 1
Managed process exited with 1
Shutting down due to signal (15).

In sysser ch1 nu sunt erori.

CH99 sysser

SYSERR: Jun  2 23:41:16 :: pid_init: 
Start of pid: 1080

SYSERR: Jun  2 23:41:32 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
query: SELECT id,map_index from player_shop WHERE channel=99 and status='OK' and exists(select name from player where id=player_id)
SYSERR: Jun  2 23:41:32 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
query: SELECT ps.id,ps.player_id,REPLACE('#PLAYER_NAME# Shop','#PLAYER_NAME#',p.name),ps.vnum,ps.count,ps.look,ps.price,ps.socket0,ps.socket1,ps.socket2,ps.attrtype0,attrvalue0,ps.attrtype1,attrvalue1,ps.attrtype2,attrvalue2,ps.attrtype3,attrvalue3,ps.attrtype4,attrvalue4,ps.attrtype5,attrvalue5,ps.attrtype6,attrvalue6 FROM `player_shop_items` ps LEFT JOIN player p ON p.id=ps.player_id where not EXISTS(select name from player_shop WHERE id=ps.shop_id) and not ISNULL(p.name)
SYSERR: Jun  2 23:43:20 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Jun  2 23:43:20 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Jun  2 23:43:20 :: pid_deinit: 
End of pid

DB sysser

SYSERR: Jun  2 23:41:08 :: pid_init: 
Start of pid: 1064

SYSERR: Jun  2 23:41:30 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
query: SELECT MAX(id) FROM item  WHERE id >= 30000001 and id <= 40000000
SYSERR: Jun  2 23:41:30 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
query: SELECT COUNT(*) FROM item  WHERE id >= 30000001 AND id <= 40000000
SYSERR: Jun  2 23:41:30 :: Process: FDWATCH: peer null in event: ident 22
SYSERR: Jun  2 23:41:31 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
query: SELECT MAX(id) FROM item  WHERE id >= 10000001 and id <= 20000000
SYSERR: Jun  2 23:41:31 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
query: SELECT COUNT(*) FROM item  WHERE id >= 10000001 AND id <= 20000000
SYSERR: Jun  2 23:41:31 :: Process: FDWATCH: peer null in event: ident 21
SYSERR: Jun  2 23:43:20 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Jun  2 23:43:20 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Jun  2 23:43:20 :: pid_deinit: 
End of pid

Fubuki.Atsuya · 03 Iun 2021, 02:46

Reinstaleaza MySQL,resetează parola și după reboot la sv..poate sunt stricate ceva tabele bănuiesc.

Metin2Moon · 03 Iun 2021, 09:12

banuliciraul123 scrie: ↑03 Iun 2021, 02:46 Reinstaleaza MySQL,resetează parola și după reboot la sv..poate sunt stricate ceva tabele bănuiesc.

Am facut asta de cel putin 3 ori, nicio sansa...

Metin2Moon · 04 Iun 2021, 14:20

Fubuki.Atsuya · 04 Iun 2021, 16:11

intră în navicat,intră pe mysql tău,la user->click dreapta->edit
apoi la username pune - > root (sau ce username ai tu)
host -> localhost
parola -> PAROLA_SERVER

Dacă nu,şterge toţi userii şi crează user nou.Pune userul şi parola în fiecare config din fiecare CH,DB,etc.

Metin2Moon · 06 Iun 2021, 11:40

Cer TC.
Am cumparat un dedicat si acolo merge fara probleme

Fubuki.Atsuya · 06 Iun 2021, 12:33

Mutat în probleme rezolvate.

Serverul nu porneste

Serverul nu porneste

Nu porneste serverul!?

Nu porneste serverul

Nu porneste Serverul !

Cine este conectat