Quote:

---

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' (using password: YES)' in /var/www/outofeve.com/includes/database.php:15 Stack trace: #0 /var/www/outofeve.com/includes/database.php(15): PDO->__construct('mysql:host=loca...', 'root', 'loaded') #1 /var/www/outofeve.com/includes/database.php(10): DBManager->Connect(Array) #2 /var/www/outofeve.com/includes/site.php(20): DBManager->DBManager(Array) #3 /var/www/outofeve.com/index.php(8): Site->Site() #4 {main} thrown in /var/www/outofeve.com/includes/database.php on line 15

---

Quote:

---

ini_set('include_path', ini_get('include_path') . PATH_SEPARATOR . dirname(__FILE__) . DIRECTORY_SEPARATOR . 'libs' . PATH_SEPARATOR . dirname(__FILE__) . DIRECTORY_SEPARATOR . 'eve');

---

Quote:

---

if (locationID.substr(0, 2) == '66')
{
locationID = locationID - 6000001;
}
else if (locationID.substr(0, 2) == '67')
{
locationID = locationID - 6000000;
}

---

Quote:

---

<row itemID="1240652248" locationID="30002384" typeID="606" quantity="1" flag="0" singleton="1">
<rowset name="contents" key="itemID" columns="itemID,typeID,quantity,flag,singleton">
<row itemID="1240652235" typeID="3651" quantity="1" flag="28" singleton="1" />
<row itemID="1240652241" typeID="3640" quantity="1" flag="27" singleton="1" />
</rowset>
</row>

---

Originally by: Azazel Mordred

---

That path issue is rather odd, I've been using exactly this format for include_path setting on Linux and Windows, under IIS and Apache, and it's never given me problems. Your suggestion is the correct way of doing it though, so I'll factor that into the next update.

---

Originally by: Azazel Mordred

---

Also not sure why you had an issue inserting an empty date on signup, but I'll get that sorted as soon as possible. What MySQL version are you using?

---

Quote:

---

CREATE TABLE IF NOT EXISTS `user` (
`id` int(11) NOT NULL auto_increment,
`username` varchar(32) NOT NULL,
`password` varchar(64) NOT NULL,
`email` varchar(32) NOT NULL,
`timezone` varchar(128) NOT NULL default 'GMT',
`theme` varchar(64) NOT NULL,
`proxy` varchar(256) NOT NULL,
`level` tinyint(4) NOT NULL,
`account_id` int(11) NOT NULL,
`activetime` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `username` (`username`,`password`)
);

---

Originally by: Azazel Mordred

---

Apologies, caught me doing some quick DB changes :). It's all back up now.

---

Originally by: Maglorre

---

OK,
Got a few things to report.

I set it up under Zend Core on a Windows box (normally use Unix/Linux at work but just don't have one at home right now). Had to do a bit of fiddling with path and directory separators in the config files to make it all happy. For example

Quote:

---

ini_set('include_path', ini_get('include_path') . PATH_SEPARATOR . dirname(__FILE__) . DIRECTORY_SEPARATOR . 'libs' . PATH_SEPARATOR . dirname(__FILE__) . DIRECTORY_SEPARATOR . 'eve');

---

Basically, make use of DIRECTORY_SEPARATOR and PATH_SEPARATOR constants in the config.php and site.php instead of / and : and it all works fine (sort of).

---

1. Mining Utility misses mining equipment(i.e strip miner II) and mining products (i.e. ice ores)


2. Profitability Tool has memory issues. Couldn't get it to work with the characters that have a lot of BPOs. Might want to look into such issues...


3. Some redirects get you to wrong url. For example I use a url patter or domainname:port and when I select another account I am redirected to simple domainname rather than domainname:port. Surely I can add it by hand, but is annoying :)

Originally by: Tonto Auri

---

Originally by: Azazel Mordred

---

Apologies, caught me doing some quick DB changes :). It's all back up now.

---

Sooory mate, isn't it just said that you're using 'root' user to access database? What you're using as brain replacement if that's true?

---

<?php 
 phpinfo();
?>

Quote:

---

Bugs Fixed:

Changing password via preferences now works, it did not previously.
Added missing level 0 skill image to all templates.
Added 0 to roman numerals function, so correct level is given for level 0 skills.

Cosmetic Changes:

Typo "Availabe Items" changed to "Available Items" under Market Prices.
Paid From changed to Paid By under Journal.
Remain. changed to Remaining under Market Orders.

Optional Downloads:

Created Blueprint Pack - As all blueprints were missing from the graphics pack.

---

Originally by: MyDow

---

Warning: curl_setopt() function.curl-setopt: CURLOPT_FOLLOWLOCATION cannot be activated when in safe_mode or an open_basedir is set in /www/htdocs/***edit***/outofeve/includes/libs/curl.class.php on line 361

phpinfo() tells me curl is enabled and openbasedir is set.

can you help here please?

---

Originally by: Ben Thomas

---

Edited by: Ben Thomas on 10/12/2008 23:13:32

Originally by: MyDow

---

Warning: curl_setopt() function.curl-setopt: CURLOPT_FOLLOWLOCATION cannot be activated when in safe_mode or an open_basedir is set in /www/htdocs/***edit***/outofeve/includes/libs/curl.class.php on line 361

phpinfo() tells me curl is enabled and openbasedir is set.

can you help here please?

---

I'm guessing PHP safe_mode is probably on. You'll need it off to fix this - and will likely have to ask your webhost to do this for you.

---

Originally by: Azazel Mordred

---

Regarding the inability to log in, I wonder if I could ask a favour.

...
If you could also let me know what web server software and version you're using, that may help also.

---

