Mailing-List: contact user-help@bloodhound.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@bloodhound.apache.org
Received-SPF: pass (athena.apache.org: domain of gary.martin@wandisco.com
 designates 209.85.212.175 as permitted sender)
Message-ID: <51F9067A.2090706@wandisco.com>
Date: Wed, 31 Jul 2013 13:43:38 +0100
From: Gary Martin <gary.martin@wandisco.com>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
 rv:17.0) Gecko/20130623 Thunderbird/17.0.7
MIME-Version: 1.0
To: user@bloodhound.apache.org
Subject: Re: Bloodhound Login Error
References: 
 <CA++H-yP1nA-GQ7OviZxcBD_d+yJ1papfhrxFveypC+D+CsOXWw@mail.gmail.com>
 <CA++H-yPLmZmJ1kKWU8WQiiYu52+F5q6k3onRLHb=3ErW8zaBgw@mail.gmail.com>
 <51F78738.5090503@wandisco.com>
 <CA++H-yNf0TM4UvDWn6sbEhJxgaXdyXCx22r0AViSHY5ccFdE_Q@mail.gmail.com>
 <4EAAB9C8-26D0-424E-A441-6658F753BAAD@digiverse.si>
 <CA++H-yP747VHREmz_DGQ3sFP=8m6P325U_3dxtcis6H+sa_+0w@mail.gmail.com>
 <FF5CE721-1D80-429A-92E8-116691233F4F@digiverse.si>
 <CA++H-yMN9HuB0y3Kr-XyZmRsLa0vQ6moo3h5ske=65rPSg9RAQ@mail.gmail.com>
 <51F7A0D7.1020000@wandisco.com>
 <CA++H-yMQEpZQZUPGBey+ZSv9vuQXFES-PCP=kBxRzfKRCXaHnQ@mail.gmail.com>
 <CAGMZAuOhm-2u1ctxGFwk6bUUAQJ9hV1aXwfuzgcJwjGO0pMsrw@mail.gmail.com>
 <CA++H-yMHrRvhOnh6Q91ajW7sfnjne8cPJ_82DBkv80_7982HAQ@mail.gmail.com>
 <CA++H-yOZ_VdPMir7mGK5iy xp3m7Nk_m4EZYbgy1EALPEp32HwA@mail.gmail.com>
 <5DDACBA9-6D7B-4D57-A90E-ED0EEECAF173@digiverse.si>
 <CA++H-yN+54N=p+Kb_5Q_kiaiXWJiv4fezE9o1eVrYucch2g=FQ@mail.gmail.com>
 <7E7A562A-B161-44A1-BD10-82884BCE3CF7@digiverse.si>
In-Reply-To: <7E7A562A-B161-44A1-BD10-82884BCE3CF7@digiverse.si>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

On 31/07/13 12:48, Matevž Bradač wrote:
> On 31. Jul, 2013, at 10:54, Pedro Estrela wrote:
>
>> I did that command:
>>
>> tracd -p 8000 /var/www/bloodhound/installer/bloodhound/environments/main
>>
>> and i get this errors on localhost:8000/main :
>>
>> " Warning: Unknown theme bloodhound configured. Please check your trac.ini. You may need to enable the theme's plugin."
>>
>> and
>>
>> " Trac detected an internal error:
>>
>> DataError: invalid input syntax for integer: "trac.wiki.api.WikiSystem.pages"
>> LINE 1: SELECT generation FROM cache WHERE id=E'trac.wiki.api.WikiSy...
>>                   
>>                              ^"
>>
>  From the looks of it, it seems like you have a corrupt virtual environment
> or something in that direction. I would suggest recreating the environment
> from scratch, under the same user account that will be used for running
> Apache. Note that you may have to manually remove Babel and replace it with an
> older version (use Babel==0.9.6 with pip), as the newer versions may not work.
> After the new environment has been set up, running a standalone tracd should
> work properly.
>
> Once this is fixed we can continue debugging the Apache issues.

This seems sensible. It might also be worth removing the system 
installed versions of the packages though if we can work out which they are.

I may not have been exhaustive in this list and it may be that some of 
these are installed from the CentOS repositories so you may need to be 
careful in case other programs need some of these.. however unless you 
expect to have Trac itself installed alongside, the following will 
hopefully be safe enough (deactivate included in case you are starting 
from an activated virtualenv):

deactivate
pip uninstall Babel
pip uninstall BloodhoundDashboardPlugin
pip uninstall BloodhoundMultiProduct
pip uninstall BloodhoundRelationsPlugin
pip uninstall BloodhoundSearchPlugin
pip uninstall BloodhoundTheme
pip uninstall Genshi
pip uninstall Pygments
pip uninstall Trac
pip uninstall TracAccountManager
pip uninstall TracPermRedirect
pip uninstall TracThemeEngine
pip uninstall Whoosh
pip uninstall sqlparse

Cheers,
     Gary