Joshua Colp
2015-Sep-24 19:46 UTC
[asterisk-users] problems with PJSIP install on UBUNTU 14.04
On 15-09-24 04:42 PM, Ryan, Travis wrote:> Did something change DB-wise with PJSIP and realtime between 13.3.2 > and 13.5.0? I'm getting an unknown column error and unsure where I > need that column and the type it needs to be.Yes, the schema can change between versions. Following the instructions on https://wiki.asterisk.org/wiki/display/AST/Setting+up+PJSIP+Realtime#SettingupPJSIPRealtime-InstallingandUsingAlembic will cause alembic to upgrade the tables. -- Joshua Colp Digium, Inc. | Senior Software Developer 445 Jan Davis Drive NW - Huntsville, AL 35806 - US Check us out at: www.digium.com & www.asterisk.org
Ryan, Travis
2015-Sep-24 21:30 UTC
[asterisk-users] problems with PJSIP install on UBUNTU 14.04
Yes, the schema can change between versions. Following the instructions on https://wiki.asterisk.org/wiki/display/AST/Setting+up+PJSIP+Realtime#SettingupPJSIPRealtime-InstallingandUsingAlembic will cause alembic to upgrade the tables. -- Joshua Colp Digium, Inc. | Senior Software Developer 445 Jan Davis Drive NW - Huntsville, AL 35806 - US Check us out at: www.digium.com & www.asterisk.org I'm not a fan of alembic at all, but I'll give it another try. One issue I have is I don't want it to make the extensions table, because I already use that name of table for some proprietary stuff I use. Right now it's complaining that I already have a table named that. Any way to exclude that other stuff, and only have it manage the core sip_devices and PJSIP stuff? travis at pcimphone1:~/downloads/asterisk-13.5.0/contrib/ast-db-manage$ sudo alembic -c config.ini upgrade head INFO [alembic.migration] Context impl MySQLImpl. INFO [alembic.migration] Will assume non-transactional DDL. INFO [alembic.migration] Running upgrade 43956d550a44 -> 581a4264e537, adding extensions Traceback (most recent call last): File "/usr/bin/alembic", line 9, in <module> load_entry_point('alembic==0.6.2', 'console_scripts', 'alembic')() File "/usr/lib/python2.7/dist-packages/alembic/config.py", line 298, in main CommandLine(prog=prog).main(argv=argv) File "/usr/lib/python2.7/dist-packages/alembic/config.py", line 293, in main self.run_cmd(cfg, options) File "/usr/lib/python2.7/dist-packages/alembic/config.py", line 279, in run_cmd **dict((k, getattr(options, k)) for k in kwarg) File "/usr/lib/python2.7/dist-packages/alembic/command.py", line 124, in upgrade script.run_env() File "/usr/lib/python2.7/dist-packages/alembic/script.py", line 199, in run_env util.load_python_file(self.dir, 'env.py') File "/usr/lib/python2.7/dist-packages/alembic/util.py", line 199, in load_python_file module = load_module(module_id, path) File "/usr/lib/python2.7/dist-packages/alembic/compat.py", line 55, in load_module mod = imp.load_source(module_id, path, fp) File "config/env.py", line 73, in <module> run_migrations_online() File "config/env.py", line 66, in run_migrations_online context.run_migrations() File "<string>", line 7, in run_migrations File "/usr/lib/python2.7/dist-packages/alembic/environment.py", line 652, in run_migrations self.get_context().run_migrations(**kw) File "/usr/lib/python2.7/dist-packages/alembic/migration.py", line 225, in run_migrations change(**kw) File "config/versions/581a4264e537_adding_extensions.py", line 45, in upgrade sa.Column('appdata', sa.String(256), nullable=False), File "<string>", line 7, in create_table File "/usr/lib/python2.7/dist-packages/alembic/operations.py", line 647, in create_table self._table(name, *columns, **kw) File "/usr/lib/python2.7/dist-packages/alembic/ddl/impl.py", line 149, in create_table self._exec(schema.CreateTable(table)) File "/usr/lib/python2.7/dist-packages/alembic/ddl/impl.py", line 76, in _exec conn.execute(construct, *multiparams, **params) File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 662, in execute params) File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 720, in _execute_ddl compiled File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 874, in _execute_context context) File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1024, in _handle_dbapi_exception exc_info File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 196, in raise_from_cause reraise(type(exception), exception, tb=exc_tb) File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 867, in _execute_context context) File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 324, in do_execute cursor.execute(statement, parameters) File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute self.errorhandler(self, exc, value) File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler raise errorclass, errorvalue sqlalchemy.exc.OperationalError: (OperationalError) (1050, "Table 'extensions' already exists") '\nCREATE TABLE extensions (\n\tid BIGINT NOT NULL AUTO_INCREMENT, \n\tcontext VARCHAR(40) NOT NULL, \n\texten VARCHAR(40) NOT NULL, \n\tpriority INTEGER NOT NULL, \n\tapp VARCHAR(40) NOT NULL, \n\tappdata VARCHAR(256) NOT NULL, \n\tPRIMARY KEY (id, context, exten, priority), \n\tUNIQUE (id)\n)\n\n' ()
Joshua Colp
2015-Sep-24 21:41 UTC
[asterisk-users] problems with PJSIP install on UBUNTU 14.04
On 15-09-24 06:30 PM, Ryan, Travis wrote:> Yes, the schema can change between versions. Following the > instructions on > https://wiki.asterisk.org/wiki/display/AST/Setting+up+PJSIP+Realtime#SettingupPJSIPRealtime-InstallingandUsingAlembic > >will cause alembic to upgrade the tables.> > -- Joshua Colp Digium, Inc. | Senior Software Developer 445 Jan Davis > Drive NW - Huntsville, AL 35806 - US Check us out at: www.digium.com > & www.asterisk.org > > > I'm not a fan of alembic at all, but I'll give it another try. > > One issue I have is I don't want it to make the extensions table, > because I already use that name of table for some proprietary stuff I > use. Right now it's complaining that I already have a table named > that. Any way to exclude that other stuff, and only have it manage > the core sip_devices and PJSIP stuff?No idea, alembic is not something we wrote and I'm not that familiar with it. -- Joshua Colp Digium, Inc. | Senior Software Developer 445 Jan Davis Drive NW - Huntsville, AL 35806 - US Check us out at: www.digium.com & www.asterisk.org