I can't install this support,error about databases

fengshajin's Avatar

fengshajin

20 Sep, 2014 01:17 AM

I want install this server on my test environment, but can not start system
my OS :debian 7.4
OS user :root
password for OS user root :root
databases :mysql 5.5
databases user:root
databases password:123456
databases port:3306

RhodeCode Installer 0.7.0
-------------------------

What database do you use?
[s]qlite (built-in, no server needed)
[m]ysql
[p]ostgresql
> m

What is the IP or hostname of the database server?
> 127.0.0.1

What is the port of the database server?
> 3306

What is the user at the database server?
> root

What is the password of the user at the database server?
>

Please enter the same password again:
>

What is the database name at the database server (default is rhodecode)?
> rhodecode

error

root@localhost:~# su root -s /bin/sh -c '"/root/rhodecode/system/bin/paster" serve "/root/rhodecode/data/production.ini"'
2014-09-20 09:15:32.332 INFO [rhodecode.model] initializing db for mysql://root:[email blocked].0.1:3306/rhodecode
2014-09-20 09:15:32.332 INFO [rhodecode.lib.auth] getting information about all available permissions
2014-09-20 09:15:32.393 ERROR [rhodecode.lib.auth] Traceback (most recent call last):
  File "/root/rhodecode/system/local/lib/python2.7/site-packages/rhodecode/lib/auth.py", line 711, in set_available_permissions
    all_perms = sa.query(Permission).all()
  File "/root/rhodecode/system/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2115, in all
    return list(self)
  File "/root/rhodecode/system/local/lib/python2.7/site-packages/rhodecode/lib/caching_query.py", line 83, in __iter__
    return Query.__iter__(self)
  File "/root/rhodecode/system/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2227, in __iter__
    return self._execute_and_instances(context)
  File "/root/rhodecode/system/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2240, in _execute_and_instances
    close_with_result=True)
  File "/root/rhodecode/system/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2231, in _connection_from_session
    **kw)
  File "/root/rhodecode/system/local/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 784, in connection
    close_with_result=close_with_result)
  File "/root/rhodecode/system/local/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 788, in _connection_for_bind
    return self.transaction._connection_for_bind(engine)
  File "/root/rhodecode/system/local/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 313, in _connection_for_bind
    conn = bind.contextual_connect()
  File "/root/rhodecode/system/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 2489, in contextual_connect
    self.pool.connect(),
  File "/root/rhodecode/system/local/lib/python2.7/site-packages/sqlalchemy/pool.py", line 236, in connect
    return _ConnectionFairy(self).checkout()
  File "/root/rhodecode/system/local/lib/python2.7/site-packages/sqlalchemy/pool.py", line 401, in __init__
    rec = self._connection_record = pool._do_get()
  File "/root/rhodecode/system/local/lib/python2.7/site-packages/sqlalchemy/pool.py", line 746, in _do_get
    con = self._create_connection()
  File "/root/rhodecode/system/local/lib/python2.7/site-packages/sqlalchemy/pool.py", line 189, in _create_connection
    return _ConnectionRecord(self)
  File "/root/rhodecode/system/local/lib/python2.7/site-packages/sqlalchemy/pool.py", line 282, in __init__
    self.connection = self.__connect()
  File "/root/rhodecode/system/local/lib/python2.7/site-packages/sqlalchemy/pool.py", line 344, in __connect
    connection = self.__pool._creator()
  File "/root/rhodecode/system/local/lib/python2.7/site-packages/sqlalchemy/engine/strategies.py", line 80, in connect
    return dialect.connect(*cargs, **cparams)
  File "/root/rhodecode/system/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 281, in connect
    return self.dbapi.connect(*cargs, **cparams)
  File "/root/rhodecode/system/local/lib/python2.7/site-packages/MySQLdb/__init__.py", line 81, in Connect
    return Connection(*args, **kwargs)
  File "/root/rhodecode/system/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 193, in __init__
    super(Connection, self).__init__(*args, **kwargs2)
