openlp-core team mailing list archive

[Tomas Groth <1588811@xxxxxxxxxxxxxxxxxx>]

As you might have guessed I misunderstood part of your report. Since you called the mysql setup your previous setup, I assumed you didn't use mysql anymore.
Anyway, as mentioned OpenLP now uses mysql connector and therefore the db type must be "mysql+mysqlconnector". I hope that will help you.
Which OpenLP version did you use before?

-- 
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