Jump to content
  • 0

Mysql Problem ( My mysql will not connect maybe simple prob)


GrimTheXReaperrr

Question

This is the error i get when i start my server but yet

libmysql.dll is in the server folder also in the modules

mta_mysql.dll is in my modules folder

and for my config i put the right info check here

<!-- This parameter specifies the name the server will be visible as in the ingame server browser  
         and on Game-Monitor. It is a required parameter. --> 
    <servername>My Server Name HERE</servername> 

<!-- Specifies the module(s) which are loaded with the server. To load several modules, add more <module> 
         parameter(s). Optional parameter. --> 
    <!-- <module src="sample_win32.dll"/> --> 
    <!-- <module src="sample_linux.so"/> --> 
           <module src="mta_mysql.dll" /> 
           <module src="libmysql.dll" /> 

and For my mysql file in resources i put this i will leave some unedited but all scripting is correct

This is the mysql connection LUA file i'll just post my info then next i'll post the other LUA file and btw meta is correct too

i retyped my real info thats why it says blah blah HERE but all is correct

-- connection settings 
local hostname = get( "hostname" ) or "mysql.vortexservers.com" 
local username = get( "username" ) or "MYUSERNAMEHERE" 
local password = get( "password" ) or "MYPASSWORDHERE" 
local database = get( "database" ) or "MYDATEBASENAMEHERE " 
local port = tonumber( get( "port" ) ) or 3306 

Now for the other one

username = get( "username" ) or "IputMyUserNameHere" 
password = get( "password" ) or "IputMYPasswordHERE" 
db = get( "database" ) or "MYDATABASEHERE" 
host = get( "hostname" ) or "mysql.vortexservers.com" 
port = tonumber( get( "port" ) ) or 3306 

see everything looks right !!! Right ?

Then now watch my server errror i get when i try and turn it on

[2013-06-23 20:56:20] Querying game-monitor.com master server... failed! (302: Moved temporarily)

[2013-06-23 20:56:20] Querying backup master server... success!

[2013-06-23 20:56:21] MODULE: Unable to find modules/mta_mysql.dll!

[2013-06-23 20:56:21] MODULE: Unable to find modules/libmysql.dll!

[2013-06-23 20:56:21] Starting resources...

[2013-06-23 20:56:21] ERROR: mysql\connection.lua:16: attempt to call global 'mysql_connect' (a nil value)

[2013-06-23 20:56:21] ERROR: mysql\connection.lua:65: attempt to call global 'mysql_ping' (a nil value)

and a bunch of other mysql connection errors which are only coming from it not being connected too

so my question is how do i fix this is there something simple i'm missing or what ?

sometimes when it trys to pick up those DLL it will say Unable to load libmysql.dll but yet pick up the mta_mysql now its saying unable to find anyone can help me with this ? and i just spent 6 bucks on a host thinking it was something just on my PC not being right

And here are my pics showing the folders the DLL's are in

qyhbv7.png

now the other pic

2jdpc1g.png

Link to comment

1 answer to this question

Recommended Posts

  • 0

Never Mind All My Info Was Correct Found Out Since I'm On My Labtop With Windows 7 I Had To Hold down the FN key and then press enter to get into my account structure and theres me thinking i'm having a problem and that was it

But i'll leave this up for anyone who needs help with knowing where to put the DLL's and how to put the formats of text in the mysql and settings hope this helps someone !!!!!!!

( Jesus Christ is Lord and Savior)

( Lock Thread Or Delete)

Link to comment

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
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...