davanniswiki Server Upgrade

Ed Johnson

27 Dec 2008 03:27

I've spent most of the day working on upgrading my server at work from Ubuntu 7.10 / Apache / PostgreSQL 8.2 / Wikidot rev 195 to Ubuntu 8.04 / Lighttpd / PostgreSQL 8.3 / Wikidot rev 393.

I made an image of the hard drive from my server at work and loaded it on a virtually identical backup server so I wouldn't break my live install. I then did a pg_dumpall > dumpfile of my PostgreSQL 8.2 database. I had a clean Wikidot install running the current version of everything on a Virtualbox VM so I used that to test my upgrade. I dumped the Wikidot database and used my dumpall file to restore it in the VM using psql -d template1 -f dumpfile. I was pleasantly surprised that it seems to load everything just fine (I've had a lot of problems trying to do this before with pgAdmin3).

Next, I had to run the update php file to get the new login pages added to my database. I ran the configure and generate_om scripts, reconfigured my hostname, hosts file, wikidot.ini and lighttpd-wikidot.conf files. Finally, I manually copied my files—sites folder, restarted lighttpd and postgresql and launched my site. It worked!

I was happier than a tornado in a trailer park! After a bit of testing, I'm still happy, but do have a few issues to resolve:

Files and /or MIME types are screwed up for some reason. I noticed that image files were not displaying on pages. The files show up in the files list on the page, but with an improper MIMI type:

Lotus123_App_Error_Fix.jpg        HTML document text        272 Bytes       info | options

Clicking on the filename causes it to open a page that says:
<!DOCTYPE html 
     PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">


<p>The file does not exist.</p>

Deleting the file and re-uploading it doesn't work.

Searches do not work - both all sites and individual sites. It seems that the new Lucene search is enabled, but it's not working after I loaded my old database. I suspect there is a table or field missing that's causing this. The weird thing is that it looks like search highlighting is working. For example, I searched for the word health knowing that I have several pages that should be returned. But, I got this:


But clicking the "Benefits" link in my menu, showed this page with the word health highlighted.


I'm going to revert my VM back to a state prior to loading my dumpfile just to confirm this is not a problem with rev 393.

If you have any ideas on what I can do to fix these issues, please help! Thanks!


Add a New Comment
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License