Pages: 1 2 3 4 5 6 7 8 9 10 11 [12] 13 14 15 16 17 18 .. 18 :: one page |
|
Author |
Thread Statistics | Show CCP posts - 1 post(s) |

Steven Trux
0
|
Posted - 2012.11.16 12:09:00 -
[331] - Quote
Dragonaire wrote:Steven Trux wrote:Dragonaire wrote:Steven Trux - Make sure you've gone through all the steps in the install.md(test) file. I'm thinking you missed step where you test DB connection that you'll find in step 9. Also make sure you got everything and if you're updating from an old version that all the files updated correctly. Thanks for reply, but that's not the problem. Step 9 works just fine  Still got the same error when running /install//createMySQLTables.php -s localhost -u YapealUser -p secret --database=yapeal If you haven't found it yet check out http://sourceforge.net/p/yapeal/wiki/StarterGuide/You also shouldn't have to add any of the -s, -u etc part if you've got a config/yapeal.ini file setup. One other cause of major problems with the tables part is a bad my.cnf setting for max_allowed_packet. It needs to be at least 2M to generally not cause problems during install and while running Yapeal later. Just on the off chance you really are missing something check that you have 2 files in ext/ADOdb/datadict/. I'm not sure if it's just a bad cut and paste from your error or if it really said 'datadict/datadict-.inc.php' which would be missing the 'mysql' part. If none of those things correct your issue please E-mail me a copy of your exact error messages and any Yapeal log files and I'll take a look and see if there's a clue that's been missed. Thank you, I'm away from home for a week. I'll try as soon as I come back. |

Sable Blitzmann
Fist of Eargon Insidious Empire
47
|
Posted - 2012.11.24 04:17:00 -
[332] - Quote
Dragon,
Can you confirm: When changing the expiration of the API key on the EVE-O site, yapeal DOES NOT update this in the database. Is this by design or is it an oversight?
EDIT:
Don't mind me, I'm an idiot. the cache had not expired and thus it was not updated. <_< |

Makkosh
Metaxa Labs
2
|
Posted - 2012.11.28 14:44:00 -
[333] - Quote
I am trying to get EVE data for my web-application with yapeal. On my home computer everything works fine. But when i moved it to the hosting server i've got error:
Quote:Unknown cipher in list: AES128-SHA AES256-SHA DES-CBC3-SHA RC4-SHA RC4-MD5 for all APIs.
Hosting has all needed for yapeal extensions and versions. Hosting support manager wrote that they support curl (cURL Information 7.19.7) with SSL (NSS/3.13.1.0) What it could be?
|

Somerset Mahm
Cognitive Distortion
125
|
Posted - 2012.11.30 06:43:00 -
[334] - Quote
I just got this same error on a new server with Yapeal as well.
Quote:Unknown cipher in list: AES128-SHA AES256-SHA DES-CBC3-SHA RC4-SHA RC4-MD5 SOMER Blink Microlotteries that finish in minutes! Running for over 2 years :) |

Somerset Mahm
Cognitive Distortion
125
|
Posted - 2012.11.30 07:35:00 -
[335] - Quote
Sorted it out. It's because curl on this server isn't compiled with OpenSSL:
Quote:curl --version curl 7.19.7 (x86_64-redhat-linux-gnu) libcurl/7.19.7 NSS/3.13.1.0 zlib/1.2.3 libidn/1.18 libssh2/1.2.2
I just commented out these lines for now :P
Quote: //$this->options['CURLOPT_SSL_VERIFYPEER'] = 1; // verify ssl certs //$this->options['CURLOPT_SSL_VERIFYHOST'] = 1; // verify ssl host //$this->options['CURLOPT_SSL_CIPHER_LIST'] = 'AES128-SHA AES256-SHA DES-CBC3-SHA RC4-SHA RC4-MD5'; // use these ciphers only //$this->options['CURLOPT_CAINFO'] = YAPEAL_CONFIG . 'eveonline.crt';
SOMER Blink Microlotteries that finish in minutes! Running for over 2 years :) |

