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

Forum Index

EVE Forums » EVE Technology and Research Center » EVE Technology Lab » JackKnife 2.0

Topic is locked indefinitely.

JackKnife 2.0 First post
Author

Previous Topic Next Topic

Equto

Imperium Technologies

Sigma Grindset

Likes received: 58

#81 - 2012-10-19 18:43:15 UTC | Edited by: Equto

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. Straight

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. Cool

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. Ugh

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

Overload This Escalation Theory 278
Xtrah Overload This Escalation Theory Likes received: 278	#82 - 2012-10-22 14:02:00 UTC Awesome api check not working? YouTube channel Latest video: Bhaals Deep against TLC (dread/triage)


Equto Imperium Technologies Sigma Grindset Likes received: 58	#83 - 2012-10-23 19:27:56 UTC Its working with the latest updates, finally updated my own website. its been hectic


Xtrah Overload This Escalation Theory Likes received: 278	#84 - 2012-10-28 19:15:38 UTC 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. YouTube channel Latest video: Bhaals Deep against TLC (dread/triage)

Yuki Kasumi

Some names are just stupid

Likes received: 41

#85 - 2013-01-16 14:44:17 UTC

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?

modro The Initiative. 440
NickyYo modro The Initiative. Likes received: 440	#86 - 2013-01-16 15:33:27 UTC Is there a class with this that contains all the api queries & calculations that one could include on another site? ..


Equto Imperium Technologies Sigma Grindset Likes received: 58	#87 - 2013-01-17 02:41:26 UTC 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

Windrammers

Goonswarm Federation

Likes received: 18

#88 - 2013-01-17 06:20:09 UTC

Yuki Kasumi wrote:

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

modro

The Initiative.

Likes received: 440

#89 - 2013-01-17 13:09:05 UTC

Mr Majestic wrote:

Yuki Kasumi wrote:

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 Sigma Grindset Likes received: 58	#90 - 2013-01-17 14:13:32 UTC 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


Mr Majestic Windrammers Goonswarm Federation Likes received: 18	#91 - 2013-01-18 07:54:56 UTC Equto wrote: 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 This was with a completely fresh database and install.


Equto Imperium Technologies Sigma Grindset Likes received: 58	#92 - 2013-01-18 14:39:20 UTC I am now looking into what is causing this, not sure why it didn't come up when I first installed it


Equto Imperium Technologies Sigma Grindset Likes received: 58	#93 - 2013-01-18 23:10:30 UTC The problem was a corrupt SQL file, I have replaced all the SQL files with the both working and new ones ( retribution 1.0.7)

Mr Majestic

Windrammers

Goonswarm Federation

Likes received: 18

#94 - 2013-01-18 23:46:57 UTC

Seems there a completly new bug now, basically the Installer instantly finishes without importing any SQL as far as I can tell.

Quote:

Notice: Use of undefined constant DEBUG - assumed 'DEBUG' in /home/majestic/domains/api.dontpod.me/public_html/eveApi/eveDb.php on line 119
FATAL SQL ERROR

QUERY: 'SELECT * FROM api__invTypes WHERE typeID = '1' LIMIT 1 OFFSET 0;'

Table 'api.api__invTypes' doesn't exist

Backtrace:
#0 eveDb->query(SELECT * FROM api__invTypes WHERE typeID = '1' LIMIT 1 OFFSET 0;) called at [/home/majestic/domains/api.dontpod.me/public_html/eveApi/eveDb.php:483]
#1 eveDb->getTypeFromTypeId(12099) called at [/home/majestic/domains/api.dontpod.me/public_html/eveApi/eveDb.php:386]
#2 eveDb->getNameFromTypeId(12099) called at [/home/majestic/domains/api.dontpod.me/public_html/eveApi/eveApiTraining.class.php:48]
#3 eveApiTraining->loadAPI() called at [/home/majestic/domains/api.dontpod.me/public_html/eveApi/eveApi.base.php:57]
#4 eveApi->fetch_xml(/char/SkillInTraining.xml.aspx, Array ([characterID] => 90278068,[keyID] => 1696661,[vCode] => 4sWQAXzr3Lm1EvszabSy2YA19S1cYsq0KJaBabRWCzAzKNB2BmNgCzoeTMl2V5Ps)) called at [/home/majestic/domains/api.dontpod.me/public_html/eveApi/eveApiTraining.class.php:38]
#5 eveApiTraining->fetch(90278068, 1696661, 4sWQAXzr3Lm1EvszabSy2YA19S1cYsq0KJaBabRWCzAzKNB2BmNgCzoeTMl2V5Ps) called at [/home/majestic/domains/api.dontpod.me/public_html/pages/auditorSkillsPage.class.php:246]
#6 auditorSkillsPage->GetOutput(eveDb Object ([link] => Resource id #23,[queries] => 1,[] => Array (),[] => Array (),[] => Array (),[] => Array (),[] => Array (),[] => Array (),[] => Array (),[] => Array ())) called at [/home/majestic/domains/api.dontpod.me/public_html/index.php:306]

This is what I'm left with after it says it's 'Finished'. I'll try manually importing the SQL now instead and see if that works.


Equto Imperium Technologies Sigma Grindset Likes received: 58	#95 - 2013-01-19 00:05:55 UTC that certainly is odd.....


Equto Imperium Technologies Sigma Grindset Likes received: 58	#96 - 2013-01-19 01:45:52 UTC Hopefully fully fixed now, after fixing the not installing sql errors I had an sql that refused to install and fixed that as well

Yuki Kasumi

Some names are just stupid

Likes received: 41

#97 - 2013-01-19 13:15:38 UTC | Edited by: Yuki Kasumi

Equto wrote:

Hopefully fully fixed now, after fixing the not installing sql errors I had an sql that refused to install and fixed that as well

Ive downloaded the latest version. Dropped all the tables in the database and rerun the installer, now I dont get an error only a red square next to invTypes.sql.gz. Clean database working permissions etc. Ive run it twice to make sure...

Im using mysql, apache and phpmyadmin for the setup. XAMPP zip version.


Mr Majestic Windrammers Goonswarm Federation Likes received: 18	#98 - 2013-01-19 15:04:58 UTC Hey Equto, the install worked successfully, but looks like the data dump is broken again or some queries have been broken. http://api.dontpod.me/ <- try and put an API in, it works, but doesn't show any of the data properly.


Equto Imperium Technologies Sigma Grindset Likes received: 58	#99 - 2013-01-19 19:37:13 UTC \| Edited by: Equto hmmm, inv types is being annoying it appears, ill need to play with it more EDIT: fixed, I forgot to fix my windows export, name insensitive so there was 2 invtype tables. And sorry for it being broken so much, college + person who I normally get to test being out of town.

Mr Majestic

Windrammers

Goonswarm Federation

Likes received: 18

#100 - 2013-01-20 03:09:54 UTC

Hey Equto, thanks a lot for your time trying to fix it all. Seems the Installer is broken again.

Quote:

invUniqueNames-1.sql.gz 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 'Bouey Sadereroseroil71), 9NDgur',Libo(3010845, 'OpUre Goskhen'an',, 1)ru(3010842' at line 1198

Stops right there it seems :(

First pagePrevious page3456Next page

EVE Technology Lab

Imperium Technologies

Sigma Grindset

Overload This

Escalation Theory

Some names are just stupid

modro

The Initiative.

Windrammers

Goonswarm Federation