open All Channels
seplocked EVE Technology Lab
blankseplocked [EVEOTS] Eve Online Teamspeak 3 API Registration with PHP5 v1.5
 
This thread is older than 90 days and has been locked due to inactivity.


 
Pages: 1 2 3 4 [5] 6

Author Topic

Pedrosito85
Posted - 2011.06.24 05:23:00 - [121]
 

Directing this question to Mr. MJ Maverick,

I am currently working to set up and install the EVEOTS app on my web host. I have a paid service web host and I run my own teamspeak server off a virtual windows server I lease as well (and have full access to the server OS).

I was able to set up, configure, and run the web interface. However, during TS registration I am hitting the F10 - Connection refused error. Using the verbose=true method, I see that this is the only error I am receiving during the registration attempt. I have tried a number of things but I am uncertain on how best to proceed. I have tried all of the following:

1. Resetting the ServerQuery login to a new user/pass combo
2. Ensured the web server IP address was included in the whitelist.txt file.
3. Shutdown TS3 and restarted after added the entry in the whitelist file.
4. Made sure serverquery port was passing properly over the firewall to the correct TS server IP
5. Logged in locally with the serveradmin locally on the TS server, manually ran the ServerQuery and kicked my standard user account out of the server.
6. Used the same ServerQuery login info in the config.php file and still got connection refused error.
7. Got frustrated (Evil or Very Mad), planted C4 on the server (Rolling Eyes), blew it up (Twisted Evil), felt bad, rebuilt it from scratch, used default serverquery logins, same issue.
8. Gave up and wrote this post.

Any help you can offer would be greatly appreciated. There may even be ISK involved with the person that can help me get this up and running.ugh

Let me know if you have any ideas.

Thanks,

- Pedro

Morgenholt Blue
RED.Legion
Posted - 2011.06.25 06:49:00 - [122]
 

Edited by: Morgenholt Blue on 25/06/2011 06:50:00
Originally by: Kiyra Chi'Amo
MJ, any thoughts on this one?

I used your api reg and found that on my character name the array does not like the return from the api. It comes back to tell me that my name is Kiyra Chi\'Amo and not Kiyra Chi'Amo. When it compares that to the return from api it sees the difference and does not allow access. Any ideas... also when processing the registration I have had both test users get stuck at step 3 and cannot continue from there.

THx


I haven't really had a chance to test this fix due to having no characters with ' in there name but I changed
$inputName = trim($_POST["inputName"]); in index.php to:
$inputName = trim(stripslashes($_POST["inputName"])); and it gets it past the first stage. Again completely untested all I know is that it gets it past the first error.


MJ Maverick
IronPig
Sev3rance
Posted - 2011.06.25 18:02:00 - [123]
 

Hey Pedro, there are a few possibilities.

Have you made sure that your VPS host hasn't got the query port (default 10011) blocked by a firewall? Check with them and make sure it's forwarded correctly. If that's not the problem send me a mail with some TS information and I'll have a rummage around.

As a connection is being sucessfully made it doesn't look like it's your web server. The VPS is actively blocking the connection.

Pedrosito85
Posted - 2011.06.25 22:38:00 - [124]
 

MJ,

Thanks for the reply.

I double checked the firewall settings and I am in fact passing port traffic to the local IP of the TS server:

Rule Name,Listen Link,Host,Listen IP,Application,Listen Port,Protocol,Forward IP,Forward Port,Enable,Enable Logging,Description
TeamSpeak_Server_API,wan2,<<REMOVED>>,WAN IP,ANY,10011,ANY,10.10.10.206,10011,Yes,0,


