[INACTIVE][ADMN] sqlPermissions v0.5b - Change your Permissions via SQL [740]

Discussion in 'Inactive/Unsupported Plugins' started by SvenBrnn, May 6, 2011.

  1. Offline

    SvenBrnn

    sqlPermissions - Change your Permissions via SQL:
    Version: v0.5b

    Projekt not needed Anymore. Permission 3.x has its own SQL permission system.
    So i stop developing this Plugin!


    The Plugin is for Administrating the Groups/Users of Nijikokun and TheYeti Permissions Plugin via MySQL. You can use the Webpage comes with the Plugin or Develop your own Pages using the Database the Plugin brings with.
    The Webpage the plugin brings with uses the Smarty Engine for Templates and a very simpel Black/White template.

    Features:
    • Loads the Permissions file into the DB if it is newer then the DB entrys
    • Writes the DB entrys into the Permission files if they are newer
    • Checks the DB and Files every 5 minutes for changes
    • Web Page uses the Smarty Template engine
    What the Plugin needs:
    Download
    Source Code

    ATTANTION: If you are using permissionPlus. When you change something in DB and after this within 5 minutes via permissionPlus your changes could be lost. I cant do anything against this!

    ATTANTION2: If you use the Website on an Linux System you have to set the cache and template_c directory rights to 777


    Planned:
    • "Nicer" looking webpage ;)
    • "real" sql Permission system as optional (so that no permissions is needed)
    • suggest something (no GroupManager ATM not^^)
    Changelog:

    Changelog (open)

    Version 0.5b
    • Fixed Webpage and Suffix
    Version 0.5
    • Some more Fixes
    Version 0.4
    • Make it Work with permissionPlus
    Version 0.3
    • Fixed an error when Parsing realy big files
    Version 0.2e
    • Changed mysql_real_escape_string to mysql_escape_string to remove PHP errors when Connection has no Password
    Version 0.2d

    • Some more Bugfixes
    Version 0.2c

    • Fixed Bug when World has a quote in its name
    Version 0.2b

    • Fixed Bug when Permissions of Group = null
    Version 0.2

    • Corrected string excaping when Reading the permission configs
    • Removed one Debug on Webpage
    Version 0.1

    • First Release
    Thanks to Nijikokun and TheYeti for the Permissions Plugin
     
    Ambedrake likes this.
  2. Offline

    Ambedrake

    4th reboot on a clean test server with just this plugin, permissions, persistence and nethergate for the multiworlds started spitting this back at me.

    Code:
    2011-05-09 03:01:12 [INFO] [sqlPermissons] Writing Permission file: TheDragon'sDen
    2011-05-09 03:01:12 [SEVERE] null
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'sDen'' at line 1
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
        at java.lang.reflect.Constructor.newInstance(Unknown Source)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
        at com.mysql.jdbc.Util.getInstance(Util.java:382)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
        at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1474)
        at SvenBrnn.sqlPermissions.sqlPermissionsDB.executeQuery(sqlPermissionsDB.java:58)
        at SvenBrnn.sqlPermissions.sqlPermissionsPermisionEditor.loadPermissionsFromDatabase(sqlPermissionsPermisionEditor.java:328)
        at SvenBrnn.sqlPermissions.sqlPermissionsWorker.run(sqlPermissionsWorker.java:72)
    
    Oh if you need me to try anything specific, I am here to help ^_^ --> testing release B


    0.2b Null pointer fixed perfectly now =P
     
  3. Offline

    SvenBrnn

    Do i see right that your World has an " ' " in its name?
    I will look over the code again to see if i have forgot some Quoting.
     
  4. Offline

    Ambedrake

    Understood, the main server has a couple " ' " worlds so I am using this to test the escapes. I am reviewing the source right now as well to see if I can find any hiccups.
     
  5. Offline

    SvenBrnn

    You dont need. It should work now. Its not fine to use quotes in filenames but its ok :).
    Would be nice if cou could test release c.

    Greeting Sven
     
  6. Offline

    Ambedrake

    huh interesting, this is the fresh release C after 2nd reboot (first was to populate the permission files)

    Code:
    2011-05-09 03:21:17 [INFO] [sqlPermissons] Reading Permission file: TheDragon'sDen
    2011-05-09 03:21:18 [SEVERE] null
    java.lang.NullPointerException
        at SvenBrnn.sqlPermissions.sqlPermissionsPermisionEditor.loadPermissionsToDatabase(sqlPermissionsPermisionEditor.java:65)
        at SvenBrnn.sqlPermissions.sqlPermissionsWorker.run(sqlPermissionsWorker.java:64)
    2011-05-09 03:21:18 [INFO] [sqlPermissons] Reading Permission file: Jigoku
    2011-05-09 03:21:19 [SEVERE] null
    java.lang.NullPointerException
        at SvenBrnn.sqlPermissions.sqlPermissionsPermisionEditor.loadPermissionsToDatabase(sqlPermissionsPermisionEditor.java:65)
        at SvenBrnn.sqlPermissions.sqlPermissionsWorker.run(sqlPermissionsWorker.java:64)
    2011-05-09 03:21:19 [INFO] [sqlPermissons] Writing Permission file: nether
    2011-05-09 03:21:19 [INFO] [sqlPermissions] World nether does not exist in db!
    2011-05-09 03:21:19 [INFO] [sqlPermissons] Reloading Permissions!
    2011-05-09 03:21:19 [INFO] [sqlPermissons] Reading Permission file: Ziggarot
    2011-05-09 03:21:19 [SEVERE] null
    java.lang.NullPointerException
        at SvenBrnn.sqlPermissions.sqlPermissionsPermisionEditor.loadPermissionsToDatabase(sqlPermissionsPermisionEditor.java:65)
        at SvenBrnn.sqlPermissions.sqlPermissionsWorker.run(sqlPermissionsWorker.java:64)
    2011-05-09 03:21:19 [INFO] [sqlPermissons] Reading Permission file: AdminLand
    2011-05-09 03:21:20 [SEVERE] null
    java.lang.NullPointerException
        at SvenBrnn.sqlPermissions.sqlPermissionsPermisionEditor.loadPermissionsToDatabase(sqlPermissionsPermisionEditor.java:65)
        at SvenBrnn.sqlPermissions.sqlPermissionsWorker.run(sqlPermissionsWorker.java:64)
    
     
  7. Offline

    SvenBrnn

    Ah i love NullPointerExeptions ^^.
    I think your Users or Groups where Emty. (For some Reason)
    This should be fixed now.
     
  8. Offline

    Ambedrake

    Cool. Will try now.

    Beautiful beautiful, passed runs 2-5. Will report back later if I run into any other tidbits.

    And since its a test server for code purposes only, I didn't think to add users to the perm files. Just added one on run 5 and still ran beautiful.

    Thanks for all the work!
     
  9. Offline

    SvenBrnn

    No Problem.
    I think this evening i will ask someone to make me a nice Layout for the Webpage. Dont know if she says yes and if how long it will take to make me a nice layout.
    If someone is booring and intrested in makeing a layout he/she can make one and send it to me :).

    Greeting Sven
     
  10. Offline

    tanaka141

    on web part mysql_real_escape_string($statement) generate many error because no user/password is set to acced to database
    but data can be acces for the other part of program...
     
  11. Offline

    SvenBrnn

    It should be fixed now.
    Noticed that i used mysql_real_escape_string($statement) instad of mysql_escape_string($statement).
    Should work with the new files.
     
  12. Offline

    Joy

    Getting an error: http://pastie.org/1880782

    This happens on loading the following yml permissions:

    plugin:
    permissions:
    system: default
    copies: world

    Should work right.
     
  13. Offline

    John Kapsis

    Well i was looking into the vb.net support for SQL and as expected is extensive as hell!
    now i know that this web page control IS a lot better then a vb window form cause a web page is supported by all OSs out there BUT i will include your pluging in my gui! tbh mostly cause i must learn to use DBs ;)
    Other then that you have done a great job!!
    I hope you don't mind me including your plugin...

    Note: i am raizing money(personal money and donations) to purchase the tools necessary to have vb.net export app to all OSs but i guess that will take some time...
     
  14. Offline

    SvenBrnn

    Can you Post your world File because the Error is bevor loading the World_Copy (Reading World_copy comes after this error ^^)

    Connecting with .net to a Database shouldn't be a Problem if the Server is configured right (Accept connections from outside). I already did it in C# and it worked fine.
     
  15. Offline

    John Kapsis

    It's not it the problem. it's me ;)
    hehe don't worry about it i will figure it out...
     
  16. Offline

    Joy

    Ahhh that explains, then I spotted a user in the world.yml with a non-existant group :D

    ===

    New issue now, it's actually importing users, and we have quite a lot, running into:

    http://pastie.org/1880926

    I suspect it is taking too long to import them all in one go? Have restarted now to try resume, but I fear this could end up being an issue in further use.

    ===

    It seems to be doing like 10 pages of users per restart right now.

    ===

    It is done importing all users, it still ends up spewing above error, with the mysql process seemingly active, so I have no idea what it's doing really :/

    It feels a bit like it is constantly re-adding everything into the DB, as it thinks the Permissions YML has been updated? Just a wild guess.
     
  17. Offline

    SvenBrnn

    that could be a reason :)
     
  18. Offline

    fugue2005

    not sure what i'm doing wrong.
    the sql is correct, and works fine through phpmyadmin and the plugin uploads to mySQL and back

    however,
    i've set the defines in config.php
    i have apache and php 5.1.6
    when i try to view the web interface it goes to login.php but it is blank.
     
  19. Offline

    SvenBrnn

    Try to add
    PHP:
     error_reporting(E_ALL);
     
    ini_set("display_errors"1); 
    after the <?php in your login.php and refresh.
    Then you should get the errors. (if your php.ini allows config changes on runtime)
     
  20. Offline

    John Kapsis

    How about this now??
    Code:
    C:\Users\John\Desktop\MC2>IF /I "64" == "64" "C:\Program Files (x86)\Java\jre6\bin\java.exe" -Xincgc -Xmx1G -jar "C:\Users\John\Desktop\MC2\craftbukkit.jar"
    [Lnet.minecraft.server.Statistic;@587c94
    146 recipes
    [Lnet.minecraft.server.Statistic;@587c94
    16 achievements
    15:53:54 [INFO] Starting minecraft server version Beta 1.5_02
    15:53:54 [INFO] Loading properties
    15:53:54 [INFO] Starting Minecraft server on *:25565
    15:53:54 [INFO] This server is running Craftbukkit version git-Bukkit-0.0.0-700-gf3ae4c3-b733jnks (MC: 1.5_02)
    15:53:54 [INFO] Preparing level "world"
    15:53:54 [INFO] Preparing start region
    15:53:55 [INFO] Starting Minequery server on *:25566
    15:53:56 [INFO] [WormholeXTremeWorlds][v0.4][By alron]Load Beginning.
    15:53:56 [INFO] [WormholeXTremeWorlds]Config Loaded
    15:53:56 [INFO] [WormholeXTremeWorlds]World Config Loaded: nether.xml
    15:53:56 [INFO] [WormholeXTremeWorlds]Auto-loaded 1 worlds.
    15:53:56 [INFO] [WormholeXTremeWorlds][v0.4]Load Completed.
    15:53:56 [INFO] [Citizens]: Permissions enabled.
    15:53:56 [INFO] [Citizens]: version [1.07i] (Helpers) loaded
    15:53:56 [INFO] Loaded Essentials build 2.2.8 maintained by Zenexer, ementalo, Aelux, Brettflan, KimKandor, snowleo and ceulemans.
    15:53:56 [INFO] Loaded EssentialsChat build 2.2.8 by Zenexer, ementalo, Aelux, Brettflan, KimKandor, snowleo and ceulemans.
    15:53:56 [INFO] Loaded EssentialsGeoIP build 2.2.8 by Zenexer, ementalo, Aelux, Brettflan, KimKandor, snowleo and ceulemans.
    15:53:56 [INFO] This product includes GeoLite data created by MaxMind, available from http://www.maxmind.com/.
    15:53:56 [INFO] GroupManager - INFO - Scheduled Data Saving is set for every 10 minutes!
    15:53:56 [INFO] GroupManager version 1.0(alpha-5) is enabled!
    15:53:56 [INFO] Fake Permissions version 2.5.1 is enabled!
    15:53:56 [INFO] Loaded EssentialsProtect build 2.2.8 maintained by Zenexer, ementalo, Aelux, Brettflan, KimKandor, snowleo and ceulemans.
    15:53:56 [INFO] Loaded EssentialsSpawn build 2.2.8 maintained by Zenexer, ementalo, Aelux, Brettflan, KimKandor, snowleo and ceulemans.
    15:53:56 [INFO] [Minecart Mania] Debug mode switched to NORMAL
    15:53:56 [INFO] [Minecart Mania] MinecartManiaCore version 1.1.1 is enabled!
    15:53:56 [INFO] [Minecart Mania] MinecartManiaSignCommands version 1.1.0 is enabled!
    15:53:56 [INFO] [Minecart Mania] MinecartManiaStation version 1.1.0 is enabled!
    15:53:56 [INFO] MoveCraft 0.6.9 Beta plugin enabled
    15:53:56 [INFO] [MultiVerse] Permissions Found
    15:53:56 [INFO] [MultiVerse] - Version 1.6.3 Enabled
    15:53:56 [INFO] [MultiVerse] Loading World & Settings - 'world' - NORMAL
    15:53:56 [INFO] [MultiVerse] Loading World & Settings - 'wilderness' - NORMAL
    15:53:57 [INFO] [MultiVerse] Loading World & Settings - 'nether' - NETHER
    15:53:57 [INFO] [MultiVerse] Loading World & Settings - 'nether2' - NETHER
    15:53:57 [INFO] [MultiVerse] 4 - World(s) loaded.
    15:53:57 [INFO] [MultiVerse] Loading Portals
    15:53:57 [INFO] [MultiVerse] 6 - Portal(s) loaded.
    15:53:57 [INFO] Fake Permissions version 2.7.2 is enabled!
    15:53:57 [INFO] [MultiVerse] Found Permissions, enabling commands.
    15:53:57 [INFO] Simple Barter version 1.2 is enabled!
    15:53:57 [INFO] [sqlPermissions] Permission system detected!
    15:53:57 [SEVERE] java.lang.Integer cannot be cast to java.lang.String loading sqlPermissions v0.2d (Is it up to date?)
    java.lang.ClassCastException: java.lang.Integer cannot be cast to java.lang.String
            at SvenBrnn.sqlPermissions.sqlPermissionsConfig.readConfig(sqlPermissionsConfig.java:50)
            at SvenBrnn.sqlPermissions.sqlPermissionsConfig.<init>(sqlPermissionsConfig.java:36)
            at SvenBrnn.sqlPermissions.sqlPermissions.onEnable(sqlPermissions.java:31)
            at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:127)
            at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:632)
            at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:218)
            at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:116)
            at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:94)
            at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:217)
            at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:204)
            at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:144)
            at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:259)
            at net.minecraft.server.ThreadServerApplication.run(SourceFile:394)
    15:53:57 [INFO] [WormholeXTremeWorlds][v0.4]Enable Beginning.
    15:53:57 [INFO] [WormholeXTremeWorlds]Attached to Permissions version 2.7.2
    15:53:57 [INFO] [WormholeXTremeWorlds]Help plugin is not yet available; there will be no Help integration until it is loaded.
    15:53:57 [INFO] [WormholeXTremeWorlds][v0.4]Enable Completed.
    15:53:57 [INFO] [Backpack] Permissions detected.
    15:53:57 [INFO] Backpack version 2.0.9 is enabled!
    15:53:57 [INFO] [Minecart Mania] Permissions detected. Using permissions.
    15:53:57 [INFO] [Minecart Mania] MinecartManiaAdminControls version 1.1.1 is enabled!
    15:53:57 [INFO] [Minecart Mania] MinecartManiaAutomations version 1.1.0 is enabled!
    15:53:57 [INFO] [Minecart Mania] MinecartManiaChestControl version 1.1.0 is enabled!
    15:53:57 [INFO] Done (0,290s)! For help, type "help" or "?"
    15:53:57 [INFO] [Citizens]: Loaded 1 NPCs.
    15:54:02 [INFO] [Minecart Mania] Loading Sensor Data.
     
  21. Offline

    Joy

    I fixed that, but the SQL errors after that are unrecoverable :p

    I will send you a copy of my world.yml if that helps finding the issue.
     
  22. Offline

    fugue2005

    apparently it doesn't but oh well, still works with phpmyadmin, so that works for me.
     
  23. Offline

    SvenBrnn

    can you post your config pls


    //EDIT:
    Fixed an Error when Parsing very big Files (Joys Config is a bit cracy xD)
     
  24. Offline

    DylanP

    I can't login...it tries logging in with no password at all...?
    Warning: mysql_real_escape_string(): Access denied for user 'apache'@'localhost' (using password: NO) in /var/www/html/web/includes/sqlDatabase.php on line 144 Warning: mysql_real_escape_string(): A link to the server could not be established in /var/www/html/web/includes/sqlDatabase.php on line 144 Warning: mysql_real_escape_string(): Access denied for user 'apache'@'localhost' (using password: NO) in /var/www/html/web/includes/sqlDatabase.php on line 144 Warning: mysql_real_escape_string(): A link to the server could not be established in /var/www/html/web/includes/sqlDatabase.php on line 144
     
  25. Offline

    John Kapsis


    Here:
    Code:
    config:
        configVersion: '0.2'
        i:
            have:
                set:
                    the:
                        mysql:
                            data: true
        mysql:
            port: '3306'
            host: localhost
            password: ******** (i will not show you my pass people :p)
            user: permissions
            database: permissions
    

    EDIT:

    at first run i get: (this is a new error i think)
    Code:
    [Lnet.minecraft.server.Statistic;@15b0afd
    146 recipes
    [Lnet.minecraft.server.Statistic;@15b0afd
    16 achievements
    18:48:05 [INFO] Starting minecraft server version Beta 1.5_02
    18:48:05 [INFO] Loading properties
    18:48:05 [INFO] Starting Minecraft server on *:25565
    18:48:05 [INFO] This server is running Craftbukkit version git-Bukkit-0.0.0-706-gf53e007-b740jnks (MC: 1.5_02)
    18:48:05 [INFO] Preparing level "world"
    18:48:05 [INFO] Preparing start region
    18:48:05 [INFO] Starting Minequery server on *:25566
    18:48:05 [INFO] [WormholeXTremeWorlds][v0.4][By alron]Load Beginning.
    18:48:05 [INFO] [WormholeXTremeWorlds]Config Loaded
    18:48:05 [INFO] [WormholeXTremeWorlds]World Config Loaded: nether.xml
    18:48:06 [INFO] [WormholeXTremeWorlds]Auto-loaded 1 worlds.
    18:48:06 [INFO] [WormholeXTremeWorlds][v0.4]Load Completed.
    18:48:06 [INFO] [Citizens]: Permissions enabled.
    18:48:06 [INFO] [Citizens]: version [1.07i] (Helpers) loaded
    18:48:06 [INFO] Loaded Essentials build 2.2.8 maintained by Zenexer, ementalo, Aelux, Brettflan, KimKandor, snowleo and ceulemans.
    18:48:06 [INFO] Loaded EssentialsChat build 2.2.8 by Zenexer, ementalo, Aelux, Brettflan, KimKandor, snowleo and ceulemans.
    18:48:06 [INFO] Loaded EssentialsGeoIP build 2.2.8 by Zenexer, ementalo, Aelux, Brettflan, KimKandor, snowleo and ceulemans.
    18:48:06 [INFO] This product includes GeoLite data created by MaxMind, available from http://www.maxmind.com/.
    18:48:06 [INFO] GroupManager - INFO - Scheduled Data Saving is set for every 10 minutes!
    18:48:06 [INFO] GroupManager version 1.0(alpha-5) is enabled!
    18:48:06 [INFO] Fake Permissions version 2.5.1 is enabled!
    18:48:06 [INFO] Loaded EssentialsProtect build 2.2.8 maintained by Zenexer, ementalo, Aelux, Brettflan, KimKandor, snowleo and ceulemans.
    18:48:06 [INFO] Loaded EssentialsSpawn build 2.2.8 maintained by Zenexer, ementalo, Aelux, Brettflan, KimKandor, snowleo and ceulemans.
    18:48:06 [INFO] [Minecart Mania] Debug mode switched to NORMAL
    18:48:06 [INFO] [Minecart Mania] MinecartManiaCore version 1.1.1 is enabled!
    18:48:06 [INFO] [Minecart Mania] MinecartManiaSignCommands version 1.1.0 is enabled!
    18:48:06 [INFO] [Minecart Mania] MinecartManiaStation version 1.1.0 is enabled!
    18:48:06 [INFO] MoveCraft 0.6.9 Beta plugin enabled
    18:48:06 [INFO] [MultiVerse] Permissions Found
    18:48:06 [INFO] [MultiVerse] - Version 1.6.3 Enabled
    18:48:06 [INFO] [MultiVerse] Loading World & Settings - 'world' - NORMAL
    18:48:06 [INFO] [MultiVerse] Loading World & Settings - 'wilderness' - NORMAL
    18:48:07 [INFO] [MultiVerse] Loading World & Settings - 'nether' - NETHER
    18:48:07 [INFO] [MultiVerse] Loading World & Settings - 'nether2' - NETHER
    18:48:07 [INFO] [MultiVerse] 4 - World(s) loaded.
    18:48:07 [INFO] [MultiVerse] Loading Portals
    18:48:07 [INFO] [MultiVerse] 6 - Portal(s) loaded.
    18:48:07 [INFO] Fake Permissions version 2.7.2 is enabled!
    18:48:07 [INFO] [MultiVerse] Found Permissions, enabling commands.
    18:48:07 [INFO] Simple Barter version 1.2 is enabled!
    18:48:07 [INFO] [sqlPermissions] Permission system detected!
    18:48:07 [INFO] [sqlPermissions] Please set the MySQL Data first.
    18:48:07 [INFO] sqlPermissions disabled!
    18:48:07 [SEVERE] null loading sqlPermissions v0.4 (Is it up to date?)
    java.lang.NullPointerException
            at SvenBrnn.sqlPermissions.sqlPermissions.disableSqlPermission(sqlPermissions.java:84)
            at SvenBrnn.sqlPermissions.sqlPermissionsConfig.readConfig(sqlPermissionsConfig.java:44)
            at SvenBrnn.sqlPermissions.sqlPermissionsConfig.<init>(sqlPermissionsConfig.java:36)
            at SvenBrnn.sqlPermissions.sqlPermissions.onEnable(sqlPermissions.java:34)
            at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:127)
            at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:632)
            at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:218)
            at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:116)
            at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:94)
            at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:217)
            at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:204)
            at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:144)
            at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:259)
            at net.minecraft.server.ThreadServerApplication.run(SourceFile:394)
    18:48:07 [INFO] [WormholeXTremeWorlds][v0.4]Enable Beginning.
    18:48:07 [INFO] [WormholeXTremeWorlds]Attached to Permissions version 2.7.2
    18:48:07 [INFO] [WormholeXTremeWorlds]Help plugin is not yet available; there will be no Help integration until it is loaded.
    18:48:07 [INFO] [WormholeXTremeWorlds][v0.4]Enable Completed.
    18:48:07 [INFO] [Backpack] Permissions detected.
    18:48:07 [INFO] Backpack version 2.0.9 is enabled!
    18:48:07 [INFO] [Minecart Mania] Permissions detected. Using permissions.
    18:48:07 [INFO] [Minecart Mania] MinecartManiaAdminControls version 1.1.1 is enabled!
    18:48:07 [INFO] [Minecart Mania] MinecartManiaAutomations version 1.1.0 is enabled!
    18:48:07 [INFO] [Minecart Mania] MinecartManiaChestControl version 1.1.0 is enabled!
    18:48:07 [INFO] Done (0,266s)! For help, type "help" or "?"
    18:48:07 [INFO] [Citizens]: Loaded 1 NPCs.
    18:48:12 [INFO] [Minecart Mania] Loading Sensor Data.
    And on second run i get this: (the same as the other one)

    Code:
    [Lnet.minecraft.server.Statistic;@15b0afd
    146 recipes
    [Lnet.minecraft.server.Statistic;@15b0afd
    16 achievements
    18:52:14 [INFO] Starting minecraft server version Beta 1.5_02
    18:52:14 [INFO] Loading properties
    18:52:14 [INFO] Starting Minecraft server on *:25565
    18:52:14 [INFO] This server is running Craftbukkit version git-Bukkit-0.0.0-706-gf53e007-b740jnks (MC: 1.5_02)
    18:52:14 [INFO] Preparing level "world"
    18:52:14 [INFO] Preparing start region
    18:52:15 [INFO] Starting Minequery server on *:25566
    18:52:15 [INFO] [WormholeXTremeWorlds][v0.4][By alron]Load Beginning.
    18:52:15 [INFO] [WormholeXTremeWorlds]Config Loaded
    18:52:15 [INFO] [WormholeXTremeWorlds]World Config Loaded: nether.xml
    18:52:16 [INFO] [WormholeXTremeWorlds]Auto-loaded 1 worlds.
    18:52:16 [INFO] [WormholeXTremeWorlds][v0.4]Load Completed.
    18:52:16 [INFO] [Citizens]: Permissions enabled.
    18:52:16 [INFO] [Citizens]: version [1.07i] (Helpers) loaded
    18:52:16 [INFO] Loaded Essentials build 2.2.8 maintained by Zenexer, ementalo, Aelux, Brettflan, KimKandor, snowleo and ceulemans.
    18:52:16 [INFO] Loaded EssentialsChat build 2.2.8 by Zenexer, ementalo, Aelux, Brettflan, KimKandor, snowleo and ceulemans.
    18:52:16 [INFO] Loaded EssentialsGeoIP build 2.2.8 by Zenexer, ementalo, Aelux, Brettflan, KimKandor, snowleo and ceulemans.
    18:52:16 [INFO] This product includes GeoLite data created by MaxMind, available from http://www.maxmind.com/.
    18:52:16 [INFO] GroupManager - INFO - Scheduled Data Saving is set for every 10 minutes!
    18:52:16 [INFO] GroupManager version 1.0(alpha-5) is enabled!
    18:52:16 [INFO] Fake Permissions version 2.5.1 is enabled!
    18:52:16 [INFO] Loaded EssentialsProtect build 2.2.8 maintained by Zenexer, ementalo, Aelux, Brettflan, KimKandor, snowleo and ceulemans.
    18:52:16 [INFO] Loaded EssentialsSpawn build 2.2.8 maintained by Zenexer, ementalo, Aelux, Brettflan, KimKandor, snowleo and ceulemans.
    18:52:16 [INFO] [Minecart Mania] Debug mode switched to NORMAL
    18:52:16 [INFO] [Minecart Mania] MinecartManiaCore version 1.1.1 is enabled!
    18:52:16 [INFO] [Minecart Mania] MinecartManiaSignCommands version 1.1.0 is enabled!
    18:52:16 [INFO] [Minecart Mania] MinecartManiaStation version 1.1.0 is enabled!
    18:52:16 [INFO] MoveCraft 0.6.9 Beta plugin enabled
    18:52:16 [INFO] [MultiVerse] Permissions Found
    18:52:16 [INFO] [MultiVerse] - Version 1.6.3 Enabled
    18:52:16 [INFO] [MultiVerse] Loading World & Settings - 'world' - NORMAL
    18:52:16 [INFO] [MultiVerse] Loading World & Settings - 'wilderness' - NORMAL
    18:52:17 [INFO] [MultiVerse] Loading World & Settings - 'nether' - NETHER
    18:52:17 [INFO] [MultiVerse] Loading World & Settings - 'nether2' - NETHER
    18:52:17 [INFO] [MultiVerse] 4 - World(s) loaded.
    18:52:17 [INFO] [MultiVerse] Loading Portals
    18:52:17 [INFO] [MultiVerse] 6 - Portal(s) loaded.
    18:52:17 [INFO] Fake Permissions version 2.7.2 is enabled!
    18:52:17 [INFO] [MultiVerse] Found Permissions, enabling commands.
    18:52:17 [INFO] Simple Barter version 1.2 is enabled!
    18:52:17 [INFO] [sqlPermissions] Permission system detected!
    18:52:17 [SEVERE] java.lang.Integer cannot be cast to java.lang.String loading sqlPermissions v0.4 (Is it up to date?)
    java.lang.ClassCastException: java.lang.Integer cannot be cast to java.lang.String
            at SvenBrnn.sqlPermissions.sqlPermissionsConfig.readConfig(sqlPermissionsConfig.java:50)
            at SvenBrnn.sqlPermissions.sqlPermissionsConfig.<init>(sqlPermissionsConfig.java:36)
            at SvenBrnn.sqlPermissions.sqlPermissions.onEnable(sqlPermissions.java:34)
            at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:127)
            at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:632)
            at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:218)
            at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:116)
            at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:94)
            at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:217)
            at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:204)
            at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:144)
            at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:259)
            at net.minecraft.server.ThreadServerApplication.run(SourceFile:394)
    18:52:17 [INFO] [WormholeXTremeWorlds][v0.4]Enable Beginning.
    18:52:17 [INFO] [WormholeXTremeWorlds]Attached to Permissions version 2.7.2
    18:52:17 [INFO] [WormholeXTremeWorlds]Help plugin is not yet available; there will be no Help integration until it is loaded.
    18:52:17 [INFO] [WormholeXTremeWorlds][v0.4]Enable Completed.
    18:52:17 [INFO] [Backpack] Permissions detected.
    18:52:17 [INFO] Backpack version 2.0.9 is enabled!
    18:52:17 [INFO] [Minecart Mania] Permissions detected. Using permissions.
    18:52:17 [INFO] [Minecart Mania] MinecartManiaAdminControls version 1.1.1 is enabled!
    18:52:17 [INFO] [Minecart Mania] MinecartManiaAutomations version 1.1.0 is enabled!
    18:52:17 [INFO] [Minecart Mania] MinecartManiaChestControl version 1.1.0 is enabled!
    18:52:17 [INFO] Done (0,265s)! For help, type "help" or "?"
    18:52:17 [INFO] [Citizens]: Loaded 1 NPCs.
    18:52:22 [INFO] [Minecart Mania] Loading Sensor Data.
     
  26. Offline

    SvenBrnn

    Added that u can use the newest permissionPlus together with sqlPermissions. Pls read the Attantion in first Post!
    Update your Web to the newest one. Already fixed this bug.

    Add '' around your Password and it should work.
     
  27. Offline

    John Kapsis

    I feel like the biggest noob EVER!

    More...

    Code:
    [Lnet.minecraft.server.Statistic;@587c94
    146 recipes
    [Lnet.minecraft.server.Statistic;@587c94
    16 achievements
    19:08:00 [INFO] Starting minecraft server version Beta 1.5_02
    19:08:00 [INFO] Loading properties
    19:08:00 [INFO] Starting Minecraft server on *:25565
    19:08:00 [INFO] This server is running Craftbukkit version git-Bukkit-0.0.0-706-gf53e007-b740jnks (MC: 1.5_02)
    19:08:00 [INFO] Preparing level "world"
    19:08:00 [INFO] Preparing start region
    19:08:01 [INFO] Starting Minequery server on *:25566
    19:08:01 [INFO] [WormholeXTremeWorlds][v0.4][By alron]Load Beginning.
    19:08:01 [INFO] [WormholeXTremeWorlds]Config Loaded
    19:08:01 [INFO] [WormholeXTremeWorlds]World Config Loaded: nether.xml
    19:08:01 [INFO] [WormholeXTremeWorlds]Auto-loaded 1 worlds.
    19:08:01 [INFO] [WormholeXTremeWorlds][v0.4]Load Completed.
    19:08:01 [INFO] [Citizens]: Permissions enabled.
    19:08:01 [INFO] [Citizens]: version [1.07i] (Helpers) loaded
    19:08:01 [INFO] Loaded Essentials build 2.2.8 maintained by Zenexer, ementalo, Aelux, Brettflan, KimKandor, snowleo and ceulemans.
    19:08:01 [INFO] Loaded EssentialsChat build 2.2.8 by Zenexer, ementalo, Aelux, Brettflan, KimKandor, snowleo and ceulemans.
    19:08:01 [INFO] Loaded EssentialsGeoIP build 2.2.8 by Zenexer, ementalo, Aelux, Brettflan, KimKandor, snowleo and ceulemans.
    19:08:01 [INFO] This product includes GeoLite data created by MaxMind, available from http://www.maxmind.com/.
    19:08:01 [INFO] GroupManager - INFO - Scheduled Data Saving is set for every 10 minutes!
    19:08:01 [INFO] GroupManager version 1.0(alpha-5) is enabled!
    19:08:01 [INFO] Fake Permissions version 2.5.1 is enabled!
    19:08:01 [INFO] Loaded EssentialsProtect build 2.2.8 maintained by Zenexer, ementalo, Aelux, Brettflan, KimKandor, snowleo and ceulemans.
    19:08:01 [INFO] Loaded EssentialsSpawn build 2.2.8 maintained by Zenexer, ementalo, Aelux, Brettflan, KimKandor, snowleo and ceulemans.
    19:08:01 [INFO] [Minecart Mania] Debug mode switched to NORMAL
    19:08:01 [INFO] [Minecart Mania] MinecartManiaCore version 1.1.1 is enabled!
    19:08:01 [INFO] [Minecart Mania] MinecartManiaSignCommands version 1.1.0 is enabled!
    19:08:01 [INFO] [Minecart Mania] MinecartManiaStation version 1.1.0 is enabled!
    19:08:01 [INFO] MoveCraft 0.6.9 Beta plugin enabled
    19:08:01 [INFO] [MultiVerse] Permissions Found
    19:08:01 [INFO] [MultiVerse] - Version 1.6.3 Enabled
    19:08:01 [INFO] [MultiVerse] Loading World & Settings - 'world' - NORMAL
    19:08:01 [INFO] [MultiVerse] Loading World & Settings - 'wilderness' - NORMAL
    19:08:02 [INFO] [MultiVerse] Loading World & Settings - 'nether' - NETHER
    19:08:02 [INFO] [MultiVerse] Loading World & Settings - 'nether2' - NETHER
    19:08:02 [INFO] [MultiVerse] 4 - World(s) loaded.
    19:08:02 [INFO] [MultiVerse] Loading Portals
    19:08:02 [INFO] [MultiVerse] 6 - Portal(s) loaded.
    19:08:02 [INFO] Fake Permissions version 2.7.2 is enabled!
    19:08:02 [INFO] [MultiVerse] Found Permissions, enabling commands.
    19:08:02 [INFO] Simple Barter version 1.2 is enabled!
    19:08:02 [INFO] [sqlPermissions] Permission system detected!
    19:08:03 [INFO] [sqlPermissions] Error while Trying to connect to Database:
    19:08:03 [INFO] Access denied for user 'permissions'@'localhost' (using password: YES)
    19:08:03 [INFO] sqlPermissions version 0.4 is enabled!
    19:08:03 [INFO] [WormholeXTremeWorlds][v0.4]Enable Beginning.
    19:08:03 [INFO] [WormholeXTremeWorlds]Attached to Permissions version 2.7.2
    19:08:03 [INFO] [WormholeXTremeWorlds]Help plugin is not yet available; there will be no Help integration until it is loaded.
    19:08:03 [INFO] [WormholeXTremeWorlds][v0.4]Enable Completed.
    19:08:03 [INFO] [Backpack] Permissions detected.
    19:08:03 [INFO] Backpack version 2.0.9 is enabled!
    19:08:03 [INFO] [Minecart Mania] Permissions detected. Using permissions.
    19:08:03 [INFO] [Minecart Mania] MinecartManiaAdminControls version 1.1.1 is enabled!
    19:08:03 [INFO] [Minecart Mania] MinecartManiaAutomations version 1.1.0 is enabled!
    19:08:03 [INFO] [Minecart Mania] MinecartManiaChestControl version 1.1.0 is enabled!
    19:08:03 [INFO] Done (0,276s)! For help, type "help" or "?"
    19:08:03 [INFO] [Citizens]: Loaded 1 NPCs.
    19:08:08 [INFO] [Minecart Mania] Loading Sensor Data.
    19:08:13 [SEVERE] null
    java.lang.NullPointerException
            at SvenBrnn.sqlPermissions.sqlPermissionsDB.executeQuery(sqlPermissionsDB.java:68)
            at SvenBrnn.sqlPermissions.sqlPermissionsWorker.run(sqlPermissionsWorker.java:56)
    19:08:13 [SEVERE] null
    java.lang.NullPointerException
            at SvenBrnn.sqlPermissions.sqlPermissionsDB.executeQuery(sqlPermissionsDB.java:68)
            at SvenBrnn.sqlPermissions.sqlPermissionsWorker.run(sqlPermissionsWorker.java:56)
    19:08:13 [SEVERE] null
    java.lang.NullPointerException
            at SvenBrnn.sqlPermissions.sqlPermissionsDB.executeQuery(sqlPermissionsDB.java:68)
            at SvenBrnn.sqlPermissions.sqlPermissionsWorker.run(sqlPermissionsWorker.java:56)
    19:08:13 [SEVERE] null
    java.lang.NullPointerException
            at SvenBrnn.sqlPermissions.sqlPermissionsDB.executeQuery(sqlPermissionsDB.java:68)
            at SvenBrnn.sqlPermissions.sqlPermissionsWorker.run(sqlPermissionsWorker.java:56)
    WTF??? am i cursed or something??

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: May 15, 2016
  28. Offline

    SvenBrnn

    i would say you should recreate your Database. or Manualy add a line with 'lastDBChange' as the param and now() as the value in your perm_conf (normaly its added automaticly if it doesnt exist)
     
  29. Offline

    John Kapsis

    I'm sorry but as i said i have no idea about sql...
    damn i must figure this out...
     
  30. Offline

    Joy

    Well now it managed to do a full import, first live testing.

    1) I removed a single permission node from a random player in the world.yml, and waited 10 minutes. It says "[sqlPermissons] Reading Permission file", but the entry is still present in the DB, instead of being removed.

    2) I also notice that in the perm_config table, the lastDBChange has not changed at all from "1970-01-01 01:00:00" yet.

    3) I can get through the login page on the web portal, after that, it shows an empty page for index.php, no content at all. Tested in Chrome and Firefox. Seeing I can login, means the DB connection is fine of course.
     
  31. Offline

    SvenBrnn

    lastDBChange must be set if you change something in DB. Its for checking if the Plugin have to read or to write the config.
    I will check the Permission issue again later or tomorrow.
     

Share This Page