These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

TEA (v1.3.1) - Member Management Mod for SMF 2, TeamSpeak 3 and Jabber
Author
Previous Topic Next Topic
Slez
Perkone
Caldari State
#141 - 2014-01-22 02:18:25 UTC
Slez wrote:
Shin Chogan wrote:
Slez wrote:


I've tried to telnet to api.eveonline.com 443 and get no response -- i've disabled the windows firewall and still no joy; so I'm stumped.


It would seem to me you need to get basic connectivity to CCP's API server first. As to how to do that if it isn't the Windows Firewall ... I'm afraid I can't help.



Thanks for the reply. I'll dive into it tonight and see what I can figure out. Was getting late last night and I was getting desperate haha; figured I'd see if anyone had had the same issue after going to r5.

IF anyone has experience with 2008 R2 and knows why I'm not getting outbound 443 connections, please share.
(I can't remember if I verified that https:// browsing is functional; although I seem to recall it as working in the past - will verify that 100% tonight)



Follow up: telnet api.eveonline.com 443 is successful (get a blinky cursor until anything is pressed then I get a connection lost message).

Error displayed at the top of the settings page where you enter the API key: API call error while fetching standings: Error Code = 221 for key id = 1976416 API call error while fetching standings: Error Code =

Naella
Negative Density
#142 - 2014-01-22 16:09:07 UTC
Shin Chogan wrote:
Naella wrote:
Hi Shin,

Running SMF 2.0.6
Teamod 1.3.1 r5

I found eventhough I have "Is a Valid Api required to Register?" checked, users can register to our forum without any API filled.
Anyway I can fix this?



I hate to say "it works for me" but .... It works correctly for me ...

So I have to ask :

is there any info in the logs (either SMF's or Apache's) ?
And the obligatory ... Are you 100% sure the option is set ?
Have you tried unchecking the box saving then checking the box again and resaving ?


Hi Shin,

Cant find any specific errors in either apache or smf, where is this setting supposed to be stored?

Doublechecked, the checkmark is there and also did try the off,save,on,save trick.
Without any result.
Shin Chogan
Federal Navy Academy
Gallente Federation
#143 - 2014-01-22 22:36:59 UTC
Slez wrote:

Follow up: telnet api.eveonline.com 443 is successful (get a blinky cursor until anything is pressed then I get a connection lost message).

Error displayed at the top of the settings page where you enter the API key: API call error while fetching standings: Error Code = 221 for key id = 1976416 API call error while fetching standings: Error Code =



as it says it can't get the standings ... the reason looks to be coz the master API key you've entered doesn't allow standings to be fetched. You need to use a corp key.
Shin Chogan
Federal Navy Academy
Gallente Federation
#144 - 2014-01-22 22:56:02 UTC
Magenta Flori wrote:
I am running r4 but change notes didn't say anything about rules with r5, should I try r5? Any gotcha I need to know before upgrading? What is the best way for upgrading, uninstalling and just installing the new?

ok so I upgraded...

getting a lot of these when I run a full member check


API call error while fetching roles: Error Code = 221 for key id = API call error while fetching roles: Error Code = 221 for key id =

Update:

All those errors were occurring on some, not all, accounts that invalid API's. Also the table would show the character name but no details on those accounts when running the member check. I simply removed all those API's and now the error does not occur anymore and they are given No API when the check is ran. So I guess its working, not sure what happened there.

Also skill rules are working now.



Error 221 is CCP's error code for "The api key provided doesn't allow you to fetch that info". For example if you have a rule that looks at skills (which I guess you do Smile) then any api key that doesn't have Character sheet enabled is going to show a 221 error.

And yes as you found r5 does indeed fix skill rules ... I must have forgotten to put it in the notes.
Nutbolt
University of Caille
Gallente Federation
#145 - 2014-01-23 07:12:40 UTC
Naella wrote:
Shin Chogan wrote:
Naella wrote:
Hi Shin,

Running SMF 2.0.6
Teamod 1.3.1 r5

I found eventhough I have "Is a Valid Api required to Register?" checked, users can register to our forum without any API filled.
Anyway I can fix this?



I hate to say "it works for me" but .... It works correctly for me ...

So I have to ask :

is there any info in the logs (either SMF's or Apache's) ?
And the obligatory ... Are you 100% sure the option is set ?
Have you tried unchecking the box saving then checking the box again and resaving ?


Hi Shin,

Cant find any specific errors in either apache or smf, where is this setting supposed to be stored?

Doublechecked, the checkmark is there and also did try the off,save,on,save trick.
Without any result.


I recently upgraded from r4 to r5 and now also have this issue. Tried unchecking and checking again. Out of curiosity Naella do you have the EFTMod installed? (the one which adds in a EFT BB code to display fittings nicely). I have noticed my cron jobs aren't running and I think it is due to this (havn't had time to test yet).

