lastpass / lastpass-cli

LastPass command line interface tool
GNU General Public License v2.0
2.85k stars 290 forks source link

type "codename" already exists when running cmsInitDB #619

Closed orebitt closed 1 year ago

orebitt commented 2 years ago

Installed build essentials, did setup.py build & install with no issues. When I run cmsInitDB, I get this error.

2021-10-12 03:10:15,643 - INFO [] Using configuration file /usr/local/etc/cms.conf. Traceback (most recent call last): File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context self.dialect.do_execute( File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/default.py", line 608, in do_execute cursor.execute(statement, parameters) psycopg2.errors.DuplicateObject: type "codename" already exists

The above exception was the direct cause of the following exception:

Traceback (most recent call last): File "/usr/local/bin/cmsInitDB", line 4, in import('pkg_resources').run_script('cms==1.5.dev0', 'cmsInitDB') File "/usr/lib/python3/dist-packages/pkg_resources/init.py", line 667, in run_script self.require(requires)[0].run_script(script_name, ns) File "/usr/lib/python3/dist-packages/pkg_resources/init.py", line 1463, in run_script exec(code, namespace, namespace) File "/usr/local/lib/python3.8/dist-packages/cms-1.5.dev0-py3.8.egg/EGG-INFO/scripts/cmsInitDB", line 59, in sys.exit(main()) File "/usr/local/lib/python3.8/dist-packages/cms-1.5.dev0-py3.8.egg/EGG-INFO/scripts/cmsInitDB", line 53, in main success = init_db() File "/usr/local/lib/python3.8/dist-packages/cms-1.5.dev0-py3.8.egg/cms/db/init.py", line 29, in init_db metadata.create_all() File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/sql/schema.py", line 4664, in create_all bind._run_visitor( File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 2095, in _run_visitor conn._run_visitor(visitorcallable, element, kwargs) File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1656, in _run_visitor visitorcallable(self.dialect, self, kwargs).traverse_single(element) File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/sql/visitors.py", line 145, in traverse_single return meth(obj, *kw) File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/sql/ddl.py", line 770, in visit_metadata metadata.dispatch.before_create( File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/event/attr.py", line 322, in call fn(args, **kw) File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/sql/ddl.py", line 256, in call return bind.execute(self.against(target)) File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1011, in execute return meth(self, multiparams, params) File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/sql/ddl.py", line 72, in _execute_on_connection return connection._execute_ddl(self, multiparams, params) File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1068, in _execute_ddl ret = self._execute_context( File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context self._handle_dbapi_exception( File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapiexception util.raise( File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/util/compat.py", line 182, in raise_ raise exception File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context self.dialect.do_execute( File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/default.py", line 608, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.ProgrammingError: (psycopg2.errors.DuplicateObject) type "codename" already exists

[SQL: CREATE DOMAIN CODENAME VARCHAR CHECK (VALUE ~ '^[A-Za-z0-9_-]+$')] (Background on this error at: http://sqlalche.me/e/13/f405)