Here is what I have in my config file:
----------------------------------------------------
class Config {
// Administrators character
public $admin = "Pedrosito85";
// Teamspeak 3 Server Query Information (REQUIRED)
public $tshost = "used FQDN (domain name) and IP - same result";
public $tsname = "REMOVED";
public $tspass = "REMOVED";
public $tsport = "10011"; //ServerQuery Port
public $tscport = "9987"; //TeamSpeak client port
// Database Information (REQUIRED)
public $db_host = "REMOVED";
public $db_user = "REMOVED";
public $db_pass = "REMOVED";
public $db_name = "REMOVED";
// API Connection Testing Information (REQUIRED) - TESTID and TESTname MUST be the characterID and characterName of the SAME character respectively
public $TESTID = 935338328;
public $TESTname = "MJ Maverick";
// Your alliance/corp name
public $ourname = "Alliance";
// Alliance Whitelist Information (REQUIRED) - Example: ("Alliance1","Alliance 2");
public $allyList = array("Alliance");
// Corporation Whitelist Information (REQUIRED) - Example: ("Corporation1","Corporation 2");
public $corpList = array("Corporation");
// Debug Mode? (true/false)
public $verbose = true;
// Teamspeak 3 group for alliance/corp members
public $group = 9;
// Teamspeak 3 group for people on the whitelist but not in your alliance/corp
public $bluegroup = 8;
// Banner Image
public $banner = "images/banner.jpg";
// Optional ticker spacers. - Example: For "IRNP | MJ Maverick" use "|".
public $spacer = "|";
}
----------------------------------------------------






Here is the debug info from stage 1 (prior to clicking register)
----------------------------------------------------
Debug: Running: Teamspeak 3 PHP Framework version: 1.1.5-beta

API Connection was established.

Checking...
Character: Pedrosito85
Debug: User ID: <<REMOVED>>
Debug: API Key: <<REMOVED>>

Debug: Character ID: 90202605

Debug: Character List:
Debug: Pedrosito85

Debug: API verified.

You are on our alliance whitelist

Debug: Getting your corp ticker... WOLS
Debug: Getting your alliance ticker... RB
Please connect to Teamspeak 3 using the following details:
Address: <<REMOVED>>:9987
Nickname: "WOLS | Pedrosito85"

Once connected, click register.
----------------------------------------------------






Here is the error after I click register:
----------------------------------------------------
Attempting to grant access to: WOLS | Pedrosito85...

An error occured: Connection refused [F10]
----------------------------------------------------




I can never get past that point. Mad

Thanks for any help in advance.


- Pedro

d3athmane
Caldari
Distinguished Gentleman's Boating Club
Test Alliance Please Ignore
Posted - 2011.06.26 05:25:00 - [125]
 

Edited by: d3athmane on 26/06/2011 05:25:41
Is there a way to NOT make use of the alliance whitelist Requirement? I have 2 corps that share one TS3, but are not in an alliance.

MJ Maverick
IronPig
Sev3rance
Posted - 2011.06.27 18:33:00 - [126]
 

Yeah, just don't use the alliance list. Leave it empty. Just put the two corp names in the Corp List.

@Pedrosito85 I'm talking with the Teamspeak chaps about this one... Seems very odd.

Pedrosito85
Posted - 2011.06.27 19:22:00 - [127]
 

Thanks MJ.

I shall await news of your discoveries.

Kiyra Chi'Amo
Posted - 2011.07.08 15:06:00 - [128]
 

Originally by: Morgenholt Blue
Edited by: Morgenholt Blue on 25/06/2011 06:50:00
Originally by: Kiyra Chi'Amo
MJ, any thoughts on this one?

I used your api reg and found that on my character name the array does not like the return from the api. It comes back to tell me that my name is Kiyra Chi\'Amo and not Kiyra Chi'Amo. When it compares that to the return from api it sees the difference and does not allow access. Any ideas... also when processing the registration I have had both test users get stuck at step 3 and cannot continue from there.

THx


I haven't really had a chance to test this fix due to having no characters with ' in there name but I changed
$inputName = trim($_POST["inputName"]); in index.php to:
$inputName = trim(stripslashes($_POST["inputName"])); and it gets it past the first stage. Again completely untested all I know is that it gets it past the first error.




I actually got inspired to write my own API registration system thanks to MJ. I had the same issue with mine and figured out that it was a string in the php config file that was causing that to happen. After correcting the setting I was able to get the proper return.

Kiyra Chi'Amo
Posted - 2011.07.08 15:18:00 - [129]
 

@Pedro

What are you using as a database server? MySQL Server?

Sounds like the script cannot establish another open connection to the database to input data to the users table. Maybe open up more allowed connections to see if that corrects the issue. Just a thought.

GL

trader4040404
Posted - 2011.07.11 21:18:00 - [130]
 

