| Pages: 1 2 3 4 [5] 6 :: one page |
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Ray McCormack
Nordar Innovations.
   |
Posted - 2010.05.08 06:40:00 -
[121]
* How did this happen?
* What steps have been take to ensure it doesn't happen again?
|
Dzil
Caldari
SafeHouse Investments of Tautology
|
Posted - 2010.05.08 07:18:00 -
[122]
I'll bet someone set up this account:
Dzil's Corp Sales - 200m |
Block Ukx
Forge Laboratories
|
Posted - 2010.05.08 15:53:00 -
[123]
 Originally by: Ray McCormack
* How did this happen?
* What steps have been take to ensure it doesn't happen again?
It is all my fault this happened.
1) I assumed backups were fine, which have been in the past and were not corrupted by the export function. For some odd reason I don't know, the export function on phpadmin was truncating the backups, so tables end up missing in the backup.
2) I dropped the tables (all) instead of renaiming them and loading the backup ones.
To ensure this does not happen again I will never drop tables again and verify the integrity of the backups made by phpadmin.
I welcome suggestions.
BSAC Mineral Market Manipulation (MinMa) Information Desk |
Alain Kinsella
Minmatar
|
Posted - 2010.05.08 16:25:00 -
[124]
From what I've read on phpbb's migration problems (with dump files larger than 2 meg), it may be a problem with phpadmin. Haven't been able to confirm this though.
You can consider dumping the database manually, via script. Depending on your hoster's capabilities, you can setup a crontab to run this regularly (perhaps once or twice a week), sending the dump file to a directory 'outside' your web root.
In addition, if you have ssh/shell access, you can run the script manually (i.e. a particularly busy day).
phpbb's notes on running manual backups (still useful as a generic doc):
Knowledge Base - How to backup and restore your database with SSH
Verifying database dumps is tricky, for most of them (I primarily deal with Sybase ASE/IQ and various Oracle instances at work). The best way is to occasionally grab one of the dumps, and try loading it to a test instance of mysql - either created on the hoster, or running locally on your PC.
--A_K
|
Haskell
Gallente
|
Posted - 2010.05.08 16:27:00 -
[125]
Two suggestions:
- Never ever modify the live database. If you want to make modifications, you can download a bulk copy, make your changes locally, double-check the result and re-upload the changed data. You can disable logins during the time so nobody can change the data in between.
- Create a read-only mirror website that shows the latest backup. This has two advantages: (a) if your main website is unavailable, visitors can still view the backup website, and (b) visitors of the backup website will immediately notice when the backup is corrupt, not just when it's too late.
|
Lana Turlock
Caldari
|
Posted - 2010.05.08 18:46:00 -
[126]
One more question... What happens to the dividends paid during the lost time period.
|
Gulnack
Minmatar
|
Posted - 2010.05.08 19:03:00 -
[127]
Signs of the Apocalypse -
- Stock market "glitch" sends Dow tumbling 900+ points
- EVE DB "glitch" causes up to 114,000 stacks of items to disappear
- BSAC Exchange tables get "dropped"
Buyer beware, all trades are NOT final and may be revoked, changed or deleted at the discretion of said exchange. Anyway, didn't mean to bash the BSAC, it's just been a bad week for data integrity everywhere and I wanted to share my lolz.
. |
Ray McCormack
Nordar Innovations.
|
Posted - 2010.05.08 19:37:00 -
[128]
Originally by: Block Ukx
I welcome suggestions.
Learn from experience. 
We have a shell script here that auto-restores mssql backups from a directory and reports if they don't. I'll see if it can be modified for mysql and get a copy to you. Quite useful.
|
Block Ukx
Forge Laboratories
|
Posted - 2010.05.08 19:44:00 -
[129]
Thanks everyone for the great tips. Will definetly use them once restore is finished.
Originally by: Lana Turlock
One more question... What happens to the dividends paid during the lost time period.
Dividends are also stored and recorded outside the website via API. API records and API backups are ok. So deposits, withdraws, AND dividends are not lost. The will be issue once the restore process is finished. Similarly, BSAMR, BSAMT, and Index share dividends are not lost.
Just to reiterate, only share trades for BSAMT, MRD, AATP, JIDSALE, and LYII conducted between 3/24 and 5/2 are lost.
BSAC Mineral Market Manipulation (MinMa) Information Desk |
Poison
Forge Laboratories
|
Posted - 2010.05.09 03:10:00 -
[130]
Originally by: Ray McCormack
Originally by: Block Ukx
I welcome suggestions.
Learn from experience.
We have a shell script here that auto-restores mssql backups from a directory and reports if they don't. I'll see if it can be modified for mysql and get a copy to you. Quite useful.
I think Block needs to contact you and maybe he can have something like this set up for BSAC site.
|
Block Ukx
Forge Laboratories
|
Posted - 2010.05.11 02:35:00 -
[131]
Exchange is OPEN
Trading is not allowed at this time, but will resume soon. Please login and review your account.
BSAC Mineral Market Manipulation (MinMa) Information Desk |
Lana Turlock
Caldari
|
Posted - 2010.05.16 01:48:00 -
[132]
Any ETA on when trades might resume? 
|
Block Ukx
Forge Laboratories
|
Posted - 2010.05.17 01:10:00 -
[133]
Trading will resume this Wednesday May 19, 2010. We will release a new website version that we hope will make share trading even easier.
BSAC Mineral Market Manipulation (MinMa) Information Desk |
Block Ukx
Forge Laboratories
|
Posted - 2010.05.19 01:51:00 -
[134]
STOCK EXCHANGE OPEN - TRADING ALLOWED.
Please review your account.
BSAC Mineral Market Manipulation (MinMa) Information Desk |
Block Ukx
Forge Laboratories
|
Posted - 2010.05.25 01:08:00 -
[135]
STOCK EXCHANGE OPEN - Login Details SENT
Since API is usually down during patch day, expect a small delay in Index price updates.
BSAC Mineral Market Manipulation (MinMa) Information Desk |
Hexxx
Minmatar
|
Posted - 2010.05.25 13:42:00 -
[136]
Making good decisions comes from experience, experience comes from making bad decisions.
Projects Blog |
Vaerah Vahrokha
Minmatar
Vahrokh Consulting
|
Posted - 2010.05.25 14:53:00 -
[137]
Originally by: Hexxx
Making good decisions comes from experience, experience comes from making bad decisions.
You said so much in so little... 
-
Auditing & consulting
When looking for investors, please read
http://tinyurl.com/n5ys4h + http://tinyurl.com/lrg4oz
|
Hexxx
Minmatar
|
Posted - 2010.05.26 13:47:00 -
[138]
Here's an oldie but a goodie all the way back from 2007.
http://www.eveonline.com/ingameboard.asp?a=topic&threadID=627059&page=1#1
Block is right, there are so many advantages from virtualizing securities (shares in the immediate case). The trick is you have to trust the exchange (Block in this case).
Projects Blog |
Vaerah Vahrokha
Minmatar
Vahrokh Consulting
|
Posted - 2010.05.26 17:35:00 -
[139]
Originally by: Hexxx
Here's an oldie but a goodie all the way back from 2007.
http://www.eveonline.com/ingameboard.asp?a=topic&threadID=627059&page=1#1
Block is right, there are so many advantages from virtualizing securities (shares in the immediate case). The trick is you have to trust the exchange (Block in this case).
This is but another effect of a big sandbox design flaw that roots deep inside EvE.
EvE is not really a neutral sandbox. The part where EvE leans towards PvP is fair, since EvE is indeed merchandished as PvP MMO.
But EvE is also sold as (The) Sandbox and this is not true.
In EvE, if it was a true sandbox, we'd have what we have in the sandbox called Real Life: (just) default diffidence towards unknowns, enforcement over mutually agreed deals / statements.
In EvE we cannot have that. In EvE there's hostility towards unknowns (i.e. EvE is "forced NBSI inside") and no possible enforcement over mutually (this is the important bit) agreed deals.
This creates all sorts of pathetic scenarios, where people cannot do and develop sane business nor enterprising individuals can introduce new financial instruments to greatly augment the trading mini-game.
I.E. I don't need money. I don't want money. For my limited play I am more than set. Yet, I want to implement new innovative securities. Not to make money, just because they "make juice" in the gameplay with their many implications.
Yet I am supposed to:
- Be rich beyond insanity, because many idiots believe that rich = less prone to scamming.
- Be a famous name "with rep" (same reason as above).
- Possibly have a nicely started 2005 corporation dealing with hundreds of billions of turnover (other "rep") just to justify a large accounting system like Block has.
... when all I wanted would be to EvE-ize some quite normal financial instruments so that everyone can be a provider of them. What if I wanted to short sell? 1000000 difficulties.
What if I want to emit ETFs? 1000000000 difficulties plus huge capital needed.
And this because in EvE - The Sandbox - someone cannot create a binding pact of any kind even if both parties are OK. No, BPO as collaterals are a joke, you always end up with someone to have *faith* in.
I think CCP should make an economy expansion sooner or later, and introduce some game triggered "events" that forcibly happen when a certain condition occurs.
Example: something that could look like a trade window (two or more people must press "OK") after a certain pre-set condition has been setup (like contracts wizard):
"on <condition> A gives B <amount|item>" and of course
<amount|item> gets locked till <condition> can be evaluated as true or false. |
Block Ukx
Forge Laboratories
|
Posted - 2010.05.26 23:43:00 -
[140]
Originally by: Hexxx
Here's an oldie but a goodie all the way back from 2007.
http://www.eveonline.com/ingameboard.asp?a=topic&threadID=627059&page=1#1
Block is right, there are so many advantages from virtualizing securities (shares in the immediate case). The trick is you have to trust the exchange (Block in this case).
Thanks for the link.
BSAC Mineral Market Manipulation (MinMa) Information Desk |
Hexxx
Minmatar
|
Posted - 2010.05.27 00:46:00 -
[141]
Originally by: Block Ukx
Originally by: Hexxx
Here's an oldie but a goodie all the way back from 2007.
http://www.eveonline.com/ingameboard.asp?a=topic&threadID=627059&page=1#1
Block is right, there are so many advantages from virtualizing securities (shares in the immediate case). The trick is you have to trust the exchange (Block in this case).
Thanks for the link.
Thanks for being the first one to pull it off. =) I swear Block...the thing I like about you the best is that you just do things. I talk about stuff, but you actually just go and do stuff. =P
Projects Blog |
Block Ukx
Forge Laboratories
|
Posted - 2010.05.28 22:03:00 -
[142]
Originally by: Hexxx
... I talk about stuff, ...
How about you tell us about short selling? Is it a good idea, bad idea? Pros an cons?
You explain this things much better than anyone.
BSAC Mineral Market Manipulation (MinMa) Information Desk |
Block Ukx
Forge Laboratories
|
Posted - 2010.06.02 01:33:00 -
[143]
JIDSALE and LYII dividends issued.
Register your shares today!
BSAC Mineral Market Manipulation (MinMa) Information Desk |
Tiberizzle
|
Posted - 2010.06.02 03:41:00 -
[144]
Edited by: Tiberizzle on 02/06/2010 03:41:26
Originally by: Vaerah Vahrokha
Yet I am supposed to:
- Be rich beyond insanity, because many idiots believe that rich = less prone to scamming.
- Be a famous name "with rep" (same reason as above).
- Possibly have a nicely started 2005 corporation dealing with hundreds of billions of turnover (other "rep") just to justify a large accounting system like Block has.
... when all I wanted would be to EvE-ize some quite normal financial instruments so that everyone can be a provider of them. What if I wanted to short sell? 1000000 difficulties.
it cracks me up every time VV whines about the atmosphere of paranoia that is perpetuated in large part by her and other auditors spamming to convince everyone that the sky will fall unless you send them a few hundred mil and let them thumb through your API details
|
SetrakDark
Northstar Cabal
OWN Alliance
|
Posted - 2010.06.02 04:10:00 -
[145]
Originally by: Tiberizzle
Edited by: Tiberizzle on 02/06/2010 03:41:26
Originally by: Vaerah Vahrokha
Yet I am supposed to:
- Be rich beyond insanity, because many idiots believe that rich = less prone to scamming.
- Be a famous name "with rep" (same reason as above).
- Possibly have a nicely started 2005 corporation dealing with hundreds of billions of turnover (other "rep") just to justify a large accounting system like Block has.
... when all I wanted would be to EvE-ize some quite normal financial instruments so that everyone can be a provider of them. What if I wanted to short sell? 1000000 difficulties.
it cracks me up every time VV whines about the atmosphere of paranoia that is perpetuated in large part by her and other auditors spamming to convince everyone that the sky will fall unless you send them a few hundred mil and let them thumb through your API details
plz link to other auditors spamming this, tyia.
|
Vaerah Vahrokha
Minmatar
Vahrokh Consulting
|
Posted - 2010.06.02 09:47:00 -
[146]
Quote:
it cracks me up every time VV whines about the atmosphere of paranoia that is perpetuated in large part by her and other auditors spamming to convince everyone that the sky will fall unless you send them a few hundred mil and let them thumb through your API details
Balls.
MD denizens are prudent (don't see you investing trillions to prove "paranoia" wrong BTW) not paranoid. It'd take to be an idiot not to be super-suspecting in a game where scamming is fully supported and endorsed.
"Other auditors" => balls again. The others tend to do their stuff and say nothing.
Or shall I say "other" because atm we active ones are in the huge massive number of two.
Third, you put it on the economic POV when even an unrecoverable idiot can prove you can do more consistent money per month with bot mining than auditing.
In fact I am more pleased when I don't have to audit than when I have. I am just stupid enough that I give on people asking me till I do it. There's no practical ROI in this, the only and exclusive objective you can achieve is one day to do one mistake and have your face covered in sh!t for the rest of your EvE years.
-
Auditing & consulting
When looking for investors, please read
http://tinyurl.com/n5ys4h + http://tinyurl.com/lrg4oz
|
Tiberizzle
|
Posted - 2010.06.02 18:27:00 -
[147]
Edited by: Tiberizzle on 02/06/2010 18:27:46
Originally by: Vaerah Vahrokha
Quote:
it cracks me up every time VV whines about the atmosphere of paranoia that is perpetuated in large part by her and other auditors spamming to convince everyone that the sky will fall unless you send them a few hundred mil and let them thumb through your API details
Balls.
MD denizens are prudent (don't see you investing trillions to prove "paranoia" wrong BTW) not paranoid. It'd take to be an idiot not to be super-suspecting in a game where scamming is fully supported and endorsed.
"Other auditors" => balls again. The others tend to do their stuff and say nothing.
Or shall I say "other" because atm we active ones are in the huge massive number of two.
Third, you put it on the economic POV when even an unrecoverable idiot can prove you can do more consistent money per month with bot mining than auditing.
In fact I am more pleased when I don't have to audit than when I have. I am just stupid enough that I give on people asking me till I do it. There's no practical ROI in this, the only and exclusive objective you can achieve is one day to do one mistake and have your face covered in sh!t for the rest of your EvE years.
I don't invest here because the ROI is stupidly low for offers that don't get trolled to death by the MD cartel, who among other reasons obviously don't want competition for capital raising their rates. The ROI is meaningless compared to what I can do with even inactive accounts and ghost market orders, nevermind actively working the ISK. If I did invest here, I would probably maintain a portfolio of the higher return lowsec / nullsec ventures that sadly get shot down with near 100% probability for bull**** reasons by ***** ass carebears. Of course, if I tried to invest in those offers I'd be wasting my time because the ventures would usually be trolled into oblivion before the offer got off the ground. So, why bother?
I don't seek capital here, because I am not willing to accept an intrusion into my API, nor am I generally willing to discuss most of my activities. Collateral requirements defeat the purpose -- if I had 110% collateral I would (and do) just liquidate it. I would probably also go forum-ape**** on the trolls and end up with the thread being deleted and investors discouraged 
It's been shown time and time again that none of the people trolling new offers have even the least ability to detect a scam, with most of them having been taken for billions in the past. But, it doesn't stop them from shooting down every new offer that comes up.
Finally, I don't think anybody was holding a gun to your head forcing you to troll offers and spam auditing services back when you were macro rep mining. So, if it's such a bother to perform audits I suggest not doing them, and not reinforcing the notion that an audit in any way secures an offer.
|
Hexxx
Minmatar
|
Posted - 2010.06.02 18:36:00 -
[148]
Originally by: Tiberizzle
Finally, I don't think anybody was holding a gun to your head forcing you to troll offers and spam auditing services back when you were macro rep mining. So, if it's such a bother to perform audits I suggest not doing them, and not reinforcing the notion that an audit in any way secures an offer.
An audit never has and never will secure an offer. An audit is intended within EVE to verify identity (alts), ability (skills and/or market history), and resources (existing assets). It is merely a tool used by investors to make a judgement call regarding the non-inherent risk of an offering.
Sometimes that tool is more desired then others, it simply depends.
Projects Blog |
Vaerah Vahrokha
Minmatar
Vahrokh Consulting
|
Posted - 2010.06.02 21:43:00 -
[149]
Edited by: Vaerah Vahrokha on 02/06/2010 21:44:41
Quote:
Finally, I don't think anybody was holding a gun to your head forcing you to troll offers and spam auditing services back when you were macro rep mining.
I was not trolling offers. I was finding where they sucked. Edit: later on I found out there was even a "metaprofession" where one is officially entitled to "debug" offers and guess what, I took it.
I was not macro mining anything and I kept howling on the old "MD elites" because they did "use" rep as currency instead. Including E-Bank and its "we are a private institution" endless stream of excuses.
If that is macro mining rep, then I am guilty and proud of it.
Also, you don't see me revelling off my 60B "built on rep" IPO or similar crap, do you?
Quote:
So, if it's such a bother to perform audits I suggest not doing them, and not reinforcing the notion that an audit in any way secures an offer.
I challenge you to find a single place where I ever stated that an audit secures an offer.
I ALWAYS divulged the concept that audit = information. From information to "secures" there's a sea of difference.
-
Auditing & consulting
When looking for investors, please read
http://tinyurl.com/n5ys4h + http://tinyurl.com/lrg4oz
|
Ray McCormack
Nordar Innovations.
|
Posted - 2010.06.03 05:40:00 -
[150]
Originally by: Tiberizzle
I don't invest here
Originally by: Tiberizzle
I don't seek capital here
Originally by: Tiberizzle
So, why bother?
Quoth the troll.
|
| |
|
| Pages: 1 2 3 4 [5] 6 :: one page |
| First page | Previous page | Next page | Last page |