Consistency of MySQL dumps...

2008-10-07 Thread Marc Coyles
Here's one that's puzzling me... If I use /usr/local/bin/mysqldump to make a backup of a database, the file it produces fails to restore with "Check syntax near..." error. If I then head into cPanel, to their "Backup" menu, and take a backup of the database from there, the file it produces also

Script works fine from CLI, but not when Cron'd

2008-10-07 Thread Marc Coyles
I've got a script to backup my MySQL databases, which works absolutely fine from the command line, but when I add it in to root's cronjobs it always fails with "mysqldump: not found" - what am I doing wrong? Script as follows: #!/bin/sh USER= PASS= mysqldump --opt -h localhost -u $USER -p$PASS h

RE: RE: Consistency of MySQL dumps...

2008-10-08 Thread Marc Coyles
> (MySQLFront running on Windows XP, connecting to > MySQL5.2.5 on FreeBSD7.0REL) Sorry, brain fade... it's early! MySQL 4.1.22... was thinking about PHP at the time... Cheers! Marc A Coyles - Horbury School ICT Support Team Mbl: 07850 518106 Land: 01924 282740 ext 730 Helpdesk: 01924 282740 ex

Mass find/replace...

2008-12-04 Thread Marc Coyles
Never had to do this so not sure where to start. Have googled and found some solutions but they don't particularly work (see below)... Someone has managed to inject php code into a PILE of php pages on my webserver... "" This basically brings up a pile of spam links. I need to do a find / repla

RE: Mass find/replace...

2008-12-05 Thread Marc Coyles
> + not \; or you will fork on every result. > > Additionally, is this injected code one long string or broken down > by the > mailer? Grep isn't the best way to deal with it. It's pretty easy > to correct > with perl, bit trickier if it's multiline, still not too hard: > > find /home/horbury -ty

Freebsd-update fetch failed...

2009-08-06 Thread Marc Coyles
Evening folks... have just built up a new 7.0-RELEASE box, and have gone to update it to 7.0-RELEASEp11, however, whenever I run freebsd-update fetch I get the following: bigsis2# freebsd-update fetch Looking up update1.FreeBSD.org mirrors... none found. Fetching metadata signature for 7.0-RELEA

RE: Mass find/replace...

2008-12-05 Thread Marc Coyles
> + not \; or you will fork on every result. > > Additionally, is this injected code one long string or broken down > by the > mailer? Grep isn't the best way to deal with it. It's pretty easy > to correct > with perl, bit trickier if it's multiline, still not too hard: > > find /home/horbury -ty

RE: Mass find/replace...

2008-12-05 Thread Marc Coyles
All done n' dusted now - thanks very much for everyone's input...! Have noted everything down in the back of my copy of "Absolute FreeBSD 2nd Edition" (which has inherited quite a few additional pages since I bought it). Now that that's done, I can start to wander thru logs and find who/how...

RE: Mass find/replace...

2008-12-05 Thread Marc Coyles
> All done n' dusted now - thanks very much for everyone's input...! > Have noted everything down in the back of my copy of "Absolute > FreeBSD 2nd Edition" (which has inherited quite a few additional > pages since I bought it). > > Now that that's done, I can start to wander thru logs and find >

RE: Ports on Macbook

2009-03-03 Thread Marc Coyles
> >>> http://www.apple.com/legal/sla/macosx.html > >> They can write whatever they want. I'm not binded by it. "This License allows you to install and use one copy of the Apple Software on a single *Apple-labeled* computer at a time" So, in theory, apply white lx tape to any PC, write "APPLE" on

RE: Fetching directories inclusive subdirectories on HTTP server via fetch or othe FreeBSD-own tools?

2009-04-02 Thread Marc Coyles
> "O. Hartmann" wrote: > > I need to fetch a whole directory tree from a public remote site. > > The top level directory and its subdirectories are accessible via > > ftp:// and http:// so I tried fetch, but fetch does only retrieve > > data on file basis and does not copy a whole directory tree >

RE: freebsd-update on FreeBSD 6.x

2009-04-22 Thread Marc Coyles
> I don't have a 6.1 machine around, but freebsd-update > is just a sh script and you should be able to find what's going on. > There is nothing hardcoded in it, at least in the version distributed > with 7.x. In fact I would try running the 7.x version on this system. I'd definitely be inclined t

Dump snapshot issue...

2009-05-05 Thread Marc Coyles
I've got a script that dumps various filesystems to tape for me, but I've always had an issue whenever I've used the -L option... see below: /usr/bin/mt rewind /sbin/dump 0aLuf /dev/sa0 / dump: Cannot create //.snap/dump_snapshot: No such file or directory /sbin/dump 0aLuf /dev/sa0 /home mksnap_f

RE: Dump snapshot issue...