Is there anyway to make the "alliance" or "corp" array list read from a database rather than having to alter the config file every time you want to allow/deny registrations? ie directors of a given corp/alliance can alter who gains access via a simple web interface?

MJ Maverick
IronPig
Sev3rance
Posted - 2011.07.15 16:48:00 - [131]
 

Edited by: MJ Maverick on 15/07/2011 16:48:30
No, but I have taken your idea on-board... I like it.

v1.31
Teamspeak 3 only supports character names up to 30 characters. Any nicknames that come to more than that will no longer cause registration problems.

T0m Cruise
Posted - 2011.07.19 17:45:00 - [132]
 

Hello MJ Maverick,

I don't see a whole lot of other replies for a while, so I hope I'm not missing something. I downloaded the zip you provided and went through the whole setup pretty well, but ran into the following after I log in to my TS server with the user-name I am given and try to use the register button on the web page:

Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL server at 'reading initial communication packet', system error: 111 in /var/www/localhost/htdocs/eveots/functions.php on line 59
Could not connect: Lost connection to MySQL server at 'reading initial communication packet', system error: 111 [F61]

Before this error happened, I had to edit my php.ini file to allow more max_execution_time and the memory_limit well over 128M. It seems like the registration is taking up a lot of resources. Has anyone else encountered this problem? Maybe I'm missing something.


Best regards,
T0m Cruise

T0m Cruise
Posted - 2011.07.19 23:43:00 - [133]
 

Edited by: T0m Cruise on 21/07/2011 22:34:01
Edited by: T0m Cruise on 20/07/2011 07:12:38
Originally by: T0m Cruise

Before this error happened, I had to edit my php.ini file to allow more max_execution_time and the memory_limit well over 128M. It seems like the registration is taking up a lot of resources. Has anyone else encountered this problem? Maybe I'm missing something.



I modified php.ini again to see what the error was before:

Fatal error: Allowed memory size of 1342177280 bytes exhausted (tried to allocate 523800 bytes) in /var/www/localhost/htdocs/eveots/TeamSpeak3/Transport/TCP.php on line 148

Why is it trying to allocate 523800 bytes and then hits the limit 1280MB? That is quite a bit of data. Not sure what I messed up here.

Update - now it's trying to download the index.php page, not sure what is going wrong here. Feel like I'm talking to myself, someone please help me not feel so dumb.

MJ Maverick
IronPig
Sev3rance
Posted - 2011.07.23 18:14:00 - [134]
 

Hi, sorry about the delay T0m.

I have no idea why so much memory is being *****d. What PHP and MySQL versions are you running? Have you tried running PHP in strict mode? Personally I'd contact your host... This seems like a pretty drastic server mess.

T0m Cruise
Posted - 2011.07.23 20:30:00 - [135]
 

Originally by: MJ Maverick
Hi, sorry about the delay T0m.

I have no idea why so much memory is being *****d. What PHP and MySQL versions are you running? Have you tried running PHP in strict mode? Personally I'd contact your host... This seems like a pretty drastic server mess.


Thanks for getting back to me MJ, no problem man. I'm sure you're busy doing other stuff. I figured out what the problem was just moments ago. I made my own queryserver login instead of using the admin that was created when I started up my TS3 server the first time. Seems like the error I was experiencing was caused by not having enough permissions. Maybe a memory leak or something looping in the background(not sure)? Anyways, thanks again for getting back to me. Hope this helps you with your project here. Awesome job buddy!

MJ Maverick
IronPig
Sev3rance
Posted - 2011.07.24 16:37:00 - [136]
 

Thanks T0m, I'll make a note of that error and see if anything can be done to notify you of such problems.

Keil Sonter
Posted - 2011.08.11 01:28:00 - [137]
 

Edited by: Keil Sonter on 11/08/2011 01:29:02
Hi,

Nice script and thank you for your work on this.

I have setup a server and am having some issues when trying to register - getting the dreaded F10 error with connection timeout.

The problem seems to be with the server query and I will be checking with my hosting company to ensure it is enabled and has a default setup. However I wondered if you could advise on any checks I can perform to diagnose the problem and ensure it is at the server end or at my website?