Makkosh
Metaxa Labs
2
|
Posted - 2012.11.30 10:09:00 -
[336] - Quote
Resolved  My development system has cURL with OpenSSL, hosting server has cURL with NSS. OpenSSL and NSS use different names for ciphers. Ciphers are in file: yapeal\ext\eac_httprequest\eac_httprequest.curl.php Defaut string for OpenSSL:
Quote: $this->options['CURLOPT_SSL_CIPHER_LIST'] = 'AES128-SHA AES256-SHA DES-CBC3-SHA RC4-SHA RC4-MD5'; And this string for NSS should be:
Quote: $this->options['CURLOPT_SSL_CIPHER_LIST'] = 'rsa_aes_128_sha,rsa_aes_256_sha,rsa_3des_sha,rsa_rc4_128_sha,rsa_rc4_128_md5'; |

Dragonaire
Corax. The Big Dirty
48
|
Posted - 2012.12.02 02:29:00 -
[337] - Quote
Sorry everyone been busy in RL with holidays etc. Glad you figured out what the issue was as I wasn't even aware anyone use anything but OpenSSL with cURL or I might have added checks for it. 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. |

Somerset Mahm
Cognitive Distortion
125
|
Posted - 2012.12.04 01:07:00 -
[338] - Quote
Will Yapeal's curl implementation take advantage of GZIP API responses when they come out in a few weeks, or do I need to tweak the config? :) SOMER Blink Microlotteries that finish in minutes! Running for over 2 years :) |

Dragonaire
Corax. The Big Dirty
48
|
Posted - 2012.12.04 15:56:00 -
[339] - Quote
Quote:$this->options['CURLOPT_ENCODING'] = 'gzip';// allow gzip compression
It's been waiting on them for over a year  Finds camping stations from the inside much easier. Designer of Yapeal-á for Eve API. Check out the Yapeal PHP Library thread for more information. |

Talos Katuma
Helion Production Labs Mildly Sober
6
|
Posted - 2012.12.12 22:01:00 -
[340] - Quote
I didn't find any way to report a defect on sourceforge (only see tickets but did not find a way to open a new one), therefore I'll report it here:
I think there's a bug in maintCleanCache.php Line 94
$sql = ' delete from `' . YAPEAL_TABLE_PREFIX . 'utilXmlCache`'; $sql .= ' where'; $sql .= ' `modified` = ';
Shouldn't this be $sql .= ' `modified` <= '; |
|

Thaddea
Clive's Crew
1
|
Posted - 2012.12.15 06:31:00 -
[341] - Quote
Gilgamoth wrote:
2012-07-18 18:15:16.031 WARN: Insert/upsert failed for charSkillQueue File: D:\yapeal\class\YapealQueryBuilder.php(493)
I was also getting this so I added a line to log the exception and it appears this is caused by characters on an account that aren't training but do have a skill queue setup. The endTime and startTime are blank in the xml returned from the API request.
Here is the output from the log:
WARN: Exception => exception 'ADODB_Exception' with message 'mysqli error: [1292: Incorrect datetime value: '' for column 'endTime' at row 1] in EXECUTE("insert into `charSkillQueue` (`endSP`,`endTime`,`level`,`ownerID`,`queuePosition`,`startSP`,`startTime`,`typeID`) values (45255,'',4,1035432898,0,8000,'',16595),(512000,'',5,1035432898,1,90510,'',3446)")
Not a big problem which can be ignored or you can remove the training queue on characters you don't plan on training.
|

Thaddea
Clive's Crew
1
|
Posted - 2012.12.25 22:14:00 -
[342] - Quote
Hi Dragonaire, this is an awesome project. I started building my own but stopped when I found yours since it was exactly what I wanted to do. It is so nice having everything available in a database so that I just need to query what I need.
In order to get familiar with the workings of Yapeal I looked into the problem above about empty endTime and startTime values in the charSkillQueue. I made the table allow nulls and I modified the query builder to allow null date/time types.
I also needed a few more of the APIs for my tools so I went ahead and implemented charLocations, corpLocations (to get all the named containers I use) and eveSkillTree. I'll contact you at SourceForge if you want me to upload the changes for you to look at.
Thanks again for making such a great tool. |

