Server Help :: View topic - Underlords duelsql.dll

Server Help

Bot Questions - Underlords duelsql.dll

freakmonger - Wed Oct 26, 2005 1:24 am
Post subject: Underlords duelsql.dll

Ok im at my wits end here.

The bot/plugin connects to the db fine. But when I do !history freakmonger after being killed afew times I get nothing. I do !top 4 or whatever and get nothing. Then I look at the db and the bot isnt writing anything to the tables...any ideas?

thanks

Dr Brain - Wed Oct 26, 2005 9:49 am
Post subject:

I've never worked with that plugin, so I'm running blind here:

Check that the SQL account you gave to the bot has full access to the table you created.

Double check the bot's config, make sure things are correct.

Check the bot's log and the mysql log.

Maverick - Wed Oct 26, 2005 11:57 am
Post subject:

hmm lemme think...
I found the bug for this bot when DS tried to put it up. It had to do with the bot not receiving *watchdamage messages somehow. (because of that, it didn't execute the updateSQL() method)

When you force the bot to work without it, it will work but not completely. I never found the real bug in the bot, but I do know that is the problem.

I suggested them not to use the bot because it doesn't keep score, but only keeps Wins/Losses over all of the duels played. You should also consider this.

Contempt+ - Wed Oct 26, 2005 2:11 pm
Post subject:

Where can I get the duelsql plugin?

Oh, and Explody's Prize3 plugin, the one that uses the SQL DB, I tried getting it to connect to my sql database, and it said when I started up merv that it couldn't connect. Is there anything else I need to do besides setting up the SQL database?

Maverick - Wed Oct 26, 2005 2:25 pm
Post subject:

Contempt+, make sure you have filled in the values in prize.ini (database settings) and they are correct.

Cyan~Fire - Wed Oct 26, 2005 4:13 pm
Post subject:

Sounds like a job for... ASSS!

Contempt+ - Wed Oct 26, 2005 6:30 pm
Post subject:

Mav, I did that. I'm not running the SQL database on the server that's hosting MERV. I'm using the SQL database on my website, and it's saying that it can't connect still. I've changed a few things, and it still doesn't work.

Anonymous - Wed Oct 26, 2005 8:33 pm
Post subject:

Your webhost might require you to add the IP Address of the server your bot is running on to it's access list. If you have cPanel, go to where you manage your dbs and you should find what I'm talking about.

Contempt+ - Wed Oct 26, 2005 8:38 pm
Post subject:

Did that, Added my IP and the hostname of my ISP, neither worked.

Anonymous - Wed Oct 26, 2005 8:44 pm
Post subject:

You probably have something wrong in your settings somewhere.

Anonymous - Thu Oct 27, 2005 1:07 am
Post subject:

Mav..The *watchdamge works when I had it in my zone. I looked at the server and seen that the bot did the *watchdamge command

Cont..At first I had that problem but once I add'ed so that my IP could access the DB I had no problem then.

Maverick - Thu Oct 27, 2005 5:23 am
Post subject:

Can someone split this topic? Contempt+ hijacked the topic.

Guest, I know the bot does *watchdamage to every player when he/she enters. However, the bot somehow fails to receive the "arena" messages that come from the server when the player receives damage. I am not going to fix this bug, but maybe another coder can help you.

Contempt+, I know for a fact that all websites from twsites.com (or resellers) have extra security software that prevents from programs on your computer to connect to the database even if you have your IP on the access hosts list in CPanel. I suggest to make sure all settings are correct and contact your host about this problem, your IP problably needs to be put on the security software. (You should test trying to get MySQL CC or MySQL-Front to connect to your database from your computer.)
(BTW, remove the screenshot, it shows your IP address)

Solo Ace - Thu Oct 27, 2005 6:12 pm
Post subject:

What kind of security software? Software protecting MySQL from its own authentication system?
MySQL is actually sending the error message, I have no idea what security software you'd mean.

I told him to get MySQL CC already.
MySQL doesn't support MySQL CC anymore, though, you'll have to get it elsewhere.

Maverick - Fri Oct 28, 2005 9:16 am
Post subject:

Solo Ace wrote:

What kind of security software? Software protecting MySQL from its own authentication system?

I don't know, but Im sure they are using it for a reason. I think its just a firewall so not everybody can really try to connect to the mysql server.

Solo Ace wrote:

you'll have to get it elsewhere.

You can still get it from the mysql site (right?).

D1st0rt - Sat Oct 29, 2005 9:14 pm
Post subject:

I like the database client from http://www.jetaware.com/

Solo Ace - Sat Oct 29, 2005 9:20 pm
Post subject:

It sure can't be a firewall in this situation.
As I stated earlier MySQL is actually sending the error message.
This means the client is getting responses from MySQL and so can it can reach the server.

Don't you people think before you post something?

They did allow you to download MySQL CC for a while, but now every link to it redirects you to MySQL Administrator (which sucks).

A mirror still seems to have it, though.

But, for Contempt+ this really is useless now, since the MySQL server won't allow him to connect anyway (he'll get the same error message as his bot does).

