Jump to content

error in mysql connect.

blackcatq8
 Share

Recommended Posts

blackcatq8 Explorer

blackcatq8 0

Posted
Posted 
181201 06:51:37 mysqld_safe Logging to '/var/db/mysql/serveur-1.err'.
181201 06:51:37 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
181201  6:51:37 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
181201  6:51:37 [Note] /usr/local/libexec/mysqld (mysqld 5.5.61) starting as process 3550 ...
181201  6:51:37 InnoDB: The InnoDB memory heap is disabled
181201  6:51:37 InnoDB: Mutexes and rw_locks use GCC atomic builtins
181201  6:51:37 InnoDB: Compressed tables use zlib 1.2.11
181201  6:51:37 InnoDB: Initializing buffer pool, size = 128.0M
181201  6:51:37 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
181201  6:51:37  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
181201  6:51:37  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
181201  6:51:37  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
181201  6:51:38  InnoDB: Waiting for the background threads to start
181201  6:51:39 InnoDB: 5.5.61 started; log sequence number 0
181201  6:51:39 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
181201  6:51:39 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
181201  6:51:39 [Note] Server socket created on IP: '0.0.0.0'.
181201  6:51:39 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
181201  6:51:39 [ERROR] Do you already have another mysqld server running on port: 3306 ?
181201  6:51:39 [ERROR] Aborting

181201  6:51:39  InnoDB: Starting shutdown...
181201  6:51:39  InnoDB: Shutdown completed; log sequence number 1595675
181201  6:51:39 [Note] /usr/local/libexec/mysqld: Shutdown complete

181201 06:51:39 mysqld_safe mysqld from pid file /var/db/mysql/serveur-1.pid ended

 

Link to comment
https://metin2.dev/topic/20122-error-in-mysql-connect/
Share on other sites
  • Replies 5
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

blackcatq8 Explorer

blackcatq8 0

Posted
  • Author
Posted 
SYSERR: Dec  1 08:25:15.735238 :: pid_init: 
Start of pid: 3187

Dec  1 08:25:15.735661 :: connecting to MySQL server (player)
Dec  1 08:25:15.735892 :: CREATING DIRECT_SQL
Dec  1 08:25:15.735974 :: AsyncSQL: locale latin1
Dec  1 08:25:15.752810 :: CREATING MAIN_SQL
Dec  1 08:25:15.753092 :: AsyncSQL: locale latin1
Dec  1 08:25:15.753355 :: CREATING ASYNC_SQL
Dec  1 08:25:15.753498 :: AsyncSQL: locale latin1
Dec  1 08:25:15.753597 ::    OK
Dec  1 08:25:15.753878 :: connecting to MySQL server (account)
Dec  1 08:25:15.753961 :: CREATING DIRECT_SQL
Dec  1 08:25:15.754053 :: AsyncSQL: locale latin1
Dec  1 08:25:15.755644 :: CREATING MAIN_SQL
Dec  1 08:25:15.755761 :: AsyncSQL: locale latin1
Dec  1 08:25:15.755867 :: CREATING ASYNC_SQL
Dec  1 08:25:15.755907 :: AsyncSQL: locale latin1
Dec  1 08:25:15.755959 ::    OK
Dec  1 08:25:15.756028 :: connecting to MySQL server (common)
Dec  1 08:25:15.756058 :: CREATING DIRECT_SQL
Dec  1 08:25:15.756099 :: AsyncSQL: locale latin1
Dec  1 08:25:15.758953 :: CREATING MAIN_SQL
Dec  1 08:25:15.759071 :: AsyncSQL: locale latin1
Dec  1 08:25:15.759296 :: CREATING ASYNC_SQL
Dec  1 08:25:15.759355 :: AsyncSQL: locale latin1
Dec  1 08:25:15.759505 ::    OK
Dec  1 08:25:15.759601 :: connecting to MySQL server (hotbackup)
Dec  1 08:25:15.763254 :: CREATING DIRECT_SQL
Dec  1 08:25:15.763337 :: AsyncSQL: locale latin1
Dec  1 08:25:15.764761 :: CREATING MAIN_SQL
Dec  1 08:25:15.764825 :: AsyncSQL: locale latin1
Dec  1 08:25:15.765070 :: CREATING ASYNC_SQL
Dec  1 08:25:15.765194 :: AsyncSQL: locale latin1
Dec  1 08:25:15.765277 ::    OK
Dec  1 08:25:15.765524 :: ClientManager initialization.. 
Dec  1 08:25:15.780261 :: InitializeLocalization() - LoadLocaleTable(count:13)
Dec  1 08:25:15.780796 :: locale[UNKNOWN_KEY(SKILL_POWER_BY_LEVEL_TYPE0)] = 0 5 6 8 10 12 14 16 18 20 22 24
Dec  1 08:25:15.780856 :: locale[UNKNOWN_KEY(SKILL_POWER_BY_LEVEL_TYPE1)] = 0 5 6 8 10 12 14 16 18 20 22 24
Dec  1 08:25:15.780907 :: locale[UNKNOWN_KEY(SKILL_POWER_BY_LEVEL_TYPE2)] = 0 5 6 8 10 12 14 16 18 20 22 24
Dec  1 08:25:15.780968 :: locale[UNKNOWN_KEY(SKILL_POWER_BY_LEVEL_TYPE3)] = 0 5 6 8 10 12 14 16 18 20 22 24
Dec  1 08:25:15.781134 :: locale[UNKNOWN_KEY(SKILL_POWER_BY_LEVEL_TYPE4)] = 0 5 6 8 10 12 14 16 18 20 22 24
Dec  1 08:25:15.781193 :: locale[UNKNOWN_KEY(SKILL_POWER_BY_LEVEL_TYPE5)] = 0 5 6 8 10 12 14 16 18 20 22 24
Dec  1 08:25:15.785142 :: locale[UNKNOWN_KEY(SKILL_POWER_BY_LEVEL_TYPE6)] = 0 5 6 8 10 12 14 16 18 20 22 24
Dec  1 08:25:15.785306 :: locale[UNKNOWN_KEY(SKILL_POWER_BY_LEVEL_TYPE7)] = 0 5 6 8 10 12 14 16 18 20 22 24
Dec  1 08:25:15.785418 :: locale[LOCALE] = turkey
Dec  1 08:25:15.785510 :: Changed g_stLocale latin1 to euckr
Dec  1 08:25:15.785564 :: SetLocale start
Dec  1 08:25:15.785608 :: End setlocale latin1

db error. ?

Link to comment
https://metin2.dev/topic/20122-error-in-mysql-connect/#findComment-109286
Share on other sites
  • Premium
WeedHex Veteran

WeedHex 661

Posted
  • Premium
Posted 
181201  6:51:39 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
181201  6:51:39 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
181201  6:51:39 [Note] Server socket created on IP: '0.0.0.0'.
Link to comment
https://metin2.dev/topic/20122-error-in-mysql-connect/#findComment-109288
Share on other sites
blackcatq8 Explorer

blackcatq8 0

Posted
  • Author
Posted
2 hours ago, WeedHex said: 

181201  6:51:39 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
181201  6:51:39 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
181201  6:51:39 [Note] Server socket created on IP: '0.0.0.0'.

how to fix it :)

Link to comment
https://metin2.dev/topic/20122-error-in-mysql-connect/#findComment-109292
Share on other sites
blackcatq8 Explorer

blackcatq8 0

Posted
  • Author
Posted
15 hours ago, WeedHex said:

DB: common/locale 

SKILL_POWER_BY_LEVEL_TYPE0    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 125 125 125 125 125
SKILL_POWER_BY_LEVEL_TYPE1    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 125 125 125 125 125
SKILL_POWER_BY_LEVEL_TYPE2    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 125 125 125 125 125
SKILL_POWER_BY_LEVEL_TYPE3    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 125 125 125 125 125
SKILL_POWER_BY_LEVEL_TYPE4    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 125 125 125 125 125
SKILL_POWER_BY_LEVEL_TYPE5    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 125 125 125 125 125
SKILL_POWER_BY_LEVEL_TYPE6    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 125 125 125 125 125
SKILL_POWER_BY_LEVEL_TYPE7    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 125 125 125 125 125
LOCALE    arabia
DB_NAME_COLUMN    locale_name
SKILL_DAMAGE_BY_LEVEL_UNDER_90    0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
SKILL_DAMAGE_BY_LEVEL_UNDER_45    0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
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 125 125 125 125 125

latin1_swedish_ci

  

sys err ch1/game1
SYSERR: Dec  2 08:52:47.289303 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Dec  2 08:52:47.312873 :: InitializeLua: LOAD_QUESTLIB_FAILURE(locale/arabia/quest/questlib.lua)
SYSERR: Dec  2 08:52:52.427041 :: pid_init: 
Start of pid: 2055
sys log
Start of pid: 1911

Dec  2 08:50:40.466384 :: SYSTEM: BINDING TCP PORT ON [13002] (fd 10)
Dec  2 08:50:40.466422 :: SYSTEM: BINDING TCP PORT ON [14002] (fd 11)
Dec  2 08:50:40.467209 :: SYSTEM: Trying to connect to localhost:15000
SYSERR: Dec  2 08:50:40.467383 :: socket_connect: HOST localhost:15000, could not connect.
Dec  2 08:50:40.467456 :: CLIENT_DESC [db_clientdesc] trying DBPacket() while not connected
Dec  2 08:50:40.467466 :: SPAM_CONFIG: duration 900 score 100 reload cycle 600

Dec  2 08:50:40.469543 :: Add Arena Map:112 startA(8534,101) startB(8564,101)
Dec  2 08:50:40.469557 :: Add Arena Map:112 startA(8584,101) startB(8614,101)
Dec  2 08:50:40.469569 :: Add Arena Map:112 startA(8534,155) startB(8564,155)
Dec  2 08:50:40.469580 :: Add Arena Map:112 startA(8584,155) startB(8614,155)
Dec  2 08:50:40.469776 :: bgm_info.set_bgm_volume_enable
Dec  2 08:50:40.471693 :: LoadSettings(locale/arabia/settings.lua), returns 0
Dec  2 08:50:40.490635 :: LoadQuestlib(locale/arabia/quest/questlib.lua), returns 1
SYSERR: Dec  2 08:50:40.490653 :: InitializeLua: LOAD_QUESTLIB_FAILURE(locale/arabia/quest/questlib.lua)
Dec  2 08:50:40.497556 :: AsyncSQL: closing mysql connection.
Dec  2 08:50:40.498248 :: AsyncSQL: closing mysql connection.
Dec  2 08:50:40.498624 :: AsyncSQL: closing mysql connection.
Dec  2 08:50:40.499014 :: AsyncSQL: closing mysql connection.
Dec  2 08:50:40.499536 :: AsyncSQL: closing mysql connection.
SYSERR: Dec  2 08:50:45.664174 :: pid_init: 
Start of pid: 1919

Dec  2 08:50:45.665133 :: SYSTEM: BINDING TCP PORT ON [13002] (fd 10)
Dec  2 08:50:45.665158 :: SYSTEM: BINDING TCP PORT ON [14002] (fd 11)
Dec  2 08:50:45.665827 :: SYSTEM: Trying to connect to localhost:15000
SYSERR: Dec  2 08:50:45.666107 :: socket_connect: HOST localhost:15000, could not connect.
Dec  2 08:50:45.666179 :: CLIENT_DESC [db_clientdesc] trying DBPacket() while not connected
Dec  2 08:50:45.666190 :: SPAM_CONFIG: duration 900 score 100 reload cycle 600

Dec  2 08:50:45.668456 :: Add Arena Map:112 startA(8534,101) startB(8564,101)
Dec  2 08:50:45.668470 :: Add Arena Map:112 startA(8584,101) startB(8614,101)
Dec  2 08:50:45.668481 :: Add Arena Map:112 startA(8534,155) startB(8564,155)
Dec  2 08:50:45.668492 :: Add Arena Map:112 startA(8584,155) startB(8614,155)
Dec  2 08:50:45.668693 :: bgm_info.set_bgm_volume_enable
Dec  2 08:50:45.669684 :: LoadSettings(locale/arabia/settings.lua), returns 0
Dec  2 08:50:45.686241 :: LoadQuestlib(locale/arabia/quest/questlib.lua), returns 1
SYSERR: Dec  2 08:50:45.686258 :: InitializeLua: LOAD_QUESTLIB_FAILURE(locale/arabia/quest/questlib.lua)
Dec  2 08:50:45.694091 :: AsyncSQL: closing mysql connection.
Dec  2 08:50:45.695626 :: AsyncSQL: closing mysql connection.
Dec  2 08:50:45.695885 :: AsyncSQL: closing mysql connection.
Dec  2 08:50:45.696165 :: AsyncSQL: closing mysql connection.
Dec  2 08:50:45.696715 :: AsyncSQL: closing mysql connection.
SYSERR: Dec  2 08:50:50.778107 :: pid_init: 
Start of pid: 1924

 

Link to comment
https://metin2.dev/topic/20122-error-in-mysql-connect/#findComment-109294
Share on other sites

Don't use any images from : imgur, turkmmop, freakgamers, inforge, hizliresim... Or your content will be deleted without notice...
Use : https://metin2.download/media/add/

Please use https://metin2.download/ when uploading files smaller than 100MB, otherwise the approval will take longer due to manual upload.

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now
 Share
Go to topic listing
×
×
  • 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.