Join Avalon Project Today!
Naella
Negative Density
#146 - 2014-01-23 10:54:47 UTC
Nutbolt wrote:
Out of curiosity Naella do you have the EFTMod installed? (the one which adds in a EFT BB code to display fittings nicely). I have noticed my cron jobs aren't running and I think it is due to this (havn't had time to test yet).


Nope, danot have that mod installed.

Do still have the issue, even after a full uninstall and reinstall of the TEAMARS mod
Shin Chogan
Federal Navy Academy
Gallente Federation
#147 - 2014-01-23 16:44:20 UTC
When you say they don't need a valid api even though the option is ticked do you mean they are entering an api key that doesn't have the right options ticked or that they are not entering an api key at all ?
Nutbolt
University of Caille
Gallente Federation
#148 - 2014-01-23 17:23:02 UTC
Shin Chogan wrote:
When you say they don't need a valid api even though the option is ticked do you mean they are entering an api key that doesn't have the right options ticked or that they are not entering an api key at all ?


Not entering one at all. Just go to our forums to test (www.avalonproject.co.uk/forums).

Join Avalon Project Today!
Naella
Negative Density
#149 - 2014-01-23 17:48:17 UTC  |  Edited by: Naella
Nutbolt wrote:
Shin Chogan wrote:
When you say they don't need a valid api even though the option is ticked do you mean they are entering an api key that doesn't have the right options ticked or that they are not entering an api key at all ?


Not entering one at all. Just go to our forums to test (www.avalonproject.co.uk/forums).



Yup, no API details at all. The check will assign the "no/invalid api" rule I set but registration is allowed.
It shouldn't register at all when no API details at provided.
Shin Chogan
Federal Navy Academy
Gallente Federation
#150 - 2014-01-24 12:51:39 UTC  |  Edited by: Shin Chogan
Nutbolt wrote:
Shin Chogan wrote:
When you say they don't need a valid api even though the option is ticked do you mean they are entering an api key that doesn't have the right options ticked or that they are not entering an api key at all ?


Not entering one at all. Just go to our forums to test (www.avalonproject.co.uk/forums).



Hmmm ... very strange ... can you confirm that there is a tea_regreq entry in you smf_settings table ?

and can you check line 3292 in TEA.php it should read :

if ( !empty($_POST['tea_user_id']) || !empty($_POST['tea_user_api']) || $this -> modSettings['tea_regreq'] )
Magenta Flori
Royal Amarr Institute
Amarr Empire
#151 - 2014-01-24 14:43:11 UTC  |  Edited by: Magenta Flori
confirmed the need a valid api is not working. It just lets people register with it blank

| tea_regreq | 1

line 3292

if ( !empty($_POST['tea_user_id']) || !empty($_POST['tea_user_api']) || $this -> modSettings['tea_regreq'] )
Shin Chogan
Federal Navy Academy
Gallente Federation
#152 - 2014-01-24 16:22:37 UTC
Doh ... found the problem ... I thought I'd tested with no api key but it looks like I just tested with duff ones.

Change line 3295 to read :

if ((empty($chars)) || (gettype($chars) == 'integer'))

and that "should" fix it.
Naella
Negative Density
#153 - 2014-01-24 17:00:45 UTC
Shin Chogan wrote:
Doh ... found the problem ... I thought I'd tested with no api key but it looks like I just tested with duff ones.

Change line 3295 to read :

if ((empty($chars)) || (gettype($chars) == 'integer'))

and that "should" fix it.


That did the job, thanks!
Magenta Flori
Royal Amarr Institute
Amarr Empire
#154 - 2014-01-24 18:04:47 UTC
confirmed.
He dares
School of Applied Knowledge
Caldari State
#155 - 2014-01-27 14:59:19 UTC
How often do you recommend running each cron?
Slez
Perkone
Caldari State
#156 - 2014-01-28 03:10:31 UTC
Shin Chogan wrote:
Slez wrote:

Follow up: telnet api.eveonline.com 443 is successful (get a blinky cursor until anything is pressed then I get a connection lost message).

Error displayed at the top of the settings page where you enter the API key: API call error while fetching standings: Error Code = 221 for key id = 1976416 API call error while fetching standings: Error Code =



as it says it can't get the standings ... the reason looks to be coz the master API key you've entered doesn't allow standings to be fetched. You need to use a corp key.


I've had one of the directors give me a new full corp key (the previous one was "shared")... still getting the same error :(
lasterax
Republic Military School
Minmatar Republic
#157 - 2014-02-03 23:39:01 UTC
First of all Shin, thanks for taking this on. I go back to ESAM with a former alliance and have always preferred SMF and this mod, thanks for updating it!