2009-05-05 Thread Marc Coyles
> You probably have not created the .snap directory in the root of > the filesystem. Like I said... "The .snap folders exist at all points, are set to root:operator, with perms 770... The dump_snapshot files seem to be present, albeit 0 bytes, root:operator, perms 400..." Marc _

RE: Dump snapshot issue...

2009-05-06 Thread Marc Coyles
> One thing you should try is to remove the dump_snapshot files, > because > they are supposed to be unlinked when the dump starts anyway, so > they > shouldn't be sticking around. > > Also, look for file flags on the directories, or ACLs, etc. > > And consider the permissions you're running dump

RE: Dump snapshot issue...

2009-05-07 Thread Marc Coyles
> Is /home really a separate file system on your system? > Or is it just a directory in another filesystem? df -h output: Filesystem SizeUsed Avail Capacity Mounted on /dev/da0s1a3.9G351M3.2G10%/ devfs 1.0K1.0K 0B 100%/dev /dev/da0s1g 98G

Upgrade 6.2-Release to 7.0-Release - stuck!

2008-07-23 Thread Marc Coyles
Am running freebsd-update following instructions at http://www.daemonology.net/blog/2007-11-11-freebsd-major-version-upgrade.htm l It’s decided that it can’t merge named.conf changes automagically and has dropped me into vi with the file open… looking as below. What exactly is it wanting me to do?

RE: Upgrade 6.2-Release to 7.0-Release - stuck!

2008-07-23 Thread Marc Coyles
D] Cc: freebsd-questions@freebsd.org Subject: Re: Upgrade 6.2-Release to 7.0-Release - stuck! Marc Coyles wrote: > Am running freebsd-update following instructions at > http://www.daemonology.net/blog/2007-11-11-freebsd-major-version-upgrade.htm l > > It’s decided that it can’t merge n

RE: Upgrade 6.2-Release to 7.0-Release - stuck!

2008-07-24 Thread Marc Coyles
OK - further developments! Got to the first reboot stage after running "sh freebsd-update.sh -f freebsd-update.conf install" First point to note: If you don't want a sudden panic attack, remember to remove the non-bootable floppy disk from the drive. Other than that, all has gone to plan and is w

RE: Upgrade 6.2-Release to 7.0-Release - stuck!

2008-07-30 Thread Marc Coyles
Righty - now that I'm back from my wanderings I've managed to complete the upgrade from 6.3 to 7.0-RELEASE, but am still getting issues with named not starting. For reference, I pulled down a clean 7.0-R version of named.conf and dropped it in as /etc/named.conf /var/log/messages shows the followi

RE: [ free_bsd_questions ] selecting a cpu heatsink / fan combo

2008-08-26 Thread Marc Coyles
> > greetings, all --- > > > > this isn't exactly a free_bsd question, --but--, > > since free_bsd is popular w/ the i386 crowd and > > there are many rugged individualists on these lists > > who like to "roll their own", > > i figure i'll get way less hyperbole and > > more practical exp

RE: [ free_bsd_questions ] selecting a cpu heatsink / fan combo [ c ]

2008-08-27 Thread Marc Coyles
> i have --never-- heard of this one. > maybe, it's because i check every mobo setting at installation time ? > > are you certain that this isn't propaganda from the joke in redmond ? > > please explain. > ASUS Motherboards have their "AI" system which attempts to automatically overclock any cpu t

Obscure df -h output

2008-08-28 Thread Marc Coyles
One of my servers appears to be having a slightly dippy moment... Running FREEBSD 5.3-RELEASE-p5 i386 (I don't have the bottle to attempt freebsd-update to 7.0-REL, altho I really should... Still a relative newb tho, and not confident on a box I can only access by remote) running WHM 11.23.2 cPanel

RE: Obscure df -h output

2008-08-28 Thread Marc Coyles
> Looks like they did some strange things trying to get it back. Those > look like nullfs mounts with the same source and destination, which > makes no sense. What does mount -v show you? > Hi Kris... [EMAIL PROTECTED] ~]$ mount -v /dev/ad0s1a on / (ufs, local, writes: sync 715484 async 362440,

RE: Obscure df -h output

2008-08-29 Thread Marc Coyles
> Yes, they did something bizarre. Ask them why :) > > Kris > ___ Mornin' Kris / list... Asked them why and they shrugged and said "we didn't"... So... I unmounted all the nullfs mounts that it'd allow me to unmount (tmp, dev, proc and bin were "busy

Live FS Dump errors...

2008-09-01 Thread Marc Coyles
Morning folks... I'm trying to use a script to run a dump of all filesystems, but whenever I use the -L option, I receive an error as follows for every mount: DUMP: Date of this level 0 dump: Mon Sep 1 13:37:57 2008 DUMP: Date of last level 0 dump: the epoch DUMP: Dumping snapshot of /dev/da