← Back to team overview

openlp-core team mailing list archive

[Bug 1588811] Re: First-run crash, Ubuntu 16.04

 

$ diff control control-with-pymsql
32a33
>  python3-pymysql,


** Description changed:

  Can't commit - no permission. So...
  
  ------------------------------------------------------------
  revno: 75
- committer: dave.bevan@xxxxxxxxx
+ committer: <hidden>
  branch nick: debian-package
  timestamp: Fri 2016-06-03 13:33:52 +0100
  message:
-   Installation/runtime bug found on Ubuntu 16.04. While openlp depends on python3-sqlalchemy, python3-sqlalchemy only /suggests/ python3-pymysql.
-   
-   Since you expressly require MySQL support (I had a first-run crash - see below), my fix below expressly adds the pymysql package as a depends in openlp rather than accepting the sqlalchemy, more relaxed, suggests.
-   
-   I was able to debug as I'm an experience linux dev and packager. It's my expectation that many less experienced (perhaps not professional Linux) users wouldn't have a clue.
-   
-   ===============================================
-   
-   
-   **OpenLP Bug Report**
-   Version: {'build': None, 'version': '2.4', 'full': '2.4'}
-   
-   --- Details of the Exception. ---
-   
-   Initial start of OpenLP 2.4-1 on a system that had a previous install.
-   
-   The previous install was configured to use MySQL as it's backing database (we have a network MySQL server install at our church which has a separate web front-end that all
+   Installation/runtime bug found on Ubuntu 16.04. While openlp depends on python3-sqlalchemy, python3-sqlalchemy only /suggests/ python3-pymysql.
+ 
+   Since you expressly require MySQL support (I had a first-run crash -
+ see below), my fix below expressly adds the pymysql package as a depends
+ in openlp rather than accepting the sqlalchemy, more relaxed, suggests.
+ 
+   I was able to debug as I'm an experience linux dev and packager. It's
+ my expectation that many less experienced (perhaps not professional
+ Linux) users wouldn't have a clue.
+ 
+   ===============================================
+ 
+   **OpenLP Bug Report**
+   Version: {'build': None, 'version': '2.4', 'full': '2.4'}
+ 
+   --- Details of the Exception. ---
+ 
+   Initial start of OpenLP 2.4-1 on a system that had a previous install.
+ 
+   The previous install was configured to use MySQL as it's backing database (we have a network MySQL server install at our church which has a separate web front-end that all
  ow
