[Alpha] [GM] VenuX: Roleplay

[qaisjp]

resource.* 

ffs viewtopic.php?f=5&t=39055

That wasn't an issue because of that, it was a security leak within Multi Theft Auto and it's resource itself.

[Ascla]

Hello,

I have a problem with the connection to MYSQL.

I enter this in the file "mysql" folder "sql"

  
local server = get( "localhost" ) or "" -- server 
local user = get( "root" ) or "" -- username 
local password = get( "" ) or "" -- password 
local db = get( "unix" ) or "" -- database 
local port = get( "" ) or 3306 
local socket = get( "" ) or nil 

But when I run the server, I have these errors

http://pastebin.com/xE8SUCE9

PS: Sorry if there are mistakes, I'm French

[jeremaniak]

Neither of this whole recources work please help me

[Xeno]

Have you set it up with mySQL?

[AeroXbird]

I'll soon be accepting a few people to commit and work on the project together with me.

Feel free to PM me if you're interested.

[jeremaniak]

Someone help me when i use this scripts and i registered then i try to login but it says in the console this:

• [2012-02-29 10:43:22] ERROR: attempt to call a nil value
  [2012-02-29 10:43:22] ERROR: call: failed to call 'sql:escape_string' [string "?"]
  [2012-02-29 10:43:22] ERROR: account\s_account.lua:53: attempt to concatenate a boolean value

[jeremaniak]

Hello,

I have a problem with the connection to MYSQL.

I enter this in the file "mysql" folder "sql"

  
local server = get( "localhost" ) or "" -- server 
local user = get( "root" ) or "" -- username 
local password = get( "" ) or "" -- password 
local db = get( "unix" ) or "" -- database 
local port = get( "" ) or 3306 
local socket = get( "" ) or nil 

But when I run the server, I have these errors

http://pastebin.com/xE8SUCE9

PS: Sorry if there are mistakes, I'm French

You should do this:

  
local server = get "localhost" 
local user = get "root"  
local password = get "" -- leave blank like this 
local db = get "mta" -- database name like when you name your database mta call it mta 
local port = get 3306 
local socket = get nil 

[Ascla]

Sorry for my late response.

I tried what you said but I always make the same mistakes.

Yes I use mySQL with wamp

[AeroXbird]

What jeremaniak said is incorrect, it's close though.

  
local server = "" -- server 
local user =  "" -- username 
local password = "" -- password 
local db =  "" -- database 
local port =  3306 
local socket =  nil 
  

Then you simply enter the credentials from your MySQL server, and you're all set.

[Wan_Lee]

Really cool project.

I'm intrested in using this for my server, as we all know Valhalla is outdated/unstable. I just need a basemode to do the rest myself ( I'm not that a good scripter at server-side scripts yet ).

I only have one issue, i installed modules, putted them in mtaserver.conf ( Everything is good cause i used to work with servers and SQL before. ) When i do login it says the warning but when i register It does nothing.. It gives only one warning:

[2012-03-10 16:11:45] ERROR: exports: Call to non-running server resource (sql) [string "?"]

How can i help this?

Greetings,

Wan Lee

My config: ( Without passwords and stuff ofcourse )

    local server = get( "server" ) or "IP IS HERE" 
    local user = get( "user" ) or "MY DATABASE NAME HERE" 
    local password = get( "password" ) or "MY PASS HERE" 
    local db = get( "database" ) or "MY DATABASE TAB HERE" 
    local port = get( "port" ) or 3306 
    local socket = get( "socket" ) or nil 

[AeroXbird]

Really cool project.

I'm intrested in using this for my server, as we all know Valhalla is outdated/unstable. I just need a basemode to do the rest myself ( I'm not that a good scripter at server-side scripts yet ).

I only have one issue, i installed modules, putted them in mtaserver.conf ( Everything is good cause i used to work with servers and SQL before. ) When i do login it says the warning but when i register It does nothing.. It gives only one warning:

[2012-03-10 16:11:45] ERROR: exports: Call to non-running server resource (sql) [string "?"]

How can i help this?

Greetings,

Wan Lee

My config: ( Without passwords and stuff ofcourse )

    local server = get( "server" ) or "IP IS HERE" 
    local user = get( "user" ) or "MY DATABASE NAME HERE" 
    local password = get( "password" ) or "MY PASS HERE" 
    local db = get( "database" ) or "MY DATABASE TAB HERE" 
    local port = get( "port" ) or 3306 
    local socket = get( "socket" ) or nil 

