| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
Comments:
<0> but, its only been ~1wk
<1> the screen is in a locked room. that's the general motivation behind me remote-connecting to the machine
<2> Ah.
<2> abc987123: Re-read. I'm not talking about a physical monitor, dumb***. That's what I meant when I said "It's a program"--amazing, what logic can get you, innit?
<3> abc987123: that means there's probably a reason it's in a locked room
<0> so people like him cant `look into screen` ?
<0> :P
<4> Steakk: Oh
<1> yikes
<4> Steakk: When I said nicked, I mean physically.
<1> friendly folks here, I see
<0> Ahh, I meant you thought hacked
<0> err
<0> thought you meant*
<2> abc987123: I do not gladly tolerate fools.
<4> Steakk: Never been.
<0> abc987123, we are friendly to our own kind .. IE: People that are willing to do research and not have their hands held like 2 year olds
<1> fair enough... can I venture a guess that you consider most people (except for yourself) to be fools?
<0> the only person we let act like that is Nanuq ... but, Nanuq is canadian, so thats an excuse
<4> :P
<0> hehe
<4> Steakk: me? a fool? or handholding?
<2> abc987123: No. Most people are great. I actually have an issue with not being able generalize the people around me. People are people. A few clueless ones prove themselves fools.
<0> Uhhh...
<0> the fool?
<4> o/~ everybody plays the fool..
<0> so, apparantly it takes MySQL to execute 4,000~ commands
<1> to be fair, you were sarcastic from the start, meaning that I rather understandably read your answer to be sarcastic. I see that your margin for error is razor thin, so, uh, sorry for wasting your precious time and insulting your supreme intelligence
<5> That's right, you better be sorry
<0> abc987123, he/we/they/us were NOT saracstic. He said `look into screen`, and then he continued on to say: `It's a program, and it's the most wonderful console tool, ever.`
<2> abc987123: Whatever. I was helpful and gave you a great answer to your question, and got sarcastic when you didn't actually read it. But, I'm now the fool for arguing the point. Do your thing.
<0> which means, abc987123, he was elaborating on it for you.
<0> So, basically, you can go to hell, and keep timing out every 5 minutes, and never see the data you want to see.
<0> g'day then.
<0> (that meant Good bye)
<1> I'm really digging the collective comic book store guy thing going on here.
<0> speaking of conics: has anyone seen the new dilbert ?
<2> dogbert2: Played that game a bit today. Couldn't find my way to a real person. Got lost in some dead-end phone support system that kept telling me to grab a pen so I could write down instructions.
<1> omg conics instead of comics
<6> ThomasM...agree
<0> Nanuq, let me have the honour, please
<1> hah
<1> loser
<0> (BOFH Ball)
<0> or not, ***prick left
<3> darn, hellhound needed a new ball
<5> better that he left anyway
<0> ThomasM, is now a bad time to pick your brain quick?
<5> he wasn't worth the energy
<2> dogbert2: All I want is to be able to sign up for a damned Earthlink account that goes with the DSL, so I have the auth details necessary to use their SMTP. Our current web host is Dotster, who is failing left and right with downtime and bugs.
<2> Steakk: Fire away. I'm having fun tonight. Talking to people. Need to do that a bit more.
<0> ThomasM, simple question, or so I hope...you mentioned MySQL, and wanna quick refresher on this...I have a .sql file which has 4000 or so commands I need to execute ... `mysql -u user -p p***word .... ` whats the rest to have that .sql be ran?
<4> Steakk: sorry
<0> Nanuq, np
<2> mysql -u root -p p***word -D database (unless there's a "use <database>;" line at the top of your SQL) < myfile.sql
<2> s/root/user/
<0> its a create database, not use
<0> then population thereof
<2> You'll need to do a "use" thereafter, unless the table names are qualified.
<3> so there sould be a create and then a use command in the sql source
<4> Steakk: maybe it's that ****ty linksys router
<5> what they said
<0> ahh
<0> yes, thre is a use...i overlooked that
<5> bedime...later
<2> Steakk: Yep. So just "mysql -u user -p < myfile.sql" and type your p***word, or "mysql -u user --p***word=p***word < myfile.sql".
<2> XyZzY: Agreed.
<2> XyZzY: I'm ****ing miserable when I'm any level of sick.
<0> likewise
<3> ThomasM: this one is a coughing, nose congestion thing. think cow-orkers brought it in
<2> XyZzY: Doing any medication, or just riding it out?
<3> ThomasM: got some antibiotics for it. don't see how 3 pills 24hours apart is gonna do any good though
<2> The new NyQuil without the good-sleep **** ****s ***. It puts me to sleep, and then I wake up every 2 hours from weird, highly erotic dreams. But hey, I'm not coughing. Guess there's some good going on.
<0> one thing I am disliking about the Plesk CP...if you do anythin via command line, it dont show up in the CP
<2> Steakk: So it's easy to get out of sync? Not knowing if something needs changed, or clicking that button breaks another change?
<0> ThomasM, from my experiences, yes...I am messing with it now to figure it out ... doing that DB creation via CLI ... then going to see if it appears in plesk...if its not in plesk right away, I will reboot (as it might populate upon boot), and see then
<2> Steakk: I've been halfways debating spry.com's webmin plan, just because it pretty much has no CP (well, other than webmin, and that's different). But if I do end up having customers access their own accounts and manage files, etc., I'd sort of like a good CP for them to use.
<2> Steakk: DB creation should be immediate, unless Plesk is complete and utter rubbish.
<2> No reason to cache that data when it's such a low-cost query to look it up on the fly.
<0> this is the first time i have used plesk, so, its a learning curve .... I'd much rather edit apache confs, and **** by hand, ya know?
<2> Steakk: So just forget you have a CP. :)
<0> debating doing just that
<2> The only reason I'm tottering is future customers. I have no plans to let them edit their **** except by FTP or by my own admin interfaces specific to the tool, but I might decide to let them do it, or that I need a submonkey to be able to change things.
<2> But, the good news is that I'm now the hiring interface for submonkeys, so I'm not going to get stuck with rubbish ***istants over and over again.
<0> ThomasM, just one question for ya then...do you prefer T-Bones, or Sirloin?
<0> (get it? heh)
<2> The last employer kept hiring me **** ***istants and insisted I keep them even after I enumerated all their major faults, and then even after a month or two at the desk proved they couldn't do **** worth **** with ****.
<0> i hate not being able to do my own hiring...which is why I am now 100% freelance
<0> christ, how long does it take MySQL to execute commands in a 400k .sql file?
<2> Steakk: Are you SSH'd into the box, or executing across a link line by line?
<0> ssh'd
<0> this .sql only has approx 700 commands
<2> If it's got a lot of keys and indexes, it might take a while if it has some INSERTs.
<0> creating db, creating tables, filling with data
<0> oh, 3266 lines in that .sql starting with INSERT
<2> Foreign key references all have to be validated. Full text indexes created and populated. Primary and secondary indexes created and populated. Full text indexes will be the biggest hit.
<2> Steakk: And they're probably multi-row inserts. Check the line lengths of those insert commands.
<0> 23:43:46 up 2:35, 2 users, load average: 1.14, 1.14, 0.84 <-- its getting a workload, thats for sure
<2> Well, 3226 lines... probably not multi-row INSERT statements.
<0> INSERT INTO `users` VALUES (1, 'admin', 'ad/RXgUYBMy3o', '0acf4539a14b3aa27deeb4cbdf6e989f', NULL, 'Administrator', NULL, 'on', NULL, '2006-09-03 20:05:59', '2006-09-03 19:58:20', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Active', NULL, NULL, NULL, NULL, NULL, NULL, 'YToyOntzOjI4OiJBZG1pbmlzdHJhdGlvbl9VU0VSX09SREVSX0JZIjtzOjIxOiJmaXJzdF9uYW1lLCBsYXN0X25hbWUiO3M6MTk6IlVzZXJzX1VTRVJfT1JERVJfQlkiO3M6MjE6ImZpcnN0X25hbWUsI
<0> Gxhc3RfbmFtZSI7fQ==', 'Europe/Berlin', 'de,en_uk,fr,it,us,', '', '0,1,2,3,4,5,6,', 1, 'yyyy-mm-dd', 0);
<0> **** like that
<2> If that' 32-character field is a p***word, you might look into whatever system you're using and make sure it's not using the simple MySQL P***WORD() functions.
<0> Its not ... its a built-in hash that the app creates
<2> Like a guid?
<2> Unique reference to the user?
<3> well by def a hash is not unique
<0> its multi-db (oracle, mysql, postgres, etc), and it creates the data dynamically ... (this is a backup I am putting back into place)
<2> XyZzY: Sometimes unique enough.
<0> god damnit
<0> this ****ing CRM refuses to accept a backup restoration
<2> MySQL does need a good GUID functionality. I'd feel better about some of my code if it did. As it stands, I'm counting on more than one person doing the same thing in the same second with 8 characters of random salt.
<0> I am NOT going to repopulate this thing, it would take me weeks
<2> Steakk: Email me your SQL file. I'll play with it on this box. Might just need to remove some of the MySQL directives.
<0> ThomasM, its a PHP error now
<0> Fatal error: Call to a member function on a non-object in /var/www/vhosts/datawiringspecialists.com/subdomains/crm/httpdocs/include/database/PearDatabase.php on line 440
<0> $result->Move($row); <-- line in question
<2> Steakk: Your DSN string is probably wrong when it creates the database, or the SQL statement used to create the result caused an error, and it's not doing good error checking.
<2> Steakk: Above that line (***uming this is a good PEAR installation), write: if( PEAR::isError( $result ) ) die( $result->getMessage() );
<7> hi all
<2> I doubt it'd get that far if the DSN is wrong, but I only know my code. I check for errors.
<8> OldMonk: hiya
<2> oi OldMonk
<0> ThomasM, refreshing now
<7> hi whitecap, ThomasM
<9> smbd[6907]: [2006/09/07 12:51:33, 0] lib/access.c:check_access(328)
<0> Fatal error: Undefined cl*** name 'pear' in /var/www/vhosts/datawiringspecialists.com/subdomains/crm/httpdocs/include/database/PearDatabase.php on line 440
<9> smbclient - //mis/Report /home/elaine/share -o username=melvin
<9> session setup failed: NT_STATUS_LOGON_FAILURE
<0> Sp0ileD, shh, you are cluttering the chat. and dont paste things like that here.
<0> ThomasM, apparantly its not taking the PEAR:: debug line
<2> Heh. Fake, or really, really old, PEAR modules. I've NFI without seeing some debug output or reading the code. You could do a "var_dump( $result )" above that line to see what sort of data you're dealing with.
<7> Sp0ileD: it's an authentication failure. try smbclient to isolate it, or enable debugging in the samba server
<9> ok thank
<2> They shouldn't include Pear in the filename if it doesn't actually reference PEAR. That's cheap.
<7> and don't even think about m***aging me
<7> ThomasM: that's only my ****
<2> OldMonk: Hahaha. Nice response.
<0> ThomasM, do you know of any (semi-easy) way to take all of the CREATE statements out of a .sql, so its only the INSERT statements?
Return to
#linux
or
Go to some related
logs:
#AllNiteCafe
www. blad.com
DSPAM SIGSEGV
ghndi
#AllNiteCafe
#mirc
fps games
#AllNiteCafe
#MissKitten
let me hear your body rock
|
|