[ADMN/WEB] OKB3 - Bulletin Board Bridge - Now on BukkitDev! [1337]

Discussion in 'Inactive/Unsupported Plugins' started by Kalman Olah, Jun 2, 2011.

Page 10 of 57
  1. Offline

    Kalman Olah

    Kalman Olah, Jun 2, 2011
    #1
    Unforted, Dr_Herbalist, fortiiiZ and 5 others like this.
  2. Offline

    Kalman Olah

    Show me a full config.yml please
    and your config.inc.php
    @Robert McKay
     
    Kalman Olah, Jun 27, 2011
    #271
  3. Offline

    Robert McKay

    Okay here is full config.yml:
    Show Spoiler

    Code:
    mode: normal
'###The mode the plugin will run in, options are ''normal'' or ''old-school''###': ''
? '###In old-school mode, the server does NOT check a username/password! It just gets
    a rank from your forum DB and sets it as your group###'
: ''
? '###If you''re using old-school mode, fill in the section labeled ''old-school-mode''
    If not, fill in the section labeled ''normal-mode'''
: ''
mysql-connection-info:
    mysql-host: 184.154.137.42
    mysql-user: wurldus_ipb
    mysql-password: PASSWORDGOESHERE
    mysql-database-name: wurldus_ipb
old-school-mode:
    usertable: user_table
    minecraftname-field: mine_user
    rank-field: rank_field
    enable-multiple-tables: false
    '###If enable-multiple-tables is true, fill in the multitable section': ''
    multitable:
        minecraftname-table: mine_table
        useridfield-in-minecraftname-table: user_id_field
        useridfield-in-usertable: user_id_field
normal-mode:
    type-of-forum: ipb
    ? '###Current supported forum types md5 for MD5 encryption-based forums,phpbb
        for phpBB3, smf for SMF, vbulletin for vBulletin, mybb for myBB, xenforo for
        XenForo, ipb for IPB, wbb for WBB, kunena for Kunena###'
    : ''
    '###Fill in the fields for the forum type that matches your type-of-forum value': ''
    location-of-passgenphp: http://wurld.us/forum/webfiles/passgen.php
    password-set-in-config-inc-php: PASSWORDGOESHERE
    md5:
        usertable: user_table
        username-field: username_field
        userpassword-field: user_pass_field
        rank-field: rank_field
    phpbb:
        usertable: user_table
        username-field: username_field
        userpassword-field: user_pass_field
        rank-field: rank_field
    smf:
        usertable: user_table
        username-field: username_field
        userpassword-field: user_pass_field
        rank-field: rank_field
    vbulletin:
        usertable: user_table
        username-field: username_field
        userpassword-field: user_pass_field
        rank-field: rank_field
    mybb:
        usertable: user_table
        username-field: username_field
        userpassword-field: user_pass_field
        rank-field: rank_field
    xenforo:
        usertable: user_table
        rank-field: rank_field
        username-field: username_field
        password-table: pass_table
        password-field: pass_field
        useridfield-in-usertable: user_id_field
        useridfield-in-passtable: user_id_field
    ipb:
        usertable: wurldus_members
        username-field: members_name
        userpassword-field: members_pass_hash
        rank-field: member_group_id
    wbb:
        usertable: user_table
        username-field: username_field
        userpassword-field: user_pass_field
        rank-field: rank_field
    kunena:
        usertable: user_table
        rank-table: rank_table
        rank-field: rank_field
        username-field: username_field
        password-field: pass_field
        useridfield-in-usertable: user_id_field
        useridfield-in-rank-table: user_id_field
groups:
    '###''RANKID IN RANKTABLE''=GROUPMANAGER GROUP###': ''
    '1': Validating
    '2': Guest
    '3': Verified
    '4': Admins
    '5': Banned
    '6': Moderator
whitelist:
    enable-whitelist: 'true'
    use-as-blacklist: 'false'
    kick-message: You must register @ our forums to join! http://wurld.us/forum/ (not our blog)
    whitelist-groups:
        '###''''RANKID IN RANKTABLE'': true'' TO ALLOW A RANK TO JOIN###': ''
        '###''''RANKID IN RANKTABLE'': false'' TO NOT ALLOW A RANK TO JOIN###': ''
        '1': 'false'
        '2': 'false'
        '5': 'false'
        '3': 'true'
        '4': 'true'
        '6': 'true'

'###If use-as-blacklist is enabled, groups that aren''t specified on the whitelist will count as blacklisted###': ''
nickname-sync:
    enable-nickname-syncing: 'true'
    nickname-field-in-usertable: ''


    And here is the config.inc.php...
    Show Spoiler

    Code:
    <?php
//Your mysql host
$dbhost = 'localhost';
//Your mysql user
$dbuser = 'wurldus_ipb';
//Your mysql password
$dbpass = 'PASSWORDGOESGERE';
//Your mysql database
$dbname = 'wurldus_ipb';
//Your custom password. #####THIS MUST MATCH THE PHP PASSWORD IN CONFIG.PROPERTIES!#####
$phppass = 'PASSWORDGOESHERE';
//The prefix used by your forum tables. Let's say your the table where your usernames are stored in
// is called 'phpbb_users'...in this case the prefix is 'phpbb_'. set to $sqlprefix = ''; for no prefix.
$sqlprefix = 'groups_';
?>


    Thanks for the fast reply btw :D

    Robert

    I also get this error:
    Code:
    [SEVERE] Could not load 'plugins/OKB3.jar' in folder 'plugins':
while scanning for the next token
found character'\t' that cannot start any token
in "", line 105, column 1:
  
at org.yaml.snakeyaml.scanner.ScannerImpl.fetchMoreTokens(ScannerImpl.java:360)
at org.yaml.snakeyaml.scanner.ScannerImpl.checkToken(ScannerImpl.java:183)
at org.yaml.snakeyaml.parser.ParserImpl$ParseBlockMappingKey.produce(ParserImpl.java:564)
at org.yaml.snakeyaml.parser.ParserImpl.peekEvent(ParserImpl.java:163)
at org.yaml.snakeyaml.parser.ParserImpl.checkEvent(ParserImpl.java:148)
at org.yaml.snakeyaml.composer.Composer.composeMappingNode(Composer.java:228)
at org.yaml.snakeyaml.composer.Composer.composeNode(Composer.java:160)
at org.yaml.snakeyaml.composer.Composer.composeMappingNode(Composer.java:230)
at org.yaml.snakeyaml.composer.Composer.composeNode(Composer.java:160)
at org.yaml.snakeyaml.composer.Composer.composeMappingNode(Composer.java:230)
at org.yaml.snakeyaml.composer.Composer.composeNode(Composer.java:160)
at org.yaml.snakeyaml.composer.Composer.composeDocument(Composer.java:122)
at org.yaml.snakeyaml.composer.Composer.getSingleNode(Composer.java:105)
at org.yaml.snakeyaml.constructor.BaseConstructor.getSingleData(BaseConstructor.java:124)
at org.yaml.snakeyaml.Yaml.load(Yaml.java:264)
at org.bukkit.util.config.Configuration.load(Configuration.java:82)
at org.bukkit.plugin.java.JavaPlugin.initialize(JavaPlugin.java:157)
at org.bukkit.plugin.java.JavaPluginLoader.loadPlugin(JavaPluginLoader.java:175)
at org.bukkit.plugin.SimplePluginManager.loadPlugin(SimplePluginManager.java:199)
at org.bukkit.plugin.SimplePluginManager.loadPlugins(SimplePluginManager.java:122)
at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:118)
at org.bukkit.craftbukkit.CraftServer.reload(CraftServer.java:356)
at org.bukkit.command.SimpleCommandMap$ReloadCommand.execute(SimpleCommandMap.java:281)
at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:129)
at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:298)
at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:726)
at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:691)
at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:684)
at net.minecraft.server.Packet3Chat.a(Packet3Chat.java:33)
at net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:84)
at net.minecraft.server.NetworkListenThread.a(SourceFile:105)
at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:451)
at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:361)
at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: May 16, 2016
    Robert McKay, Jun 27, 2011
    #272
  4. Offline

    Kalman Olah

    First of all: Your $sqlprefix is the PREFIX OF THE TABLES. So if your table is called "TEST_members", $sqlprefix is 'TEST_'. Second, ipb should be:
    Code:
        ipb:
        usertable: FULL TABLE NAME
        username-field: name
        userpassword-field: members_pass_hash
        rank-field: member_group_id
    Edit only the table name. username-field is just 'name'. Change the sqlprefix in config.inc.php if needed, and report back with the config.yml, config.inc.php and results.

    Also remove the blank rule under the whitelist groups.

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: May 16, 2016
    Kalman Olah, Jun 27, 2011
    #273
  5. Offline

    Robert McKay

    Okay sorry for all these posts (atleast you show up at the top of bukkit plugin lists :D)

    I fixed that error ^^(I accidently indented)

    Now i'm getting this. Appears to be an error with MySql username. I have my password right and username. What could be wrong?

    Code:
    >21:20:56 [SEVERE] [OKB3-MYSQL] SQLException! Access denied for user 'wurldus_ipb'@'184.154.205.2' (using password: YES)
     
    Robert McKay, Jun 27, 2011
    #274
  6. Offline

    Kalman Olah

    And since you set enable-nickname-syncing to true, either fill in the nickname-field, or set it to false.

    You must give your MySQL user permission to access the forum database from a remote IP(the IP of your minecraft server-.

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: May 16, 2016
    Kalman Olah, Jun 27, 2011
    #275
  7. Offline

    Robert McKay

    How do I do that?
     
    Robert McKay, Jun 27, 2011
    #276
  8. Offline

    Kalman Olah

    If you have access to PHPMyADmin, go to priveleges, make a new user, and give it access from all IPs. If you don't have PHPMyAdmin... Ask your webhost or something :p
     
    Kalman Olah, Jun 27, 2011
    #277
  9. Offline

    Robert McKay

    I have PHPMyAdmin, is it the table called USER_PRIVELEGES.
    And if so, how do I edit it?

    Here is that config you asked for earlier...
    Show Spoiler
    Code:
    mode: normal
'###The mode the plugin will run in, options are ''normal'' or ''old-school''###': ''
? '###In old-school mode, the server does NOT check a username/password! It just gets
    a rank from your forum DB and sets it as your group###'
: ''
? '###If you''re using old-school mode, fill in the section labeled ''old-school-mode''
    If not, fill in the section labeled ''normal-mode'''
