[ckan-dev] trying a production deployment gives error when running paster --plugin ckan db init --config tmpl-ckan : TypeError: __init__() takes exactly 1 argument (2 given

David Read david.read at okfn.org
Thu Jun 30 14:56:20 UTC 2011 

Marc,

I notice you have a long list of unrelated python modules installed,
and I'm thinking these problems may stem from having had the old
version of sqlalchemy-migrate installed before you installed CKAN.

In this case, it is probably better to make the python virtual
environment isolated from your main python install, so these other
libraries don't affect the CKAN install.

(You are correct that the --upgrade option for the pip install causes
unrelated upgrades that you don't want. Best just to delete/uninstall
a wrong version of a package and install again.)

I think the problem with the "db init" command is one of two things:
1. there is debris from trying it with the old version of
sqlalchemy-migrate. Hence recreate the database.
2. the sqlalchemy.url in your config is not pointing to your database correctly

If I were you, I'd back-track a bit:

1. Redo step 4 - delete your pyenv folder and recreate it with:

virtualenv --no-site-packages pyenv
. pyenv/bin/activate

2. Repeat step 6 - install the CKAN code and dependencies

wget https://bitbucket.org/okfn/ckan/raw/ckan-1.4/pip-requirements.txt
pip -E pyenv install -r pip-requirements.txt

3. Recreate the database

paster --plugin ckan db clean --config demo.ckan.net.ini
paster --plugin ckan db init --config demo.ckan.net.ini

(or if "db clean" doesn't work, use "dropdb")

4. Check the database url

sudo -u postgres psql -l
grep -i sqlalchemy.url demo.ckan.net.ini

e.g.
ckantest1       | tester   | UTF8     | en_GB.UTF-8 | en_GB.UTF-8 |
sqlalchemy.url = postgresql://tester:letmein@localhost/ckantest1

Do let me know how you get on with these. You can try and catch me on
irc as too: dread on #ckan at irc.oftc.net

David

On 30 June 2011 15:33, Kimpe Marc <Marc.Kimpe at cronos.be> wrote:
> David :
>
> On the golden sequence : after fixing some version of e.g. SQLAlchemy
> I go further and have this error now :
>
> (pyenv)grizzzly at tmpl-ckan:~$ paster --plugin ckan db init --config
> tmpl-ckanTraceback (most recent call last):
>   File "/home/grizzzly/pyenv/bin/paster", line 8, in <module>
>     load_entry_point('PasteScript==1.7.3', 'console_scripts',
> 'paster')()
>   File "/home/grizzzly/pyenv/lib/python2.6/site-packages/paste/script/
> command.py", line 84, in run
>     invoke(command, command_name, options, args[1:])
>   File "/home/grizzzly/pyenv/lib/python2.6/site-packages/paste/script/
> command.py", line 123, in invoke
>     exit_code = runner.run(args)
>   File "/home/grizzzly/pyenv/lib/python2.6/site-packages/paste/script/
> command.py", line 218, in run
>     result = self.command()
>   File "/home/grizzzly/pyenv/lib/python2.6/site-packages/ckan-1.4.1-
> py2.6.egg/ckan/lib/cli.py", line 87, in command
>     model.repo.init_db()
>   File "/home/grizzzly/pyenv/lib/python2.6/site-packages/ckan-1.4.1-
> py2.6.egg/ckan/model/__init__.py", line 70, in init_db
>     self.upgrade_db()
>   File "/home/grizzzly/pyenv/lib/python2.6/site-packages/ckan-1.4.1-
> py2.6.egg/ckan/model/__init__.py", line 169, in upgrade_db
>     self.setup_migration_version_control()
>   File "/home/grizzzly/pyenv/lib/python2.6/site-packages/ckan-1.4.1-
> py2.6.egg/ckan/model/__init__.py", line 156, in
> setup_migration_version_control
>     self.migrate_repository, version)
>   File "<string>", line 2, in version_control
>   File "/home/grizzzly/pyenv/lib/python2.6/site-packages/migrate/
> versioning/util/__init__.py", line 160, in with_engine
>     return f(*a, **kw)
>   File "/home/grizzzly/pyenv/lib/python2.6/site-packages/migrate/
> versioning/api.py", line 248, in version_control
>     ControlledSchema.create(engine, repository, version)
>   File "/home/grizzzly/pyenv/lib/python2.6/site-packages/migrate/
> versioning/schema.py", line 128, in create
>     repository = Repository(repository)
>   File "/home/grizzzly/pyenv/lib/python2.6/site-packages/migrate/
> versioning/repository.py", line 76, in __init__
>     self.verify(path)
>   File "/home/grizzzly/pyenv/lib/python2.6/site-packages/migrate/
> versioning/repository.py", line 97, in verify
>     raise exceptions.InvalidRepositoryError(path)
> migrate.versioning.exceptions.InvalidRepositoryError: /home/grizzzly/
> pyenv/lib/python2.6/site-packages/ckan-1.4.1-py2.6.egg/ckan/migration
>
>
> pyenv)grizzzly at tmpl-ckan:~$ ls /home/grizzzly/pyenv/lib/python2.6/site-
> packages/ckan-1.4.1-py2.6.egg/ckan/migration
> __init__.py  __init__.pyc  manage.py  manage.pyc  versions
>
>
> and :
>
> (pyenv)grizzzly at tmpl-ckan:~$ ls
> ckan.log  Documents  examples.desktop  Pictures              Public
> Templates  var
> Desktop   Downloads  Music             pip-requirements.txt  pyenv
> tmpl-ckan  Videos
> (pyenv)grizzzly at tmpl-ckan:~$ cat pyenv/bin/tmpl-ckan.py
> import os
> instance_dir = '/home/grizzzly/var/srvc/tmpl-ckan'
> config_file = 'tmpl-ckan.ini'
> pyenv_bin_dir = os.path.join(instance_dir, 'pyenv', 'bin')
> activate_this = os.path.join(pyenv_bin_dir, 'activate_this.py')
> execfile(activate_this, dict(__file__=activate_this))
> from paste.deploy import loadapp
> config_filepath = os.path.join(instance_dir, config_file)
> from paste.script.util.logging_config import fileConfig
> fileConfig(config_filepath)
> application = loadapp('config:%s' % config_filepath)
> (pyenv)grizzzly at tmpl-ckan:~$
>
> (pyenv)grizzzly at tmpl-ckan:~$ ls /home/grizzzly/var/srvc/tmpl-ckan
> lucid_conflict.txt  lucid_missing.txt  lucid_present.txt  pip-
> requirements.txt
>
>
>
> What's missing ?
>
> Kind Regards,
>
> Marc
> On 30 Jun 2011, at 14:46, Kimpe Marc wrote:
>
>> Hi David,
>>
>>
>> Thanks for the quick anwser ....
>>
>> There is definitely a versioning problem.
>>
>> I executed you suggestions,  the system however insisted on using --
>> upgrade
>>
>> and got another message :
>>
>> "ValueError: VDM only works with SQLAlchemy versions 0.4 through 0.6"
>>
>> SQLAlchemy seems to be upgraded in the same exercise -- making me
>> apparently turn into rounds since I already encountered this message
>> before.
>>
>> ---------  actions done :
>>
>> (pyenv)grizzzly at tmpl-ckan:~$ rm /home/grizzzly/pyenv/lib/python2.6/
>> site-packages/migrate-0.2.2-py2.6.egg
>> rm: cannot remove `/home/grizzzly/pyenv/lib/python2.6/site-packages/
>> migrate-0.2.2-py2.6.egg': Is a directory
>> (pyenv)grizzzly at tmpl-ckan:~$
>> (pyenv)grizzzly at tmpl-ckan:~$
>> (pyenv)grizzzly at tmpl-ckan:~$
>> (pyenv)grizzzly at tmpl-ckan:~$ rm -rf /home/grizzzly/pyenv/lib/
>> python2.6/
>> site-packages/migrate-0.2.2-py2.6.egg
>> (pyenv)grizzzly at tmpl-ckan:~$ pip -E pyenv install sqlalchemy-
>> migrate==0.6
>> Requirement already satisfied (use --upgrade to upgrade): sqlalchemy-
>> migrate==0.6 in ./pyenv/lib/python2.6/site-packages/
>> sqlalchemy_migrate-0.6-py2.6.egg
>> Requirement already satisfied (use --upgrade to upgrade):
>> sqlalchemy>=0.5 in ./pyenv/lib/python2.6/site-packages/
>> SQLAlchemy-0.6.6-py2.6.egg (from sqlalchemy-migrate==0.6)
>> Requirement already satisfied (use --upgrade to upgrade): decorator
>> in ./pyenv/lib/python2.6/site-packages/decorator-3.3.1-py2.6.egg (from
>> sqlalchemy-migrate==0.6)
>> Requirement already satisfied (use --upgrade to upgrade): tempita
>> in ./
>> pyenv/lib/python2.6/site-packages/Tempita-0.5.1-py2.6.egg (from
>> sqlalchemy-migrate==0.6)
>> Cleaning up...
>> (pyenv)grizzzly at tmpl-ckan:~$ pip -E pyenv upgrade sqlalchemy-
>> migrate==0.6
>> Usage: pip COMMAND [OPTIONS]
>>
>> pip: error: No command by the name pip upgrade
>>   (maybe you meant "pip install upgrade")
>> (pyenv)grizzzly at tmpl-ckan:~$ pip -E pyenv install --upgrade
>> sqlalchemy-
>> migrate==0.6
>> Downloading/unpacking sqlalchemy-migrate==0.6
>>   Downloading sqlalchemy-migrate-0.6.tar.gz (98Kb): 98Kb downloaded
>>   Running setup.py egg_info for package sqlalchemy-migrate
>>     warning: no files found matching '*' under directory 'tests'
>>     warning: no previously-included files matching '*pyc' found
>> anywhere in distribution
>> Downloading/unpacking sqlalchemy>=0.5 (from sqlalchemy-migrate==0.6)
>>   Downloading SQLAlchemy-0.7.1.tar.gz (2.3Mb): 2.3Mb downloaded
>>   Running setup.py egg_info for package sqlalchemy
>>     warning: no files found matching '*.jpg' under directory 'doc'
>>     no previously-included directories found matching 'doc/build/
>> output'
>> Downloading/unpacking decorator (from sqlalchemy-migrate==0.6)
>>   Downloading decorator-3.3.1.tar.gz
>>   Running setup.py egg_info for package decorator
>>     warning: no previously-included files found matching 'Makefile'
>> Downloading/unpacking tempita (from sqlalchemy-migrate==0.6)
>>   Downloading Tempita-0.5.1.tar.gz
>>   Running setup.py egg_info for package tempita
>> Installing collected packages: sqlalchemy-migrate, sqlalchemy,
>> decorator, tempita
>>   Found existing installation: sqlalchemy-migrate 0.6
>>     Uninstalling sqlalchemy-migrate:
>>       Successfully uninstalled sqlalchemy-migrate
>>   Running setup.py install for sqlalchemy-migrate
>>     warning: no files found matching '*' under directory 'tests'
>>     warning: no previously-included files matching '*pyc' found
>> anywhere in distribution
>>     Installing migrate script to /home/grizzzly/pyenv/bin
>>     Installing migrate-repository script to /home/grizzzly/pyenv/bin
>>   Found existing installation: SQLAlchemy 0.6.6
>>     Uninstalling SQLAlchemy:
>>       Successfully uninstalled SQLAlchemy
>>   Running setup.py install for sqlalchemy
>>     building 'sqlalchemy.cprocessors' extension
>>     gcc -pthread -fno-strict-aliasing -DNDEBUG -g -fwrapv -O2 -Wall -
>> Wstrict-prototypes -fPIC -I/usr/include/python2.6 -c lib/sqlalchemy/
>> cextension/processors.c -o build/temp.linux-i686-2.6/lib/sqlalchemy/
>> cextension/processors.o
>>     gcc -pthread -shared -Wl,-O1 -Wl,-Bsymbolic-functions build/
>> temp.linux-i686-2.6/lib/sqlalchemy/cextension/processors.o -o build/
>> lib.linux-i686-2.6/sqlalchemy/cprocessors.so
>>     building 'sqlalchemy.cresultproxy' extension
>>     gcc -pthread -fno-strict-aliasing -DNDEBUG -g -fwrapv -O2 -Wall -
>> Wstrict-prototypes -fPIC -I/usr/include/python2.6 -c lib/sqlalchemy/
>> cextension/resultproxy.c -o build/temp.linux-i686-2.6/lib/sqlalchemy/
>> cextension/resultproxy.o
>>     gcc -pthread -shared -Wl,-O1 -Wl,-Bsymbolic-functions build/
>> temp.linux-i686-2.6/lib/sqlalchemy/cextension/resultproxy.o -o build/
>> lib.linux-i686-2.6/sqlalchemy/cresultproxy.so
>>     warning: no files found matching '*.jpg' under directory 'doc'
>>     no previously-included directories found matching 'doc/build/
>> output'
>>   Found existing installation: decorator 3.3.1
>>     Uninstalling decorator:
>>       Successfully uninstalled decorator
>>   Running setup.py install for decorator
>>     warning: no previously-included files found matching 'Makefile'
>>   Found existing installation: Tempita 0.5.1
>>     Uninstalling Tempita:
>>       Successfully uninstalled Tempita
>>   Running setup.py install for tempita
>> Successfully installed sqlalchemy-migrate sqlalchemy decorator tempita
>> Cleaning up...
>> (pyenv)grizzzly at tmpl-ckan:~$ paster --plugin ckan db init --config
>> tmpl-ckan
>> Traceback (most recent call last):
>>   File "/usr/bin/paster", line 18, in <module>
>>     command.run()
>>   File "/usr/lib/pymodules/python2.6/paste/script/command.py", line
>> 84, in run
>>     invoke(command, command_name, options, args[1:])
>>   File "/usr/lib/pymodules/python2.6/paste/script/command.py", line
>> 123, in invoke
>>     exit_code = runner.run(args)
>>   File "/usr/lib/pymodules/python2.6/paste/script/command.py", line
>> 218, in run
>>     result = self.command()
>>   File "/home/grizzzly/pyenv/lib/python2.6/site-packages/ckan-1.4.1-
>> py2.6.egg/ckan/lib/cli.py", line 82, in command
>>     self._load_config()
>>   File "/home/grizzzly/pyenv/lib/python2.6/site-packages/ckan-1.4.1-
>> py2.6.egg/ckan/lib/cli.py", line 36, in _load_config
>>     from ckan.config.environment import load_environment
>>   File "/home/grizzzly/pyenv/lib/python2.6/site-packages/ckan-1.4.1-
>> py2.6.egg/ckan/config/environment.py", line 18, in <module>
>>     from ckan import model
>>   File "/home/grizzzly/pyenv/lib/python2.6/site-packages/ckan-1.4.1-
>> py2.6.egg/ckan/model/__init__.py", line 9, in <module>
>>     from core import *
>>   File "/home/grizzzly/pyenv/lib/python2.6/site-packages/ckan-1.4.1-
>> py2.6.egg/ckan/model/core.py", line 2, in <module>
>>     import vdm.sqlalchemy
>>   File "/home/grizzzly/pyenv/lib/python2.6/site-packages/vdm-0.9-
>> py2.6.egg/vdm/sqlalchemy/__init__.py", line 32, in <module>
>>     from tools import Repository
>>   File "/home/grizzzly/pyenv/lib/python2.6/site-packages/vdm-0.9-
>> py2.6.egg/vdm/sqlalchemy/tools.py", line 31, in <module>
>>     raise ValueError("VDM only works with SQLAlchemy versions 0.4
>> through 0.6")
>> ValueError: VDM only works with SQLAlchemy versions 0.4 through 0.6
>> (pyenv)grizzzly at tmpl-ckan:~$ pip freeze
>> Warning: cannot find svn location for flup==1.0.3.dev-20110405
>> Babel==0.9.6
>> Beaker==1.5.4
>> Brlapi==0.5.5
>> CouchDB==0.6
>> FormAlchemy==1.4
>> FormEncode==1.2.2
>> Genshi==0.6
>> GnuPGInterface==0.3.2
>> Jinja2==2.5.5
>> Mako==0.3.4
>> MarkupSafe==0.9.2
>> PAM==0.4.2
>> PIL==1.1.7
>> Paste==1.7.4
>> PasteDeploy==1.3.3
>> PasteScript==1.7.3
>> PyUtilib==3.6.2498
>> Pygments==1.4
>> Pylons==0.9.7
>> Routes==1.12.3
>> SQLAlchemy==0.7.1
>> Sphinx==0.6.4
>> Tempita==0.5.1
>> Twisted-Core==10.1.0
>> Twisted-Names==10.1.0
>> Twisted-Web==10.1.0
>> WebError==0.10.3
>> WebHelpers==1.2
>> WebOb==1.0.8
>> WebTest==1.2.3
>> adium-theme-ubuntu==0.3
>> apt-xapian-index==0.39
>> apturl==0.4.1ubuntu7
>> argparse==1.1
>> autoneg==0.5
>> command-not-found==0.1
>> configglue==0.9pre1
>> decorator==3.3.1
>> distribute==0.6.14
>> docutils==0.7
>> ## FIXME: could not find svn URL in dependency_links for this package:
>> flup==1.0.3.dev-20110405
>> gnome-app-install==0.4.7ubuntu2
>> httplib2==0.6.0
>> jockey==0.5.10
>> launchpadlib==1.6.1
>> lazr.restfulclient==0.9.20
>> lazr.uri==1.0.2
>> licenses==0.6
>> louis==2.0.0
>> lxml==2.2.4
>> mercurial==1.6.3
>> mod-python==3.3.1
>> nose==1.0.0
>> nvidia-common==0.0.0
>> oauth==1.0a
>> onboard==0.94.0
>> papyon==0.5.1
>> pexpect==2.3
>> protobuf==2.3.0
>> psutil==0.2.1
>> psycopg2==2.0.13
>> pyOpenSSL==0.10
>> pycrypto==2.0.1
>> pycups==1.9.51
>> pycurl==7.19.0
>> pyinotify==0.8.9
>> pyserial==2.3
>> pysmbc==1.0.8
>> python-apt==0.7.96.1ubuntu11
>> python-debian==0.1.16ubuntu1
>> python-openid==2.2.4
>> python-virtkey==0.60.0
>> pyutilib.R==3.0.5
>> pyutilib.autotest==1.4.6
>> pyutilib.common==3.0.5
>> pyutilib.component.app==3.1.6
>> pyutilib.component.config==3.3.2
>> pyutilib.component.core==4.3.1
>> pyutilib.component.doc==1.0.1
>> pyutilib.component.executables==3.4.1
>> pyutilib.component.loader==3.3.1
>> pyutilib.dev==1.15.2
>> pyutilib.enum==1.0.7
>> pyutilib.excel==3.0.6
>> pyutilib.math==3.0.6
>> pyutilib.misc==4.6
>> pyutilib.ply==3.0.6
>> pyutilib.pyro==3.3
>> pyutilib.services==3.3.1
>> pyutilib.subprocess==3.2.3
>> pyutilib.svn==1.0.1
>> pyutilib.th==5.0
>> pyutilib.virtualenv==2.5
>> pyutilib.workflow==2.2.4
>> pyxdg==0.19
>> rdflib==2.4.2
>> repoze.who==2.0b1
>> scgi==1.13
>> screen-resolution-extra==0.0.0
>> sessioninstaller==0.0.0
>> simplejson==2.1.1
>> speechd==0.3
>> speechd-config==0.0
>> sqlalchemy-migrate==0.6
>> system-service==0.1.6
>> ubuntu-sso-client==1.0.3
>> ubuntuone-storage-protocol==1.4.0
>> ufw==0.30.0-1ubuntu2
>> unattended-upgrades==0.1
>> unittest2==0.5.1
>> usb-creator==0.2.23
>> vdm==0.9
>> virtualenv==1.6.1
>> wadllib==1.1.4
>> wsgiref==0.1.2
>> xkit==0.0.0
>> zope.interface==3.6.1
>> (pyenv)grizzzly at tmpl-ckan:~$
>>
>>
>>
>> ---------------   requirements.txt used :
>>
>>
>> (pyenv)grizzzly at tmpl-ckan:~$ cat var/srvc/tmpl-ckan/*.txt
>> # These are packages where we require a different version of a package
>> from
>> # the one in Lucid. Rather than packaging a backport which could
>> potentially
>> # interfere with a user's other installed software, we put these
>> modules into
>> # a single location which CKAN imports from in preference to the Lucid
>> # equivalent.
>>
>> Genshi>=0.6,<0.6.99
>> sqlalchemy-migrate==0.6
>> sqlalchemy==0.6.6
>> webhelpers==1.2
>>
>> # NOTE: Developers, our build script for the Debian packages relies on
>> the
>> #       requirements above being specified as editable resources with
>> their
>> #       mercurial, SVN or git repository specified at the correct
>> revision to
>> #       package.
>> # These are packages that we rely on that aren't present in Lucid. We
>> package
>> # them and put them in our own CKAN repository
>>
>> # pyutilib.component.core>=4.1,<4.1.99
>> -e svn+https://software.sandia.gov/svn/public/pyutilib/pyutilib.component.core/trunk@1972#egg=pyutilib.component.core
>> # licenses==0.4,<0.6.99
>> -e hg+https://bitbucket.org/okfn/licenses@0eed4a13296b#egg=licenses
>> # vdm>=0.9,<0.9.99
>> -e hg+https://bitbucket.org/okfn/vdm@vdm-0.9#egg=vdm
>> # markupsafe==0.9.2 required by webhelpers==1.2 required by
>> formalchemy with SQLAlchemy 0.6
>> -e git+https://github.com/mitsuhiko/
>> markupsafe.git at 0.9.2#egg=markupsafe
>> # autoneg>=0.5
>> -e git+https://github.com/wwaites/autoneg.git@b4c727b164f411cc9d60#egg=autoneg
>> # flup>=0.5
>> -e hg+http://hg.saddi.com/flup@301a58656bfb#egg=flup
>> # All the conflicting dependencies from the lucid_conflict.txt file
>> -e hg+https://bitbucket.org/okfn/ckan-deps@6287665a1965#egg=ckan-deps
>> # FormAlchemy
>> -e git+https://github.com/FormAlchemy/formalchemy.git@1.3.9#egg=formalchemy
>>
>> # NOTE: Developers, our build script for the Debian packages relies on
>> the
>> #       requirements above being specified as editable resources with
>> their
>> #       mercurial, SVN or git repository specified at the correct
>> revision to
>> #       package
>> # These CKAN dependencies are already in Lucid and should be installed
>> via
>> # apt-get if you are on that platform. If you are using a different
>> platform
>> # you can install these dependencies via pip instead.
>> #
>> # sudo apt-get install python-psycopg2 python-lxml python-sphinx
>> python-pybabel
>> # sudo apt-get install python-pylons python-formalchemy python-
>> repoze.who
>> # sudo apt-get install python-repoze.who-plugins python-tempita
>> python-
>> zope.interface
>>
>> babel==0.9.4
>> psycopg2==2.0.13
>> lxml==2.2.4
>> sphinx==0.6.4
>> Pylons==0.9.7
>> repoze.who==1.0.18
>> tempita==0.4
>> zope.interface==3.5.3
>> # These are both combined into the python-repoze.who-plugins package
>> repoze.who.plugins.openid
>> # Actually from python-repoze.who-plugins but the openid plugin in the
>> same
>> # package is too old
>> repoze.who-friendlyform==1.0.8
>> routes==1.11
>> paste==1.7.2
>> pastescript==1.7.3
>>
>> # NOTE: Developers, please do not edit the versions, these versions
>> are fixed
>> #       in Lucid. If you start to depend on a different vesion you'll
>> need to
>> #       remove the version here and package your version as a
>> conflict.
>> # This file allows you to install CKAN and all its dependencies
>> # in a virtual environment.
>> #
>> # Use it like this:
>> #
>> #     pip install --ignore-installed -r pip-requirements.txt
>>
>> -e hg+https://bitbucket.org/okfn/ckan@default#egg=ckan
>> # CKAN dependencies
>> -r https://bitbucket.org/okfn/ckan/raw/default/requires/lucid_conflict.txt
>> -r https://bitbucket.org/okfn/ckan/raw/default/requires/lucid_present.txt
>> -r https://bitbucket.org/okfn/ckan/raw/default/requires/lucid_missing.txt
>>
>> # NOTE: Developers, please do not edit this file. Changes should go in
>> the
>> #       appropriate files in the `requires' directory.
>>
>>
>>
>>
>>
>>
>> So there must be a golden sequence of install different from :  http://packages.python.org/ckan/deployment.html
>>
>> Can you help ?
>>
>> mvg,
>>
>> Marc
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> On 30 Jun 2011, at 14:31, David Read wrote:
>>
>>> Hi Marc,
>>>
>>> Thanks for the detailed info - this really helps. It looks like you
>>> have got the old sqlalchemy-migrate version 0.2.2 installed into your
>>> python environment, when you need v0.6.
>>>
>>> To fix the issue I suggest you "rm
>>> /home/grizzzly/pyenv/lib/python2.6/site-packages/migrate-0.2.2-
>>> py2.6.egg"
>>> and reinstall with "pip -E pyenv install sqlalchemy-migrate==0.6".
>>>
>>> To work out what as gone wrong, can you show us your
>>> pip-requirements.txt you used in step 6 please? This should reference
>>> a particular version of lucid_conflict.txt which contains the
>>> reference to "sqlalchemy-migrate==0.6".
>>>
>>> David
>>>
>>> On 30 June 2011 12:04, Kimpe Marc <Marc.Kimpe at cronos.be> wrote:
>>>> Resending after subscription.
>>>>
>>>> Thanks,
>>>>
>>>> Marc
>>>>
>>>>
>>>> On 29 Jun 2011, at 15:30, Kimpe Marc wrote:
>>>>
>>>>> Hi,
>>>>>
>>>>>
>>>>> In order to prepare for a new open data site, I'm trying to follow
>>>>> the
>>>>> procedure in
>>>>> http://packages.python.org/ckan/deployment.html
>>>>> on a Ubuntu :
>>>>> Linux tmpl-ckan 2.6.35-22-generic #33-Ubuntu SMP Sun Sep 19
>>>>> 20:34:50
>>>>> UTC 2010 i686 GNU/Linux
>>>>>
>>>>>
>>>>> I got to the stage were I try to initialize the database with
>>>>> running :
>>>>>
>>>>> paster --plugin ckan db init --config tmpl-ckan
>>>>>
>>>>> However this gives me an error :
>>>>>
>>>>> (pyenv)grizzzly at tmpl-ckan:~$ paster --plugin ckan db init --config
>>>>> tmpl-ckan
>>>>> /home/grizzzly/pyenv/lib/python2.6/site-packages/migrate-0.2.2-
>>>>> py2.6.egg/migrate/versioning/unique_instance.py:19:
>>>>> DeprecationWarning: object.__new__() takes no parameters
>>>>>  instances[key] = super(UniqueInstance,cls).__new__(cls,*p,**k)
>>>>> Traceback (most recent call last):
>>>>>  File "/usr/bin/paster", line 18, in <module>
>>>>>    command.run()
>>>>>  File "/usr/lib/pymodules/python2.6/paste/script/command.py", line
>>>>> 84, in run
>>>>>    invoke(command, command_name, options, args[1:])
>>>>>  File "/usr/lib/pymodules/python2.6/paste/script/command.py", line
>>>>> 123, in invoke
>>>>>    exit_code = runner.run(args)
>>>>>  File "/usr/lib/pymodules/python2.6/paste/script/command.py", line
>>>>> 218, in run
>>>>>    result = self.command()
>>>>>  File "/home/grizzzly/pyenv/lib/python2.6/site-packages/ckan-1.4.1-
>>>>> py2.6.egg/ckan/lib/cli.py", line 87, in command
>>>>>    model.repo.init_db()
>>>>>  File "/home/grizzzly/pyenv/lib/python2.6/site-packages/ckan-1.4.1-
>>>>> py2.6.egg/ckan/model/__init__.py", line 70, in init_db
>>>>>    self.upgrade_db()
>>>>>  File "/home/grizzzly/pyenv/lib/python2.6/site-packages/ckan-1.4.1-
>>>>> py2.6.egg/ckan/model/__init__.py", line 168, in upgrade_db
>>>>>    import migrate.versioning.api as mig
>>>>>  File "/home/grizzzly/pyenv/lib/python2.6/site-packages/
>>>>> migrate-0.2.2-py2.6.egg/migrate/versioning/api.py", line 5, in
>>>>> <module>
>>>>>    from migrate.versioning.repository import *
>>>>>  File "/home/grizzzly/pyenv/lib/python2.6/site-packages/
>>>>> migrate-0.2.2-py2.6.egg/migrate/versioning/repository.py", line 8,
>>>>> in
>>>>> <module>
>>>>>    from migrate.versioning import script,exceptions,version
>>>>>  File "/home/grizzzly/pyenv/lib/python2.6/site-packages/
>>>>> migrate-0.2.2-py2.6.egg/migrate/versioning/script/__init__.py",
>>>>> line
>>>>> 1, in <module>
>>>>>    from py import *
>>>>>  File "/home/grizzzly/pyenv/lib/python2.6/site-packages/
>>>>> migrate-0.2.2-py2.6.egg/migrate/versioning/script/py.py", line 2,
>>>>> in
>>>>> <module>
>>>>>    from logsql import LogsqlFile
>>>>>  File "/home/grizzzly/pyenv/lib/python2.6/site-packages/
>>>>> migrate-0.2.2-py2.6.egg/migrate/versioning/script/logsql.py", line
>>>>> 2,
>>>>> in <module>
>>>>>    from migrate.versioning import logengine
>>>>>  File "/home/grizzzly/pyenv/lib/python2.6/site-packages/
>>>>> migrate-0.2.2-py2.6.egg/migrate/versioning/logengine.py", line
>>>>> 260, in
>>>>> <module>
>>>>>    LogEngineStrategy()
>>>>>  File "/home/grizzzly/pyenv/lib/python2.6/site-packages/
>>>>> migrate-0.2.2-py2.6.egg/migrate/versioning/logengine.py", line
>>>>> 253, in
>>>>> __init__
>>>>>    super(LogEngineStrategy,self).__init__('logsql')
>>>>> TypeError: __init__() takes exactly 1 argument (2 given)
>>>>>
>>>>>
>>>>> Here are the versions PIP reports currently :
>>>>>
>>>>> (pyenv)grizzzly at tmpl-ckan:~$ pip freeze
>>>>> Warning: cannot find svn location for flup==1.0.3.dev-20110405
>>>>> Babel==0.9.6
>>>>> Beaker==1.5.4
>>>>> Brlapi==0.5.5
>>>>> CouchDB==0.6
>>>>> FormAlchemy==1.4
>>>>> FormEncode==1.2.2
>>>>> Genshi==0.6
>>>>> GnuPGInterface==0.3.2
>>>>> Jinja2==2.5.5
>>>>> Mako==0.3.4
>>>>> MarkupSafe==0.9.2
>>>>> PAM==0.4.2
>>>>> PIL==1.1.7
>>>>> Paste==1.7.4
>>>>> PasteDeploy==1.3.3
>>>>> PasteScript==1.7.3
>>>>> PyUtilib==3.6.2498
>>>>> Pygments==1.4
>>>>> Pylons==0.9.7
>>>>> Routes==1.12.3
>>>>> SQLAlchemy==0.6.6
>>>>> Sphinx==0.6.4
>>>>> Tempita==0.5.1
>>>>> Twisted-Core==10.1.0
>>>>> Twisted-Names==10.1.0
>>>>> Twisted-Web==10.1.0
>>>>> WebError==0.10.3
>>>>> WebHelpers==1.2
>>>>> WebOb==1.0.8
>>>>> WebTest==1.2.3
>>>>> adium-theme-ubuntu==0.3
>>>>> apt-xapian-index==0.39
>>>>> apturl==0.4.1ubuntu7
>>>>> argparse==1.1
>>>>> autoneg==0.5
>>>>> command-not-found==0.1
>>>>> configglue==0.9pre1
>>>>> decorator==3.3.1
>>>>> distribute==0.6.14
>>>>> docutils==0.7
>>>>> ## FIXME: could not find svn URL in dependency_links for this
>>>>> package:
>>>>> flup==1.0.3.dev-20110405
>>>>> gnome-app-install==0.4.7ubuntu2
>>>>> httplib2==0.6.0
>>>>> jockey==0.5.10
>>>>> launchpadlib==1.6.1
>>>>> lazr.restfulclient==0.9.20
>>>>> lazr.uri==1.0.2
>>>>> licenses==0.6
>>>>> louis==2.0.0
>>>>> lxml==2.2.4
>>>>> mercurial==1.6.3
>>>>> migrate==0.2.2
>>>>> mod-python==3.3.1
>>>>> nose==1.0.0
>>>>> nvidia-common==0.0.0
>>>>> oauth==1.0a
>>>>> onboard==0.94.0
>>>>> papyon==0.5.1
>>>>> pexpect==2.3
>>>>> protobuf==2.3.0
>>>>> psutil==0.2.1
>>>>> psycopg2==2.0.13
>>>>> pyOpenSSL==0.10
>>>>> pycrypto==2.0.1
>>>>> pycups==1.9.51
>>>>> pycurl==7.19.0
>>>>> pyinotify==0.8.9
>>>>> pyserial==2.3
>>>>> pysmbc==1.0.8
>>>>> python-apt==0.7.96.1ubuntu11
>>>>> python-debian==0.1.16ubuntu1
>>>>> python-openid==2.2.4
>>>>> python-virtkey==0.60.0
>>>>> pyutilib.R==3.0.5
>>>>> pyutilib.autotest==1.4.6
>>>>> pyutilib.common==3.0.5
>>>>> pyutilib.component.app==3.1.6
>>>>> pyutilib.component.config==3.3.2
>>>>> pyutilib.component.core==4.3.1
>>>>> pyutilib.component.doc==1.0.1
>>>>> pyutilib.component.executables==3.4.1
>>>>> pyutilib.component.loader==3.3.1
>>>>> pyutilib.dev==1.15.2
>>>>> pyutilib.enum==1.0.7
>>>>> pyutilib.excel==3.0.6
>>>>> pyutilib.math==3.0.6
>>>>> pyutilib.misc==4.6
>>>>> pyutilib.ply==3.0.6
>>>>> pyutilib.pyro==3.3
>>>>> pyutilib.services==3.3.1
>>>>> pyutilib.subprocess==3.2.3
>>>>> pyutilib.svn==1.0.1
>>>>> pyutilib.th==5.0
>>>>> pyutilib.virtualenv==2.5
>>>>> pyutilib.workflow==2.2.4
>>>>> pyxdg==0.19
>>>>> rdflib==2.4.2
>>>>> repoze.who==2.0b1
>>>>> scgi==1.13
>>>>> screen-resolution-extra==0.0.0
>>>>> sessioninstaller==0.0.0
>>>>> simplejson==2.1.1
>>>>> speechd==0.3
>>>>> speechd-config==0.0
>>>>> sqlalchemy-migrate==0.6
>>>>> system-service==0.1.6
>>>>> ubuntu-sso-client==1.0.3
>>>>> ubuntuone-storage-protocol==1.4.0
>>>>> ufw==0.30.0-1ubuntu2
>>>>> unattended-upgrades==0.1
>>>>> unittest2==0.5.1
>>>>> usb-creator==0.2.23
>>>>> vdm==0.9
>>>>> virtualenv==1.6.1
>>>>> wadllib==1.1.4
>>>>> wsgiref==0.1.2
>>>>> xkit==0.0.0
>>>>> zope.interface==3.6.1
>>>>> (pyenv)grizzzly at tmpl-ckan:~$
>>>>>
>>>>> Except for the database login the tmpl-ckan is the standard
>>>>> generated
>>>>>
>>>>>
>>>>> What is wrong ?
>>>>>
>>>>>
>>>>> Many thanks,
>>>>>
>>>>> Marc
>>>>>
>>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> ckan-dev mailing list
>>>> ckan-dev at lists.okfn.org
>>>> http://lists.okfn.org/mailman/listinfo/ckan-dev
>>>>
>>
>
>

More information about the ckan-dev mailing list