Pages: 1 2 [3] 4 :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
qu1ckkkk
The Warp Core Stabilizers Spies R' Us
2
|
Posted - 2012.10.18 16:13:00 -
[61] - Quote
In the light of CCP making the HTTPS moves on api.eveonline.com, I suspect API Calls are now broken for jackknife. I haven't had time to look into investigating it yet or checking the code to fix this, but take this as a FYI :) |
Equto
Imperium Technologies Get Off My Lawn
17
|
Posted - 2012.10.18 16:29:00 -
[62] - Quote
You are correct, for people using the SVN this has been updated. A patch will be released shortly for everyone else |
Alina Thano
Shadow Jumpers
0
|
Posted - 2012.10.18 18:39:00 -
[63] - Quote
With the updated patch i still got a nice list of error's
Notice: Trying to get property of non-object in /xxx/xxxxx/xxxxx/jackknife/index.php on line 152
Same for line's: 155,156,159,162
and
Call to a member function xpath() on a non-object in /xxxxx/xxxxx/public_html/jackknife/index.php on line 162
any one else with this issue? |
Troy Aihaken
THE SARCASTIC BASTARDS. Hoist The Colors
1
|
Posted - 2012.10.18 19:17:00 -
[64] - Quote
Same here CO-EXEC THE SARCASTIC BASTARDS.-á
|
qu1ckkkk
The Warp Core Stabilizers Spies R' Us
2
|
Posted - 2012.10.19 05:27:00 -
[65] - Quote
Equto wrote:You are correct, for people using the SVN this has been updated. A patch will be released shortly for everyone else
The code is incorrect based on : http://code.google.com/p/eve-jackknife/source/detail?r=53
Line 27 of "eveApi/eveApiCaching.php" should say:
[...] define("API_BASE_URL","https://api.eveonline.com"); [...]
That should fix it. |
Equto
Imperium Technologies Get Off My Lawn
17
|
Posted - 2012.10.19 14:06:00 -
[66] - Quote
The problem for most is likely due to not having a ca-cert file with their curl install. I am currently packaging a new update that includes a generic version of this file to allow jackknife to work again.
will upload when googlecode stops being in read-only mode |
Dragonaire
Corax. The Big Dirty
48
|
Posted - 2012.10.19 15:50:00 -
[67] - Quote
Everyone might be interested in looking at my post on another thread about how to properly making the change.
https://forums.eveonline.com/default.aspx?g=posts&m=2067392#post2067392 Finds camping stations from the inside much easier. Designer of Yapeal for Eve API. Check out the Yapeal PHP API library thread for more information. |
Equto
Imperium Technologies Get Off My Lawn
17
|
Posted - 2012.10.19 15:58:00 -
[68] - Quote
I am using a cert file by CAcert as its one I have on hand and have assured to work. I understand the importance of the https and will not "disable" it |
qu1ckkkk
The Warp Core Stabilizers Spies R' Us
2
|
Posted - 2012.10.19 17:12:00 -
[69] - Quote
Exactly this. Equto's code is incorrect by trying to use eve-online.com for API calls as there is not a valid cert on the domain, and hence CURL freaking out. NO, do not change it to "VALIDATE_PEER" : false.
Simply change the URL to eveonline.com ( no - ) as that domain has a valid wildcard cert. No need for "cert files"... |
Equto
Imperium Technologies Get Off My Lawn
17
|
Posted - 2012.10.19 17:24:00 -
[70] - Quote
qu1ckkkk wrote:Exactly this. Equto's code is incorrect by trying to use eve-online.com for API calls as there is not a valid cert on the domain, and hence CURL freaking out. NO, do not change it to "VALIDATE_PEER" : false. Simply change the URL to eveonline.com ( no - ) as that domain has a valid wildcard cert. No need for "cert files"... Actually it still needs a cert file as its ssl and curl needs a cert file to validate the connection. |
|
qu1ckkkk
The Warp Core Stabilizers Spies R' Us
2
|
Posted - 2012.10.19 17:32:00 -
[71] - Quote
Equto wrote: Actually it still needs a cert file as its ssl and curl needs a cert file to validate the connection.
That is not true. That would mean you need a "file" for every SSL enabled website on the internet. Lol... You only need to import it if it is signed by a untrusted CA or if there is some problem with the certificate validation and you want to explicitly use it anyways.
See command line curl at the following paste. http://pastebin.com/yfp6Wg8u No need to import anything whatsoever if you are using the correct domain... |
Equto
Imperium Technologies Get Off My Lawn
17
|
Posted - 2012.10.19 17:35:00 -
[72] - Quote
qu1ckkkk wrote:Equto wrote: Actually it still needs a cert file as its ssl and curl needs a cert file to validate the connection.
That is not true. That would mean you need a "file" for every SSL enabled website on the internet. Lol... You only need to import it if it is signed by a untrusted CA or if there is some problem with the certificate validation and you want to explicitly use it anyways. See command line curl at the following paste. http://pastebin.com/yfp6Wg8u No need to import anything whatsoever if you are using the correct domain... The reason being almost all installs come with a valid CA cert file. You do not need a valid different file for every website on the internet however in this file ( which is shipped with firefox and chrome mind you) is a public key that allows one to validate the certificate on the website. So this file is used in the validation process of the certificate |
qu1ckkkk
The Warp Core Stabilizers Spies R' Us
2
|
Posted - 2012.10.19 17:41:00 -
[73] - Quote
Equto wrote:The reason being almost all installs come with a valid CA cert file. You do not need a valid different file for every website on the internet however in this file ( which is shipped with firefox and chrome mind you) is a public key that allows one to validate the certificate on the website. So this file is used in the validation process of the certificate edit: http://serverfault.com/questions/241046/what-is-the-cacert-pem-and-for-what-to-use-that explains why the file is needed
If it fails, then you OS's cert bundle is out of date... cURL is using the system-default CA bundle as is uslauuly stored in /etc/pki/tls/certs/ca-bundle.crt. Not something other software is supposed to hack to get working. |
Equto
Imperium Technologies Get Off My Lawn
17
|
Posted - 2012.10.19 17:43:00 -
[74] - Quote
qu1ckkkk wrote:Equto wrote:The reason being almost all installs come with a valid CA cert file. You do not need a valid different file for every website on the internet however in this file ( which is shipped with firefox and chrome mind you) is a public key that allows one to validate the certificate on the website. So this file is used in the validation process of the certificate edit: http://serverfault.com/questions/241046/what-is-the-cacert-pem-and-for-what-to-use-that explains why the file is needed If it fails, then you OS's cert bundle is out of date... cURL is using the system-default CA bundle as is uslauuly stored in /etc/pki/tls/certs/ca-bundle.crt. Not something other software is supposed to hack to get working. To be honest is depends on the CURL install, almost all php cURL installs use libcurl and do not search for said file. In the 14 servers I have used https on none of the cURLS recognized a valid https url without that file. Regardless it works and you can check both the code and the file. |
qu1ckkkk
The Warp Core Stabilizers Spies R' Us
2
|
Posted - 2012.10.19 17:51:00 -
[75] - Quote
Cause https://api.eve-online.com does not have a valid cert. It will never validate unless you go the "import the CA" route. Which is wrong. |
Equto
Imperium Technologies Get Off My Lawn
17
|
Posted - 2012.10.19 17:54:00 -
[76] - Quote
qu1ckkkk wrote:Cause https://api.eve-online.com does not have a valid cert. It will never validate unless you go the "import the CA" route. Which is wrong. I have tested it on both eve-online and eveonline, eveonline replied an error 60 SSL certificate problem,verify that the CA cert is OK. So that file is nessicary |
qu1ckkkk
The Warp Core Stabilizers Spies R' Us
2
|
Posted - 2012.10.19 18:01:00 -
[77] - Quote
Equto wrote:qu1ckkkk wrote:Cause https://api.eve-online.com does not have a valid cert. It will never validate unless you go the "import the CA" route. Which is wrong. I have tested it on both eve-online and eveonline, eveonline replied an error 60 SSL certificate problem,verify that the CA cert is OK. So that file is nessicary
How old is your cURL install? When last have you had a CA bundle updated? I need to log for the night, but in the meantime I have tested this on 24 of the many servers I have. Not one has complained about the cert. And this is various diffident flavors of *nix, centos, ubuntu gentoo, archlinux and even freebsd :0
Honestly, I'd make 100% sure about this if I were you, before you ship a cert, *.eveonline.com gets a new cert signed by another CA, and you have to do this whole mess all over again :(
|
qu1ckkkk
The Warp Core Stabilizers Spies R' Us
2
|
Posted - 2012.10.19 18:05:00 -
[78] - Quote
qu1ckkkk wrote: How old is your cURL install? When last have you had a CA bundle updated?
In retrospect, some OS's will have this sorted with a update of the open-ssl install for it. |
Equto
Imperium Technologies Get Off My Lawn
17
|
Posted - 2012.10.19 18:06:00 -
[79] - Quote
qu1ckkkk wrote:Equto wrote:qu1ckkkk wrote:Cause https://api.eve-online.com does not have a valid cert. It will never validate unless you go the "import the CA" route. Which is wrong. I have tested it on both eve-online and eveonline, eveonline replied an error 60 SSL certificate problem,verify that the CA cert is OK. So that file is nessicary How old is your cURL install? When last have you had a CA bundle updated? I need to log for the night, but in the meantime I have tested this on 24 of the many servers I have. Not one has complained about the cert. And this is various diffident flavors of *nix, centos, ubuntu gentoo, archlinux and even freebsd :0 Honestly, I'd make 100% sure about this if I were you, before you ship a cert, *.eveonline.com gets a new cert signed by another CA, and you have to do this whole mess all over again :( No, because this is the public keys from several signing agencies, so unless they do something crazy and sign their own keys without any authority then this will continue to work. Regardless once again this works, if you have a problem with me and other developers shipping necessary files for compatibility reasons then don't use the software. |
qu1ckkkk
The Warp Core Stabilizers Spies R' Us
2
|
Posted - 2012.10.19 18:27:00 -
[80] - Quote
Equto wrote: No, because this is the public keys from several signing agencies, so unless they do something crazy and sign their own keys without any authority then this will continue to work. Regardless once again this works, if you have a problem with me and other developers shipping necessary files for compatibility reasons then don't use the software.
I know very well, infact, exactly how SSL Certs work. Regardless of what you may believe, if a users cURL install (or anything using libcurl for that matter) cannot verify a GeoTrust cert, and you insist that eve-online.com is valid, then so be it. In such a case the user probably has many more problems to be concerned about than a mere cert, which will be invalidated at some point anyways, bundled in some software for compatibility reasons. Just take the advise.
Your welcome to get another opinion here. https://www.ssllabs.com/ssltest/analyze.html?d=api.eve-online.com https://www.ssllabs.com/ssltest/analyze.html?d=api.eveonline.com
Do yourself another favor and cat your bundle grepping for geotrust. Is wget able to validate the cert? What is in CURL_CA_BUNDLE in you env? At least try and check how to update you os flavours CA bundle, or if you have to use a curl specific one, on the curl website, http://curl.haxx.se/ca/cacert.pem
Anyways. As you please. |
|
Equto
Imperium Technologies Get Off My Lawn
17
|
Posted - 2012.10.19 18:43:00 -
[81] - Quote
qu1ckkkk wrote:Equto wrote: No, because this is the public keys from several signing agencies, so unless they do something crazy and sign their own keys without any authority then this will continue to work. Regardless once again this works, if you have a problem with me and other developers shipping necessary files for compatibility reasons then don't use the software.
I know very well, infact, exactly how SSL Certs work. Regardless of what you may believe, if a users cURL install (or anything using libcurl for that matter) cannot verify a GeoTrust cert, and you insist that eve-online.com is valid, then so be it. In such a case the user probably has many more problems to be concerned about than a mere cert, which will be invalidated at some point anyways, bundled in some software for compatibility reasons. Just take the advise. Your welcome to get another opinion here. https://www.ssllabs.com/ssltest/analyze.html?d=api.eve-online.comhttps://www.ssllabs.com/ssltest/analyze.html?d=api.eveonline.comDo yourself another favor and cat your bundle grepping for geotrust. Is wget able to validate the cert? What is in CURL_CA_BUNDLE in you env? At least try and check how to update you os flavours CA bundle, or if you have to use a curl specific one, on the curl website, http://curl.haxx.se/ca/cacert.pemAnyways. As you please. it actually is the cacert.pem from the curl website
Edit: I don't know why you assumed that I somehow or for some reason didn't change my code but instead did a hack but the code is visible |
Xtrah
No Holes Barred
2
|
Posted - 2012.10.22 14:02:00 -
[82] - Quote
Awesome api check not working? |
Equto
Imperium Technologies Get Off My Lawn
17
|
Posted - 2012.10.23 19:27:00 -
[83] - Quote
Its working with the latest updates, finally updated my own website. its been hectic |
Xtrah
No Holes Barred
3
|
Posted - 2012.10.28 19:15:00 -
[84] - Quote
Nice. Also I suggest you look at "can fly t2 guardian" @ skills, it should include logistics skill to 4 or 5 if not, it's a pretty useless guardian. |
Yuki Kasumi
Some names are just stupid
11
|
Posted - 2013.01.16 14:44:00 -
[85] - Quote
I get this when using the installer on a fresh database:
MYSQL Error: 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 '422,NULL165,633,NULL,26,NULL,30),(2004,6LL,0.8),(2161,28,525,69.8),(2161,2054),(' at line 1MYSQL Error: 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 '830952053,(238311200490213,(253,(2382919520)102153,(238291952153,(23782238291952' at line 1
This is during the installation of dgmTypeAttributes.sql.gz how can I get around this? |
NickyYo
StarHug
285
|
Posted - 2013.01.16 15:33:00 -
[86] - Quote
Is there a class with this that contains all the api queries & calculations that one could include on another site? .. |
Equto
Imperium Technologies Get Off My Lawn
18
|
Posted - 2013.01.17 02:41:00 -
[87] - Quote
NickyYo wrote:Is there a class with this that contains all the api queries & calculations that one could include on another site? No, its a set of classes designed for use with the site. Queries are in one location but calculations are another |
Mr Majestic
nul-li-fy Nulli Secunda
1
|
Posted - 2013.01.17 06:20:00 -
[88] - Quote
Yuki Kasumi wrote:I get this when using the installer on a fresh database:
MYSQL Error: 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 '422,NULL165,633,NULL,26,NULL,30),(2004,6LL,0.8),(2161,28,525,69.8),(2161,2054),(' at line 1MYSQL Error: 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 '830952053,(238311200490213,(253,(2382919520)102153,(238291952153,(23782238291952' at line 1
This is during the installation of dgmTypeAttributes.sql.gz how can I get around this? I get this same error, having to use the older version of jackknife to get around this.
Any chance of fixing this one Equto? <3 |
NickyYo
StarHug
290
|
Posted - 2013.01.17 13:09:00 -
[89] - Quote
Mr Majestic wrote:Yuki Kasumi wrote:I get this when using the installer on a fresh database:
MYSQL Error: 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 '422,NULL165,633,NULL,26,NULL,30),(2004,6LL,0.8),(2161,28,525,69.8),(2161,2054),(' at line 1MYSQL Error: 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 '830952053,(238311200490213,(253,(2382919520)102153,(238291952153,(23782238291952' at line 1
This is during the installation of dgmTypeAttributes.sql.gz how can I get around this? I get this same error, having to use the older version of jackknife to get around this. Any chance of fixing this one Equto? <3
Error message looks like the database structure was changed but the queries wasn't changed to represent the new structure. .. |
Equto
Imperium Technologies Get Off My Lawn
18
|
Posted - 2013.01.17 14:13:00 -
[90] - Quote
The installer doesn't update current installations if you are using it todo that. I will however make an update function in a few days to update things like items. Other than that I am not sure what could be causing the issue |
|
|
|
|
Pages: 1 2 [3] 4 :: one page |
First page | Previous page | Next page | Last page |