: ''
mysql-connection-info:
    mysql-host: 184.154.137.42
    mysql-user: wurldus_ipb
    mysql-password: PASSWURD
    mysql-database-name: wurldus_ipb
old-school-mode:
    usertable: user_table
    minecraftname-field: mine_user
    rank-field: rank_field
    enable-multiple-tables: false
    '###If enable-multiple-tables is true, fill in the multitable section': ''
    multitable:
        minecraftname-table: mine_table
        useridfield-in-minecraftname-table: user_id_field
        useridfield-in-usertable: user_id_field
normal-mode:
    type-of-forum: ipb
    ? '###Current supported forum types md5 for MD5 encryption-based forums,phpbb
        for phpBB3, smf for SMF, vbulletin for vBulletin, mybb for myBB, xenforo for
        XenForo, ipb for IPB, wbb for WBB, kunena for Kunena###'
    : ''
    '###Fill in the fields for the forum type that matches your type-of-forum value': ''
    location-of-passgenphp: http://wurld.us/forum/webfiles/passgen.php
    password-set-in-config-inc-php: PASSWURD
    md5:
        usertable: user_table
        username-field: username_field
        userpassword-field: user_pass_field
        rank-field: rank_field
    phpbb:
        usertable: user_table
        username-field: username_field
        userpassword-field: user_pass_field
        rank-field: rank_field
    smf:
        usertable: user_table
        username-field: username_field
        userpassword-field: user_pass_field
        rank-field: rank_field
    vbulletin:
        usertable: user_table
        username-field: username_field
        userpassword-field: user_pass_field
        rank-field: rank_field
    mybb:
        usertable: user_table
        username-field: username_field
        userpassword-field: user_pass_field
        rank-field: rank_field
    xenforo:
        usertable: user_table
        rank-field: rank_field
        username-field: username_field
        password-table: pass_table
        password-field: pass_field
        useridfield-in-usertable: user_id_field
        useridfield-in-passtable: user_id_field
    ipb:
        usertable: wurldus_members_
        username-field: name
        userpassword-field: members_pass_hash
        rank-field: member_group_id
    wbb:
        usertable: user_table
        username-field: username_field
        userpassword-field: user_pass_field
        rank-field: rank_field
    kunena:
        usertable: user_table
        rank-table: rank_table
        rank-field: rank_field
        username-field: username_field
        password-field: pass_field
        useridfield-in-usertable: user_id_field
        useridfield-in-rank-table: user_id_field