Gladi
Liga Freier Terraner Northern Coalition.
0
|
Posted - 2013.01.04 15:10:00 -
[343] - Quote
ok do i understand this correctly:
I set your library up, let the cron run every x time and my mysql DB is uptodate with the API keys i put in.
I then can just work the DB and dont need to use any eve api calls etc?
what would i need your other functions for that you provide? |

Dragonaire
Corax. The Big Dirty
50
|
Posted - 2013.01.06 18:43:00 -
[344] - Quote
Talos Katuma - You're right it should be. I started to work on the maintenance stuff but didn't get very far into it before I got busy with other things.
Gladi - Most of the other classes in class/util are there to make integrate Yapeal with your software easier but if you don't think you need them they can be ignored.
Thaddea - I'd be interested in looking at what you have done do contract me on SF. If you already did might try it a gain because I was deleting some SPam the other day and think I got some other stuff as well  Finds camping stations from the inside much easier. Designer of Yapeal-á for Eve API. Check out the Yapeal PHP Library thread for more information. |

Tek Handle
Vanishing Point. The Initiative.
28
|
Posted - 2013.01.07 04:47:00 -
[345] - Quote
Hey, I tried Yapeal as an alternative to Ale the first time tonight. It's a whole new story, but it looks neat. I got a few questions tho. Is there an easy way to change the order in which the API pages are fetched? By default corpstarbasedetail is fetched before corpstarbaselist, leading to no details for newly placed towers for the interval time of the cronjob. You get the issue at this point? Speaking of interval, is there any suggestion on which one's optimal?
One more question: Any objection on setting the cache_output setting to none? I take it Yapeal uses the cacheduntil timestamps stored in the database to prevent requests based on those timestamps? If so I don't see a reason to keep them data cached. |

Dragonaire
Corax. The Big Dirty
50
|
Posted - 2013.01.11 17:06:00 -
[346] - Quote
Yapeal actually calls the APIs in a random order so any bugs or API server errors don't end up block another API call and since it's hardwared into the code it can't be changed. The crontab should be ran every minute as I've stated multiple times since Yapeal manages work load internally to spend out the API calls to keep from cause API server spikes. If there's nothing for it to do it does cause any load on your server since it only does a few DB calls to check the cached times.
Wither you have the caching on or off is up to you as Yapeal doesn't need it but it can be useful when trying to track down errors. Finds camping stations from the inside much easier. Designer of Yapeal-á for Eve API. Check out the Yapeal PHP Library thread for more information. |

Mikokoel
Mining Industry Exile Foundation Black Core Alliance
4
|
Posted - 2013.01.22 20:18:00 -
[347] - Quote
Oh my god. 
I posted this last August:
Mikokoel wrote: Since 3 days, the cronjob running Yapeal doesn't output anything, but there are no log files and no updates in the database.
Edit: Nevermind, fixed it
I fixed the problem and simply edited it in. Now I had the same problem again in another project.
And it took me 3h until i figured out what it was. But this time I'm smart and writing it here, so my brain can find it again 
Apparently, on some server configurations, log4php doesn't like the paths to the log files (e.g. "log/yapeal_error.log"). After changing all those to absoulte paths (/www/htdocs/...), it finally works.
Debugging is seriously ****, when the part which should print the errors doesn't work!
Mikokoel EvE API Development zap - advanced programming |