Originally by: S'if

---

just installed this locally on my PC and I'm getting the following error message repeating multiple times:


Warning: Division by zero in C:\xampp\htdocs\outofeve\includes\functions.php on line 141

Any ideas?

---

Originally by: Azazel Mordred

---

Originally by: S'if

---

just installed this locally on my PC and I'm getting the following error message repeating multiple times:


Warning: Division by zero in C:\xampp\htdocs\outofeve\includes\functions.php on line 141

Any ideas?

---

Looks like your "keypass" file is either empty or doesn't exist. You'll need to create a new file with a single "secret" word in it, and check that config.php's option "$config['site']['keypass']" points to it.

---

Originally by: S'if

---

Does that file need to have a specific name or can I crete any randomnly named txt file? My path is currently set as '/outofeve/ooekeypath' - and I created a folder in the install directory called ooekeypath and put the txt file called ooekeypass.txt in there - is that right?

---

Originally by: Ben Thomas

---

Originally by: S'if

---

Does that file need to have a specific name or can I crete any randomnly named txt file? My path is currently set as '/outofeve/ooekeypath' - and I created a folder in the install directory called ooekeypath and put the txt file called ooekeypass.txt in there - is that right?

---

No. In that case the path should be (assuming ooekeypath is inside your outofeve directory)

$config['site']['keypass'] = 'C:\xampp\htdocs\outofeve\ooekeypath\ooekeypass.txt';

What was originally referred to in the config file was a Linux file path. As you are using Windows, you need to use the exact path to the file, as I have provided above for you.

Hope this helps!

---

Originally by: Rilwar

---

Also, a suggestion if I may. Make a dropdown for any of the plugins that have a corp and char output, I.E. the Industry pages. Simply editing char to corp in the plugin gave me a perfect result, so I'm thinking it would be simple.

---

• Your are only doing a single MD5 hash of the password variable when setting the cookie. You might want to consider adding a random salt value to this md5 sum either on a per-user basis (stored in the DB in the user table) or globally (defined value in the config.php). Rainbow tables make unsalted MD5 hashes trivia to reverse. While this won't prevent access to OOE if somebody manages to get the cookie values it will protect the users from themselves if they've used their OOE password someplace else (like their EVE login) something that happens all to often unfortunately.


• You might want to consider using a database abstraction layer like ADODB or MDB2 or moving to the MySQLi PHP interface and run all of your DB queries through a prepare/bind/execute cycle to further protect against SQL injections. I notice that you are escaping user input which is good but this would just add an extra layer of protection.

Quote:

---

Have you ever considered using ajax in your project? As I am no PHP professional I had several difficulties to make a plugin that uses xajax, without changing your base code.

---

Quote:

---

Do you know someone else who is implementing corp plugins atm? Just would like to know whatkind of tools I can expect and for what plugins community has a need for.

---

Quote:

---

You might want to consider using a database abstraction layer like ADODB or MDB2 or moving to the MySQLi PHP interface and run all of your DB queries through a prepare/bind/execute cycle to further protect against SQL injections. I notice that you are escaping user input which is good but this would just add an extra layer of protection.

---

Quote:

---

Although since you (and perhaps others?) may be interested in adding plugins with AJAX support, it's pretty trivial to add some built-in AJAX support, which other developers can make use of.

---

Quote:

---

Fatal error: Uncaught exception 'PDOException' with message 'could not find driver' in
/..dir../outofeve/includes/database.php:15 Stack trace: #0 /..dir../outofeve/includes/database.ph
(15): PDO->__construct('mysql:host=[address]', '[user]', '[pass]') #1
/..dir../outofeve/includes/database.php(10): DBManager->Connect(Array) #2
/..dir../outofeve/includes/site.php(20): DBManager->DBManager(Array) #3
/..dir../outofeve/index.php(8): Site->Site() #4 {main} thrown in
/..dir../outofeve/includes/database.php on line 15

---

Quote:

---

PDO
PDO supportenabled
PDO drivers sqlite, sqlite2

pdo_sqlite
PDO Driver for SQLite 3.xenabled
PECL Module version (bundled) 1.0.1 $Id: pdo_sqlite.c,v 1.10.2.6.2.1 2007/01/01 09:36:05 sebastian Exp $
SQLite Library 3.3.7

---

Quote:

---

PDO
PDO supportenabled
PDO drivers sqlite, sqlite2

Edit - I think my problem is that while PDO is installed, it's only setup for sqlite and sqlite2, not mysql. I'm just guessing at this point... I'll contact my hosting provider to see if they can enable it though.

---

Originally by: Azazel Mordred

---

Right now, I'm building in Corporation support - corp sheet and member listing/activity, transactions, journal, market orders, assets, kills, POSs etc. Should all be in action before Christmas .

---

Originally by: Adira Deimos

---

Azazel,

Any chance of this awesome tool being done without requiring the PDO mySql driver? (My hosting company won't install the required driver. It seems their on Debian, and claim the PDO mySql driver isn't compatible with their shared hosting architecture.)

---

Quote:

---

Lists ALL BPC/BPO's :''( (yes i know CCP dont difrenciate)
could this data be collapsable or sortable into type ?

---

Quote:

---

does the calculator use the prints actual ME level or is it all ME set by the drop down menu ?

---

Quote:

---

Not sure if it's just me or not, but I've got a whole bunch of icon errors while looking at the manufacture page.

---

Originally by: Azazel Mordred

---

Quote:

---

Not sure if it's just me or not, but I've got a whole bunch of icon errors while looking at the manufacture page.

---

Could you perhaps try applying the images provided by Ben Thomas in this post? I neglected to include BP image support since prior to the latest image dump, these weren't available. Will be corrected for the next release.