I don't know much about cPanel, I just think something went wrong between that and MySQL.
Get your host to figure out what went wrong, and if needed let him manually configure the MySQL access table.

If you can't be bothered, run your own MySQL server.

Contempt+ - Sat Oct 29, 2005 9:48 pm
Post subject:

I think that's what I'm going to end up doing.

Maverick - Sun Oct 30, 2005 5:59 am
Post subject:

Solo Ace wrote:

As I stated earlier MySQL is actually sending the error message.
This means the client is getting responses from MySQL and so can it can reach the server.

Not really, it can be the bot (with the mysql libraries) showing the error just aswell.
All sites of twsites.com are protected by this extra security software and putting your IP at CPanel will only allow you to connect to MySQL but not through the firewall.

Solo Ace - Sun Oct 30, 2005 9:27 am
Post subject:

Yeah, so, the bot with mysql libraries looked its hosts internet hostname up to show an error looking exactly like the one the server would give.
So you think it's giving this error because it can't connect due to a firewall? Wouldn't the error look a bit more like "Can't connect to MySQL server on '<serverip>'"?

This "extra security software" is just a firewall? Why not just call it a firewall then? Of course modifying a cPanel MySQL access configuration won't configure a firewall, it's not what it's supposed to do.

And also, what does twsites.com have to do with this issue? The client can reach the server, which is obvious since the displayed error is coming from the server (you could even connect to it with telnet or nc ("netcat") and see the error). You don't have to keep giving twistes as example.
The client can reach the MySQL server.

So, your "firewall" and "extra security" theories are wrong and useless.

Maverick - Sun Oct 30, 2005 10:04 am
Post subject:

There is no point in discussing this with you.
I have told you what I know and I know the problems with twsites / mysql databases.
Go back to your cave.

D1st0rt - Sun Oct 30, 2005 12:34 pm
Post subject:

http://freesql.org

Solo Ace - Mon Oct 31, 2005 1:47 pm
Post subject:

Obviously there was no point in discussing this, Mav, but you still tried to.
You were just telling me wrong, which I wasn't.

What cave? If anyone of us lives in a cave it'd be you.

Maverick - Mon Oct 31, 2005 3:44 pm
Post subject:

Go ask Dock> if you don't believe me and please keep believing you are correct in some way.

Ignorance

Solo Ace - Mon Oct 31, 2005 4:40 pm
Post subject:

I never said you were wrong about the TW crap, but why do you keep referring to that? It has, obviously, nothing to do with this issue.
You told me wrong about the error message, which was wrong of you.

Contempt+ - Mon Oct 31, 2005 4:51 pm
Post subject:

Ok fellas.

Where can I get the sqlduel plugin?

D1st0rt - Mon Oct 31, 2005 11:40 pm
Post subject:

I access the database on my twsites site through a phpmyadmin component for mambo. Another option you have is that if you can get ssh shell access PuTTy can do port forwarding