Pages: 1 [2] 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 .. 21 :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Turhan Bey
EVE University Ivy League
0
|
Posted - 2011.09.28 02:14:00 -
[31] - Quote
I strongly recommend against using IGB trust to disseminate lost passwords. It is one of the easier things to spoof. Registering an email address on account creation would be the ideal "easy" solution.
EDIT: However, sending in-game EVEmails for password reminder/reset could be secure if the account has a CAK registered with character info access. But as stated above, it cannot be automated. |
Callean Drevus
Icosahedron Crafts and Shipping Silent Infinity
13
|
Posted - 2011.09.28 09:46:00 -
[32] - Quote
Turhan Bey wrote:I strongly recommend against using IGB trust to disseminate lost passwords. It is one of the easier things to spoof. Registering an email address on account creation would be the ideal "easy" solution.
EDIT: However, sending in-game EVEmails for password reminder/reset could be secure if the account has a CAK registered with character info access. But as stated above, it cannot be automated. I am not planning on using the IGB for any authentication whatsoever :)
It might just be safer and best to do those few times it happens manually. Until CCP builds in automatic sending of IG mails (spam ftw?). [img]http://www.evemarketeer.com/player/sig/511049420[/img] Want images? |
Scrapyard Bob
EVE University Ivy League
0
|
Posted - 2011.09.29 01:51:00 -
[33] - Quote
Quote:LOGSQL Insert Failed: insert into adodb_logsql (created,sql0,sql1,params,tracer,timer) values( NOW(),?,?,?,?,?) Table './admin_icras/adodb_logsql' is marked as crashed and last (automatic?) repair failed
http://www.evemarketeer.com/statistics/uploads/24
This is showing up at the top of a few pages as well as in the upload tool. |
Dragonaire
Corax. PURgE Alliance
11
|
Posted - 2011.09.29 03:47:00 -
[34] - Quote
Looks like the DB isn't keeping up and crashing for some reason I'd make sure it's not filling up it's log space. I've ran into default configs where every few days that was happening to me as well. There's some settings in my.cnf you should check and make sure it's not configured to keep them forever only like last 24 hours or so. Having thre extra query logging on also add a lot of extra load so except if you just turned it on to figure out what's going wrong I'd have it off on a production server. Finds camping stations from the inside much easier. Designer of Yapeal for Eve API. Check out the Yapeal forum thread |
Turhan Bey
EVE University Ivy League
0
|
Posted - 2011.09.29 17:54:00 -
[35] - Quote
I've noticed that when receiving these errors, it will sometimes work without fault, but then it will generate errors continuously for an even longer time. The ratio varies greatly, but seems to average perhaps 10 errors to 1 success.
I've also seen the Upload Backlog with greatly skewed values against EVE-MarketData. For example, as I write this, I see the backlog as:
EVE Marketeer: 2 EVE Marketdata: 127 EVE Central: 0
Just a guess, but perhaps it is the update rate from the EMD feed that is throttling the database? Can it be slowed down to see if doing so has an effect on the error rate? |
Callean Drevus
Icosahedron Crafts and Shipping Silent Infinity
13
|
Posted - 2011.09.29 18:15:00 -
[36] - Quote
Hey, thank you for your replies and help trying to get it fixed.
I made a post a few hours ago, but it seems it didn't get trough. First of all, I've installed logging software, that at least gives me an idea of what happens. If you feel interested, you can view the server stats via Munin
As you can see, there isn't anything shocking there, nothing suddenly happens, except a sudden spike in the usage of one disk. I've yet to find out what is causing this.
To clear two things up. It is not the error you've been seeing about logging, at least it seems very unlikely. That is just due to me neglecting to recover that table after the last crash (it's pretty much always writing to the log table, so every crash kills it :P).
It does not seem to be the database either, as I've been monitoring that, and it steadily keeps at about 5-10 connections doing queries a second, which isn't enough to kill it.
[img]http://www.evemarketeer.com/player/sig/511049420[/img] Want images? |
Gretzaki
The New Federation Detrimental Imperative
0
|
Posted - 2011.09.30 03:35:00 -
[37] - Quote
Callean Drevus wrote:Hey, thank you for your replies and help trying to get it fixed.
Update: It might be google, trying to index the website :P
Update II: The logs seem to be fine. No huge files there.
If you really think it might be a google index, try using a robots txt to ignore that directory of the site.
Also I would be interested in helping with development in any way I can. Please let me know.
and btw the backlogs are piling up....
EVE Marketeer 6355 EVE Marketdata 25 EVE Central 0 |
Domi Etymology
Violent Alternatives C0NVICTED
0
|
Posted - 2011.09.30 06:53:00 -
[38] - Quote
my uploader keeps giving me this:
Error: Upload unknown problem: Warning: mysql_connect(): Lost connection to MySQL server at 'reading initial communication packet', system error: 111 in /var/www/core/lib/adodb5/drivers/adodb-mysql.inc.php on line 362 1
? |
Vessper
Indicium Technologies Hephaestus Forge Alliance
0
|
Posted - 2011.09.30 14:40:00 -
[39] - Quote
Region XML download is giving errors again:
Warning: mysql_connect(): Lost connection to MySQL server at 'reading initial communication packet', system error: 111 in /var/www/core/lib/adodb5/drivers/adodb-mysql.inc.php on line 362
|
Callean Drevus
Icosahedron Crafts and Shipping Silent Infinity
14
|
Posted - 2011.09.30 20:13:00 -
[40] - Quote
Ok, I basically removed every server package that had anything to do with serving up pages and reinstalled the latest versions, and sometimes even different packages (I'm now using nginx instead of apache, and running php as cgi instead of module). In any case, I hope it solves some of the problems.
Also, I might need to start processing EMD orders in the same way I now process EMK orders, since that seems to be the fastest way, and I now get an immense backlog of EMD orders :P or I could just work on making order processing faster.
Gretzaki, expect an ingame mail about helping development soon. [img]http://www.evemarketeer.com/player/sig/511049420[/img] Want images? |
|
Scrapyard Bob
EVE University Ivy League
0
|
Posted - 2011.10.01 02:29:00 -
[41] - Quote
Callean Drevus wrote: Also, I might need to start processing EMD orders in the same way I now process EMK orders, since that seems to be the fastest way, and I now get an immense backlog of EMD orders :P or I could just work on making order processing faster.
As in, making the upload tool send them directly to EMD instead of passing them through the EMK site? That would be good, at least EMD would get its updates even if EMK is having trouble (or vice-versa).
(Tonight, in order to update market data, I'm using the EMD market-scanner page, because the EMK page button to start scanning is not showing up.) |
Callean Drevus
Icosahedron Crafts and Shipping Silent Infinity
14
|
Posted - 2011.10.01 07:30:00 -
[42] - Quote
It actually does directly send them to EMD, even before it sends them to EMK. So in that regard everything plods along pretty well even if the website is down (though the tool will keep complaining about not being able to upload to EMK, it should have uploaded to EMD fine) :P
I'll take a look at the scanner page, maybe something to do with the move. [img]http://www.evemarketeer.com/player/sig/511049420[/img] Want images? |
Scrapyard Bob
EVE University Ivy League
0
|
Posted - 2011.10.04 15:17:00 -
[43] - Quote
The scanner page is definitely still having issues, if it does come up, it eventually ends up with a gateway timeout error - which means my noble attempt to leave an alt logged in overnight comes to naught.
On the feature request side:
http://www.evemarketeer.com/statistics/uploads - It would be better if this page was sorted by region name in alphabetical order, instead of by RegionID
http://www.evemarketeer.com/statistics/regions - same request, please sort by region name
http://www.evemarketeer.com/item/itemprice/Oxygen_Isotopes - On the regional prices tab, it would be useful if there was an indicator as to how current the data is for each region. Maybe presented as "The Forge (3 hrs)" or "Domain (2 days)" - The orders tab, doesn't let me look at other regions |
Scrapyard Bob
EVE University Ivy League
0
|
Posted - 2011.10.04 15:24:00 -
[44] - Quote
One other question - does the EMK uploader send data to EVE Central as well?
(The fact that you send data to EMD in addition to EMK is a key reason I use your uploader.) |
Callean Drevus
Icosahedron Crafts and Shipping Silent Infinity
14
|
Posted - 2011.10.04 18:32:00 -
[45] - Quote
Scrapyard Bob wrote:The scanner page is definitely still having issues, if it does come up, it eventually ends up with a gateway timeout error - which means my noble attempt to leave an alt logged in overnight comes to naught. On the feature request side: http://www.evemarketeer.com/statistics/uploads- It would be better if this page was sorted by region name in alphabetical order, instead of by RegionID http://www.evemarketeer.com/statistics/regions- same request, please sort by region name http://www.evemarketeer.com/item/itemprice/Oxygen_Isotopes- On the regional prices tab, it would be useful if there was an indicator as to how current the data is for each region. Maybe presented as "The Forge (3 hrs)" or "Domain (2 days)" - The orders tab, doesn't let me look at other regions
Thank you for your feedback.
Sorting on the regions page makes sense, I'll fix that.
Sorting on the uploads page is already by name, only from left to right and up to down, instead of up to down left to right.
The itemprice page currently has a field that shows you how recent the data was. I agree it might be useful to add it to the regional tab. I do wonder what you mean by, the orders tab does not let me look at other regions though. I think your issue is mainly with having to reload the entire page to switch regions, while it could be done faster? Or that you would like to quickly look at a different region without changing your default?
In regards to the uploader, it does not upload to EVE Central. Nor do I have plans to support it in the future. I do understand Muscaat of EVE Markets made an uploader that uploaded to all of our websites (EC, EMK and EMD), though the one that I can download from his website at this moment does not work (at least on my PC).
Lastly, the uploader page, I have no idea why it would be giving gateway timeout errors. I'll test it myself and see what I can dig up. It it not really acceptable that people leave their computers on all night to upload, only to find that it crashes halfway trough. Otherwise I'll just make the refresh AJAX too, and have it automagically refresh it's list if it detects no activity. [img]http://www.evemarketeer.com/player/sig/511049420[/img] Want images? |
Callean Drevus
Icosahedron Crafts and Shipping Silent Infinity
17
|
Posted - 2011.10.13 22:06:00 -
[46] - Quote
Did some minor fixes, and implemented caching today (for home and for statistics pages). Caching might be a bit erratic at the moment. [img]http://www.evemarketeer.com/player/sig/511049420[/img] Want images? |
Domi Etymology
Violent Alternatives C0NVICTED
0
|
Posted - 2011.10.19 00:11:00 -
[47] - Quote
getting an error when trying to log in at the moment, and this error message
Server Time: 2011-10-19 00:10:43 Warning: Invalid argument supplied for foreach() in /var/www/core/lib/dwoo/plugins/personal/region_list.php on line 28 |
Turhan Bey
EVE University Ivy League
0
|
Posted - 2011.10.19 10:08:00 -
[48] - Quote
Get well soon! |
Controller Vrelk
New Eden Regimental Navy Rebel Alliance of New Eden
0
|
Posted - 2011.10.19 17:18:00 -
[49] - Quote
When you're feeling better.
1) http://www.evemarketeer.com/player/account Warning: implode(): Invalid arguments passed in /var/www/mod/player.php on line 75
2) You also might want to turn the order history page when looking at an item into a paged list, or shorten it. Right now it takes a long time to load and is very long.
3) Shorten/page the upload history page. Also some of mine are showing -1 for the credits earned. ex: Assault Missile Launcher II, Assault Missile Launcher I Blueprint, Ship Scanner II
4) On the mission statistics page, it says I need to add a character to the account, when I have and it has pulled the API for it. Maybe say what permissions from the API are needed when showing that error. |
Callean Drevus
Icosahedron Crafts and Shipping Silent Infinity
22
|
Posted - 2011.10.19 18:35:00 -
[50] - Quote
Thank you for your kindness I'm still feeling unwell though.
Which is one of the reasons I'm uploading the entire EVE Marketeer codebase to Github. Previously, I already added a few people to the mercurial repository I was using before, but this seems immensely easier. Besides, everyone will be able to contribute instead of just a few.
I'll also expose access to the live database to a few people that I trust not to give away private information.
This will hopefully allow updates to happen even if I'm not feeling ok .
The only thing I'm struggling with is providing a copy of the database. I could allow a complete download, but at the moment it's about 45 GB, which is probably a tad much for most people. Anyone have any ideas? [img]http://www.evemarketeer.com/player/sig/511049420[/img] Want images? |
|
Controller Vrelk
New Eden Regimental Navy Rebel Alliance of New Eden
0
|
Posted - 2011.10.19 20:28:00 -
[51] - Quote
Callean Drevus wrote:Thank you for your kindness I'm still feeling unwell though. Which is one of the reasons I'm uploading the entire EVE Marketeer codebase to Github. Previously, I already added a few people to the mercurial repository I was using before, but this seems immensely easier. Besides, everyone will be able to contribute instead of just a few. I'll also expose access to the live database to a few people that I trust not to give away private information. This will hopefully allow updates to happen even if I'm not feeling ok . The only thing I'm struggling with is providing a copy of the database. I could allow a complete download, but at the moment it's about 45 GB, which is probably a tad much for most people. Anyone have any ideas?
Maybe just include active orders, or just ones that have been seen in the past x days in the download. |
Callean Drevus
Icosahedron Crafts and Shipping Silent Infinity
22
|
Posted - 2011.10.19 21:24:00 -
[52] - Quote
Hmm, git is being recalcitrant as usual. I wonder why I still try... Maybe just stay with mercurial... [img]http://www.evemarketeer.com/player/sig/511049420[/img] Want images? |
Controller Vrelk
New Eden Regimental Navy Rebel Alliance of New Eden
0
|
Posted - 2011.10.19 21:30:00 -
[53] - Quote
Callean Drevus wrote:Hmm, git is being recalcitrant as usual. I wonder why I still try... Maybe just stay with mercurial...
I don't remember what it was but with another project that I think was on google code, people could upload patches that the devs would then incorporate into the main code if they thought it was good. I don't remember what system it was with, but maybe that would be helpful allowing anyone to submit code patches to you.
It seems I about doubled/tripled the length of the feedback page on the site now =] |
Callean Drevus
Icosahedron Crafts and Shipping Silent Infinity
22
|
Posted - 2011.10.19 21:51:00 -
[54] - Quote
Woot! EVE Marketeer was on github. And then I noticed I had some production passwords in the source that should have been hidden. Oh well, I'll give up for today. Tomorrow will probably see me simply committing the damn thing to bitbucket. I do (again) not feel like dealing with git ever again.
And yes, both of those websites allow people to commit patches which I can then merge into the main codebase. That's kind of the point
You won't be able to edit the code on the site itself though, but using mercurial should be relatively painless (as opposed to git).
EDIT: Regarding my sig, yeah, but I seem to not be able to edit it anymore. [img]http://www.evemarketeer.com/player/sig/511049420[/img] Want images? |
Controller Vrelk
New Eden Regimental Navy Rebel Alliance of New Eden
0
|
Posted - 2011.10.19 21:58:00 -
[55] - Quote
Callean Drevus wrote:Woot! EVE Marketeer was on github. And then I noticed I had some production passwords in the source that should have been hidden. Oh well, I'll give up for today. Tomorrow will probably see me simply committing the damn thing to bitbucket. I do (again) not feel like dealing with git ever again. And yes, both of those websites allow people to commit patches which I can then merge into the main codebase. That's kind of the point You won't be able to edit the code on the site itself though, but using mercurial should be relatively painless (as opposed to git). EDIT: Regarding my sig, yeah, but I seem to not be able to edit it anymore.
I haven't used github much. I'm used to SVN. I'm assuming you will post a link to the repo as soon as you are done setting it up?
Edit: just curious. What are the machine specs this is run off of? I know it's ubuntu and running nginx. Apache backend or just nginx? |
Callean Drevus
Icosahedron Crafts and Shipping Silent Infinity
23
|
Posted - 2011.10.20 06:41:00 -
[56] - Quote
Try appending ?debug=3 to any URL if you want to see loadtime and queries.
The specs are: i3 Intel processor 4 Gb RAM 2 1 Gb SATA disks in raid 1 100 Mbit uplink
Those are probably the most relevant ;) [img]http://www.evemarketeer.com/player/sig/511049420[/img] Want images? |
Controller Vrelk
New Eden Regimental Navy Rebel Alliance of New Eden
0
|
Posted - 2011.10.20 16:22:00 -
[57] - Quote
Callean Drevus wrote:Try appending ?debug=3 to any URL if you want to see loadtime and queries.
The specs are: i3 Intel processor 4 Gb RAM 2 1 Gb SATA disks in raid 1 100 Mbit uplink
Those are probably the most relevant ;)
Ok. I was thinking of something more along the lines of it showing all the time in a way that doesn't mess up the page layout. ex. http://chubaka.dyndns.biz/~ci/ipb_stats.png |
Callean Drevus
Icosahedron Crafts and Shipping Silent Infinity
24
|
Posted - 2011.10.20 16:29:00 -
[58] - Quote
I know you were :) this is just the best it can do at the moment. Havent found a decent way to incorporate the stats into the page yet. [img]http://www.evemarketeer.com/player/sig/511049420[/img] Want images? |
Controller Vrelk
New Eden Regimental Navy Rebel Alliance of New Eden
0
|
Posted - 2011.10.20 17:00:00 -
[59] - Quote
Callean Drevus wrote:I know you were :) this is just the best it can do at the moment. Havent found a decent way to incorporate the stats into the page yet. Ok. I thought the screenshot would help give you an idea of what I meant and an idea for a way to incorporate it into the site.
How about this? http://chubaka.dyndns.biz/~ci/evemarketeer_stats.png (I just grabbed the code from the IPB Forums site and stuck it in there using your theme.) http://chubaka.dyndns.biz/~ci/stats_code.txt (if you like it, there is the code/links to images. I think they are the famfamfam silk icon ones though) |
Callean Drevus
Icosahedron Crafts and Shipping Silent Infinity
24
|
Posted - 2011.10.20 17:28:00 -
[60] - Quote
Lol, nice going there
Don't you think it's a lot of space (distraction) for just the stats though? That has been what has kept me from implementing it this way. I would do it if I had something else to show in that bar, but right now, it's just a waste of space (though I doubt many people would mind, spending 10% of the (visible) page height on stats feels wrong to me)
That said, think up something useful to go on the left side of that box, and it would be ok ;) maybe we should also show number of users active or something [img]http://www.evemarketeer.com/player/sig/511049420[/img] Want images? |
|
|
|
|
Pages: 1 [2] 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 .. 21 :: one page |
First page | Previous page | Next page | Last page |