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.
 

phpBB 3.x API Registration Mod v6+

Author
De'Veldrin
Republic University
Minmatar Republic
#521 - 2012-11-07 01:37:47 UTC
Cyerus wrote:
De'Veldrin wrote:
Ok, first time user here. I installed Automod, installed the Eve API mod, cleared the mod, and I can't find the Eve API settings panel. So either I did something wrong, or I'm just blind.

Anyone got any advice?


Advice: Watch the videos.
http://www.youtube.com/playlist?list=PLKWZBmvnMlzEtdIRPGl4O5t_FKx_8NgMm


RTFM.

Good advice.

Thanks mate.

De'Veldrin's Corollary (to Malcanis' Law): Any idea that seeks to limit the ability of a large nullsec bloc to do something in the name of allowing more small groups into sov null will inevitably make it that much harder for small groups to enter sov null.

De'Veldrin
Republic University
Minmatar Republic
#522 - 2012-11-08 19:28:30 UTC
Ok, so I am getting table errors about missing columns now. Reading through the thread, I am seeing that there should be a file called default.sql that I need to run that (I presume) adds the needed columns.

Except there doesn't seem to be a file named that anywhere in the package I downloaded.

Any suggestions?

De'Veldrin's Corollary (to Malcanis' Law): Any idea that seeks to limit the ability of a large nullsec bloc to do something in the name of allowing more small groups into sov null will inevitably make it that much harder for small groups to enter sov null.

Cyerus
University of Caille
Gallente Federation
#523 - 2012-11-08 19:50:37 UTC  |  Edited by: Cyerus
De'Veldrin wrote:
Ok, so I am getting table errors about missing columns now. Reading through the thread, I am seeing that there should be a file called default.sql that I need to run that (I presume) adds the needed columns.

Except there doesn't seem to be a file named that anywhere in the package I downloaded.

Any suggestions?


Yes, watch the videos.
http://www.youtube.com/playlist?list=PLKWZBmvnMlzEtdIRPGl4O5t_FKx_8NgMm
I've made the videos to make the installation and configuration a lot easier.

There is no default.sql since that file became obsolete when I made the install script, which is mentioned in the very first video of the series, named Installation.
ISuper
State War Academy
Caldari State
#524 - 2012-11-09 01:53:52 UTC
Finally i found it:

Quote:

EVE API Generic error: 0 -> API Date could not be read / parsed, original exception: Operation timed out after 10 seconds with 0 bytes received
EVE API error: 0 -> API Date could not be read / parsed, original exception: Operation timed out after 10 seconds with 0 bytes received
Removing user from TeamSpeak group
Removing user from TeamSpeak group
Removing user sessions and disabling account


And after it i successfully activate that user from `User management` with the same API.
Enochia Starr
Caldari Provisions
Caldari State
#525 - 2012-11-09 17:15:16 UTC  |  Edited by: Enochia Starr
nevermind fixed :)
Apollo Eros
Percussive Diplomacy
Sedition.
#526 - 2012-11-10 02:46:13 UTC
Hello There. Great Videos. A couple of questions.

-After install when I goto have my avatar pulled from server it loads this page "/ucp.php?i=profile&mode=avatar" As a blank page and the avatar does not populate.
-Also when I enter my API information it works aok however the teamspeak UID will not save.

Also when registering a new user I added a test corp and had him register initially with email auth on. The user was added but the email auth did not go through like it usually does and loaded a blank page "ucp.php?mode=register" I then turned off email auth and allowed direct registration as long as the corp is listed and it registers the user however still loads the blank screen.

What could be causing this.

Thank you!

[Triple OG LVL 5 Space Wizard]

Aron Fox
Tranquillian Imperial Navy
#527 - 2012-11-13 02:39:00 UTC
Which of the different API parts do you need to have enabled for the registration to work? becaus id does not work only with character sheet.
legi superior
Liga Freier Terraner
Northern Coalition.
#528 - 2012-11-13 11:57:33 UTC  |  Edited by: legi superior
I run into some problems using the Jabber authentification.

When i try to connect with a Forum user/pass there is nothing happening.

The ejabberd.log shows something like this.
The

=INFO REPORT==== 2012-11-13 12:25:39 ===
I(<0.357.0>:ejabberd_listener:232) : (#Port<0.1863>) Accepted connection {{77,185,196,150},50068} -> {{**,**,***,$

=ERROR REPORT==== 2012-11-13 12:25:39 ===
** State machine <0.374.0> terminating
** Last event in was {xmlstreamelement,
{xmlelement,"auth",
[{"xmlns","urn:ietf:params:xml:ns:xmpp-sasl"},
{"mechanism","PLAIN"}],
[{xmlcdata,<<"AFNlcnZhbmRhADk4NzQxMjNjUw==">>}]}}
** When State == wait_for_feature_request
** Data == {state,{socket_state,tls,
{tlssock,#Port<0.1863>,#Port<0.1865>},
<0.373.0>},
ejabberd_socket,#Ref<0.0.0.9730>,false,"2502071781",
{sasl_state,"jabber","***.de",[],
Fun ejabberd_c2s.1.30334249>,
Fun ejabberd_c2s.2.32721014>,
Fun ejabberd_c2s.3.7052687>,undefined,
undefined},
c2s,c2s_shaper,false,true,false,true,
[verify_none,{certfile,"/etc/ejabberd/ejabberd.pem"}],
false,undefined,[],"****.de",[],undefined,
{pres_t,0},
{pres_f,0},
{pres_a,0},
{pres_i,0},
undefined,undefined,undefined,false,
{userlist,none,[],false},
unknown,unknown,
{{77,185,196,150},50068},
"en"}
** Reason for termination =
** {badarg,[{extauth,call_port,2},
{ejabberd_auth_external,check_password_extauth,3},
{ejabberd_auth,check_password_loop,2},
{cyrsasl_plain,mech_step,2},
{cyrsasl,server_step,2},
{ejabberd_c2s,wait_for_feature_request,2},
{p1_fsm,handle_msg,10},
{proc_lib,init_p_do_apply,3}]}



Edit

Ok i solved this problem.
in your ejabberd_side.php In Line 160 and 171 it says
return doXML($fields); but should be
return $this->doXML($fields);
This made the auth script crash.
STrike3Ds
White Shadow Federation
#529 - 2012-11-13 13:32:43 UTC
Great job Cyerus.

Are we able to use this for Mumble or only for TS3?
Suleiman Shouaa
The Tuskers
The Tuskers Co.
#530 - 2012-11-13 19:03:03 UTC
Really excellent mod with great support. +1

However, I do have a slight issue. Some of the accounts fail the API check and get disabled. However, when I go into the ACP and re-enable their account then check their API key that way, it works fine and they get assigned to the correct usergroup etc.

Any idea what's going on?
legi superior
Liga Freier Terraner
Northern Coalition.
#531 - 2012-11-13 21:30:43 UTC  |  Edited by: legi superior
I had the same Problem. I removed the Line that disables forum accounts. For my purpos it's enough to remove users from the groups. Should this happen again they will be reasigned with the next croncycle.
ISuper
State War Academy
Caldari State
#532 - 2012-11-15 03:22:14 UTC  |  Edited by: ISuper
ISuper wrote:
Finally i found it:

Quote:

EVE API Generic error: 0 -> API Date could not be read / parsed, original exception: Operation timed out after 10 seconds with 0 bytes received
EVE API error: 0 -> API Date could not be read / parsed, original exception: Operation timed out after 10 seconds with 0 bytes received
Removing user from TeamSpeak group
Removing user from TeamSpeak group
Removing user sessions and disabling account


And after it i successfully activate that user from `User management` with the same API.



>EVE API Generic error: 0 -> API Date could not be read / parsed, original exception: HTTP Request Failed
>EVE API error: 0 -> API Date could not be read / parsed, original exception: HTTP Request Failed
>Removing user from TeamSpeak group
>Removing user from TeamSpeak group
>Removing user sessions and disabling account

There is another problem: eveapi_cron.php working 6 minutes after running(:
Cyerus
University of Caille
Gallente Federation
#533 - 2012-11-15 23:35:02 UTC  |  Edited by: Cyerus
Apollo Eros wrote:
Hello There. Great Videos. A couple of questions.

-After install when I goto have my avatar pulled from server it loads this page "/ucp.php?i=profile&mode=avatar" As a blank page and the avatar does not populate.
-Also when I enter my API information it works aok however the teamspeak UID will not save.

Also when registering a new user I added a test corp and had him register initially with email auth on. The user was added but the email auth did not go through like it usually does and loaded a blank page "ucp.php?mode=register" I then turned off email auth and allowed direct registration as long as the corp is listed and it registers the user however still loads the blank screen.

What could be causing this.

Thank you!


Probably a permission issue with the avatar; I'm guessing they aren't allowed to be saved in the avatar folder, you'll need to google phpBB folder permissions or something similar to check whether or not all the correct permissions are set.

TeamSpeak UID not being saved is caused by something going wrong between the forum and the TeamSpeak server, most likely not being able to connect or not having enough permissions to set groups.
I'm in the process of adding error-checks to the TeamSpeak connection, but it will take some time before being released.


Aron Fox wrote:
Which of the different API parts do you need to have enabled for the registration to work? becaus id does not work only with character sheet.


Public Information -> CharacterInfo = 8388608
Public Information -> FacWarStats = 64


STrike3Ds wrote:
Great job Cyerus.

Are we able to use this for Mumble or only for TS3?


TeamSpeak 3 only.

I don't support Mumble (even though it has been requested a couple of times) simply because of Mumble's weird design of API. It requires to have an additional 3rd-party PHP extension to be enabled on the webhost before you can even connect to the Murmur server using the API, which they forgot about the fact that many webhosts don't allow any extensions outside of the default PHP package, and rarely no extensions at all. So even if I build something like this, many people still won't be able to use it, making it not really worth my time.


legi superior wrote:
* snip *
Ok i solved this problem.
in your ejabberd_side.php In Line 160 and 171 it says
return doXML($fields); but should be
return $this->doXML($fields);
This made the auth script crash.


Thanks! Package has been fixed.
Cyerus
University of Caille
Gallente Federation
#534 - 2012-11-15 23:41:03 UTC
Hereby I'm releasing version 6.1.1


  • Improved error-handling to avoid disabled accounts caused by connection issues


Default update instructions apply, and don't forget to clear your cache.

Download can be found in the first post of this topic as usual.
Let me know if you come across any other issues.
JustSharkbait
University of Caille
Gallente Federation
#535 - 2012-11-16 00:08:52 UTC
Works great. Love it. Keep it up.

:)

is the jabber part you are working on going to allow registration on a jabber server via the forums?

Hoo Ha Ha!!

Cyerus
University of Caille
Gallente Federation
#536 - 2012-11-16 11:55:33 UTC
JustSharkbait wrote:
Works great. Love it. Keep it up.

:)

is the jabber part you are working on going to allow registration on a jabber server via the forums?


Technically no; it's much simpler than that.

Whenever an users tries to connect to ejabberd, ejabberd then connects to phpBB (automated process) to ask if the user/pass combination is allowed to connect. This way we only have to keep one user database (phpBB), since ejabberd doesn't store any information.
rylia Crestfall
The Illuminatii
Wrecktical Supremacy.
#537 - 2012-11-16 15:42:04 UTC
is it possible to automatic assign users with a certain role within a corp to a group?
Allorria
Forge Trilogy Incorporated
#538 - 2012-11-18 05:18:22 UTC
My TS3 host requires that I use a virtual server ID number when issuing commands to the query port. Any advise on how to set this up to work with this mod?
Gidgets
Sons of the Confederacy
#539 - 2012-11-19 03:07:39 UTC
When I try to run eveapi_cron.php I get the following error message. Do you happen to know how to fix it?

Fatal error: Uncaught exception 'TeamSpeak3_Transport_Exception' with message 'Connection refused' in /home/content/55/8780655/html/5otc/includes/eveapi/TeamSpeak3/Transport/TCP.php:54 Stack trace: #0 /home/content/55/8780655/html/5otc/includes/eveapi/TeamSpeak3/Transport/TCP.php(108): TeamSpeak3_Transport_TCP->connect() #1 /home/content/55/8780655/html/5otc/includes/eveapi/TeamSpeak3/Adapter/ServerQuery.php(76): TeamSpeak3_Transport_TCP->readLine() #2 /home/content/55/8780655/html/5otc/includes/eveapi/TeamSpeak3/Adapter/Abstract.php(60): TeamSpeak3_Adapter_ServerQuery->syn() #3 /home/content/55/8780655/html/5otc/includes/eveapi/TeamSpeak3/TeamSpeak3.php(310): TeamSpeak3_Adapter_Abstract->__construct(Array) #4 /home/content/55/8780655/html/5otc/eveapi_cron.php(277): TeamSpeak3::factory('serverquery://a...') #5 {main} thrown in /home/content/55/8780655/html/5otc/includes/eveapi/TeamSpeak3/Transport/TCP.php on line 54
ISuper
State War Academy
Caldari State
#540 - 2012-11-19 10:58:16 UTC  |  Edited by: ISuper
Gidgets wrote:
When I try to run eveapi_cron.php I get the following error message. Do you happen to know how to fix it?

Fatal error: Uncaught exception 'TeamSpeak3_Transport_Exception' with message 'Connection refused' in /home/content/55/8780655/html/5otc/includes/eveapi/TeamSpeak3/Transport/TCP.php:54 Stack trace: #0 /home/content/55/8780655/html/5otc/includes/eveapi/TeamSpeak3/Transport/TCP.php(108): TeamSpeak3_Transport_TCP->connect() #1 /home/content/55/8780655/html/5otc/includes/eveapi/TeamSpeak3/Adapter/ServerQuery.php(76): TeamSpeak3_Transport_TCP->readLine() #2 /home/content/55/8780655/html/5otc/includes/eveapi/TeamSpeak3/Adapter/Abstract.php(60): TeamSpeak3_Adapter_ServerQuery->syn() #3 /home/content/55/8780655/html/5otc/includes/eveapi/TeamSpeak3/TeamSpeak3.php(310): TeamSpeak3_Adapter_Abstract->__construct(Array) #4 /home/content/55/8780655/html/5otc/eveapi_cron.php(277): TeamSpeak3::factory('serverquery://a...') #5 {main} thrown in /home/content/55/8780655/html/5otc/includes/eveapi/TeamSpeak3/Transport/TCP.php on line 54


you could try to restart TS server first