Can you confirm that users are added to the database after a successful connection to the server as at the moment no users are being logged to the dbase at registration.

Any assistance is much appreciated.

Jack Lagoon
Posted - 2011.08.15 09:01:00 - [138]
 

Any word yet on the F10 error? Still getting that error as well when trying to register with this script.

king curt
Caldari
The Maverick Navy
Against ALL Authorities
Posted - 2011.08.17 17:08:00 - [139]
 

I was having the F10 issue, but fixed it by using the "serveradmin"/"password" combination when you first set up your TS.

If you don't have it or don't remember it go to server query login and create a new one to a "name" and it will give you a new "password". ***Note*** it does not seem to like a space in the name, so if you have a two word name like "joe blow" use "joeblow" when generating a new password for the server query login.

Put that in your config.

$tsname="serveradmin" or "joeblow"
$tspass="PW when you first set up TS" or "PW issued for server query login when creating one using a new name"

At least this is what worked for me.

Also do not forget the port number when making your connection to TS when it asks you to connect during the registration process. I found that by not using the port number it was giving an F25 error.

Dutch Psycho00
Posted - 2011.08.20 16:11:00 - [140]
 

i aswell still have the issue with the time out (f10) error.

not matter what i try it keeps popping up.
or when i try a localhost db it keeps giving me the error(f61) cant connect to mysql.

what am i doing wrong?

- dutch

Duc Lebowski
Posted - 2011.08.21 10:50:00 - [141]
 

I am trying to work this script out and its working like a charm with 1 fault i cant seem to beat here is the verbose i hope somone can help fix this as its awsome and the coding looks fine.

-----------------------------
Step 2

Debug: Running: Teamspeak 3 PHP Framework version: 1.1.5-beta

API Connection was established.

Checking...
Character: Duc Lebowski

Debug: API Key: *****

Debug: Character ID: *****

Debug: Character List:
Debug: Duc Lebowski

Debug: API verified.

You are on our corp whitelist
Debug: Getting your corp ticker... XOHX
Please connect to Teamspeak 3 using the following details:
Address: *****:7715
Nickname: XOHX - Duc Lebowski

-----------------
Then this

Attempting to grant access to: XOHX - Duc Lebowski...

An error occured: invalid URI supplied [F10]

Ive checked with the host the domain IP has been added to the white list and the details are fine exact to the TS server how on earth can i fix this

Jabberwockeee
Posted - 2011.08.21 11:07:00 - [142]
 

Quote:
I was having the F10 issue, but fixed it by using the "serveradmin"/"password" combination when you first set up your TS.

If you don't have it or don't remember it go to server query login and create a new one to a "name" and it will give you a new "password". ***Note*** it does not seem to like a space in the name, so if you have a two word name like "joe blow" use "joeblow" when generating a new password for the server query login.

Put that in your config.



Now thats fixed and now getting Attempting to grant access to: XOHX - Duc Lebowski...

An error occured: Connection timed out [F10]

Keil Sonter
Posted - 2011.08.21 15:11:00 - [143]
 

Hi,

Made some progress and figuring out how this app works :)

Discovered the outgoing ports were blocked from my shared hosting. Anyone else getting [F10] - Connection Timeout - its probably the same reason - check with your host.

Once I setup the app on a VPS with ports enabled and had no problems other than a glitch which occurred due to having set the groupID's set incorrectly but once setup right the app worked a treat.

One 'issue' I now see is having multiple accounts and trying to add alts from these. I get - [F25] duplicate entry - which I guess is because the unique id for the connection via the client is the same value.

I'd like to add multiple accounts and have a different alt connect via the client so need a way to add these.

Good work you've done here and I'd like to see this app being a bit more sophisticated with web enabled admin to modify the corps/alliances to an additional table in the d'base rather than editing the config via FTP.

Dutch Psycho00
Posted - 2011.08.21 19:48:00 - [144]
 

Originally by: Keil Sonter
Hi,

Made some progress and figuring out how this app works :)

Discovered the outgoing ports were blocked from my shared hosting. Anyone else getting [F10] - Connection Timeout - its probably the same reason - check with your host.

Once I setup the app on a VPS with ports enabled and had no problems other than a glitch which occurred due to having set the groupID's set incorrectly but once setup right the app worked a treat.