-   s worship planners to search the OpenLP song database for content).
-   
-    --- Exception Traceback ---
-   Traceback (most recent call last):
-     File "/usr/bin/openlp", line 44, in <module>
-       main()
-     File "/usr/share/openlp/openlp/core/__init__.py", line 391, in main
-       sys.exit(application.run(qt_args))
-     File "/usr/share/openlp/openlp/core/__init__.py", line 142, in run
-       Registry().execute('bootstrap_initialise')
-     File "/usr/share/openlp/openlp/core/common/registry.py", line 137, in execute
-       result = function(*args, **kwargs)
-     File "/usr/share/openlp/openlp/core/lib/pluginmanager.py", line 54, in bootstrap_initialise
-       self.find_plugins()
-     File "/usr/share/openlp/openlp/core/lib/pluginmanager.py", line 102, in find_plugins
-       plugin = p()
-     File "/usr/share/openlp/openlp/plugins/songs/songsplugin.py", line 84, in __init__
-       self.manager = Manager('songs', init_schema, upgrade_mod=upgrade)
-     File "/usr/share/openlp/openlp/core/lib/db.py", line 238, in __init__
-       db_ver, up_ver = upgrade_db(self.db_url, upgrade_mod)
-     File "/usr/share/openlp/openlp/core/lib/db.py", line 130, in upgrade_db
-       session, metadata = init_db(url)
-     File "/usr/share/openlp/openlp/core/lib/db.py", line 53, in init_db
-       engine = create_engine(url, poolclass=NullPool)
-     File "/usr/lib/python3/dist-packages/sqlalchemy/engine/__init__.py", line 386, in create_engine
-       return strategy.create(*args, **kwargs)
-     File "/usr/lib/python3/dist-packages/sqlalchemy/engine/strategies.py", line 75, in create
-       dbapi = dialect_cls.dbapi(**dbapi_args)
-     File "/usr/lib/python3/dist-packages/sqlalchemy/dialects/mysql/pymysql.py", line 49, in dbapi
-       return __import__('pymysql')
-     File "/usr/lib/python3/dist-packages/uno.py", line 268, in _uno_import
-       return _g_delegatee( name, *optargs, **kwargs )
-   ImportError: No module named 'pymysql'
-   
-   --- System information ---
-   Platform: Linux-4.4.0-22-generic-x86_64-with-Ubuntu-16.04-xenial
-   Desktop: GNOME
-   
-   --- Library Versions ---
-   Python: 3.5.1+
-   Qt5: 5.5.1
-   PyQt5: 5.5.1
-   QtWebkit: 538.1
-   SQLAlchemy: 1.0.11
-   SQLAlchemy Migrate: -
-   BeautifulSoup: 4.4.1
-   lxml: 3.5.0
-   Chardet: 2.3.0
-   PyEnchant: 1.6.6
-   Mako: 1.0.3
-   pyICU: -
-   pyUNO bridge: 5.1
-   VLC: -
+   s worship planners to search the OpenLP song database for content).
+ 
+    --- Exception Traceback ---
+   Traceback (most recent call last):
+     File "/usr/bin/openlp", line 44, in <module>
+       main()
+     File "/usr/share/openlp/openlp/core/__init__.py", line 391, in main
+       sys.exit(application.run(qt_args))
+     File "/usr/share/openlp/openlp/core/__init__.py", line 142, in run
+       Registry().execute('bootstrap_initialise')
+     File "/usr/share/openlp/openlp/core/common/registry.py", line 137, in execute
+       result = function(*args, **kwargs)
+     File "/usr/share/openlp/openlp/core/lib/pluginmanager.py", line 54, in bootstrap_initialise
+       self.find_plugins()
+     File "/usr/share/openlp/openlp/core/lib/pluginmanager.py", line 102, in find_plugins
+       plugin = p()
+     File "/usr/share/openlp/openlp/plugins/songs/songsplugin.py", line 84, in __init__
+       self.manager = Manager('songs', init_schema, upgrade_mod=upgrade)
+     File "/usr/share/openlp/openlp/core/lib/db.py", line 238, in __init__
+       db_ver, up_ver = upgrade_db(self.db_url, upgrade_mod)
+     File "/usr/share/openlp/openlp/core/lib/db.py", line 130, in upgrade_db
+       session, metadata = init_db(url)
+     File "/usr/share/openlp/openlp/core/lib/db.py", line 53, in init_db
+       engine = create_engine(url, poolclass=NullPool)
+     File "/usr/lib/python3/dist-packages/sqlalchemy/engine/__init__.py", line 386, in create_engine
+       return strategy.create(*args, **kwargs)
+     File "/usr/lib/python3/dist-packages/sqlalchemy/engine/strategies.py", line 75, in create
+       dbapi = dialect_cls.dbapi(**dbapi_args)
+     File "/usr/lib/python3/dist-packages/sqlalchemy/dialects/mysql/pymysql.py", line 49, in dbapi
+       return __import__('pymysql')
+     File "/usr/lib/python3/dist-packages/uno.py", line 268, in _uno_import
+       return _g_delegatee( name, *optargs, **kwargs )
+   ImportError: No module named 'pymysql'
+ 
+   --- System information ---
+   Platform: Linux-4.4.0-22-generic-x86_64-with-Ubuntu-16.04-xenial
+   Desktop: GNOME
+ 
+   --- Library Versions ---
+   Python: 3.5.1+
+   Qt5: 5.5.1
+   PyQt5: 5.5.1
+   QtWebkit: 538.1
+   SQLAlchemy: 1.0.11
+   SQLAlchemy Migrate: -
+   BeautifulSoup: 4.4.1
+   lxml: 3.5.0
+   Chardet: 2.3.0
+   PyEnchant: 1.6.6
+   Mako: 1.0.3
+   pyICU: -
+   pyUNO bridge: 5.1
+   VLC: -
  ------------------------------------------------------------

