Leginon

h1. How to Update from v16 (Linux)

The changes from v1.6 requires update of all in-house components of Leginon, dbemtools (called myamiweb in the new version) and database

but *not the php mrctools*. 

*This processing package upgrade instruction includes that for installing Appion's processing scripts and executables.  They have more supporting package requirement.  Therefore, if you do not plan to use Appion on this computer, you may skip it.*

Don't forget that you need to also update the packages on the microscope-controlling computer

since the pyScope update need to be synchronized.

See [[Installation Troubleshooting]] and  "Leginon Bulletin Board":http://emg.nysbc.org/projects/leginon/boards  searching

for "install" if you run into problems.

h2. Check and correct the following before you start, because we did not put in the checks for you, and your upgrade will fail if it is incorrect.

h3. You must have an administrator user in your database

# Go to "http://your_host/dbem_1_5_1/adduser.php

# Check to see that you do have a user with "name" ( as in username) as "administrator" (all lower-case).  If you don't have one,  make one and save it.

h3. All users should be assigned to a group

# Go to "http://your_host/dbem_1_5_1/addgroup.php

# Create at least a group and save

# Go to "http://your_host/dbem_1_5_1/adduser.php

# If you did not have group created before, select each user and choose a group and then click save.  If there is only one group that you just created, you will need to click save even though you can not make the group selection.

h2. Packages required from NRAMM

All Leginon (and Appion) packages distributed from NRAMM are now under one svn control called myami.

A few updates are needed for preparation of python 3.0 compatibility where the method for importing module is changed.  They will still run under python 2.4 and up.

Here are the packages you need to install with python installer

|_.SVN subPackage Name|_.Reason for update:|

|numextension|package import method change|

|libcv|package import method change|

|leginon|new features|

|pyami|new features|

|sinedon|required for updating database|

|pyscope|new method for creating pythoncom modules|

|imageviewer|debug|

h2. Download Leginon 2.0 source code

{{include(appion:Download_Appion_Files_Shared)}}

h2. Perform system check if you can't remember where you have installed your Leginon before.

<pre>cd /your_download_area/myami/leginon

python syscheck.py</pre>

You should have all the supporting packages installed for v1.6. If you see any lines like "*** Failed...", then you have something missing. Otherwise, everything should result in "OK".

h2. Move your existing python processing packages to a backup directory:

At the beginning of the syscheck.py output, the location of the exisiting Leginon folder is shown. Although new installation overwrite the old in most cases, problem has been observed in the past. Therefore, it is best to remove the old files from the path before new installation.  Better yet, copy into a backup folder because we need some configuration files from them.

For example, your Leginon folder is at /usr/lib/python/site-packages/Leginon

<pre>cd /usr/lib/python/site-packages

mkdir Leginon1_6_backup

mv Leginon Leginon1_6_backup</pre>

Be aware that in some cases the installed package name is different (capitalized) from your svn package name and that numextension amd libCV are not in its own subdirectory in the python library but just the compiled .so files

{{include(appion:Install Appion Packages Shared)}}

h2. Copy your Leginon1.6 sinedon.cfg to the new installation

* Find your sinedon.cfg. Depending on your previous setting, look in the directories listed here in order:

*your home directory as described in syscheck.py

*The sinedon directory where it is called from. If unsure, start python command line and type these to find out:

<pre>python> import sinedon

python> sinedon</pre>

*  If sinedon.cfg reside in the installed sinedon subpackage, you should copy it from your Leginon1,6 backup to the new installation.

<pre>cd /your_default_python_installation_path

cp Leginon_1_6_backup/sinedon/sinedon.cfg sinedon

</pre>

h2. Copy your Leginon1.6 leginon.cfg to the new installation similarly

* Find your leginon.cfg. Depending on your previous setting, look in the directories listed here in order:

*your home directory as described in syscheck.py

*The leginon directory where it is called from. If unsure, start python command line and type these to find out:

<pre>python> import leginon

python> leginon</pre>

*  If leginon.cfg reside in the installed leginon subpackage, you should copy it from your Leginon1,6 backup to the new installation.

<pre>cd /your_default_python_installation_path

cp Leginon_1_6_backup/Leginon/leginon.cfg leginon

</pre>

h2. Back up all your databases

*Very Important: Fix the bad tables before backup with mysqldump or the backup would be corrrupted.  Sorry, it was our fault a long time ago.*

h3. Check and Fix your database for bad tables

We've found this on two databases outside NRAMM that there are empty tables created that causes a bad database backup.  Please check and correct your database first before your backup.

# start mysql command line on your leginondb

<pre>

mysql -u usr_object your_leginon_database

</pre>

# display all tables

<pre>

mysql> show tables;

</pre>

# if you find both BindngSpecData and bindingspecdata, you have a problem.  The former has data in there and the later does not.  If you have data in both tables, please contact us.  We will need to create a customized solution. You can check like this:

<pre>

mysql> select * from BindingSpecData;

mysql> select * from bindingspecdata;

</pre>

# remove the empty lowercased table

<pre>

mysql> drop table bindingspecdata;

</pre>

# repeat 3-4 on launchedapplicationdata and nodespecdata

h3. Backup

We will be doing a database update that is not backward compatible,  Make sure you back up all your current databases before performing the update

* mysqldump -u usr_object your_leginon_database > leginondb_1_6_backup_today's_date

* mysqldump -u usr_object your_project_database > projectdb_1_2_backup_today's_date

* .... do the same to any of your processing databases if you have installed and used Appion 1.0 beta

h2. Install updated Web viewers and tools

*You will not need to upgrade php mrc tools*.

See [[Install the Web Interface]] section in Complete Installation Chapter to put the new web tools (Now under subpackage myamiweb) to document root for the web server.  

h2. Step through setup wizard in the myamiweb on your server

The Setup Wizard will take you through the steps to create config.php and to create and initialize values for the new tables.  For example, project database will contain a table called privileges when you finish. Your old config.php is not formatted correctly for the new viewers but the parameters for databases stands. You can enter them in the wizard.

You will be asked about whether you want to enable myamiweb user login feature that restricts individual user's access to projects and administrator features.  Read about it [[appion:User Management|here]]

h2. Check and modify your [[Configure_sinedoncfg|sinedon.cfg]] to be compatible to the new version

All module names are now all in lower cass.

h2. Run database update scripts

<pre>cd /your_download_area/myami/dbschema

python schema-r12857.py

python schema-r13713.py

python schema-r14077.py

</pre>

The first one updates UserData and GroupData so that new data viewing and processing privileges can be enforced

The second is a wide-scale change on database schema many on appion processing databases, and some on projectdata and leginondata.

The third fills in some appion data that was obtained with slow query in previous versions.

______

[[How_to_Update_from_v16_(Microscope_Windows_Computer)|How to Update from v1.6 (Microscope Windows Computer) >]]

______