furrie
Forum Replies Created
-
Forum: Fixing WordPress
In reply to: What on Earth have I done to my site?Well, I have it sorted now. This is what I did: –
I had previously tarred up my whole mysql folder, containing all my DBs.
# tar cvf /data/backup/mysql.tar /var/db/mysql
Having started with a fresh OS install & some known stable (not bleeding edge) programs: –
FreeBSD 5.1-RELEASE
apache-1.3.27_4
mod_php4-4.3.1,1
mysql-server-4.0.13_1
mysql-client-4.0.13
mysql-client-3.23.56 (last time I tried removing this package but it really upset things, so it’s staying)
phpMyAdmin-2.3.2
I untarred the mysql.tar file to a temp directory in my home directory on the new box. I then changed into that directory & tarred up each DB (which I’m told is just a directory with files in it), copied that file to /var/db/mysql/ & untarred them there. I changed their ownership to the same as that of the other working DBs.
# chown -R mysql:mysql MyNewDBs
Now that that was done & I could see no obvious “issues” with what I had, I was about to have a look at following your instructions…
I could only find these files: –
/usr/local/share/mysql/my-huge.cnf
/usr/local/share/mysql/my-large.cnf
/usr/local/share/mysql/my-medium.cnf
/usr/local/share/mysql/my-small.cnf
& there was no /etc/my.cnf
I looked at the link you posted & ran: –
# myisamchk /MyDBs/*
which told me that all was fine… OK!
I went to my websites & to my amazement, they were all working! Actually, there were some that weren’t, but that changed when I adjusted their php config files to the new mysql user details.
I’m going to have a look at creating a /etc/my.cnf file (now I know that it exists – thanks).
I am also going to have a gander at the .cgi script you posted a link to, tweak it for my system & maybe even use it! Just need to get my head round the code stuff. I’m no coder 🙂 I’m no webdesigner either! LOL
I’ve got an entry in my crontab that does nightly backups of /var/db/mysql, but that will not be too great if it copies bad info over the top of good stuff, so I’ll have to get cracking on incremental backups.
I’d like to thank you (& everyone else), for your help & support. I’ve tried to make this post as complete as possible, to make it helpful for future users.
Kindest Regards,
Chris Phillips
(furrie)Forum: Fixing WordPress
In reply to: What on Earth have I done to my site?Yes, unfortunately, there is something wrong with the backups that I made, so that phpMyAdmin is no longer able to read the actual databases.or rather, MySQL doesn’t like them. Now I know about phpMyAdmin being able to perform dumps, I shall be doing that regularly. But my main problem remains…
Forum: Fixing WordPress
In reply to: What on Earth have I done to my site?OK then.
I’ve managed to get over the checksum problem (simply by deleting the source file in /usr/ports/distfiles) & both libmcrypt & mod_php are succesfully upgraded.
I still have a broken blog though, so it must be something in Apache or the newer version of php…Forum: Fixing WordPress
In reply to: What on Earth have I done to my site?Well, as you can see, the answer would be “Yes”. I have changed stuff. I noticed that the blog was broken on the 2nd November.
root@Venus:/usr/ports/distfiles# cat /var/log/www/httpd-error.log
[Thu Oct 23 02:41:31 2003] [notice] Apache/1.3.28 (Unix) PHP/5.0.0a1-alexdupre configured — resuming normal operations
[Mon Oct 27 20:38:04 2003] [notice] Apache/1.3.28 (Unix) PHP/5.0.0a1-alexdupre configured — resuming normal operations
[Tue Oct 28 16:48:14 2003] [notice] Apache/1.3.28 (Unix) DAV/1.0.3 PHP/5.0.0a1-alexdupre configured — resuming normal operations
[Sat Nov 1 16:55:25 2003] [notice] Apache/1.3.29 (Unix) DAV/1.0.3 PHP/5.0.0a3-alexdupre configured — resuming normal operations
[Wed Nov 5 11:37:47 2003] [notice] Apache/1.3.29 (Unix) PHP/5.0.0a3-alexdupre configured — resuming normal operations
[Thu Nov 6 02:45:05 2003] [notice] Apache/1.3.29 (Unix) DAV/1.0.3 PHP/5.0.0a3-alexdupre configured — resuming normal operations
I don’t think WebDAV is responsible, because (as you can see in the httpd-error.log), I unconfigured it, tested the blog, then re-configured it. Apache1.3 had no problems on the upgrade & I see no change in the way it serves. The PHP/5.0.0a3-alexdupre package seemed to upgrade well, but on checking again… There is already another version available (possibly a bugfix?).
Looking at the “other” problem I’ve had, I wonder if this is where my problem lies… I have been unable to successfully upgrade limbcrypt: –
root@Venus:/usr/src# portupgrade -Rr libmcrypt
—> Upgrading ‘libmcrypt-2.5.6_1’ to ‘libmcrypt-2.5.7_1’ (security/libmcrypt)
—> Building ‘/usr/ports/security/libmcrypt’
===> Cleaning for libmcrypt-2.5.7_1
===> Extracting for limbcrypt-2.5.7_1
>> Checksum mismatch for libmcrypt-2.5.7.tar.gz.
===> Refetch for 1 more times files: libmcrypt-2.5.7.tar.gz
>> libmcrypt-2.5.7.tar.gz doesn’t seem to exist in /usr/ports/distfiles/.
>> Attempting to fetch from http://us.dl.sourceforge.net/mcrypt/.
fetch: http://us.dl.sourceforge.net/mcrypt/libmcrypt-2.5.7.tar.gz: Requested Range Not Satisfiable
>> Couldn’t fetch it – please try to retrieve this
>> port manually into /usr/ports/distfiles/ and try again.
*** Error code 1
Stop in /usr/ports/security/libmcrypt.
*** Error code 1
Stop in /usr/ports/security/libmcrypt.
** Command failed [exit code 1]: /usr/bin/script -qa /tmp/portupgrade71733.0 make
** Fix the problem and try again.
—> Skipping ‘www/mod_php5’ (mod_php5-5.0.0.a3,1) because ‘security/libmcrypt’ (libmcrypt-2.5.6_1) failed
** The following packages were not installed or upgraded (*:skipped / !:failed)
! security/libmcrypt (libmcrypt-2.5.6_1) (checksum mismatch)
* www/mod_php5 (mod_php5-5.0.0.a3,1)
So, it looks as if there’s a patched version of mod_php5, that I am unable to install in the normal way, because there is a “checksum mismatch” bug in libmcrypt… This is apparently a known bug: –
o [2003/10/16] ports/58131 ports-bugs Checksum error on libmcrypt port
o = open
A problem report has been submitted, no sanity checking performed.
From here, I know not where to go 🙁
THIS forum, is probably no longer the one to be asking the questions on now though…
Pointers anyone?Forum: Fixing WordPress
In reply to: What on Earth have I done to my site?Oh Dear. The host…
That would be me then 🙁
Erm, I wonder if perhaps there’s anyone who’s seen this before, that has also been silly like me, but fixed the mess?
I tried searching the site, but it was fruitless.
I live in hope…