groups:
    '###''RANKID IN RANKTABLE''=GROUPMANAGER GROUP###': ''
    '1': Validating
    '2': Guest
    '3': Verified
    '4': Admins
    '5': Banned
    '6': Moderator
whitelist:
    enable-whitelist: 'true'
    use-as-blacklist: 'false'
    kick-message: You must register @ our forums to join! http://wurld.us/forum/ (not our blog)
    whitelist-groups:
        '###''''RANKID IN RANKTABLE'': true'' TO ALLOW A RANK TO JOIN###': ''
        '###''''RANKID IN RANKTABLE'': false'' TO NOT ALLOW A RANK TO JOIN###': ''
        '1': 'false'
        '2': 'false'
        '5': 'false'
        '3': 'true'
        '4': 'true'
        '6': 'true'
'###If use-as-blacklist is enabled, groups that aren''t specified on the whitelist will count as blacklisted###': ''
nickname-sync:
    enable-nickname-syncing: 'false'
    nickname-field-in-usertable: ''


    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: May 16, 2016
    Robert McKay, Jun 27, 2011
    #278
  10. Offline

    Kalman Olah

    You don't. You go to the main page, select your main database. And click "priveleges"
     
    Kalman Olah, Jun 27, 2011
    #279
  11. Offline

    Robert McKay

    And the php one...
    Code:
    <?php
