[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

    My BukkitDev Profile
    My Plugins (5)
    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
  2. Offline

    fffizzz

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
    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

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
    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

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
    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)
     
  5. Offline

    fffizzz

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
    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.
     
  6. Offline

    croemmich

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
    hmm.. I'll look into the for you. I didn't really test the db stuff... just kind of assumed it would work [​IMG]
     
  7. Offline

    marcus

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
    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 ._.
     
  8. Offline

    croemmich

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
    Code (Text):
    1. ln -s /your/mincraft/directory/OnlineUsers/online_users.txt /var/www/online_users.txt
     
  9. Offline

    marcus

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
    That only moves the txt file, then the plugin says it cant find the txt file.
     
  10. Offline

    croemmich

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
    That shouldn't move/alter the text file... are you sure you did ln -s?
     
  11. Offline

    marcus

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
    heh sorry, works now. Thanks!
     
  12. Offline

    Huene

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
    Is there an option to allow you to output just a comma delimited list of usernames? If not I'd like to request it.
     
  13. Offline

    marcus

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
    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
     
  14. Offline

    croemmich

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
    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 (Text):
    1. #beginusers
    2. {username},
    3. #endusers
    --- merged: Jan 18, 2011 9:07 PM ---
    Check the file permissions.
    Code (Text):
    1. chmod 755 /your/mincraft/directory/OnlineUsers/online_users.txt
    Also check that the parent directories are readable by the www user.
     
  15. Offline

    marcus

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
    how do i do that? :)
     
  16. Offline

    croemmich

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
    This should work for you...

    Code (Text):
    1. chmod -R 755 /your/mincraft/directory/
     
  17. Offline

    marcus

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
  18. Offline

    croemmich

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
    Sorry, I don't know what to tell you. I'm pretty sure it is a permission issue however.
     
  19. Offline

    fffizzz

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
    Nothing answers on port 80 on that IP. You sure you even have a webserver running? Thats beyond the scope of help here however.
     
  20. Offline

    marcus

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
    I can access the other files.
     
  21. Offline

    fffizzz

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
    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.
     
  22. Offline

    marcus

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
    i dont get it o_o pwd post path? wat?
     
  23. Offline

    fffizzz

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
    Ya, im gonna go ahead an bow out now. Sorry its not working for you.
     
  24. Offline

    croemmich

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
    Try this. You should at least see the file, no matter the file permissions.

    Code (Text):
    1. cd /your/minecraft/path/OnlineUsers
    2. 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 (Text):
    1. ls -al /var/www
     
  25. Offline

    AtomicAcidbath

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
    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 (Text):
    1.  
    2. 2011-01-19 18:53:06 [SEVERE] OnlineUsers: No suitable driver found for jdbc:mysql://db1:3306/mcs_2114t
    3. 2011-01-19 18:53:06 [SEVERE] Could not connect to the database. Check your credentials in online-users.settings
    4. 2011-01-19 18:53:06 [SEVERE] OnlineUsers: null
    5. 2011-01-19 18:53:06 [SEVERE] OnlineUsers: Could not init the datasource
    6. 2011-01-19 18:53:06 [SEVERE] OnlineUsers: No suitable driver found for jdbc:mysql://db1:3306/mcs_2114t
    7. 2011-01-19 18:53:06 [SEVERE] Could not connect to the database. Check your credentials in online-users.settings
    8. 2011-01-19 18:53:06 [SEVERE] OnlineUsers: null
    9. 2011-01-19 18:53:06 [SEVERE] OnlineUsers: could not execute the sql "UPDATE `users_online` SET `online`=0"
    10. 2011-01-19 18:53:06 [SEVERE] OnlineUsers: No suitable driver found for jdbc:mysql://db1:3306/mcs_2114t
    11. 2011-01-19 18:53:06 [SEVERE] Could not connect to the database. Check your credentials in online-users.settings
    12. 2011-01-19 18:53:06 [SEVERE] OnlineUsers: null
    13. 2011-01-19 18:53:06 [SEVERE] OnlineUsers: could not execute the sql "TRUNCATE `users_online`"
    14. 2011-01-19 18:53:06 [INFO] OnlineUsers 1.4 disabled
    15.  
     
  26. Offline

    fffizzz

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME

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

    AtomicAcidbath

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
    Yup! Fixed 'er right up. An odd way of doing things, but it works.
    Thanks!
     
  28. Offline

    marcus

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
    it says online_users.txt -> /minecraft/path/OnlineUsers/online_users.txt
     
  29. Offline

    atomicben

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
    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. =(
     
  30. Offline

    shadrxninga

    My BukkitDev Profile
    My Plugins (0)
    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
    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
     

Share This Page