[INFO] OnlineUsers 1.7.0 - logged users in a file/mysql [BukkitDev]

OnlineUsers is on BukkitDev

 

you are the man! thanks a bundle

My only feature request is the option for players group in the mysql table
thanks, and rock on!

 

I'll consider adding that. The lack of built in group support is what is holding me off. I could show users/ops right now I guess...

 

Using build 79 of CB, I see the plugin load, but it wont actually post anything to the DB till i /enable OnlineUsers in game (this is a command from general plugin, fyi)

Also, it appears to stop sending updates to the DB, or the plugin stops after a bit. Ill search through the logs to see if i can find anything helpful.

This is my settings.

I downloaded latest mysql-java file from site, ill test that out. I did notice this,
2011-01-17 20:38:32 [SEVERE] OnlineUsers: No suitable driver found for jdbc:mysql://localhost:3306/mcraft_mybb

But, when I enable from in game, it works fine which i dont understand.

Thanks again for porting this.

EDIT by Moderator: merged posts, please use the edit button instead of double posting.

 

hmm.. I'll look into the for you. I didn't really test the db stuff... just kind of assumed it would work

 

Hey, how do i do if i want the flatfile, online-players.txt to be generated in my www folder? if i do /var/www/ it wont work, since it thinks its where the plugin is ._.

 

Code:

ln -s /your/mincraft/directory/OnlineUsers/online_users.txt /var/www/online_users.txt

 

That only moves the txt file, then the plugin says it cant find the txt file.

 

That shouldn't move/alter the text file... are you sure you did ln -s?

 

heh sorry, works now. Thanks!

 

Is there an option to allow you to output just a comma delimited list of usernames? If not I'd like to request it.

 

Ugh! sorry again, but it seems like i cant acess the txt file trough my website now, even tho its linked in my www folder :S

 

Just put this in the template file. You will have to strip line breaks, as they are added automatically. I may be able to change that functionality if you can't strip the breaks.

Code:

#beginusers
{username},
#endusers

--- merged: Jan 18, 2011 9:07 PM ---

Check the file permissions.

Code:

chmod 755 /your/mincraft/directory/OnlineUsers/online_users.txt

Also check that the parent directories are readable by the www user.

 

how do i do that?

 

This should work for you...

Code:

chmod -R 755 /your/mincraft/directory/

 

http://74.63.229.33/online-users.txt
nope

 

Sorry, I don't know what to tell you. I'm pretty sure it is a permission issue however.

 

Nothing answers on port 80 on that IP. You sure you even have a webserver running? Thats beyond the scope of help here however.

 

I can access the other files.

 

http://74.63.229.33/

The users file is not present here... which would be a good reason its not showing up.
So, do this..
goto that folder in your console (im assuming you ssh to your server?) and do pwd, post path
then post settings for onlineusers.settings.

Looks like the symlink he was trying to help you with didnt get created.

 

i dont get it o_o pwd post path? wat?

 

Ya, im gonna go ahead an bow out now. Sorry its not working for you.

 

Try this. You should at least see the file, no matter the file permissions.

Code:

cd /your/minecraft/path/OnlineUsers
ln -s online_users.txt /var/www/online_users.txt

After doing that, try this. It will show the link if it was created properly.

Code:

ls -al /var/www

 

The plugin doesn't seem to be logging to MySQL. No errors on console or in the log. Just no data is being saved to the MySQL table.
JDBC driver used is the one linked in first post.
Database/Table permissions correct. (BigBrother is logging events to MySQL)

Edit:
Dropped the table to have plugin recreate it, and now:

Code:

2011-01-19 18:53:06 [SEVERE] OnlineUsers: No suitable driver found for jdbc:mysql://db1:3306/mcs_2114t
2011-01-19 18:53:06 [SEVERE] Could not connect to the database. Check your credentials in online-users.settings
2011-01-19 18:53:06 [SEVERE] OnlineUsers: null
2011-01-19 18:53:06 [SEVERE] OnlineUsers: Could not init the datasource
2011-01-19 18:53:06 [SEVERE] OnlineUsers: No suitable driver found for jdbc:mysql://db1:3306/mcs_2114t
2011-01-19 18:53:06 [SEVERE] Could not connect to the database. Check your credentials in online-users.settings
2011-01-19 18:53:06 [SEVERE] OnlineUsers: null
2011-01-19 18:53:06 [SEVERE] OnlineUsers: could not execute the sql "UPDATE `users_online` SET `online`=0"
2011-01-19 18:53:06 [SEVERE] OnlineUsers: No suitable driver found for jdbc:mysql://db1:3306/mcs_2114t
2011-01-19 18:53:06 [SEVERE] Could not connect to the database. Check your credentials in online-users.settings
2011-01-19 18:53:06 [SEVERE] OnlineUsers: null
2011-01-19 18:53:06 [SEVERE] OnlineUsers: could not execute the sql "TRUNCATE `users_online`"
2011-01-19 18:53:06 [INFO] OnlineUsers 1.4 disabled

 

I get the same thing, but if you use General, /enable OnlineUsers while in game and it starts working

 

Yup! Fixed 'er right up. An odd way of doing things, but it works.
Thanks!

 

it says online_users.txt -> /minecraft/path/OnlineUsers/online_users.txt

 

Awesome plugin! I'm using MySQL currently with it, but I have a feeling something may have broken with CB b107. Updates to the table seem to have stopped. =(

 

Can this write to an external database? How would I do that?

jdbc\:mysql\://localhost\:3306/minecraft
by removing the jdbc?
mysql\://<IP of Database>\:3306/minecraft

 

Just change "localhost" to the iP of your MySQL server. keep the rest of the line intact.