• 0
Sign in to follow this  
Followers 0
reignofdave

Database error.

Question

I am having issues with connecting to a database.  Here is the log.

 

[11:11:34:493548 +11:00] [Thread 71956] extDB2: Input from Server: 9:VERSION
[11:11:34:493548 +11:00] [Thread 71956] extDB2: Output to Server: 65
[11:11:34:493548 +11:00] [Thread 71956] extDB2: Input from Server: 9:ADD_DATABASE:exile
[11:11:34:493548 +11:00] [Thread 71956] extDB2: Database Type: MySQL
[11:11:35:736619 +11:00] [Thread 71956] extDB2: Database Exception Error: Connection attempt failed: Access denied for user 'armadbuser'@'103.231.91.80' (using password: YES)
[11:11:35:742619 +11:00] [Thread 71956] extDB2: Output to Server: [0,"Database Exception Error"]
[11:11:35:742619 +11:00] [Thread 71956] extDB2: Input from Server: 9:SHUTDOWN
[11:11:35:742619 +11:00] [Thread 71956] extDB2: Sending Shutdown to Armaserver
[11:11:35:769621 +11:00] [Thread 71956] extDB2: Stopping ...
 

I have tested that the database info is correct via my personal website.

Share this post


Link to post
Share on other sites

7 answers to this question

  • 1

The error is clearly stated:

Database Exception Error: Connection attempt failed: Access denied for user 'armadbuser'@'103.231.91.80' (using password: YES)

Double check if armadbuser is allowed to connect via 127.0.0.1 and localhost or from servers ip if it is external

Share this post


Link to post
Share on other sites
  • 0
On 11/25/2015, 6:20:27, Flow said:

The error

Hey :) I have similar problem now while updating to 0.9.4, its little more complicated because info in log is very limited :(  :

Message: Torndeco: 20/02/15 


extDB2: Found extdb-conf.ini 
extDB2: Detected 12 Cores, Setting up 6 Worker Threads 


[13:00:09:653389 +02:00] [Thread 18044] extDB2: Input from Server: 9:VERSION 
[13:00:09:653389 +02:00] [Thread 18044] extDB2: Output to Server: 65 
[13:00:09:655389 +02:00] [Thread 18044] extDB2: Input from Server: 9:SHUTDOWN 
[13:00:09:655389 +02:00] [Thread 18044] extDB2: Sending Shutdown to Armaserver 
[13:00:09:656389 +02:00] [Thread 18044] extDB2: Stopping ... 

 

This is basically all i got, any chance you could help out here please? 

Share this post


Link to post
Share on other sites
Advertisement
  • 0

This log is useless. No idea without more information. Did you update database layout and extdb?

Share this post


Link to post
Share on other sites
  • 0

Yeah, i updated everything crrectly, it works on my test server (i updated db myself here) but when i upload the files to the live server i cant join in. No info in the RPT really, and yeah as you said i did think the same this log is useless as well... My host have enabled instalation of 5.6 version after i asked them, so it was pretty much just uninstall mySQL 5.5 and install the next one down 5.6 seemed nice through all the process. I have updated the extDB dll, and i added config.ini content from the fix(addition?) on website :) Thanks for taking your time to help with this!!

Share this post


Link to post
Share on other sites
  • 0

Hahaha! im trying to remove tables and drop sql query from update in, but having problems to delete tables account and clan. In Navicat its an error :

1217 - Cannot delete or update a parent row: a foreign key constrains fails

 

When i try to delete them 2 tables through the CP of my server, it says :

Unable to lubricate table !! xD

Share this post


Link to post
Share on other sites
  • 0

@[OMG]Slim 

[13:00:09:653389 +02:00] [Thread 18044] extDB2: Input from Server: 9:VERSION 

[13:00:09:653389 +02:00] [Thread 18044] extDB2: Output to Server: 65 

Should be version 69 I believe. Did you update your extdb-conf.ini to the one from the Lime release?

Share this post


Link to post
Share on other sites
  • 0

Yes i did :) And sorry guys i didnt notice that this was last one today that has been logged.(maybe i shouldnt be going to bed at 6amxD) I belive that at that time i have just copied the config.ini into the server... I think it is gonna be some sort of problem with the host, maybe something gone wrong while changing versions, and db works just doesnt allow to join or something. Im just about to get in touch with them, theyll check that up :)

Thanks for helps , and sorry for wasting your time!

Share this post


Link to post
Share on other sites
Advertisement

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0

  • Recently Browsing   0 members

    No registered users viewing this page.