---

Originally by: Mangala Solaris

---

Getting this repeated endlessly on every page:

Warning: Division by zero in /home/jonsscom/public_html/maadim/maadimanage/includes/functions.php on line 141

I think I have linked to the ooekey correctly, but is there anything I may have missed? (Coding is beyond me, i just muddle on till things work)

---

/home/jonsscom/ooekey.txt

$config['site']['keypass'] = '/home/jonsscom/ooekey.txt';

Originally by: Azazel Mordred

---

OOE 1.4 released with corporation support, original post updated with all the new stuff. If you're running your own OOE instance, please see the update notes at the end of the original post in this thread.

Existing outofeve.com users will have access to the new corporation stuff automatically.

---

Originally by: Helena Shun

---

In apiChar.php, loadCorporation never gets called, thus making it pretty much impossible to access the corporation section.

---

Originally by: Helena Shun

---

In corpLogo.php, the layers gets printed backwards (top most layer at the bottom, and vis-versa).

---

Originally by: Helena Shun

---

Originally by: Azazel Mordred

---

OOE 1.4 released with corporation support, original post updated with all the new stuff. If you're running your own OOE instance, please see the update notes at the end of the original post in this thread.

Existing outofeve.com users will have access to the new corporation stuff automatically.

---

Alright, 2 small bugs with the source release.

In apiChar.php, loadCorporation never gets called, thus making it pretty much impossible to access the corporation section.

In corpLogo.php, the layers gets printed backwards (top most layer at the bottom, and vis-versa).

---

Originally by: Ben Thomas

---

Edit: Another bug to report, "Currently Training: Leadership to level 0IV, eta 1h 7m" (note 0 in front of actual level), fixed this by using the method I came up with originally to display level 0 skills.

---

Originally by: Azazel Mordred

---

Originally by: Ben Thomas

---

Edit: Another bug to report, "Currently Training: Leadership to level 0IV, eta 1h 7m" (note 0 in front of actual level), fixed this by using the method I came up with originally to display level 0 skills.

---

Hah, at least someone's paying attention .

Re-fixed properly .

---

Originally by: Azazel Mordred

---

On the menu issues, I suspect it's related to the above, perhaps grab the updated package and take another look?

---

Originally by: Rilwar

---

Although I'm still only seeing the single Corporation entry in the Corporation Data menu.

---

Originally by: Azazel Mordred

---

Originally by: Rilwar

---

Although I'm still only seeing the single Corporation entry in the Corporation Data menu.

---

This is rather odd. Might I ask how your character's corporation roles are configured? If you have either of Director or Factory Manager enabled, the Manufacturing (for example) option should definitely be showing up.

Are you perhaps only using titles rather than manually assigned roles? I'm not sure, but perhaps the API doesn't return the correct role setup per character when roles are purely title-managed (wild guessing here).

---

Originally by: Azazel Mordred

---

Just updated with a whole bunch of stuff. See the original post for changes and upgrade info. Should address almost all issues pointed out so far.

Sorry for spamming with updates

---

Originally by: Azazel Mordred

---

That'd be the one with your user and account details (not the data dump).

---

Originally by: Azazel Mordred

---

Sorry for spamming with updates

---

Originally by: Azazel Mordred

---

Man, some really random stuff seems to be getting though all the damn time. I've corrected 1.5 with the proper length API key field.

I think I'm trying to hurry too much with these releases to get everything done while I'm on my piddly 7 days of leave. Anyway, expect slower better executed releases next time .

Thanks a LOT for the ISK everyone who's donated, it's nice motivation

---

Originally by: Ben Thomas

---

Aww, if you do end up slowing down the release cycle, I'm more than happy to be a beta tester if you'd like to err, keep me busy

---

Originally by: Rilwar

---

Playing with 1.5, attempted to toggle the checkboxes for forcing corp menus, the API Key box loads the encrypted API key, that pops a API Auth Failure error, inputting the real API key and then trying to save settings with the boxes enabled also throw up the error.

Also not sure if it's just me, or the fact I've hammered all my API sheets over and over the past few minutes (Cache clearing) - But OOE won't load any data now, even after resotring the OOE cache files to an earlier set. I'll update this in a little over an hour, see if I just upset CCP's API server.

---

Originally by: William Shakespeare

---

A fool thinks himself to be wise, but a wise man knows himself to be a fool.

---

Originally by: Rilwar

---

Which is correct, however;

• Status
  In Progress -1.08%

---

Originally by: S'if

---

Edited by: S''if on 31/12/2008 00:03:32
OK I got everything running fine on my local test server and am now trying to install this on my host. I can register new members fine as I can see them in the database, however when I try to login nothing happens and I return to the main page.

Is this something to do with the encryption file?

---

Quote:

---

same problem on 2 servers, already ask several time about this bug but no real answer. Hope someone have the answer...

---

Originally by: Error Log

---

[31-Dec-2008 09:52:33] PHP Notice: Undefined offset: 16594 in /nfs/webroots/gs-apps/public_html/outofeve/includes/eve/apiChar.php on line 255
[31-Dec-2008 09:52:33] PHP Notice: Undefined offset: 3444 in /nfs/webroots/gs-apps/public_html/outofeve/includes/eve/apiChar.php on line 255
[31-Dec-2008 09:52:33] PHP Notice: Undefined offset: 18580 in /nfs/webroots/gs-apps/public_html/outofeve/includes/eve/apiChar.php on line 255
[31-Dec-2008 09:52:33] PHP Notice: Undefined offset: 3447 in /nfs/webroots/gs-apps/public_html/outofeve/includes/eve/apiChar.php on line 255
[31-Dec-2008 09:52:33] PHP Notice: Undefined offset: 16596 in /nfs/webroots/gs-apps/public_html/outofeve/includes/eve/apiChar.php on line 255