** Description changed:

  Can't commit - no permission. So...
  
  ------------------------------------------------------------
  revno: 75
  committer: <hidden>
  branch nick: debian-package
  timestamp: Fri 2016-06-03 13:33:52 +0100
  message:
    Installation/runtime bug found on Ubuntu 16.04. While openlp depends on python3-sqlalchemy, python3-sqlalchemy only /suggests/ python3-pymysql.
  
    Since you expressly require MySQL support (I had a first-run crash -
  see below), my fix below expressly adds the pymysql package as a depends
  in openlp rather than accepting the sqlalchemy, more relaxed, suggests.
  
    I was able to debug as I'm an experience linux dev and packager. It's
  my expectation that many less experienced (perhaps not professional
  Linux) users wouldn't have a clue.
  
    ===============================================
  
    **OpenLP Bug Report**
    Version: {'build': None, 'version': '2.4', 'full': '2.4'}
  
    --- Details of the Exception. ---
  
+ First-run crash. I now know that prior MySQL use was not the factor in
+ this crash - it was the missing python3-pymysql dependency.
+ 
+ <PleaseIgnore>
    Initial start of OpenLP 2.4-1 on a system that had a previous install.
  
    The previous install was configured to use MySQL as it's backing database (we have a network MySQL server install at our church which has a separate web front-end that all
- ow
-   s worship planners to search the OpenLP song database for content).
+ ows worship planners to search the OpenLP song database for content).
+ </PleaseIgnore>
  
     --- Exception Traceback ---
    Traceback (most recent call last):
      File "/usr/bin/openlp", line 44, in <module>
        main()
      File "/usr/share/openlp/openlp/core/__init__.py", line 391, in main
        sys.exit(application.run(qt_args))
      File "/usr/share/openlp/openlp/core/__init__.py", line 142, in run
        Registry().execute('bootstrap_initialise')
      File "/usr/share/openlp/openlp/core/common/registry.py", line 137, in execute
        result = function(*args, **kwargs)
      File "/usr/share/openlp/openlp/core/lib/pluginmanager.py", line 54, in bootstrap_initialise
        self.find_plugins()
      File "/usr/share/openlp/openlp/core/lib/pluginmanager.py", line 102, in find_plugins
        plugin = p()
      File "/usr/share/openlp/openlp/plugins/songs/songsplugin.py", line 84, in __init__
        self.manager = Manager('songs', init_schema, upgrade_mod=upgrade)
      File "/usr/share/openlp/openlp/core/lib/db.py", line 238, in __init__
        db_ver, up_ver = upgrade_db(self.db_url, upgrade_mod)
      File "/usr/share/openlp/openlp/core/lib/db.py", line 130, in upgrade_db
        session, metadata = init_db(url)
      File "/usr/share/openlp/openlp/core/lib/db.py", line 53, in init_db
        engine = create_engine(url, poolclass=NullPool)
      File "/usr/lib/python3/dist-packages/sqlalchemy/engine/__init__.py", line 386, in create_engine
        return strategy.create(*args, **kwargs)
      File "/usr/lib/python3/dist-packages/sqlalchemy/engine/strategies.py", line 75, in create
        dbapi = dialect_cls.dbapi(**dbapi_args)
      File "/usr/lib/python3/dist-packages/sqlalchemy/dialects/mysql/pymysql.py", line 49, in dbapi
        return __import__('pymysql')
      File "/usr/lib/python3/dist-packages/uno.py", line 268, in _uno_import
        return _g_delegatee( name, *optargs, **kwargs )
    ImportError: No module named 'pymysql'
  
    --- System information ---
    Platform: Linux-4.4.0-22-generic-x86_64-with-Ubuntu-16.04-xenial
    Desktop: GNOME
  
    --- Library Versions ---
    Python: 3.5.1+
    Qt5: 5.5.1
    PyQt5: 5.5.1
    QtWebkit: 538.1
    SQLAlchemy: 1.0.11
    SQLAlchemy Migrate: -
    BeautifulSoup: 4.4.1
    lxml: 3.5.0
    Chardet: 2.3.0
    PyEnchant: 1.6.6
    Mako: 1.0.3
    pyICU: -
    pyUNO bridge: 5.1
    VLC: -
  ------------------------------------------------------------

-- 
You received this bug notification because you are a member of OpenLP
Core, which is subscribed to OpenLP.
https://bugs.launchpad.net/bugs/1588811

Title:
  First-run crash, Ubuntu 16.04

