Search found 22 matches

by Rhythmatic
Sat Apr 09, 2011 10:10 am
Forum: Minecraft
Topic: Minecraft, MySQL, and plugins - Could not create connection
Replies: 6
Views: 6316

Re: Minecraft, MySQL, and plugins - Could not create connect

Right. That makes sense. I think the big, scary red text just got my blood boiling, cause that should have been obvious. I just tried adding a table, and it worked. :\ Are there any queries that I can try in the MySQL CLI client that could simulate what the plugins are trying to do? Perhaps narrow d...
by Rhythmatic
Sat Apr 09, 2011 10:03 am
Forum: Minecraft
Topic: Minecraft, MySQL, and plugins - Could not create connection
Replies: 6
Views: 6316

Re: Minecraft, MySQL, and plugins - Could not create connect

I just logged in (for the third time) with the "minecraft" username and noticed that it says "Create new database: NO PRIVILEGES". What the hell? I thought I gave it privs. What do I need to do to fix this?
by Rhythmatic
Sat Apr 09, 2011 8:20 am
Forum: Minecraft
Topic: Minecraft, MySQL, and plugins - Could not create connection
Replies: 6
Views: 6316

Re: Minecraft, MySQL, and plugins - Could not create connect

Also, this. # Netstats Error Log CraftBukkit Version: git-Bukkit-0.0.0-612-g4c7a9e7-b617jnks (MC: 1.4) Netstats Version: b3.9.1 MySQL Error: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure Last packet sent to the server was 0 ms ago. Offending Statement: UPDATE n...
by Rhythmatic
Sat Apr 09, 2011 8:18 am
Forum: Minecraft
Topic: Minecraft, MySQL, and plugins - Could not create connection
Replies: 6
Views: 6316

Minecraft, MySQL, and plugins - Could not create connection

I have a minecraft server that is running Recommended Build #617 of CraftBukkit . We have a ton of plugins installed already, but there are a few more that I need to add to wrap everything up. These three ( iConomy , BigBrother , and NetStats ) all require a database, with two of the three requiring...
by Rhythmatic
Wed Apr 06, 2011 10:58 am
Forum: Dedicated servers and Virtual Dedicated Servers
Topic: [phpBB] Host is not allowed to connect to this MySQL server
Replies: 8
Views: 2448

Re: [phpBB] Host is not allowed to connect to this MySQL ser

Erm. Nevermind. I know how to reset the password. Give me a few minutes and then I'll try your suggestion.
by Rhythmatic
Wed Apr 06, 2011 10:57 am
Forum: Dedicated servers and Virtual Dedicated Servers
Topic: [phpBB] Host is not allowed to connect to this MySQL server
Replies: 8
Views: 2448

Re: [phpBB] Host is not allowed to connect to this MySQL ser

You're going to love this. Earlier, when I put a password on the root MySQL account, I followed my normal pattern of opening a text editor and typing out a random combination of lowercase, uppercase, numbers, and symbols, at least 8 characters long. One of those was a '('. It keeps saying "synt...
by Rhythmatic
Wed Apr 06, 2011 10:47 am
Forum: Dedicated servers and Virtual Dedicated Servers
Topic: [phpBB] Host is not allowed to connect to this MySQL server
Replies: 8
Views: 2448

Re: [phpBB] Host is not allowed to connect to this MySQL ser

Oh, and what particular this and that should I do to make that other account and how do I set the security parameters so that it's more secure, as you mentioned?
by Rhythmatic
Wed Apr 06, 2011 10:43 am
Forum: Dedicated servers and Virtual Dedicated Servers
Topic: [phpBB] Host is not allowed to connect to this MySQL server
Replies: 8
Views: 2448

Re: [phpBB] Host is not allowed to connect to this MySQL ser

Ah, good call. I had tried using 127.0.0.1, as it's generally considered to be the same as "localhost" and it always gave a weird answer, indicating that the daemon wasn't even running on that address. Now I get the following: Could not connect to the database, see error message below. Unk...
by Rhythmatic
Wed Apr 06, 2011 10:04 am
Forum: Dedicated servers and Virtual Dedicated Servers
Topic: [phpBB] Host is not allowed to connect to this MySQL server
Replies: 8
Views: 2448

[phpBB] Host is not allowed to connect to this MySQL server

First off, system specs and such. Ubuntu server 10.10 x86_64 2 GB RAM / Dual Core unmanaged VDS MySQL, PHP5, Apache2 all installed using Ubuntu's "tasksel" option for a "LAMP server". phpBB downloaded from phpbb.com TODAY. Version is 3.0.8, as far as I know. Here's what I'm tryi...
by Rhythmatic
Thu Feb 24, 2011 11:51 am
Forum: Dedicated servers and Virtual Dedicated Servers
Topic: Automatic login to TTY1 on Ubuntu 10.10
Replies: 19
Views: 4319

Re: Automatic login to TTY1 on Ubuntu 10.10

I thought I WAS running it in a screen. What would you change?
by Rhythmatic
Thu Feb 24, 2011 6:16 am
Forum: Dedicated servers and Virtual Dedicated Servers
Topic: Automatic login to TTY1 on Ubuntu 10.10
Replies: 19
Views: 4319

Re: Automatic login to TTY1 on Ubuntu 10.10

I can't seem to be able to connect to the server. I'm using the same java arguments as I usually do, and the command "free -m" indicates that about 650MB more than usual are being used, but it's still no use.

Thoughts?
by Rhythmatic
Thu Feb 24, 2011 5:39 am
Forum: Dedicated servers and Virtual Dedicated Servers
Topic: Automatic login to TTY1 on Ubuntu 10.10
Replies: 19
Views: 4319

Re: Automatic login to TTY1 on Ubuntu 10.10

Found a typo. Here's the correct one. I left out the "sh". Also, I'm not sure how to edit posts. :oops: #!/bin/sh -e # # rc.local # # This script is executed at the end of each multiuser runlevel. # Make sure that the script will "exit 0" on success or any other # value on error....
by Rhythmatic
Thu Feb 24, 2011 5:32 am
Forum: Dedicated servers and Virtual Dedicated Servers
Topic: Automatic login to TTY1 on Ubuntu 10.10
Replies: 19
Views: 4319

Re: Automatic login to TTY1 on Ubuntu 10.10

I'd appreciate constructive critique, if you don't mind. Main Script Starts the server, and backs up and restores the map in the event of a hardware crash. #!/bin/sh ##Script for rc.local to be run at VDS start. ##Starts server in a screen, restores most recent ##backup, and makes a backup when shut...
by Rhythmatic
Thu Feb 24, 2011 4:22 am
Forum: Dedicated servers and Virtual Dedicated Servers
Topic: Automatic login to TTY1 on Ubuntu 10.10
Replies: 19
Views: 4319

Re: Automatic login to TTY1 on Ubuntu 10.10

Thanks. That helped. I'm writing up my Minecraft server backup, restore, and restart scripts. I'll post them up for the benefit of the community once I finish them.