Jump to content
  • 0
Vermithore

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

Question

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)

 

Share this post


Link to post
Share on other sites

4 answers to this question

Recommended Posts

  • 1

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.

 

Share this post


Link to post
Share on other sites
  • 0

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.

 

 

 

 

 

 

 

Share this post


Link to post
Share on other sites
  • 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

Share this post


Link to post
Share on other sites
  • 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

sql_connection.PNG

login_server.PNG

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.