Re: [galaxy-dev] galaxy-dev Digest, Vol 96, Issue 1
Hello Alejandro, You are probably using a MySQL database as a backend rather than PostgreSQL. The data definition layer in Galaxy's code uses a column type that has different maximum lengths between mysql (max chars is 2^16) and postgres (more than that). As a result, when you install a repository that has more than 2^16 character of metadata, the metadata gets truncated and you get those errors. Login in to the database backend and run the following: select id, tool_shed, name from tool_shed_repository; Find the repository in the list and write down its ID. Then run the following: Delete from tool_shed_repository where id="<PUT ID NUMBER HERE>"; Then, we need to fix the table column type for your database. Note that my database table has been fixed with the new datatype "mediumblob". | metadata | mediumblob | YES | | NULL | | You should do a backup of the database before you proceed. Run the following command to modify the metadata column on table tool_shed_repository to the mediumblob data type to allow a large amount of metadata. ALTER TABLE tool_shed_repository MODIFY metadata MEDIUMBLOB NULL; I had opened a Trello card about this but haven't had time to push a fix. Regards, Iyad Kandalaft Bioinformatics Application Developer Agriculture and Agri-Food Canada | Agriculture et Agroalimentaire Canada KW Neatby Bldg | éd. KW Neatby 960 Carling Ave| 960, avenue Carling Ottawa, ON | Ottawa (ON) K1A 0C6 E-mail Address / Adresse courriel: Iyad.Kandalaft@agr.gc.ca Telephone | Téléphone 613- 759-1228 Facsimile | Télécopieur 613-759-1701 Government of Canada | Gouvernement du Canada -----Original Message----- From: galaxy-dev-bounces@lists.bx.psu.edu [mailto:galaxy-dev-bounces@lists.bx.psu.edu] On Behalf Of galaxy-dev-request@lists.bx.psu.edu Sent: Monday, June 02, 2014 12:00 PM To: galaxy-dev@lists.bx.psu.edu Subject: galaxy-dev Digest, Vol 96, Issue 1 Send galaxy-dev mailing list submissions to galaxy-dev@lists.bx.psu.edu To subscribe or unsubscribe via the World Wide Web, visit http://lists.bx.psu.edu/listinfo/galaxy-dev or, via email, send a message with subject or body 'help' to galaxy-dev-request@lists.bx.psu.edu You can reach the person managing the list at galaxy-dev-owner@lists.bx.psu.edu When replying, please edit your Subject line so it is more specific than "Re: Contents of galaxy-dev digest..." HEY! This is important! If you reply to a thread in a digest, please 1. Change the subject of your response from "Galaxy-dev Digest Vol ..." to the original subject for the thread. 2. Strip out everything else in the digest that is not part of the thread you are responding to. Why? 1. This will keep the subject meaningful. People will have some idea from the subject line if they should read it or not. 2. Not doing this greatly increases the number of emails that match search queries, but that aren't actually informative. Today's Topics: 1. Unable to access admin after install EMBOSS 5 from galaxy test repo (Cristian Alejandro Rojas) 2. Re: Uploading files to galaxy from a folder (John Chilton) 3. Re: Uploading files to galaxy from a folder (Kandalaft, Iyad) 4. Installing galaxy with Apache (Matthias Enders) 5. Re: Cluster Admins - Call for experiences/issues encountered (Bj?rn Gr?ning) 6. Re: stdout in history (Daniel Blankenberg) 7. Re: Cluster Admins - Call for experiences/issues encountered (Eric Rasche) 8. Re: Cluster Admins - Call for experiences/issues encountered (Bj?rn Gr?ning) 9. Re: New tool on TestToolShed still not tested (Dave Bouvier) ---------------------------------------------------------------------- Message: 1 Date: Sun, 1 Jun 2014 13:32:15 -0500 From: Cristian Alejandro Rojas <alejandro.0317@gmail.com> To: galaxy-dev@lists.bx.psu.edu Subject: [galaxy-dev] Unable to access admin after install EMBOSS 5 from galaxy test repo Message-ID: <CALk039YufzUvf_iQ1CQuq9Sh3J9t94kMakOD6u87=qRGU0mPig@mail.gmail.com> Content-Type: text/plain; charset="utf-8" Hello all, I've select the emboss 5 suite to install from Galaxy test repo. After install I cant access to the admin panel. I think that is beacuse the json value is not complete (len(value):65535), and therefore the json decoder cant decode the value. In attachments I have included the debug data generated by galaxy and the file containing the "value" variable. Can anybody bring me some help? Is there some way to remove emboss without using the admin panel? Thanks in advance, best regards. *Cristian Alejandro Rojas Quintero*
participants (1)
-
Kandalaft, Iyad