Iax Masali
Vent Mob
17
|
Posted - 2013.01.27 21:22:00 -
[348] - Quote
Went though all the Installation Steps in the install.txt no error were shown.
Came to Yapeal Testing
Entered php -f yapeal.php into the CLI and it has thrown this at me.
Quote:File: C:\BitNami\wampstack-5.4.11-0\apache2\htdocs\test\yapeal\yapeal.php(150) 2013-01-27 21:06:44.244 FATAL: mysqli error: [1146: Table 'yapeal.eve-utilsections' doesn't exist] in EXECUTE("select `section` from `EVE-utilSections`")
Code: 1146 Trace: #0 C:\BitNami\wampstack-5.4.11-0\apache2\htdocs\test\yapeal\ext\ADOdb\adodb.inc.php(1042): adodb_throw('mysqli', 'EXECUTE', 1146, 'Table 'yapeal.e...', 'select `section...', false, Object(ADODB_mysqli)) #1 C:\BitNami\wampstack-5.4.11-0\apache2\htdocs\test\yapeal\ext\ADOdb\adodb.inc.php(1017): ADOConnection->_Execute('select `section...', false) #2 C:\BitNami\wampstack-5.4.11-0\apache2\htdocs\test\yapeal\ext\ADOdb\adodb.inc.php(1470): ADOConnection->Execute('select `section...', false) #3 C:\BitNami\wampstack-5.4.11-0\apache2\htdocs\test\yapeal\yapeal.php(147): ADOConnection->GetCol('select `section...') #4 {main} --------- END TRACE ----------
File: C:\BitNami\wampstack-5.4.11-0\apache2\htdocs\test\yapeal\yapeal.php(150)
2013-01-27 21:06:44.281 ERROR: No sections were found in utilSections check database. File: C:\BitNami\wampstack-5.4.11-0\apache2\htdocs\test\yapeal\yapeal.php(154)
I have deleted the Database and went though the install steps again but same result
I saw that this poster had the same Error
Controller Vrelk wrote:What is the correct way to add an API key to the system? I manually added one to utilregisteredkey and set `active` to 1 and the existing example one to `active`=0. When I run yapeal.php from console I get this: Quote: ERROR: No sections were found in utilSections check database. File: /home/****/*****/ratter/yapeal/yapeal.php(155) It also does not add the other information to the rest of the tables. The key has access to char/WallerJournal only. I tried going through the wiki (which is outdated, as you have said before) and code to find the correct way of doing so, but didn't find anything that seemed to do what I wanted.
and read your response
Dragonaire wrote:Make sure the char section in utilSections has isActive=1 It sound like you did the rest right though you didn't say what your activeAPIMask value was but if it's NULL the one from sections will control it. As to the wiki yes it is outdated on a lot of stuff but the UsingClassUtilClasses and UtilDatabaseTableDependences are still useful for understanding the things you're having trouble with and have been updated to the current way things work since I last wrote about them being outdated. If you have any other questions just ask I'm much better answering questions here than I ever have been trying to write about how to use stuff for new people in general 
so I check the utilSections in phpmyadmin and yes char isActive=1 is how it is set.
Any ideas?
Thanks |

Somerset Mahm
Cognitive Distortion
149
|
Posted - 2013.01.28 21:16:00 -
[349] - Quote
You're checking utilSections, but it looks like you've defined a database prefix of EVE- in yapeal.ini. Try removing the prefix. SOMER Blink Microlotteries that finish in minutes! Running for over 2 years :) |

Iax Masali
Vent Mob
17
|
Posted - 2013.01.29 14:31:00 -
[350] - Quote
Somerset Mahm wrote:You're checking utilSections, but it looks like you've defined a database prefix of EVE- in yapeal.ini. Try removing the prefix. Thanks that got it working |
|

Steven Trux
Amarr Research Laboratories
21
|
Posted - 2013.02.18 23:12:00 -
[351] - Quote
Hi all and thanks in advance for your help. I can't fetch corp contracts. I've followed all the instructions in the wiki, added the corp api and so on. Assets, industry jobs, market orders, work fine but not contracts... I try to solve the problem in the last three days with no luck. ARLAB BPCs & BPOs Shop |

Seres Kashuken
Sacrificium X
0
|
Posted - 2013.02.27 22:00:00 -
[352] - Quote
Thanks for this useful tool! Still futzing with it but I think I got it working as supposed to. |

