EVE Technology Lab

Looks like it's struggling to connect to the jabber database.

I would suggest first seeing if you can actually access the database remotely. If you have SSH access on the same server as the forums use that, if not, use something like the below PHP to test if you can connect to the DB server

    $db_server = "";
    $db_user = "openfire";
    $db_passwd = "";
    $db_name =  "openfiredb";
    

    $link = mysqli_connect($db_server, $db_user, $db_passwd, $db_name);
    
    $sql = "SELECT * FROM  ofUser";
    
    if (!mysqli_query($link,$sql))
      {
      die('Error: ' . mysqli_error($link));
      }

      print "Accessed ok (hopefully)";
    

Try uninstalling the TEA mod and reinstalling. It should keep settings but possibly fix the unable to edit issue.

However yes, openfire support was flakey to start with, and now the method they use is deprecated by UserService.

For my corp I have coded our own solution into our own system, which makes use of SMF forum groups, which uses TEA to manage the groups.

If you know PHP I would strongly recommend looking at this:

https://github.com/Cyerus/Php-OpenFire-UserService

also unistall and reinstall doesn't fix the issue of now being locked out of the jabber settings -_-

could it be a timer that has locked you out? I think I remember seeing something similar for TS but with TS i believe it was user friendly and told me how long to wait before making changes again. If you have scheduled tasks running for jabber, it could be trying to access jabber and continueing to lock you out. Maybe turn that off, then wait and see if you can make changes on the settings.

Is your SMF database also remote? If not, why not just have everything in one place?

so TEA doesn't seem to be writing users to the openfire db despite being setup correctly and cron jobs running fine.

My guess is you don't have both options checked under admin. go to admin > config > temars api > teamspeak and make sure both "use unique id" and "use online check" or whatever they are called are checked and saved. I am thinking you only get a radio option when there are two choices and yours only shows one (unique id).

I'm confused... I just forked TEA so I can update the interface which uses the deprecated User Service plugin for Openfire, so now it uses the "REST API" plugin (as recommend). Now I find out that the User Service plugin got updated... REST API plugin vs User Service plugin dafuq -_-

Anyway, you can find my work on github. I removed any DB requirements for Jabber. All you need is the REST API plugin and the secret key, which you can create after you installed the plugin.

I'll probably create a pull request as soon as I'm happy with it.

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 '' at line 1
File: /****/forum/Sources/TEA.php
Line: 2757

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 2.0.4, while your database is at version 2.0.7. The above error might possibly go away if you execute the latest version of upgrade.php.


Happens when I try to run a check...


What do?

Also looking for an alternative to TEA as it's been nothing but headaches for me. Also not a fan of SMF.

Got old users working just fine

getting another error now...

http://i.imgur.com/EhPzwn8.jpg?1

whenever someone tries to register.


I absolutely despise this plugin

What happened with the database issue that you had in your last issue you report? How did you resolve it? Is this happening for more than one user or is it the same person? have you tried to have them create a new API? Assuming it isn't "user error" then I would have them try to register, and then check the logs to see if there is any additional information that might be helpful. If it is only 1 person, I'd lean towards user error. Try it yourself (unless you are the user). I have a test server you could use if you wanted to see if it is something specific to your server. (you could just cancel the api if the registration goes through).

I'm leaning towards user error or bring more details from the logs that might shed some light.