---

Originally by: Error Log

---

[31-Dec-2008 01:45:40] PHP Warning: touch() [<a href='function.touch'>function.touch</a>]: Unable to create file /nfs/webroots/gs-apps/var/ooe/cache/market/8b4c03d1ed382ff417879ca92beb67a0 because No such file or directory in /nfs/webroots/gs-apps/public_html/outofeve/includes/eve/apimarket.php on line 60

---

Originally by: Walkin' Dude

---

Quote:

---

same problem on 2 servers, already ask several time about this bug but no real answer. Hope someone have the answer...

---

What version of php is on the host? Think you need php 5.2+

---

Originally by: Solo Drakban

---

Originally by: Error Log

---

[31-Dec-2008 09:52:33] PHP Notice: Undefined offset: 16594 in /nfs/webroots/gs-apps/public_html/outofeve/includes/eve/apiChar.php on line 255
[31-Dec-2008 09:52:33] PHP Notice: Undefined offset: 3444 in /nfs/webroots/gs-apps/public_html/outofeve/includes/eve/apiChar.php on line 255
[31-Dec-2008 09:52:33] PHP Notice: Undefined offset: 18580 in /nfs/webroots/gs-apps/public_html/outofeve/includes/eve/apiChar.php on line 255
[31-Dec-2008 09:52:33] PHP Notice: Undefined offset: 3447 in /nfs/webroots/gs-apps/public_html/outofeve/includes/eve/apiChar.php on line 255
[31-Dec-2008 09:52:33] PHP Notice: Undefined offset: 16596 in /nfs/webroots/gs-apps/public_html/outofeve/includes/eve/apiChar.php on line 255

---

These seem to appear doing just about anything.

Originally by: Error Log

---

[31-Dec-2008 01:45:40] PHP Warning: touch() [<a href='function.touch'>function.touch</a>]: Unable to create file /nfs/webroots/gs-apps/var/ooe/cache/market/8b4c03d1ed382ff417879ca92beb67a0 because No such file or directory in /nfs/webroots/gs-apps/public_html/outofeve/includes/eve/apimarket.php on line 60

---

---

Originally by: Rilwar

---

Your error log prompted me to check mine as well, but is empty. I don't have extensive knowledge of everything HTTPD/PHP related, but I'm wondering if maybe fcgi is the culprit there? I'm using PHP 5.2.6 without fcgi, so there's very little disparity between our versions.

-EDIT What version of fcgi are you running, and *nix/Win32? I'll try installing fcgi on my copy to test that theory, as I'm assuming doing the reverse on your systems would be much more hassle than it's worth to see if it is in fact the problem.

---

Originally by: Rilwar

---

Also, if you've not looked @ index.php - Theres a commented line to add Query/Execution data, check what that gives you, I'm curious as to what GF's memory usage might be if my little alt corp with no starbases uses 4MB to hash out the starbases module.

---

Originally by: Helena Shun

---

Concerning all the Notices, just add the following line in index.php

error_reporting(E_ALL & ~E_NOTICE);

That's should "fix" them.

---

Originally by: Solo Drakban

---

I highly doubt it's fcgi. There really isn't any difference between FCGI and mod_php other than one is handled internal to the webserver and the other is handled external. If you really want to know the FCGI pool is running a separate server. It's PHP v5.2.8 running in an FCGI pool listening on a socket. The FCGI spawner is the spawn-cgi system (and scripts) that come with lighttpd slightly modified to allow for separate php.ini's for each FCGI pool. The front-end webserver is lighttpd. The web directories are mounted via NFS from a third server and the pathing is identical on both front and back-end servers to avoid any possible pathing issues.

---

Originally by: Solo Drakban

---

Processed in 2.5662 seconds, 389 queries, 13307.05kb memory used.

---

Originally by: Solo Drakban

---

Originally by: Helena Shun

---

Concerning all the Notices, just add the following line in index.php

error_reporting(E_ALL & ~E_NOTICE);

That's should "fix" them.

---

No, that will just mask them. If I wanted to just mask them I would have already done this and not posted about them being an issue.

---

Originally by: Pronas

---

Originally by: S'if

---

Edited by: S''if on 31/12/2008 00:03:32
OK I got everything running fine on my local test server and am now trying to install this on my host. I can register new members fine as I can see them in the database, however when I try to login nothing happens and I return to the main page.

Is this something to do with the encryption file?

---

same problem on 2 servers, already ask several time about this bug but no real answer. Hope someone have the answer...

---

Originally by: S'if

---

Originally by: Pronas

---

Originally by: S'if

---

Edited by: S''if on 31/12/2008 00:03:32
OK I got everything running fine on my local test server and am now trying to install this on my host. I can register new members fine as I can see them in the database, however when I try to login nothing happens and I return to the main page.

Is this something to do with the encryption file?

---

same problem on 2 servers, already ask several time about this bug but no real answer. Hope someone have the answer...

---

on my installation, users can register, but not login. Login redirection me to index.

No one hass any ideas about this then? Really frustrating as it is such a good bit of software.

---

Originally by: Helena Shun

---

Note that notices in PHP are just that... Notices... they do not affect the functionality of the application in any way, they just warn the coder that a possible issue may be present in their program (if the said behavior is unintended). Notices should be disabled on a production server. For development, you leave them on, not on production.

---

Quote:

---

when i try to look at production profitability

it tells me i dont own any BP's

my corp owns tons ( and i have full director access )