I'm having a whale of a time with TS3 integration though. Am I to understand it the mod will not work unless you have database access on the server? Our comms are hosted by Lightspeed Gaming so not sure if that would be possible for us or not. I put all the info on for the ServerQuery login but nothing seems to take.

If anyone else has TS3 integration set up and can provide any tips would appreciate it.

--Rax
Magenta Flori
Royal Amarr Institute
Amarr Empire
#158 - 2014-02-06 21:15:34 UTC  |  Edited by: Magenta Flori
Ok got a new one I'm stuck on. Got an ex member, left 8 days ago. Confirmed his API key really shows him as gone yet SMF still shows him as in corp. He has no alts in corp/alliance or any alt that matches any rules with the API key that is provided on his account. I even run full member check manually and it still shows him as in corp/alliance. I try to run php TEA_Cron.php debug but it does not give me anything at all to work with. Not sure how to troubleshoot.

Ok got the debug output sorted. I'm assuming the first number is the user of smf. Main is the main rule and the additional are the other rules. My rule 16 is an alliance rule and the other rule 10 is a corp rule. So it clearly thinks this user is still in alliance/corp? I'm baffled.


[246]=>
array(2) {
["main"]=>
string(2) "16"
["additional"]=>
array(1) {
[0]=>
string(2) "10"
}
}

I even removed his API and re-added it. The same API that I can check with evemon and it shows him as in the NPC corp. After I re-added it, it still put him right back into alliance in SMF.

If I create a rule for the npc corp he is in, it sees it and applies the npc corp rule. When I remove that rule, it puts him right back in Alliance. I do have a neut rule before the alliance rule in case it was looking at history for some reason. Did not matter, still says in Alliance.

https://api.eveonline.com/account/Characters.xml.aspx also shows both characters with this API as in NPC corps.

Spent about 4-5 hours trying to sort this out. I'm stumped.
Magenta Flori
Royal Amarr Institute
Amarr Empire
#159 - 2014-02-07 02:17:25 UTC
lasterax wrote:
First of all Shin, thanks for taking this on. I go back to ESAM with a former alliance and have always preferred SMF and this mod, thanks for updating it!

I'm having a whale of a time with TS3 integration though. Am I to understand it the mod will not work unless you have database access on the server? Our comms are hosted by Lightspeed Gaming so not sure if that would be possible for us or not. I put all the info on for the ServerQuery login but nothing seems to take.

If anyone else has TS3 integration set up and can provide any tips would appreciate it.

--Rax


You will need direct access to the DB. You won't get it from any of the hosting companies as far as I'm aware as they are shared TS3 severs.
Magenta Flori
Royal Amarr Institute
Amarr Empire
#160 - 2014-02-07 18:09:56 UTC  |  Edited by: Magenta Flori
Magenta Flori wrote:
Ok got a new one I'm stuck on. Got an ex member, left 8 days ago. Confirmed his API key really shows him as gone yet SMF still shows him as in corp. He has no alts in corp/alliance or any alt that matches any rules with the API key that is provided on his account. I even run full member check manually and it still shows him as in corp/alliance. I try to run php TEA_Cron.php debug but it does not give me anything at all to work with. Not sure how to troubleshoot.

Ok got the debug output sorted. I'm assuming the first number is the user of smf. Main is the main rule and the additional are the other rules. My rule 16 is an alliance rule and the other rule 10 is a corp rule. So it clearly thinks this user is still in alliance/corp? I'm baffled.


[246]=>
array(2) {
["main"]=>
string(2) "16"
["additional"]=>
array(1) {
[0]=>
string(2) "10"
}
}

I even removed his API and re-added it. The same API that I can check with evemon and it shows him as in the NPC corp. After I re-added it, it still put him right back into alliance in SMF.

If I create a rule for the npc corp he is in, it sees it and applies the npc corp rule. When I remove that rule, it puts him right back in Alliance. I do have a neut rule before the alliance rule in case it was looking at history for some reason. Did not matter, still says in Alliance.

https://api.eveonline.com/account/Characters.xml.aspx also shows both characters with this API as in NPC corps.


Spent about 4-5 hours trying to sort this out. I'm stumped.


UPDATE: I discovered that the smf_tea_cache table was not updating, even when removing and re-adding this users API. So I backed up my DB and truncated that table. Welp, that fixed it. Next time I put the key in and ran full member check it pulled new data from api.eveonline.com. So I guess the question is did I have DB corruption? Why was it pulling from this cache and not updating it? Should I do a cron job to wipe this table out daily? I also have noticed that the full member check was running super fast. Now it is back to running slow with about 10 per page or so. Instead of 100 per page. After that initial run it appears to be using cached data again, even an hour later.