Status in OpenLP:
  New

Bug description:
  Can't commit - no permission. So...

  ------------------------------------------------------------
  revno: 75
  committer: <hidden>
  branch nick: debian-package
  timestamp: Fri 2016-06-03 13:33:52 +0100
  message:
    Installation/runtime bug found on Ubuntu 16.04. While openlp depends on python3-sqlalchemy, python3-sqlalchemy only /suggests/ python3-pymysql.

    Since you expressly require MySQL support (I had a first-run crash -
  see below), my fix below expressly adds the pymysql package as a
  depends in openlp rather than accepting the sqlalchemy, more relaxed,
  suggests.

    I was able to debug as I'm an experience linux dev and packager.
  It's my expectation that many less experienced (perhaps not
  professional Linux) users wouldn't have a clue.

    ===============================================

    **OpenLP Bug Report**
    Version: {'build': None, 'version': '2.4', 'full': '2.4'}

    --- Details of the Exception. ---

  First-run crash. I now know that prior MySQL use was not the factor in
  this crash - it was the missing python3-pymysql dependency.

  <PleaseIgnore>
    Initial start of OpenLP 2.4-1 on a system that had a previous install.

    The previous install was configured to use MySQL as it's backing database (we have a network MySQL server install at our church which has a separate web front-end that all
  ows worship planners to search the OpenLP song database for content).
  </PleaseIgnore>

     --- Exception Traceback ---
    Traceback (most recent call last):
      File "/usr/bin/openlp", line 44, in <module>
        main()
      File "/usr/share/openlp/openlp/core/__init__.py", line 391, in main
        sys.exit(application.run(qt_args))
      File "/usr/share/openlp/openlp/core/__init__.py", line 142, in run
        Registry().execute('bootstrap_initialise')
      File "/usr/share/openlp/openlp/core/common/registry.py", line 137, in execute
        result = function(*args, **kwargs)
      File "/usr/share/openlp/openlp/core/lib/pluginmanager.py", line 54, in bootstrap_initialise
        self.find_plugins()
      File "/usr/share/openlp/openlp/core/lib/pluginmanager.py", line 102, in find_plugins
        plugin = p()
      File "/usr/share/openlp/openlp/plugins/songs/songsplugin.py", line 84, in __init__
        self.manager = Manager('songs', init_schema, upgrade_mod=upgrade)
      File "/usr/share/openlp/openlp/core/lib/db.py", line 238, in __init__
        db_ver, up_ver = upgrade_db(self.db_url, upgrade_mod)
      File "/usr/share/openlp/openlp/core/lib/db.py", line 130, in upgrade_db
        session, metadata = init_db(url)
      File "/usr/share/openlp/openlp/core/lib/db.py", line 53, in init_db
        engine = create_engine(url, poolclass=NullPool)
      File "/usr/lib/python3/dist-packages/sqlalchemy/engine/__init__.py", line 386, in create_engine
        return strategy.create(*args, **kwargs)
      File "/usr/lib/python3/dist-packages/sqlalchemy/engine/strategies.py", line 75, in create
        dbapi = dialect_cls.dbapi(**dbapi_args)
      File "/usr/lib/python3/dist-packages/sqlalchemy/dialects/mysql/pymysql.py", line 49, in dbapi
        return __import__('pymysql')
      File "/usr/lib/python3/dist-packages/uno.py", line 268, in _uno_import
        return _g_delegatee( name, *optargs, **kwargs )
    ImportError: No module named 'pymysql'

    --- System information ---
    Platform: Linux-4.4.0-22-generic-x86_64-with-Ubuntu-16.04-xenial
    Desktop: GNOME

    --- Library Versions ---
    Python: 3.5.1+
    Qt5: 5.5.1
    PyQt5: 5.5.1
    QtWebkit: 538.1
    SQLAlchemy: 1.0.11
    SQLAlchemy Migrate: -
    BeautifulSoup: 4.4.1
    lxml: 3.5.0
    Chardet: 2.3.0
    PyEnchant: 1.6.6
    Mako: 1.0.3
    pyICU: -
    pyUNO bridge: 5.1
    VLC: -
  ------------------------------------------------------------

To manage notifications about this bug go to:
https://bugs.launchpad.net/openlp/+bug/1588811/+subscriptions


References