Its good to hear you like the project.

The error states that the SQL resource is not running meaning it either failed to load the module, connect to the mysql server or to select the database.

Check if your MySQL server is running, check your credentials, check if the database is correct.

Otherwise, if you happen to be running Linux you might be experiencing one of these two issues:

The .sock file for MySQL is not where mta-mysql thinks it is, use this command to fix it:

 ln -s /var/run/mysqld/mysqld.sock /tmp/mysql.sock 

If that still does not fix your issue, it could be that your are missing libmysqlclient.so.15

follow this tutorial to install this file on your Linux system.

[Wan_Lee]

These are the needed modules, right?

"ml_sockets.so"/> 
"mta_mysql.so"/> 
"sha.so"/> 

[Wan_Lee]

Really cool project.

I'm intrested in using this for my server, as we all know Valhalla is outdated/unstable. I just need a basemode to do the rest myself ( I'm not that a good scripter at server-side scripts yet ).

I only have one issue, i installed modules, putted them in mtaserver.conf ( Everything is good cause i used to work with servers and SQL before. ) When i do login it says the warning but when i register It does nothing.. It gives only one warning:

[2012-03-10 16:11:45] ERROR: exports: Call to non-running server resource (sql) [string "?"]

How can i help this?

Greetings,

Wan Lee

My config: ( Without passwords and stuff ofcourse )

    local server = get( "server" ) or "IP IS HERE" 
    local user = get( "user" ) or "MY DATABASE NAME HERE" 
    local password = get( "password" ) or "MY PASS HERE" 
    local db = get( "database" ) or "MY DATABASE TAB HERE" 
    local port = get( "port" ) or 3306 
    local socket = get( "socket" ) or nil 

Its good to hear you like the project.

The error states that the SQL resource is not running meaning it either failed to load the module, connect to the mysql server or to select the database.

Check if your MySQL server is running, check your credentials, check if the database is correct.

Otherwise, if you happen to be running Linux you might be experiencing one of these two issues:

The .sock file for MySQL is not where mta-mysql thinks it is, use this command to fix it:

 ln -s /var/run/mysqld/mysqld.sock /tmp/mysql.sock 

If that still does not fix your issue, it could be that your are missing libmysqlclient.so.15

follow this tutorial to install this file on your Linux system.

I think i'm missing the good ACL.xml, can you send me the good one?

[AeroXbird]

I think i'm missing the good ACL.xml, can you send me the good one?

That is very possible.

replace the admin group part in the admin acl with this:

  
    <group name="Admin"> 
        <acl name="Moderator"></acl> 
        <acl name="SuperModerator"></acl> 
        <acl name="Admin"></acl> 
        <acl name="RPC"></acl> 
        <object name="resource.admin"></object> 
        <object name="resource.webadmin"></object> 
        <object name="resource.admin2"></object> 
        <object name="resource.account"></object> 
        <object name="resource.sql"></object> 
    </group> 
  

[Wan_Lee]

Still.. still.. the string bug at sql, i had this before on another resource but don't know how i fixed it that time..

[AeroXbird]

Still.. still.. the string bug at sql, i had this before on another resource but don't know how i fixed it that time..

It is missing something, if you get the error that sql is not running, it is either because it has no ACL rights, the credentials are incorrect or the mta-mysql module is not loaded which means there is something wrong with either the module or its dependencies.

are you running windows or linux?

[Wan_Lee]

Still.. still.. the string bug at sql, i had this before on another resource but don't know how i fixed it that time..

It is missing something, if you get the error that sql is not running, it is either because it has no ACL rights, the credentials are incorrect or the mta-mysql module is not loaded which means there is something wrong with either the module or its dependencies.

are you running windows or linux?

Linux, but it worked before, with vG. The modules are startred, uhm.. I don't know what the problem is. It's hosted by ServerFFS. I think there's still something with the ACL, so i'm checking that now..

[abu5lf]

I have a problem when I run the resource

WARNING: sql\mysql.lua:55: Access denied @ 'shutdown'

[Castillo]

Add the resource "sql" to "acl.xml" group "Admin".

[abu5lf]

We have already added, but did not work

[|GTAZ|home]

any update on whats going on if people have figure out how to get it to work and when the next release is gonna be ?

[Subtixx]

nothing new? Please Post newer Screens!!! I Love your Project!

[qaisjp]

I comitted soomething.

[digigir]

Where i put "mysql.sql"? sorry im stupid

[qaisjp]

Execute it.