this solved my f10 connection timed out error
thnx for this
reason for timeout was cause of fact some ports that were used by the script were indeed closed
One 'issue' I now see is having multiple accounts and trying to add alts from these. I get - [F25] duplicate entry - which I guess is because the unique id for the connection via the client is the same value.

I'd like to add multiple accounts and have a different alt connect via the client so need a way to add these.

Good work you've done here and I'd like to see this app being a bit more sophisticated with web enabled admin to modify the corps/alliances to an additional table in the d'base rather than editing the config via FTP.


MJ Maverick
IronPig
Sev3rance
Posted - 2011.08.23 23:39:00 - [145]
 

Hi chaps, best thing to do if you are having problems is read the previous pages. All these errors have been had before. Failing that mailing me in game is the quickest way to get a hold of me.

[F10] = The web server failed to connect to the TS. So things you need to check are, firewalls, blocked ports, if it's actively refused then you need to make sure you are using a SQAdmin that was created by a person with FULL SA on TS. Remember to check with your provider for blocked ports on both the web server and the TS. Also some TS providers like to disable ServerQuery because they are "special". The kind of special you put on a bus and send on it's merry way as far away from the rest of humanity as possible.

@Keil Sonter, users are only entered into the database once they have been successfully registered.

@Dutch Psycho00, I only advise using a local database, in these cases you need to double and triple check your database details. Try recreating a new one, remember spaces can be bad. Failing that make sure your host hasn't been "special" and disabled any modifications of the database that aren't done manually.

@Duc Lebowski, I'm looking into URI's but for now I believe it's invalid login credentials.

MJ Maverick
IronPig
Sev3rance
Posted - 2011.08.29 00:13:00 - [146]
 

Update: v1.5
Admin panel added.
All admin actions are logged.
Security level allows you to have admins and just whitelist operators.
Admin lists stream the admins current corp/alliance.
Cron job updates whitelist member counts.
Change password.
Admins can edit admin accounts easily.
Whitelist is now totally databased.
Cron.php in /admin/ added to optionally update whitelist member counts.

Keil Sonter
Posted - 2011.08.29 03:46:00 - [147]
 

Originally by: MJ Maverick
Update: v1.5
Admin panel added.
All admin actions are logged.
Security level allows you to have admins and just whitelist operators.
Admin lists stream the admins current corp/alliance.
Cron job updates whitelist member counts.
Change password.
Admins can edit admin accounts easily.
Whitelist is now totally databased.
Cron.php in /admin/ added to optionally update whitelist member counts.


Excellent work MJ Very Happy

This has added some much needed sophistication to your work - small donation heading your way...


MJ Maverick
IronPig
Sev3rance
Posted - 2011.08.29 04:09:00 - [148]
 

You're more than welcome, and yay \o/ :D

MillerUk
Caldari
Knights Of Divinity
Unforgiving.
Posted - 2011.08.29 17:59:00 - [149]
 

Edited by: MillerUk on 29/08/2011 18:02:44
Nice work MJ!

Altered the admin system to fit my needs and removed the need to login based on previous sessions made from website so i dont have to use mutiple logins

Also added option to list all registered members and their TS id, can also edit a member (usefull if they change corp so i can change the ticker without having to use database editing)

Mediek Ordos
Caldari
Association of Commonwealth Enterprises
Imperial 0rder
Posted - 2011.08.30 05:11:00 - [150]
 

Originally by: MillerUk
Edited by: MillerUk on 29/08/2011 18:02:44
Nice work MJ!

Altered the admin system to fit my needs and removed the need to login based on previous sessions made from website so i dont have to use mutiple logins

Also added option to list all registered members and their TS id, can also edit a member (usefull if they change corp so i can change the ticker without having to use database editing)

Nice, and usefull, are you going to share your adjustments ?
Ill drop you admin link later MJ, we alterd the templates again :-) worked sweet as a nut again nice one m8ty :-)


Pages: 1 2 3 4 [5] 6

This thread is older than 90 days and has been locked due to inactivity.


 


The new forums are live

Please adjust your bookmarks to https://forums.eveonline.com

These forums are archived and read-only