View Full Version : How to upgrade 1.80b0 to 1.81b2
Newton K
07-27-2007, 04:18 AM
I was following the upgrade guide to go from b0 to b2, but figured I need not create a new database (I beleive the upgrade page is written for those coming from Gooseberry) so just left it as it was...
So I followed it through and really ended up just loading 1.81b2 by copying in all the files and editing the config files.
I've checked the new Deki exe is running and left my database as it was.
Result: A 500 error when trying to access the home page:
* Your site settings could not be loaded - this could affect your wiki's operations. Please check to ensure that Dekihost is running.
* This page's contents could not be loaded.
More info is supplied in the error's browser pop-up:
Request URI: http://deki/@api/deki/pages/28/files?dream.out.format=php&dream.in.host=etrii&dream.in.origin=XX.XX.XX.XX
Server response
Array
(
[error] => Array
(
[message] => site deki has failed to initialize or did not start up properly: Initialization exception: Procedure or function 'config_get_Config' cannot be found in database 'wikidb'.
[status] => 500
[title] => Internal Error
[uri] => http://deki/@api/deki/pages/28/files?dream.out.format=php&dream.in.host=deki&dream.in.origin=XX.XX.XX.XX
)
)
(The XX address is substituted)
Does a new database needs to be created? Or is it a matter of importing the old data into the new database using the dump and import (http://wiki.opengarden.org/DekiWiki/Installation_Guide/FAQ) method (surely if this is so the 1.80b0 database will work)? Thanks in advance, N.
PeteE
07-27-2007, 03:02 PM
I was following the upgrade guide to go from b0 to b2, but figured I need not create a new database (I beleive the upgrade page is written for those coming from Gooseberry) so just left it as it was...
So I followed it through and really ended up just loading 1.81b2 by copying in all the files and editing the config files.
Hey Newton K - I've been meaning to document the upgrade process for Hayes beta's to Hayes 1.8.x. You've done the proper steps but should do one more thing.
After copying the LocalSettings.php, AdminSettings.php, to your new directory, do this to recreate the stored procedures (and apply any schema changes to the DB)
cd /var/www/deki-hayes/maintenance
php update-db.php
Then, make sure the new lucene index can be created:
mkdir /usr/local/var
chown www-data /usr/local/var
Also, you may want to check your /etc/dekiwiki/mindtouch.deki.startup.xml to make sure it looks like the attached file. There may have been a few minor changes between the betas and the final version.
<script>
<!-- register Deki services -->
<action verb="POST" path="/host/load?name=mindtouch.deki" />
<action verb="POST" path="/host/load?name=mindtouch.deki.services" />
<action verb="POST" path="/host/load?name=mindtouch.indexservice" />
<!-- start Deki services -->
<action verb="POST" path="/host/services">
<config>
<!-- Service startup -->
<!-- deki: relative path for deki-api service. I.e., http://host/deki -->
<!-- sid: the serviceid points to a class that represents the service for startup-->
<path>deki</path>
<sid>http://services.mindtouch.com/deki/draft/2006/11/dekiwiki</sid>
<!-- Global settings -->
<!-- deki-path: full path to dekiwiki php (pointed to by web server) -->
<!-- apikey: apikey used to access privileged features of deki-api -->
<!-- imagemagick-ignore-list: comma separated list of file extensions to bypass image preview -->
<!-- imagemagick-convert-path: full path to imagemagick convert (used to generate image previews) -->
<!-- imagemagick-identify-path: full path to imagemagick identify (used to determine image dimensions) -->
<!-- deki-resources-path: path to deki-wiki resources directory containing txt files with localized strings.
Resource files are searched in the order "resources.custom.txt" -> "resources-[language]-[culture].txt" -> "resources-[language].txt" -> "resources.txt"
where [language] and [culture] are standard two letter abbreviations such as en-us -->
<!-- dblogging-conn-string: DB connection string for detailed logging of deki-api requests/responses. Comment out to disable this logging -->
<deki-path>/var/www/deki-hayes</deki-path>
<apikey>jxFBbVe2bi0nC3HKzfh8UwsuPfXmw1Vt</apikey>
<imagemagick-ignore-list>ico</imagemagick-ignore-list>
<imagemagick-convert-path>/usr/bin/convert</imagemagick-convert-path>
<imagemagick-identify-path>/usr/bin/identify</imagemagick-identify-path>
<!-- <deki-resources-path>/var/www/mks-wiki/resources</deki-resources-path> -->
<!-- dblogging-conn-string>Server=localhost;Port=3306;Database=wikidb;Uid=roo t;Pwd=password;pooling=true; Connection Timeout=5; Protocol=sockets; Min Pool Size=1; Max Pool Size=100; Connection Reset=false;character set=utf8;ProcedureCacheSize=25;Use Procedure Bodies=true;</dblogging-conn-string -->
<!-- Per instance settings -->
<!-- authtoken-salt: this is a unique key for the wiki instance thats used for generating and validating the authentication token cookie.
Ensure that the attribute 'hidden' is set to true to not expose this value-->
<!-- storage-provider @type: 'fs' or 's3' for filesystem and Amazon S3 storage backend.
For @type = 'fs':
storage-provider/path: local storage path for file attachments. Default: /var/www/mks-wiki/attachments
for @type = 's3':
storage-provider/publickey: public key for your S3 account
storage-provider/privatekey: private key for your S3 account
storage-provider/bucket: the bucket to use for storage (ensure this exists)
storage-provider/prefix: prefix for all files created within the bucket
storage-provider/timeout: timeout in seconds for s3 requests
-->
<!-- max-image-size: size in bytes of largest image (mimetype: image/*) to accept. comment out or set to 0 to disable maximum-->
<!-- blocked-attachment-extensions: list of file attachment extensions to disallow for security-->
<!-- banned-words: comma separated list of banned words -->
<!-- db-server: hostname/ip of database for this instance-->
<!-- db-port: db port (default 3306 for mysql)-->
<!-- db-catalog: catalog or database name for this instance (default wikidb for non-cluster setup) -->
<!-- db-user: db account to use. Ensure full access to the catalog and rights to exec stored procs.-->
<!-- db-password: password for db account-->
<!-- db-options: other connection string settings. Ensure db connection pooling is enabled and that the connection supports utf8 encoding-->
<!-- filter-path: file extension and the location of an executable to convert that file extension to plain text. -->
<!-- Note: the executable MUST read from stdin and write to stdout -->
<authtoken-salt hidden="true">super secret stuff</authtoken-salt>
<storage-provider type="fs">
<publickey></publickey>
<privatekey hidden="true"></privatekey>
<bucket></bucket>
<prefix>dekiwiki</prefix>
<path>/var/www/deki-hayes/attachments</path>
</storage-provider>
<max-image-size>2000000</max-image-size>
<blocked-attachment-extensions>exe, vbs, scr, reg, bat, com</blocked-attachment-extensions>
<db-server>localhost</db-server>
<db-port>3306</db-port>
<db-catalog>wikidb</db-catalog>
<db-user>wikiuser</db-user>
<db-password hidden="true">password</db-password>
<db-options>pooling=true; Connection Timeout=5; Protocol=socket; Min Pool Size=2; Max Pool Size=50; Connection Reset=false;character set=utf8;ProcedureCacheSize=25;Use Procedure Bodies=true;</db-options>
<indexer>
<path.store>/usr/local/var/luceneindex</path.store>
<filter-path extension="doc">/var/www/deki-hayes/bin/filters/wvText</filter-path>
<filter-path extension="pdf">/var/www/deki-hayes/bin/filters/pdf2text</filter-path>
<filter-path extension="xhtml">/var/www/deki-hayes/filters/html2text</filter-path>
<filter-path extension="html">/var/www/deki-hayes/bin/filters/html2text</filter-path>
<filter-path extension="htm">/var/www/deki-hayes/bin/filters/html2text</filter-path>
<filter-path extension="docx">/var/www/deki-hayes/bin/filters/docx2txt</filter-path>
<filter-path extension="odt">/var/www/deki-hayes/bin/filters/odt2txt</filter-path>
<filter-path extension="odp">/var/www/deki-hayes/bin/filters/odp2txt</filter-path>
<filter-path extension="ppt">/var/www/deki-hayes/bin/filters/ppt2txt</filter-path>
<filter-path extension="pptx">/var/www/deki-hayes/bin/filters/pptx2txt</filter-path>
<filter-path extension="xls">/var/www/deki-hayes/bin/filters/xls2txt</filter-path>
<filter-path extension="pl"></filter-path>
<filter-path extension="c"></filter-path>
<filter-path extension="h"></filter-path>
<filter-path extension="inc"></filter-path>
<filter-path extension="php"></filter-path>
<filter-path extension="cs"></filter-path>
<filter-path extension="txt"></filter-path>
<filter-path extension="csv"></filter-path>
<filter-path extension="xml"></filter-path>
<filter-path extension="xsl"></filter-path>
<filter-path extension="xslt"></filter-path>
</indexer>
</config>
</action>
</script>
Newton K
07-28-2007, 01:26 AM
Awesome news Pete E, thank you for your tips. Could be all stations go for when I get back on Monday!
Powered by vBulletin™ Version 4.1.3 Copyright © 2013 vBulletin Solutions, Inc. All rights reserved.