OperationalError: (OperationalError) (1049, "Unknown database 'rhodecode'") None None

Traceback (most recent call last):
  File "/root/rhodecode/system/bin/paster", line 9, in <module>
    load_entry_point('PasteScript==1.7.5', 'console_scripts', 'paster')()
  File "/root/rhodecode/system/local/lib/python2.7/site-packages/paste/script/command.py", line 104, in run
    invoke(command, command_name, options, args[1:])
  File "/root/rhodecode/system/local/lib/python2.7/site-packages/paste/script/command.py", line 143, in invoke
    exit_code = runner.run(args)
  File "/root/rhodecode/system/local/lib/python2.7/site-packages/paste/script/command.py", line 238, in run
    result = self.command()
  File "/root/rhodecode/system/local/lib/python2.7/site-packages/paste/script/serve.py", line 284, in command
    relative_to=base, global_conf=vars)
  File "/root/rhodecode/system/local/lib/python2.7/site-packages/paste/script/serve.py", line 321, in loadapp
    **kw)
  File "/root/rhodecode/system/local/lib/python2.7/site-packages/paste/deploy/loadwsgi.py", line 247, in loadapp
    return loadobj(APP, uri, name=name, **kw)
  File "/root/rhodecode/system/local/lib/python2.7/site-packages/paste/deploy/loadwsgi.py", line 272, in loadobj
    return context.create()
  File "/root/rhodecode/system/local/lib/python2.7/site-packages/paste/deploy/loadwsgi.py", line 710, in create
    return self.object_type.invoke(self)
  File "/root/rhodecode/system/local/lib/python2.7/site-packages/paste/deploy/loadwsgi.py", line 146, in invoke
    return fix_call(context.object, context.global_conf, **context.local_conf)
  File "/root/rhodecode/system/local/lib/python2.7/site-packages/paste/deploy/util.py", line 55, in fix_call
    val = callable(*args, **kw)
  File "/root/rhodecode/system/local/lib/python2.7/site-packages/rhodecode/config/middleware.py", line 56, in make_app
    config = load_environment(global_conf, app_conf)
  File "/root/rhodecode/system/local/lib/python2.7/site-packages/rhodecode/config/environment.py", line 118, in load_environment
    repos_path = make_ui('db').configitems('paths')[0][1]
  File "/root/rhodecode/system/local/lib/python2.7/site-packages/rhodecode/lib/utils.py", line 377, in make_ui
    .options(FromCache("sql_cache_short", "get_hg_ui_settings"))\
  File "/root/rhodecode/system/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2115, in all
    return list(self)
  File "/root/rhodecode/system/local/lib/python2.7/site-packages/rhodecode/lib/caching_query.py", line 80, in __iter__
    return self.get_value(createfunc=lambda:
  File "/root/rhodecode/system/local/lib/python2.7/site-packages/rhodecode/lib/caching_query.py", line 99, in get_value
    ret = cache.get_value(cache_key, createfunc=createfunc)
  File "/root/rhodecode/system/local/lib/python2.7/site-packages/beaker/cache.py", line 305, in get
    return self._get_value(key, **kw).get_value()
  File "/root/rhodecode/system/local/lib/python2.7/site-packages/beaker/container.py", line 385, in get_value
    v = self.createfunc()
  File "/root/rhodecode/system/local/lib/python2.7/site-packages/rhodecode/lib/caching_query.py", line 81, in <lambda>
    list(Query.__iter__(self)))
  File "/root/rhodecode/system/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2227, in __iter__
    return self._execute_and_instances(context)
  File "/root/rhodecode/system/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2240, in _execute_and_instances
    close_with_result=True)
  File "/root/rhodecode/system/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2231, in _connection_from_session
    **kw)
  File "/root/rhodecode/system/local/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 784, in connection
    close_with_result=close_with_result)
  File "/root/rhodecode/system/local/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 788, in _connection_for_bind
    return self.transaction._connection_for_bind(engine)
  File "/root/rhodecode/system/local/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 313, in _connection_for_bind
    conn = bind.contextual_connect()
  File "/root/rhodecode/system/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 2489, in contextual_connect
    self.pool.connect(),
  File "/root/rhodecode/system/local/lib/python2.7/site-packages/sqlalchemy/pool.py", line 236, in connect
    return _ConnectionFairy(self).checkout()
  File "/root/rhodecode/system/local/lib/python2.7/site-packages/sqlalchemy/pool.py", line 401, in __init__
    rec = self._connection_record = pool._do_get()
  File "/root/rhodecode/system/local/lib/python2.7/site-packages/sqlalchemy/pool.py", line 746, in _do_get
    con = self._create_connection()
  File "/root/rhodecode/system/local/lib/python2.7/site-packages/sqlalchemy/pool.py", line 189, in _create_connection
    return _ConnectionRecord(self)
  File "/root/rhodecode/system/local/lib/python2.7/site-packages/sqlalchemy/pool.py", line 282, in __init__
    self.connection = self.__connect()
  File "/root/rhodecode/system/local/lib/python2.7/site-packages/sqlalchemy/pool.py", line 344, in __connect
    connection = self.__pool._creator()
  File "/root/rhodecode/system/local/lib/python2.7/site-packages/sqlalchemy/engine/strategies.py", line 80, in connect
    return dialect.connect(*cargs, **cparams)
  File "/root/rhodecode/system/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 281, in connect
    return self.dbapi.connect(*cargs, **cparams)
  File "/root/rhodecode/system/local/lib/python2.7/site-packages/MySQLdb/__init__.py", line 81, in Connect
    return Connection(*args, **kwargs)
  File "/root/rhodecode/system/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 193, in __init__
    super(Connection, self).__init__(*args, **kwargs2)
