Time Nick Message 07:32 cait good morning #koha 08:52 cait @wunder Konstanz 08:52 huginn cait: The current temperature in Taegerwilen, Taegerwilen, Germany is 20.3°C (10:45 AM CEST on August 11, 2013). Conditions: Mostly Cloudy. Humidity: 67%. Dew Point: 14.0°C. Pressure: 30.15 in 1021 hPa (Steady). 09:28 ambz Hello all. I'm running Koha 3.8 on Ubuntu 12.04 in AWS. I wanted to upgrade to 3.10, but I've forgotten my password (so I can't sudo). I can still ssh in (public/private keys were setup properly luckily) 09:30 ambz I can take a MySql dump. I'm wondering if I can install a new Koha instance on a new EC2 instance, and then plug in the old MySQL dump? 09:30 cait you can do that, but you will have to reindex 09:30 ambz So, are there any DB migrations from 3.8 to 3.10 that will make my old 3.8 dump fail with a new 3.10 Koha instance? 09:31 cait there are a lot of database changes, but when you load an older db in a new installation the mechanism for the web installer will take care of that 09:31 ambz cait: that's great! 09:31 cait that's howupdates work in general - if the database version is not the version of your Koha, Koha will bring up the web installer and do the updates to the schema 09:32 ambz I see. 09:33 ambz Also, I was running a local MySQL along with Koha on the same VM. It should work if I run MySQL on a separate instance (say, with RDS) and Koha on a separate instance, right?> 09:39 cait oyu can have the mysql server separately but i have never tried that 09:41 ambz ok 15:16 ambz Hi, I was running Koha3.12 via Ubuntu packages with a local MySQL server. 15:16 ambz I wanted to move the DB to an external machine (RDS instance). 15:17 ambz So I went and got a MySQL dump and plugged it into the new external DB. Setup the permissions etc. 15:17 ambz Then I changed the DB hostname to /etc/koha/sites/library2/koha-conf.xml from 'localhost' to the new external hostname, and restarted Apache2. 15:18 ambz *DB hostname *in* /etc/koha/sites/library2/koha-conf.xml 15:18 ambz It's hitting the web installer now. 15:19 ambz But I just want everything to continue as normal (without going through the installer). I don't want to drop tables and lose data etc. 15:19 ambz A little help please :) 15:20 ambz Any idea how I could bypass the web installer? 15:39 ambz Guess it's too early in the Western hemisphere 15:44 cait ambz: is it really the web installer or is it the update? both look very similar 15:44 cait it should be apparent what it does after the first few steps 16:00 ambz Well, it clearly says "Web installer" 16:01 ambz and the url is "http://library2-intra.artofliving.org/cgi-bin/koha/installer/install.pl" 16:02 cait yes 16:02 cait but they are the same 16:02 cait or very similar 16:02 cait what does it ask you after you log into it? 16:04 ambz language ('en'), database settings 16:04 cait hm 16:04 ambz step 3: "Now we're ready to create the database tables and fill them with some default data." 16:04 cait then it didn't find your external database i wouldsay 16:04 ambz okay, let me check that 16:05 ambz Are there any problems with the steps I took? 16:07 cait i am not sure how to set up the external database server 16:07 cait but changing in the conf file would be what I would do i ugess 16:08 ambz I'm quite sure it can access the external database. 16:08 ambz For example, if I set the wrong password in koha-conf.xml, and restart apache, it gives me an 'access denied' error . 16:10 cait and you did load your dump in there correctly? 16:17 ambz Okay, it's working! :D 16:18 cait cool 16:18 cait what was it? 16:18 ambz During the web installer, I noticed that it failed trying to "drop table auth_header"... don't know why exactly.... so I got onto a mysql prompt (logged in as the koha user) and manually did a "drop table auth_header;" 16:18 cait HM 16:18 ambz That's it...! 16:18 cait not having this table could be a problem later 16:18 cait it's used for storing authorities 16:18 ambz oh 16:19 ambz in that case, i'll create it using the corresponding sql in the old mysql dump 16:19 cait that might be a good idea 16:19 ambz cool, thanks for your help, cait :) 16:19 cait maybe check if the structure is still the same in the new version taking a look at the kohastructure.sql file 16:22 ambz okay, i compared the created schema of auth_header with that in /usr/share/koha/intranet/cgi-bin/installer/data/mysql/kohastructure.sql... they look identical 16:43 ambz thanks and bye for now 19:54 cait @wunder hamburg, Germany 19:54 huginn cait: The current temperature in Hamburg Airport, Germany is 15.0°C (9:50 PM CEST on August 11, 2013). Conditions: Light Rain Showers. Humidity: 82%. Dew Point: 12.0°C. Pressure: 29.95 in 1014 hPa (Rising). 19:54 cait hm 22:56 rangi http://schema.koha-community.org/ <-- upgraded 22:56 wizzyrea \o/ 22:56 cait1 rangi++ 22:57 wizzyrea rangi++