Dragonaire
Corax. The Big Dirty
50
|
Posted - 2013.05.28 14:13:00 -
[353] - Quote
As Everybody has probably noticed I've become very inactive in Eve over the last few months and having been updating Yapeal either. There are many reasons for this but in the end it doesn't matter much to most of you. Given that I don't see my interest level increasing in the near future I'd like to find someone to take over development and the day to day maintenance of Yapeal. If you are interest in taking over the project Eve-mail me and I'll also probably contact a couple of people I believe would be good at continue the project as well. It's hard to let the project go since I've worked on it for almost as long as I played Eve and actually spend more time on it then I did playing but it's really past time for me to step down and let someone else take the lead in moving forward. It's been fun and I've learn a lot both from working on Yapeal and from all of the other developers here on the forums. Finds camping stations from the inside much easier. Designer of Yapeal-á for Eve API. Check out the Yapeal PHP Library thread for more information. |

Dragonaire
Here there be Dragons
50
|
Posted - 2013.06.04 16:32:00 -
[354] - Quote
Ok so at least one of my account now only has a few days left on it and I don't plan on keeping it going and I may not keep the main one either so thought I better make one more post before it does too. None of the people I talked to were interest in keeping Yapeal going and no one else stepped forward on their own either so I expect development to stop completely now which it had mostly done already in the last few month since I haven't been doing anything. The good thing about is it's open source and host where it'll be available for a long time. I'd still welcome having someone else take over the project and be available to help consult on understand the inner works of Yapeal but have no interest in adding to it or rewriting it myself though it probably could use that again in areas.
Anyway thanks all of you who have help me along and been friends for years both in and out of game as a player and a developer with the Eve API over the last 6 years and maybe I'll see you all again someday flying around in EVE which is still one of the best games I've ever played. Finds camping stations from the inside much easier. Designer of Yapeal-á for Eve API. Check out the Yapeal PHP Library thread for more information. |

Somerset Mahm
Cognitive Distortion
165
|
Posted - 2013.06.04 20:26:00 -
[355] - Quote
I'd be happy to PLEX your account to keep a line of contact open. SOMER Blink Microlotteries that finish in minutes! Running for over 2 years :) |

Somerset Mahm
Cognitive Distortion
167
|
Posted - 2013.06.26 18:04:00 -
[356] - Quote
Ogads, the API changed and now Yapeal is broken. Time to put on my big kid pants and try to figure out how to change the schemas. SOMER Blink Microlotteries that finish in minutes! Running for over 2 years :) |

Somerset Mahm
Cognitive Distortion
167
|
Posted - 2013.06.26 19:16:00 -
[357] - Quote
I did it yay. I'll post a diff soon with the needed changes to get your Yapeal working once more. It's basically just updating xml and table schemas. SOMER Blink Microlotteries that finish in minutes! Running for over 2 years :) |

Dasola
Rookie Empire Citizens Rookie Empire
199
|
Posted - 2013.06.26 19:56:00 -
[358] - Quote
Sad to see development of this project suspend.. if i would be better programmer i would offer to take over. But my php skills, nahhh... We are Minmatar, Our ship are made of scraps, but look what our scraps can do... |

Somerset Mahm
Cognitive Distortion
168
|
Posted - 2013.06.26 22:56:00 -
[359] - Quote
Dragonaire is going to add me as a committer so I can at least try to help Yapeal limp along for now. SOMER Blink Microlotteries that finish in minutes! Running for over 2 years :) |

Zaepho
Phoenix Propulsion Labs
15
|
Posted - 2013.06.27 03:34:00 -
[360] - Quote
Somerset Mahm wrote:Dragonaire is going to add me as a committer so I can at least try to help Yapeal limp along for now. Thank goodness!!
Just looked at my logs after a few days away and saw all the errors and got really really scared.
Thanks for helping all of us limp along until somebody with the time and desire to maintain the project can step up. |
|
|
|
|
Pages: 1 2 3 4 5 6 7 8 9 10 11 [12] 13 14 15 16 17 18 .. 18 :: one page |
First page | Previous page | Next page | Last page |