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

Discussion in 'Archived: Plugin Releases' started by Brettflan, Jan 17, 2011.

  1. Offline

    Brettflan

  2. Offline

    fffizzz

    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!
     
  3. Offline

    croemmich

    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...
     
  4. Offline

    fffizzz

    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.
     
    Last edited by a moderator: May 6, 2016
  5. Offline

    croemmich

    hmm.. I'll look into the for you. I didn't really test the db stuff... just kind of assumed it would work [​IMG]
     
  6. Offline

    marcus

    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 ._.
     
  7. Offline

    croemmich

    Code:
    ln -s /your/mincraft/directory/OnlineUsers/online_users.txt /var/www/online_users.txt
     
  8. Offline

    marcus

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

    croemmich

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

    marcus

    heh sorry, works now. Thanks!
     
  11. Offline

    Huene

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

    marcus

    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
     
  13. Offline

    croemmich

    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.
     
  14. Offline

    marcus

    how do i do that? :)
     
  15. Offline

    croemmich

    This should work for you...

    Code:
    chmod -R 755 /your/mincraft/directory/
     
  16. Offline

    marcus

  17. Offline

    croemmich

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

    fffizzz

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

    marcus

    I can access the other files.
     
  20. Offline

    fffizzz

    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.
     
  21. Offline

    marcus

    i dont get it o_o pwd post path? wat?
     
  22. Offline

    fffizzz

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

    croemmich

    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
     
  24. Offline

    AtomicAcidbath

    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
    
     
  25. Offline

    fffizzz


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

    AtomicAcidbath

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

    marcus

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

    user_2408

    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. =(
     
  29. Offline

    shadrxninga

    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
     
  30. Offline

    fffizzz

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

Share This Page