so why isnt it working?

---

Quote:

---

OK I got everything running fine on my local test server and am now trying to install this on my host. I can register new members fine as I can see them in the database, however when I try to login nothing happens and I return to the main page.

Is this something to do with the encryption file?

---

Quote:

---

Original: $newPlug = new $plugin(&$this->db, &$this);
Modified: $newPlug = new $plugin($this->db, $this);

I just removed the ampersands to enable the call-time pass-by-reference.

---

Quote:

---

I'm also sorry to report that it doesn't react well to a huge corporation.. :( The Asset list for corporation won't load for GoonFleet due to memory allocation limitations. I have PHP allowed to use up to 128MB of RAM per instance but apparently that's not enough. As an experiment I bumped it up to 256MB but it still failed. Perhaps some sort of paging system for the data? :)

---

Quote:

---

OK I got everything running fine on my local test server and am now trying to install this on my host. I can register new members fine as I can see them in the database, however when I try to login nothing happens and I return to the main page.

Is this something to do with the encryption file?

I'm really sorry about this, but I've no idea what on earth could be preventing users logging in :(. I'm almost convinced it's a cookie problem, so I'll try some things in this area for the next update.

If it were a 'keypass' problem as others have had, you'd be getting big errors with the latest release informing you of a problem, and pages would refuse to load at all.

I know this sounds silly (desperation), but after 'logging in', have you tried a Ctrl+F5?

---

Quote:

---

1146 [2] => Table 'eve_dbo.crpRoles' doesn't exist

---

Originally by: Shiu

---

Edited by: Shiu on 13/01/2009 12:14:55
Edited by: Shiu on 13/01/2009 11:39:23
Edited by: Shiu on 13/01/2009 11:09:01
Edited by: Shiu on 13/01/2009 10:42:57
Just installed PHP 5.2.8 and gotten to the point where I can log in, and I get the data from my character. However the XML file is displayed on the background behind everything making it really hard to read. I have absolutely no idea what causes this.

Any ideas?

Edit: just noticed it only happens with one of my characters. My main one.


Another Edit: It seems that when using two different databases it looks for the user details in the wrong database when selecting a certain character.
Im using two databases. c_ooe and eve_dbo. c_ooe contains the users and API details. But since Im logging in fine and getting the details there must be an error in the code, or I installed it wrong.
Heres a snippet of the error I get.

Quote:

---

1146 [2] => Table 'eve_dbo.crpRoles' doesn't exist

---

Edit: This is indeed the problem, after creating the crpRoles table in eve_dbo it now works fine.
Edit: The manufacture and research page tries to grab the ramCompletedStatuses table from eve_dbo. after creating this tablev in eve_dbo it is fine as well

---

Originally by: install.txt

---

Installation is quite straight-forward. Extract and upload the contents of the
outofeve-x.x.tar.bz2 source package to your web server.

Extract and upload the contents of outofeve-eveimages-x.x.tar.bz2 to the same
location.

When you have the MySQL database dump imported, you will need to run the
included "additional-tables.sql" SQL script, which will create tables for
the missing Manufacturing completion status descriptions, and ore reprocessing
values.

---

Quote:

---

API key encryption file not found at "/root/ooekeypass"

---

Quote:

---

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/root/ooekeypass) is not within the allowed path(s): (/home/<username>/:/tmp:/usr/local/lib/php/) in /home/<username>/domains/<domain.com>/public_html/includes/functions.php on line 108

---

Originally by: Adira Deimos

---

Found a hosting company that I think meets the install requirements.

Server: Running on Linux / PHP 5.2.8 with Curl, mcrypt, and mysql PDO / MySql 5

Out of Eve: 1.5 QR


I'm trying to get through the ooekeypass error, and having problems. It's in the root of the webspace. (domain.com = website || domain.com/ooekeypass/ooekeypass.txt = key file)

I tried the example in the config file, and everything else working backwards that shows up when I login via FTP.

Via FTP this is what I see:
/domains/<domain>/public_html

I've seen some people comment on open_basedir settings at the host I have, so I'll share that too. phpinfo shows "/home/<username>/:/tmp:/usr/local/lib/php/" (I replaced username obviously)

My typical error:

Quote:

---

API key encryption file not found at "/root/ooekeypass"

---

Sometimes I get this one too, like when I use the default example:

Quote:

---

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/root/ooekeypass) is not within the allowed path(s): (/home/<username>/:/tmp:/usr/local/lib/php/) in /home/<username>/domains/<domain.com>/public_html/includes/functions.php on line 108

---

Any suggestions on what I should use for the directory path? Or is it an issue with the open_basedir restriction error?

---

Also, you will need to create an encription key file. This is a simple plain 
text file containing nothing but a keyword which will be used to encrypt API
keys. This file should be kept well away from any www-published paths. An 
example for creating a key file on *nix:

 $ echo "mykey9876" > /root/ooekeypass

API key encryption file not found at "xxx"

Originally by: CyPhEr UmOs

---

I have everything set up but ran into a glitch. The following part of your instructions I do not know how to do:

Also, you will need to create an encription key file. This is a simple plain 
text file containing nothing but a keyword which will be used to encrypt API
keys. This file should be kept well away from any www-published paths. An 
example for creating a key file on *nix:

 $ echo "mykey9876" > /root/ooekeypass

I do not have access to command line, only cPanel. I tried creating a text file with a key code in it but nothing happens, it gives me the following error message:

API key encryption file not found at "xxx"

Can you please tell me how to accomplish this part?

---

Originally by: CyPhEr UmOs

---

I am not provided ssh access or telnet access to my account. They do not offer it. There has to be a way to do this without requiring command line access.