sqlalchemy.exc.OperationalError: (OperationalError) (1049, "Unknown database 'rhodecode'") None None

  1. Support Staff 1 Posted by Marcin Kuzminsk... on 20 Sep, 2014 12:52 PM

    Marcin Kuzminski's Avatar

    Hi,

    The problem is that you have to create new database called "rhodecode" installer doesn't have permission to create new databases. When you create the database in mysql then all things should be working fine.

    Cheers

  2. Marcin Kuzminski closed this discussion on 20 Sep, 2014 12:52 PM.

  3. fengshajin re-opened this discussion on 23 Sep, 2014 04:36 AM

  4. 2 Posted by fengshajin on 23 Sep, 2014 04:36 AM

    fengshajin's Avatar

    I use root acount execute this script
    and if I created rhodecode database some errors still happened:table not exist!

  5. Support Staff 3 Posted by Marcin Kuzminsk... on 23 Sep, 2014 08:42 AM

    Marcin Kuzminski's Avatar

    Can you paste the error ?

  6. 4 Posted by fengshajin on 24 Sep, 2014 01:34 AM

    fengshajin's Avatar

    here is the log

    thank you

  7. Support Staff 5 Posted by Marcin Kuzminsk... on 24 Sep, 2014 04:24 AM

    Marcin Kuzminski's Avatar

    It looks like there's an issue of connecting to our server: https://rhodecode.com/dl/virtualenv-1.10.1.zip

    Does your connection require a custom SSL certificate ?

  8. 6 Posted by fengshajin on 24 Sep, 2014 04:44 AM

    fengshajin's Avatar

    I use wget https://rhodecode.com/dl/virtualenv-1.10.1.zip can download this file.

    what can I do?

    will this project give us the whole file,it will not use network,and we can install this system without network

  9. Support Staff 7 Posted by Marcin Kuzminsk... on 24 Sep, 2014 04:48 AM

    Marcin Kuzminski's Avatar

    The current installer doesn't support offline installation. We're soon releasing a new one that does. In the mean time is there any option that you could try install this with proper internet access ? The error you showed me comes from python and SSL certificate checks

  10. 8 Posted by fengshajin on 24 Sep, 2014 06:24 AM

    fengshajin's Avatar

    can you help me?
    I do not know how solve the problem.
    I need you help.
    my OS is debian7.4

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac