conf/global/sql_connection.conf:1 - syntax error

[Vermithore 0]

I am having the same problem as this topic.

 

I used the mariaDB.bat

 

and my conf/global/sql_connection.conf ended up having this.

 

sql_connection: {
    db_username: "hercules"
    db_password: "***"
    db_database: "hercules"
}

 

I updated the file to be the same as the one on github

 

//================= Hercules Configuration ================================
//=       _   _                     _
//=      | | | |                   | |
//=      | |_| | ___ _ __ ___ _   _| | ___  ___
//=      |  _  |/ _ \ '__/ __| | | | |/ _ \/ __|
//=      | | | |  __/ | | (__| |_| | |  __/\__ \
//=      \_| |_/\___|_|  \___|\__,_|_|\___||___/
//================= License ===============================================
//= This file is part of Hercules.
//= http://herc.ws - http://github.com/HerculesWS/Hercules
//=
//= Copyright (C) 2014-2021 Hercules Dev Team
//=
//= Hercules is free software: you can redistribute it and/or modify
//= it under the terms of the GNU General Public License as published by
//= the Free Software Foundation, either version 3 of the License, or
//= (at your option) any later version.
//=
//= This program is distributed in the hope that it will be useful,
//= but WITHOUT ANY WARRANTY; without even the implied warranty of
//= MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
//= GNU General Public License for more details.
//=
//= You should have received a copy of the GNU General Public License
//= along with this program.  If not, see <http://www.gnu.org/licenses/>.
//=========================================================================
//= SQL connection configuration file.
//=========================================================================
// This file affects how ALL server sql connections work, unless explicitly
// defined so in the server configuration file (See
// doc/global_configuration.txt for more information).
//=========================================================================

sql_connection: {
	// [INTER] You can specify the codepage to use in your mySQL tables here.
	// (Note that this feature requires MySQL 4.1+)
	//default_codepage: ""

	// [LOGIN] Is `userid` in account_db case sensitive?
	//case_sensitive: false

	// For IPs, ideally under linux, you want to use localhost instead of 127.0.0.1.
	// Under windows, you want to use 127.0.0.1.  If you see a message like
	// "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)"
	// and you have localhost, switch it to 127.0.0.1
	db_hostname: "127.0.0.1"
	db_port: "3306"
	db_username: "hercules"
	db_password: "******"
	db_database: "hercules"
	//codepage:""
}

I am db name and username appears to be correct as i'm able to connect through mysql workbench.

 

[Error]: conf/global/sql_connection.conf:1 - syntax error
[Info]: Server uses 'select' as event dispatcher
[Info]: Server supports up to '4096' concurrent connections.
[Error]: conf/global/sql_connection.conf:1 - syntax error
[Status]: Read information about 1 LAN subnets.
[Status]: Read information about 1 trusted IP ranges.
[Status]: Read information about 1 allowed server IP ranges.
[Warning]: Using a wildcard IP range in the allowed server IPs is NOT RECOMMENDED.
[Notice]: Please edit your 'conf/network.conf' allowed list to fit your network configuration.
[SQL]: Access denied for user 'ragnarok'@'localhost' (using password: YES)

 

[4144 364]

this error mean you conf file corrupted

probably you using wrong text editor

try use editor what can show BOM char and also try not use windows end lines.

in other words get original file and edit it with safe editor.

 

[Dastgir 1246]

Check the error in console. 

[Error]: conf/global/sql_connection.conf:1 - syntax error. 

 

Post your sql_connection with user/password removed, or check syntax yourself. Might be missing something, or unknown symbols somewhere.

 

 

 

 

 

 

 

[Vermithore 0]

Hi @Dastgir,

 

I already posted my sql_connection.conf on my initial post.

First the first one was auto generated after running mariaDB.bat

 

The second one was after I start troubleshooting and used the one on repository and editing my db info

[Vanberk1 0]

I have the same problem exactly, tried to edit my sql_connection.conf like Vermithore did and nothingI have the same problem exactly, tried to edit my sql_connection.conf like Vermithore did and nothing

 

 

Here is my file and login-server console

[Vanberk1 0]

Thanks you!! That fix the problem