//Your mysql host
$dbhost = 'localhost';
//Your mysql user
$dbuser = 'wurldus_ipb';
//Your mysql password
$dbpass = 'PASSWURD';
//Your mysql database
$dbname = 'wurldus_ipb';
//Your custom password. #####THIS MUST MATCH THE PHP PASSWORD IN CONFIG.PROPERTIES!#####
$phppass = 'PASSWURD';
//The prefix used by your forum tables. Let's say your the table where your usernames are stored in
// is called 'phpbb_users'...in this case the prefix is 'phpbb_'. set to $sqlprefix = ''; for no prefix.
$sqlprefix = 'wurldus_';
?>
    I cant find that privileges thing...

    Where to?
    [​IMG]

    I think its working :D

    Tell me if it is...
    'play.wurld.us'

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: May 16, 2016
    Robert McKay, Jun 27, 2011
    #280
  12. Offline

    Kalman Olah

    select your ipb database on the left first, then it should show up
     
    Kalman Olah, Jun 27, 2011
    #281
  13. Offline

    Robert McKay

    Do i have something mixed up with whitelist and such?

    My username on my forum is Trewyy, and in game it is also Trewyy, but it wont let me connect because I am not on whitelist?

    And then I get this error when I type /bbb sync into my console:

    Code:
    21:45:16 [WARNING] Unexpected exception while parsing console command
