[ckan-discuss] CKAN install on SL5: migrate.versioning.exceptions.InvalidRepositoryError

[Rufus Pollock]

Hi Ewan,

Can you access irc? If so will probably be quicker to debug there:
#ckan on irc.oftc.net.

Rufus

On 17 June 2011 14:09, Ewan Klein <ewan.klein at gmail.com> wrote:
> Hi Adrià,
>
> Thanks for your swift response. Yes, this suggestion does help narrow down the problem.
> I did in fact have a connection string for sqlalchemy in the config file that looks syntactically correct to me, viz
>
> sqlalchemy.url = postgresql://ewan:XXX@remotehost/ckan
>
> So there's a difference here with examples in the sqlalchemy documentation, which only use localhost, and maybe that is the problem.  On the other hand, when I use the same information, including the IP address of the host, in the connection string for psycopg2, eg
>
> conn = psycopg2.connect(database="ckan", host="remotehost", user="ewan", password="XXX")
>
> then I do manage to connect to the remote db. So this would suggest that the URL is OK, and something else is not working right.
>
> Regards,
>
> Ewan
>
>
> On 16 Jun 2011, at 18:51, Mercader wrote:
>
>> Hi Ewan,
>> It's great to hear that you are playing around with CKAN.
>>
>>> I am at Step 9, and have hit a problem after executing the command:
>>>
>>> paster --plugin ckan db init --config ckanvm.inf.ed.ac.uk.ini
>> [...]
>>> migrate.versioning.exceptions.InvalidRepositoryError: /disk/data/web/ckanvm.inf.ed.ac.uk/pyenv/lib/python2.7/site-packages/ckan-1.4-py2.7.egg/ckan/migration
>>
>> Did you define a sqlalchemy connection string in the configuration
>> file (point 8.1 in the deployment protocol)?
>> It should look like this if you set up a Postgres database:
>> sqlalchemy.url = postgresql://<user>:<password>@localhost/<db_name>
>>
>> Hope this helps,
>>
>> Adrià
>
> ---------------
> Ewan Klein
> School of Informatics
> University of Edinburgh
> Informatics Forum 2.11
> 10 Crichton Street
> Edinburgh, EH8 9AB
> Scotland, United Kingdom
>
> Email: ewan at inf.ed.ac.uk
> Tel: +44 131 650 2705
> Fax: +44 131 650 6899
>
>
>
>
>
>
>
>
> _______________________________________________
> ckan-discuss mailing list
> ckan-discuss at lists.okfn.org
> http://lists.okfn.org/mailman/listinfo/ckan-discuss
>



-- 
Co-Founder, Open Knowledge Foundation
Promoting Open Knowledge in a Digital Age
http://www.okfn.org/ - http://blog.okfn.org/