---

Originally by: Rilwar

---

Edited by: Rilwar on 20/01/2009 21:46:24

Originally by: CyPhEr UmOs

---

I am not provided ssh access or telnet access to my account. They do not offer it. There has to be a way to do this without requiring command line access.

---

Create text file named ookeypass.txt

Upload said file to your /includes folder. The one with config.php in it.

Go thru cPanel and rename said text file, remove the .txt from the end.

Use this;

$config['site']['keypass'] = 'includes/ookeypass';


Using the '/home/<cpanel login name>/ooekeypass'; is redundant, there's no point to it. The server is automagically looking for the file starting from the directory that index.php is in, telling it to go all the way down to /home then back up to your userdir is dumb.




TBH I *guarantee* you're getting hung up on the file extension. Linux does not require them, and wayyyyyyy too many people are too used to Windows coddling them.

---

Originally by: Walkin' Dude

---

Quote:

---

OK I got everything running fine on my local test server and am now trying to install this on my host. I can register new members fine as I can see them in the database, however when I try to login nothing happens and I return to the main page.

Is this something to do with the encryption file?

I'm really sorry about this, but I've no idea what on earth could be preventing users logging in :(. I'm almost convinced it's a cookie problem, so I'll try some things in this area for the next update.

If it were a 'keypass' problem as others have had, you'd be getting big errors with the latest release informing you of a problem, and pages would refuse to load at all.

I know this sounds silly (desperation), but after 'logging in', have you tried a Ctrl+F5?

---

---

I have already asked twice in this thread what version of php people are using when they have problems logging in, since it seems php 5.2+ is required. I tried with php 5.1 and could not log in, php 5.2, it worked.

---

Originally by: Sen Quenten

---

Originally by: Walkin' Dude

---

Quote:

---

OK I got everything running fine on my local test server and am now trying to install this on my host. I can register new members fine as I can see them in the database, however when I try to login nothing happens and I return to the main page.

Is this something to do with the encryption file?

I'm really sorry about this, but I've no idea what on earth could be preventing users logging in :(. I'm almost convinced it's a cookie problem, so I'll try some things in this area for the next update.

If it were a 'keypass' problem as others have had, you'd be getting big errors with the latest release informing you of a problem, and pages would refuse to load at all.

I know this sounds silly (desperation), but after 'logging in', have you tried a Ctrl+F5?

---

---

I have already asked twice in this thread what version of php people are using when they have problems logging in, since it seems php 5.2+ is required. I tried with php 5.1 and could not log in, php 5.2, it worked.

---

5.2.8 here. Still not able to log in. Both user[username] and user[password] cookies are in the browser. The user record is in the database. Nothing is in the Apache error log file. Any other thoughts?

---

Originally by: Tinka Blackmore

---

I has the same problem.

FIX: change function QueryA in includes/database.php

function QueryA($sql)
{
$rs = $this->Query($sql);
if ($rs)
{
//if ($rs->rowCount() > 0)
return $this->rsToArray($rs);
//else
//return false;
}
else
print_r(array('errorInfo' => $this->conn->errorInfo(), 'sql' => $sql));
}

Than you can login...

---

Quote:

---

Found a workaround on an earlier page:

Originally by: Tinka Blackmore

---

I has the same problem.

FIX: change function QueryA in includes/database.php

function QueryA($sql)
{
$rs = $this->Query($sql);
if ($rs)
{
//if ($rs->rowCount() > 0)
return $this->rsToArray($rs);
//else
//return false;
}
else
print_r(array('errorInfo' => $this->conn->errorInfo(), 'sql' => $sql));
}

Than you can login...

---

Function is a bit different now, but the principle is the same.

Love the program. Excellent work. I would like to make one recommendation. For the transactions lists, it'd be great to filter on buy or sell orders.

---

you@host:~/public_html$ svn co http://outofeve.com/sv/trunk/ outofeve

Originally by: Tourim

---

Okay... my understanding of mysql and php is rather limited. I installed ooe on my macbook. At the beginning it went fine but as I tried to login, after registration, I got a blank page. Since I'm a total php-n00b I fooled a bit around with some text outputs in the functions and found that it crashes during the loadPlugins function after the line $newPlug....

I'm running:
Apache 2.0.59
MySQL 5.0.41
PHP 5.2.3
curl 7.16.2
mcrypt 2.5.8

---

Originally by: Melysa Reul

---

I got a weird error when running on nginx:

2009/02/01 15:06:08 [error] 5775#0: *21182 FastCGI sent in stderr: "PHP Notice: Undefined property: Site::$character in /data/www/www.mysite.net/htdocs/outofeve/plugins/character/plugin.php on line 10
PHP Notice: Undefined index: mode in /data/www/www.mysite.net/htdocs/outofeve/plugins/users/plugin.php on line 116" while reading response header from upstream, client: 69.31.81.37, server: www.mysite.net, request: "POST /outofeve/ HTTP/1.0", upstream: "fastcgi://127.0.0.1:8888", host: "www.mysite.net", referrer: "http://www.mysite.net/outofeve/"

---

Originally by: midge Mo'yb

---

Edited by: midge Mo''yb on 02/02/2009 03:54:55
Ive installed this and am getting this weh ni hit register -

PHP Notice: Undefined index: username in \outofeve\plugins\users\plugin.php on line 137
PHP Notice: Undefined index: password in \outofeve\plugins\users\plugin.php on line 138

If anyone could help that would be great :p

---

Originally by: Erialor Godsent

---

Originally by: Tourim

---

Okay... my understanding of mysql and php is rather limited. I installed ooe on my macbook. At the beginning it went fine but as I tried to login, after registration, I got a blank page. Since I'm a total php-n00b I fooled a bit around with some text outputs in the functions and found that it crashes during the loadPlugins function after the line $newPlug....

I'm running:
Apache 2.0.59
MySQL 5.0.41
PHP 5.2.3
curl 7.16.2
mcrypt 2.5.8

---

Sounds like your solved your problem - care to share how, please?

Having installed 1.5QR I were able to register an user fine (and it gets added to the DB fine) but when logging in I end up with a blank page.

Apache-logs doesn't show anything out of the ordinary...

---

Originally by: Rilwar

---

Originally by: midge Mo'yb

---

Edited by: midge Mo''yb on 02/02/2009 03:54:55
Ive installed this and am getting this weh ni hit register -

PHP Notice: Undefined index: username in \outofeve\plugins\users\plugin.php on line 137
PHP Notice: Undefined index: password in \outofeve\plugins\users\plugin.php on line 138

If anyone could help that would be great :p

---

Who are you using as a webhost?

What version of PHP are they running?

---

Originally by: Tourim

---

Okay... my understanding of mysql and php is rather limited. I installed ooe on my macbook. At the beginning it went fine but as I tried to login, after registration, I got a blank page. Since I'm a total php-n00b I fooled a bit around with some text outputs in the functions and found that it crashes during the loadPlugins function after the line $newPlug....

I'm running:
Apache 2.0.59
MySQL 5.0.41
PHP 5.2.3
curl 7.16.2
mcrypt 2.5.8

---

Originally by: Tourim

---

Edited by: Tourim on 01/12/2008 21:06:31
Hi!
After a bit of work I got ooe to run. The mistake, as aspected, has been on my site. So... now I got a nice overview of this really great app and have some features I would love to request.

- It would be great to have the prizes of every item in the asset view. Those prizes could be cached once or twice a week. Amybe even for the region the item is in (and jita).
- A reprocess calculator would be nice
- Some nice visual presentation of the data would be cool. Maybe that will help u (http://www.liquidx.net/plotkit/) If u want some help with the javascript stuff maybe I can help u out a bit.

thx again.

TouriM

---

$newPlug = new $plugin(&$this->db, &$this);

Originally by: ShadowandLight

---

i LOVE THIS WEBSITE

could we make the website smarter for POS stuff?

maybe incorporate "mypos" like qualities?

http://oldforums.eveonline.com/?a=topic&threadID=585203

---

Originally by: Rilwar

---

Using the '/home/<cpanel login name>/ooekeypass'; is redundant, there's no point to it. The server is automagically looking for the file starting from the directory that index.php is in, telling it to go all the way down to /home then back up to your userdir is dumb.

---

17c17,25
< $prep = $this->conn->prepare($sql);
---
> $prep = $this->conn->prepare($sql);
> if (!$prep){
> echo $dbh->errorCode() . "<br>";
> $info = $dbh->errorInfo();
> print_r(array('errorInfo' => $info, 'sql' => $sql));
> // $info[0] == $dbh->errorCode() unified error code
> // $info[1] is the driver specific error code
> // $info[2] is the driver specific error string
> }

Originally by: Sen Quenten

---

Originally by: Walkin' Dude

---

Quote:

---

OK I got everything running fine on my local test server and am now trying to install this on my host. I can register new members fine as I can see them in the database, however when I try to login nothing happens and I return to the main page.

Is this something to do with the encryption file?

I'm really sorry about this, but I've no idea what on earth could be preventing users logging in :(. I'm almost convinced it's a cookie problem, so I'll try some things in this area for the next update.

If it were a 'keypass' problem as others have had, you'd be getting big errors with the latest release informing you of a problem, and pages would refuse to load at all.

I know this sounds silly (desperation), but after 'logging in', have you tried a Ctrl+F5?

---

---

I have already asked twice in this thread what version of php people are using when they have problems logging in, since it seems php 5.2+ is required. I tried with php 5.1 and could not log in, php 5.2, it worked.

---

5.2.8 here. Still not able to log in. Both user[username] and user[password] cookies are in the browser. The user record is in the database. Nothing is in the Apache error log file. Any other thoughts?

---

Originally by: Croax Kra

---

love this tool, but since a few days i get this error.



would be good if, the error would build up at the bottom of the page, so I could check the pref.

---

Originally by: Quantar Raalsken

---

Edited by: Quantar Raalsken on 08/04/2009 02:48:32
Edited by: Quantar Raalsken on 08/04/2009 02:35:08
OMG how did i miss this b4?

EXACTLY what i need

tho can i ask? can u see if u can add it so that i can check production profitability of BPCs and BPOs that belong to the corp?

it would rly help seeing as we have a whole bunch in our corp hanger

EDIT: also it seems a few icons are broken but thats nothing compared to some of the other issues ive seen

also i think the new probe launchers are getting errors as they are an Apocrypha thing and i see that the site is made for QR

EDIT2: also i think it would be pretty easy to pull from my assets and be able to calculate mining yield directly w/o having to pick out what modules im using...especially if im using a mix of modules

---

Originally by: Croax Kra

---

love this tool, but since a few days i get this error.



would be good if, the error would build up at the bottom of the page, so I could check the pref.

---

Quote:

---

Fatal error: Uncaught exception 'PDOException' with message 'invalid data source name' in .../outofeve/includes/database.php:12 Stack trace: #0 .../outofeve/includes/database.php(12): PDO->__construct('[my db]', '[my username]', '[my password]') #1 .../outofeve/includes/database.php(8): DBManager->Connect(Array) #2 .../outofeve/includes/site.php(18): DBManager->DBManager(Array) #3 .../outofeve/index.php(8): Site->Site() #4 {main} thrown in .../outofeve/includes/database.php on line 12

---

Originally by: Tribalize

---

Originally by: Quantar Raalsken

---

Edited by: Quantar Raalsken on 08/04/2009 02:48:32
Edited by: Quantar Raalsken on 08/04/2009 02:35:08
OMG how did i miss this b4?

EXACTLY what i need

tho can i ask? can u see if u can add it so that i can check production profitability of BPCs and BPOs that belong to the corp?

it would rly help seeing as we have a whole bunch in our corp hanger

EDIT: also it seems a few icons are broken but thats nothing compared to some of the other issues ive seen

also i think the new probe launchers are getting errors as they are an Apocrypha thing and i see that the site is made for QR

EDIT2: also i think it would be pretty easy to pull from my assets and be able to calculate mining yield directly w/o having to pick out what modules im using...especially if im using a mix of modules

---

Update the database using the apoc database should fix some of your probs.

---

Originally by: bigsteve

---

Unless the DB files are split up into more small manageable chunks/files. I will not be able to install the tables on my server.

---

Originally by: bigsteve

---

Unless the DB files are split up into more small manageable chunks/files. I will not be able to install the tables on my server.

---

[16-May-2009 09:42:32] PHP Warning: file_put_contents(/home/online/public_html/eve/includes/cache/24e58d8f08c1d53dbe81a60fdaeafd08) [<a href='function.file-put-contents'>function.file-put-contents</a>]: failed to open stream: No such file or directory in /home/online/public_html/eve/includes/eve/api.php on line 158
[16-May-2009 09:42:32] PHP Warning: touch() [<a href='function.touch'>function.touch</a>]: Unable to create file /home/online/public_html/eve/includes/cache/24e58d8f08c1d53dbe81a60fdaeafd08 because No such file or directory in /home/online/public_html/eve/includes/eve/api.php on line 159
[16-May-2009 09:42:32] PHP Warning: file_put_contents(/home/online/public_html/eve/includes/cache/790d6915e21a924d80e68f2b8881e3a9) [<a href='function.file-put-contents'>function.file-put-contents</a>]: failed to open stream: No such file or directory in /home/online/public_html/eve/includes/eve/api.php on line 158
[16-May-2009 09:42:32] PHP Warning: touch() [<a href='function.touch'>function.touch</a>]: Unable to create file /home/online/public_html/eve/includes/cache/790d6915e21a924d80e68f2b8881e3a9 because No such file or directory in /home/online/public_html/eve/includes/eve/api.php on line 159
[16-May-2009 09:42:32] PHP Warning: file_put_contents(/home/online/public_html/eve/includes/cache/c243545e83db40119427aac2751ba9d0) [<a href='function.file-put-contents'>function.file-put-contents</a>]: failed to open stream: No such file or directory in /home/online/public_html/eve/includes/eve/api.php on line 158
[16-May-2009 09:42:32] PHP Warning: touch() [<a href='function.touch'>function.touch</a>]: Unable to create file /home/online/public_html/eve/includes/cache/c243545e83db40119427aac2751ba9d0 because No such file or directory in /home/online/

Quote:

---

API Error: () A general error has occured, please try again later.

---

but no results

Quote:

---

<a href="#" onclick="showInfo({$i.typeid});return false;">
{if $i.icon}
<img src="{$site_url}/eveimages/icons/32/icon{$i.icon}.png" alt="{$i.typename}" align="absmiddle" />
{else}
<img src="{$site_url}/eveimages/types/32/{$i.typeid}.png" alt="{$i.typename}" align="absmiddle" />
{/if}
</a>

---

Quote:

---

function QueryA($sql, $params) {
$rs = $this->Query($sql, $params);
if ($rs) {
return $this->rsToArray($rs);
}
}

---

Quote:

---

Fatal error: Class 'DateTimeZone' not found in /home/default/ooe.exsecratio.com/user/htdocs/plugins/users/plugin.php on line 52

---

Originally by: Azazel Mordred

---

Sup

I r bax, and will hopefully be attending to a bunch of the errors which have been reported lately, revamping the error handling mechanisms, bringing everything up to Apocrypha-spec and supporting any new API things which might be changed or added since last I saw.

Cya soon.

---

Originally by: Azazel Mordred

---

Sup

I r bax, and will hopefully be attending to a bunch of the errors which have been reported lately, revamping the error handling mechanisms, bringing everything up to Apocrypha-spec and supporting any new API things which might be changed or added since last I saw.

Cya soon.

---

Originally by: Seiver D'amross

---

Edited by: Seiver D''amross on 29/06/2009 22:37:17
im running this on a box at home, any advice? i get this when trying to view assets


Fatal error: Allowed memory size of 16777216 bytes exhausted (tried to allocate 42 bytes) in /var/www/outofeve/includes/functions.php on line 16

---

Originally by: Azazel Mordred

---

I've made a small adjustment to the assets list, which may help the memory issue, feel free to grab it from SVN if you'd like to try it.

Alternatively if it doesn't make enough of a difference on a large asset list (mine is unfortunately way too small to test this properly ), and since you're running this on your own machine, you might try just upping the PHP memory limit to 32mb.

---

Originally by: Grasfer

---

Originally by: Azazel Mordred

---

I've made a small adjustment to the assets list, which may help the memory issue, feel free to grab it from SVN if you'd like to try it.

Alternatively if it doesn't make enough of a difference on a large asset list (mine is unfortunately way too small to test this properly ), and since you're running this on your own machine, you might try just upping the PHP memory limit to 32mb.

---

Where is the SVN?

---