org.bukkit.command.CommandException: Unhandled exception executing command 'bbb' in plugin OKB3 v1.3.1
at org.bukkit.command.PluginCommand.execute(PluginCommand.java:37)
at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:129)
at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:290)
at net.minecraft.server.MinecraftServer.b(MinecraftServer.java:480)
at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:465)
at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:361)
at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
Caused by: java.lang.NullPointerException
at net.genericgaming.kalmanolah.okb3.OKmain.CheckPermission(OKmain.java:184)
at net.genericgaming.kalmanolah.okb3.OKCmd.onCommand(OKCmd.java:39)
at org.bukkit.command.PluginCommand.execute(PluginCommand.java:35)
... 6 more
    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: May 16, 2016
    Robert McKay, Jun 27, 2011
    #282
  14. Offline

    Kalman Olah

    show me your config.yml, config.inc.php and your server log on startup please :)
     
    Kalman Olah, Jun 27, 2011
    #283
  15. Offline

    Robert McKay

    posted above ^^ havent changed since last post (i updated, dont know if you saw)

    also, i cant find privileges, will upload image in a moment...

    Here is image of what I am faced with:

    [​IMG]

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: May 16, 2016
    Robert McKay, Jun 27, 2011
    #284
  16. Offline

    Kalman Olah

    $phppass needs to be set to the config.yml value of password-set-in-config-inc-php...They're not your MySQL password. Just a password. And show me the startup server log please :)
     
    Kalman Olah, Jun 27, 2011
    #285
  17. Offline

    Robert McKay

    Yah, the password I use is universal (Shhhh....) so the password isn't wrong.

    I'll show start up log in one sec...
     
    Robert McKay, Jun 27, 2011
    #286
  18. Offline

    Kalman Olah

    Well if there is no way for you to make a new MySQL user in PHPMyAdmin, with permissions to access the database remotely, you'll have to ask your webhost to do it for you. But show me the server.log first, I want to be sure.
     
    Kalman Olah, Jun 27, 2011
    #287
  19. Offline

    Robert McKay

    >21:49:13 [INFO] Starting Minequery server on 184.154.44.140:25566
    >21:49:13 [INFO] [Permissions] (Yeti) was initialized.
    >21:49:13 [INFO] [Permissions] version [3.1.6] (Yeti) loaded
    >21:49:13 [INFO] [MYHOME] 1 homes loaded
    >21:49:13 [INFO] [MYHOME] Permissions enabled using: Permissions v3.1.6
    >21:49:13 [WARNING] [MYHOME] Help plugin not detected. Only providing help via /home help.
    >21:49:13 [INFO] [MYHOME] MyHome 2.0 enabled
    >21:49:13 [INFO] CraftBukkitUpToDate version 2.5.6 is enabled!
    >21:49:13 [INFO] CButD: CraftBukkit is Outdate, try to download new version
    >21:49:21 [INFO] CButD: CraftBukkit download new Build, please stop the server and copy /home/robertm/service28/bukkit_update/craftbukkit-0.0.1-SNAPSHOT.jar to your Main-Folder.
    >21:49:21 [INFO] Loaded vote listener: FlatfileVoteListener
    >21:49:21 [INFO] Votifier enabled.
    >21:49:21 [INFO] [BBROTHER] ------------------------------------
    >21:49:21 [INFO] [BBROTHER] Hello, and thank you for using the TESTING version of BigBrother!
    >21:49:21 [INFO] [BBROTHER] Please note that, since this is far from complete, there will be many bugs.
    >21:49:21 [INFO] [BBROTHER] IF YOU FIND ANY BUGS, PLEASE REPORT THEM ON http://bugs.nexisonline.net/bb
    >21:49:21 [INFO] [BBROTHER] Please stay tuned in irc.esper.net #bigbrother for updates and build notifications.
    >21:49:21 [INFO] [BBROTHER] ------------------------------------
    >21:49:24 [INFO] [BBROTHER] Building `bbdata` table...
    >21:49:24 [INFO] [BBROTHER] BBData H2 Driver r1 loaded!
    >21:49:24 [INFO] [BBROTHER] Building `bbworlds` table...
    >21:49:24 [INFO] [BBROTHER] Building `bbusers` table...
    >21:49:24 [INFO] [BBROTHER] Permissions enabled using: Permissions v3.1.6
    >21:49:24 [WARNING] [BBROTHER] 'Help' isn't detected. No /help support
    >21:49:24 [INFO] [BBROTHER] BigBrother 1.9-SNAPSHOT (build #569) enabled!
    >21:49:24 [INFO] MCBans: mcbans version 2.9.1 is enabled!
    >21:49:24 [INFO] MCBans: Voting enabled!
    >21:49:24 [INFO] MCBans: Debug mode active!
    >21:49:24 [INFO] MCBans: Checking for premium!
    >21:49:24 [INFO] MCBans: Server NOT premium!
    >21:49:24 [INFO] WorldGuard: Permissions plugin detected! Using Permissions plugin for permissions.
    >21:49:24 [INFO] WorldGuard: (world) Single session is enforced.
    >21:49:24 [INFO] WorldGuard: (world) TNT ignition is blocked.
    >21:49:24 [INFO] WorldGuard: (world) Lighters are PERMITTED.
    >21:49:24 [INFO] WorldGuard: (world) Lava fire is blocked.
    >21:49:24 [INFO] WorldGuard: (world) All fire spread is disabled.
    >21:49:24 [INFO] WorldGuard: Loaded configuration for world 'world"
    >21:49:24 [INFO] WorldGuard: (world_nether) Single session is enforced.
    >21:49:24 [INFO] WorldGuard: (world_nether) TNT ignition is PERMITTED.
    >21:49:24 [INFO] WorldGuard: (world_nether) Lighters are PERMITTED.
    >21:49:24 [INFO] WorldGuard: (world_nether) Lava fire is blocked.
    >21:49:24 [INFO] WorldGuard: (world_nether) Fire spread is UNRESTRICTED.
    >21:49:24 [INFO] WorldGuard: Loaded configuration for world 'world_nether"
    >21:49:24 [INFO] WorldGuard: 1 regions loaded for 'world'
    >21:49:24 [INFO] WorldGuard 5.2.3-SNAPSHOT enabled.
    >21:49:24 [INFO] WorldEdit 70-cf3238d enabled.
    >21:49:24 [INFO] WorldEdit: Permissions plugin detected! Using Permissions plugin for permissions.
    >21:49:25 [INFO] BlocksOnGlass version 0.34 is enabled!
    >21:49:25 [INFO] [BlocksOnGlass] Permission system detected.
    >21:49:25 [INFO] [BoatRemover] Booting...
    >21:49:25 [INFO] [BoatRemover] Permissions system detected!
    >21:49:25 [INFO] [BoatRemover] Done!
    >21:49:25 [INFO] [OKB3] Attempting to enable OKB3 v1.3.1 by Kalman Olah...
    >21:49:25 [INFO] [OKB3] Successfully hooked into Permissions.
    >21:49:25 [INFO] [OKB3] Attempting to load configuration file...
    >21:49:25 [INFO] [OKB3] Configuration file successfully loaded.
    >21:49:25 [INFO] [OKB3] Attempting to load PlayerList file...
    >21:49:25 [INFO] [OKB3] PlayerList file successfully loaded.
    >21:49:25 [INFO] [OKB3-MYSQL] Initializing MySQ connection...
    >21:49:25 [SEVERE] [OKB3-MYSQL] SQLException! Access denied for user 'wurldus_ipb'@'184.154.205.2' (using password: YES)
    >21:49:25 [INFO] [OKB3-MYSQL] MySQ connection successful.
    >21:49:25 [INFO] [OKB3] OKB3 v1.3.1 enabled successfully.
    >21:49:25 [INFO] [Permissions] SQ Interface enabled!
    >21:49:25 [INFO] [MYWARP] [MYWARP]: 0 warps loaded
    >21:49:25 [INFO] [MYWARP] Permissions enabled using: Permissions v3.1.6
    >21:49:25 [WARNING] [MYWARP] Help plugin not detected. Only providing help via /warp help.
    >21:49:25 [INFO] [MYWARP] MyWarp 2.0 enabled
    >21:49:25 [WARNING] Version mismatch! Please update EssentialsChat to the same version.
    >21:49:25 [WARNING] Version mismatch! Please update EssentialsSpawn to the same version.
    >21:49:25 [INFO] Loaded Essentials build 2.3.6 by Zenexer, ementalo, Aelux, Brettflan, KimKandor, snowleo, ceulemans and Xeology
    >21:49:25 [WARNING] Version mismatch! Please update all Essentials jars to the same version.
    >21:49:25 [INFO] Loaded EssentialsChat build 2.3.7 by Zenexer, ementalo, Aelux, Brettflan, KimKandor, snowleo, ceulemans and Xeology
    >21:49:25 [WARNING] Version mismatch! Please update all Essentials jars to the same version.
    >21:49:25 [INFO] Loaded EssentialsSpawn build 2.3.7 by Zenexer, ementalo, Aelux, Brettflan, KimKandor, snowleo, ceulemans and Xeology
     
    Robert McKay, Jun 27, 2011
    #288
  20. Offline

    Kalman Olah

    >21:49:25 [SEVERE] [OKB3-MYSQL] SQLException! Access denied for user 'wurldus_ipb'@'184.154.205.2' (using password: YES)
    ...
    So yeah, you don't have remote access yet. Check your webhost's control panel. Maybe there is an option to do it there. If you can't find one, contact them.
     
    Kalman Olah, Jun 27, 2011
    #289
  21. Offline

    Robert McKay

    I sent you an image of the panel after you told be to press _ipb
     
    Robert McKay, Jun 27, 2011
    #290
  22. Offline

    Kalman Olah

    Yeah, and the tab's not there...It should be at the top when you go to PHPMyAdmin, and it should allow you to make a new user with access from all IPs...But it appears your webhost has limited your ability to make new accounts...So yeah...
     
    Kalman Olah, Jun 27, 2011
    #291
  23. Offline

    Robert McKay

    Okay, I got the Error to go away, but I cant seem to be able to whitelist myself?
     
    Robert McKay, Jun 27, 2011
    #292
  24. Offline

    Kalman Olah

    You should know the drill by now :p. Config.yml, config.inc.php, server log
     
    Kalman Olah, Jun 27, 2011
    #293
  25. Offline

    Robert McKay

    config.php:
    <?php //Your mysql host $dbhost = 'localhost'; //Your mysql user $dbuser = 'wurldus_ipb'; //Your mysql password $dbpass = 'PASSWURD'; //Your mysql database $dbname = 'wurldus_ipb'; //Your custom password. #####THIS MUST MATCH THE PHP PASSWORD IN CONFIG.PROPERTIES!##### $phppass = 'PASSWURD'; //The prefix used by your forum tables. Let's say your the table where your usernames are stored in // is called 'phpbb_users'...in this case the prefix is 'phpbb_'. set to $sqlprefix = ''; for no prefix. $sqlprefix = 'wurldus_'; ?>




    config.yml:

    Show Spoiler
    Code:
    [/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]mode: normal[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]'###The mode the plugin will run in, options are ''normal'' or ''old-school''###': ''[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]? '###In old-school mode, the server does NOT check a username/password! It just gets[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]    a rank from your forum DB and sets it as your group###'[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]: ''[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]? '###If you''re using old-school mode, fill in the section labeled ''old-school-mode''[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]    If not, fill in the section labeled ''normal-mode'''[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]: ''[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]mysql-connection-info:[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]    mysql-host: 184.154.137.42[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]    mysql-user: wurldus_ipb[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]    mysql-password: PASSWURD[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]    mysql-database-name: wurldus_ipb[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]old-school-mode:[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]    usertable: user_table[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]    minecraftname-field: mine_user[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]    rank-field: rank_field[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]    enable-multiple-tables: false[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]    '###If enable-multiple-tables is true, fill in the multitable section': ''[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]    multitable:[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]        minecraftname-table: mine_table[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]        useridfield-in-minecraftname-table: user_id_field[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]        useridfield-in-usertable: user_id_field[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]normal-mode:[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]    type-of-forum: ipb[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]    ? '###Current supported forum types md5 for MD5 encryption-based forums,phpbb[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]        for phpBB3, smf for SMF, vbulletin for vBulletin, mybb for myBB, xenforo for[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]        XenForo, ipb for IPB, wbb for WBB, kunena for Kunena###'[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]    : ''[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]    '###Fill in the fields for the forum type that matches your type-of-forum value': ''[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]    location-of-passgenphp: http://wurld.us/forum/webfiles/passgen.php[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]    password-set-in-config-inc-php: PASSWURD[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]    md5:[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]        usertable: user_table[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]        username-field: username_field[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]        userpassword-field: user_pass_field[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]        rank-field: rank_field[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]    phpbb:[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]        usertable: user_table[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]        username-field: username_field[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]        userpassword-field: user_pass_field[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]        rank-field: rank_field[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]    smf:[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]        usertable: user_table[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]        username-field: username_field[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]        userpassword-field: user_pass_field[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]        rank-field: rank_field[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]    vbulletin:[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]        usertable: user_table[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]        username-field: username_field[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]        userpassword-field: user_pass_field[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]        rank-field: rank_field[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]    mybb:[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]        usertable: user_table[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]        username-field: username_field[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]        userpassword-field: user_pass_field[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]        rank-field: rank_field[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]    xenforo:[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]        usertable: user_table[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]        rank-field: rank_field[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]        username-field: username_field[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]        password-table: pass_table[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]        password-field: pass_field[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]        useridfield-in-usertable: user_id_field[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]        useridfield-in-passtable: user_id_field[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]    ipb:[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]        usertable: wurldus_members_[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]        username-field: name[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]        userpassword-field: members_pass_hash[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]        rank-field: member_group_id[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]    wbb:[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]        usertable: user_table[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]        username-field: username_field[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]        userpassword-field: user_pass_field[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]        rank-field: rank_field[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]    kunena:[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]        usertable: user_table[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]        rank-table: rank_table[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]        rank-field: rank_field[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]        username-field: username_field[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]        password-field: pass_field[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]        useridfield-in-usertable: user_id_field[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]        useridfield-in-rank-table: user_id_field[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]groups:[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]    '###''RANKID IN RANKTABLE''=GROUPMANAGER GROUP###': ''[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]    '1': Validating[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]    '2': Guest[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]    '3': Verified[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]    '4': Admins[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]    '5': Banned[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]    '6': Moderator[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]whitelist:[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]    enable-whitelist: 'true'[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]    use-as-blacklist: 'false'[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]    kick-message: You must register @ our forums to join! http://wurld.us/forum/ (not our blog)[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]    whitelist-groups:[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]        '###''''RANKID IN RANKTABLE'': true'' TO ALLOW A RANK TO JOIN###': ''[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]        '###''''RANKID IN RANKTABLE'': false'' TO NOT ALLOW A RANK TO JOIN###': ''[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]        '1': 'false'[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]        '2': 'false'[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]        '5': 'false'[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]        '3': 'true'[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]        '4': 'true'[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]        '6': 'true'[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]'###If use-as-blacklist is enabled, groups that aren''t specified on the whitelist will count as blacklisted###': ''[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]nickname-sync:[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]    enable-nickname-syncing: 'false'[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]    nickname-field-in-usertable: ''[/FONT][/COLOR]
[COLOR=rgb(20, 20, 20)][FONT=Georgia]
    [/code][/FONT][/COLOR]

    Server log looks fine, no use uploading. Yah, whatever, here you go:

    >22:06:54 [INFO] [BBROTHER] Building `bbdata` table...
    >22:06:54 [INFO] [BBROTHER] BBData H2 Driver r1 loaded!
    >22:06:54 [INFO] [BBROTHER] Building `bbworlds` table...
    >22:06:54 [INFO] [BBROTHER] Building `bbusers` table...
    >22:06:54 [INFO] [BBROTHER] Permissions enabled using: Permissions v3.1.6
    >22:06:54 [WARNING] [BBROTHER] 'Help' isn't detected. No /help support
    >22:06:54 [INFO] [BBROTHER] BigBrother 1.9-SNAPSHOT (build #569) enabled!
    >22:06:54 [INFO] MCBans: mcbans version 2.9.1 is enabled!
    >22:06:54 [INFO] MCBans: Voting enabled!
    >22:06:54 [INFO] MCBans: Debug mode active!
    >22:06:54 [INFO] MCBans: Checking for premium!
    >22:06:54 [INFO] MCBans: Server NOT premium!
    >22:06:54 [INFO] WorldGuard: Permissions plugin detected! Using Permissions plugin for permissions.
    >22:06:54 [INFO] WorldGuard: (world) Single session is enforced.
    >22:06:54 [INFO] WorldGuard: (world) TNT ignition is blocked.
    >22:06:54 [INFO] WorldGuard: (world) Lighters are PERMITTED.
    >22:06:54 [INFO] WorldGuard: (world) Lava fire is blocked.
    >22:06:54 [INFO] WorldGuard: (world) All fire spread is disabled.
    >22:06:54 [INFO] WorldGuard: Loaded configuration for world 'world"
    >22:06:55 [INFO] WorldGuard: (world_nether) Single session is enforced.
    >22:06:55 [INFO] WorldGuard: (world_nether) TNT ignition is PERMITTED.
    >22:06:55 [INFO] WorldGuard: (world_nether) Lighters are PERMITTED.
    >22:06:55 [INFO] WorldGuard: (world_nether) Lava fire is blocked.
    >22:06:55 [INFO] WorldGuard: (world_nether) Fire spread is UNRESTRICTED.
    >22:06:55 [INFO] WorldGuard: Loaded configuration for world 'world_nether"
    >22:06:55 [INFO] WorldGuard: 1 regions loaded for 'world'
    >22:06:55 [INFO] WorldGuard 5.2.3-SNAPSHOT enabled.
    >22:06:55 [INFO] WorldEdit 70-cf3238d enabled.
    >22:06:55 [INFO] WorldEdit: Permissions plugin detected! Using Permissions plugin for permissions.
    >22:06:55 [INFO] BlocksOnGlass version 0.34 is enabled!
    >22:06:55 [INFO] [BlocksOnGlass] Permission system detected.
    >22:06:55 [INFO] [BoatRemover] Booting...
    >22:06:55 [INFO] [BoatRemover] Permissions system detected!
    >22:06:55 [INFO] [BoatRemover] Done!
    >22:06:55 [INFO] [OKB3] Attempting to enable OKB3 v1.3.1 by Kalman Olah...
    >22:06:55 [INFO] [OKB3] Successfully hooked into Permissions.
    >22:06:55 [INFO] [OKB3] Attempting to load configuration file...
    >22:06:55 [INFO] [OKB3] Configuration file successfully loaded.
    >22:06:55 [INFO] [OKB3] Attempting to load PlayerList file...
    >22:06:55 [INFO] [OKB3] PlayerList file successfully loaded.
    >22:06:55 [INFO] [OKB3-MYSQL] Initializing MySQ connection...
    >22:06:55 [INFO] [OKB3-MYSQL] MySQ connection successful.
    >22:06:55 [INFO] [OKB3] OKB3 v1.3.1 enabled successfully.
    >22:06:55 [INFO] [Permissions] SQ Interface enabled!
    >22:06:55 [INFO] [MYWARP] [MYWARP]: 0 warps loaded
    >22:06:55 [INFO] [MYWARP] Permissions enabled using: Permissions v3.1.6
    >22:06:55 [WARNING] [MYWARP] Help plugin not detected. Only providing help via /warp help.
    >22:06:55 [INFO] [MYWARP] MyWarp 2.0 enabled
    >22:06:55 [WARNING] Version mismatch! Please update EssentialsChat to the same version.
    >22:06:55 [WARNING] Version mismatch! Please update EssentialsSpawn to the same version.
    >22:06:55 [INFO] Loaded Essentials build 2.3.6 by Zenexer, ementalo, Aelux, Brettflan, KimKandor, snowleo, ceulemans and Xeology
    >22:06:55 [WARNING] Version mismatch! Please update all Essentials jars to the same version.
    >22:06:55 [INFO] Loaded EssentialsChat build 2.3.7 by Zenexer, ementalo, Aelux, Brettflan, KimKandor, snowleo, ceulemans and Xeology
    >22:06:55 [WARNING] Version mismatch! Please update all Essentials jars to the same version.
    >22:06:55 [INFO] Loaded EssentialsSpawn build 2.3.7 by Zenexer, ementalo, Aelux, Brettflan, KimKandor, snowleo, ceulemans and Xeology
    >22:06:55 [INFO] Done (1.366s)! For help, type "help" or "?"




    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: May 16, 2016
    Robert McKay, Jun 27, 2011
    #294
  26. Offline

    Kalman Olah

    usertable should be wurldus_members

    not

    wurldus_members_

    As for the whitelist: when a group is set to false, it CAN'T join. You should also check out the use-whitelist-as-blacklist option. If it is set to true, any group that isn't mentioned in the file is allowed to join. If it is set to false, any group that isn't mentioned in the config.yml is kicked. If it still doesn't work, check your entry for your OWN forum user in the members table, and make sure the value in the field members_group_id matches the groups mentioned in the config.yml.
     
    Kalman Olah, Jun 27, 2011
    #295
  27. Offline

    Robert McKay

    On my forum I am Adminastrator, not an "admins".

    This isnt a hook with Permissions?
     
    Robert McKay, Jun 27, 2011
    #296
  28. Offline

    Kalman Olah

    It is. I meant that the ID in the members_group_id field should match let's say '3': Admins in the config.yml or something. Or '3': true for the whitelist. Make sure your group ID on the forum is actually listed.
     
    Kalman Olah, Jun 27, 2011
    #297
  29. Offline

    Robert McKay

    It works!

    I think... do you mind testing at play.wurld.us?
     
    Robert McKay, Jun 27, 2011
    #298
  30. Offline

    Kalman Olah

    Hang on, I know what your problem is. You have whitelist turned on in normal mode. You can't whitelist your server in normal mode the way you think. Because in normal mode, the whitelist checks a user's rank before they log in. The way it does that is by using saved usernames/encrypted passwords. Those are only stored if someone ALREADY LOGGED IN and used the /bbb sync command.
     
    Kalman Olah, Jun 27, 2011
    #299
  31. Offline

    Robert McKay

    Also, thank you so much for being so patient with me.

    If you set up a paypal, message me and I will donate :D

    Thanks again!
    Trewyy

    ooohhhh, so that means it should be false?

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: May 16, 2016
    Robert McKay, Jun 27, 2011
    #300
Page 10 of 57

Share This Page