{"action":"created","issue":{"url":"https://api.github.com/repos/MetricsGrimoire/Bicho/issues/157","labels_url":"https://api.github.com/repos/MetricsGrimoire/Bicho/issues/157/labels{/name}","comments_url":"https://api.github.com/repos/MetricsGrimoire/Bicho/issues/157/comments","events_url":"https://api.github.com/repos/MetricsGrimoire/Bicho/issues/157/events","html_url":"https://github.com/MetricsGrimoire/Bicho/issues/157","id":118302711,"number":157,"title":"Can't use non-mysql output database when using jira backend","user":{"login":"benmishkanian","id":6743930,"avatar_url":"https://avatars.githubusercontent.com/u/6743930?v=3","gravatar_id":"","url":"https://api.github.com/users/benmishkanian","html_url":"https://github.com/benmishkanian","followers_url":"https://api.github.com/users/benmishkanian/followers","following_url":"https://api.github.com/users/benmishkanian/following{/other_user}","gists_url":"https://api.github.com/users/benmishkanian/gists{/gist_id}","starred_url":"https://api.github.com/users/benmishkanian/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/benmishkanian/subscriptions","organizations_url":"https://api.github.com/users/benmishkanian/orgs","repos_url":"https://api.github.com/users/benmishkanian/repos","events_url":"https://api.github.com/users/benmishkanian/events{/privacy}","received_events_url":"https://api.github.com/users/benmishkanian/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-11-23T01:01:58Z","updated_at":"2015-11-25T23:53:19Z","closed_at":null,"body":"It seems that when using a JIRA backend, the output database must be MySQL, or else bicho crashes. For example, if I try to use postgresql:\r\n\r\n    bicho --db-user-out=postgresusername --db-password-out=postgrespassword --db-database-out=bicho --db-driver-out=postgresql -d 15 -b jira -u \"https://issues.apache.org/jira/browse/CASSANDRA\" -g\r\n\r\nI get this:\r\n\r\n    Checking URL: https://issues.apache.org\r\n    No account provided.\r\n    DBG: [22/Nov/2015-16:49:58] Bicho object created, options and backend initialized\r\n    Running Bicho with delay of 15 seconds\r\n    No account data provided. Not logged in Jira\r\n    Traceback (most recent call last):\r\n      File \"/home/bmishkan/.local/bin/bicho\", line 25, in <module>\r\n        retval = bicho.main.main()\r\n      File \"/home/bmishkan/.local/lib/python2.7/site-packages/bicho/main.py\", line 56, in main\r\n        backend.run()\r\n      File \"/home/bmishkan/.local/lib/python2.7/site-packages/bicho/backends/jira.py\", line 932, in run\r\n        bugsdb.insert_supported_traker(\"jira\", \"4.1.2\")\r\n    AttributeError: 'NoneType' object has no attribute 'insert_supported_traker'\r\n\r\nbugsdb is initialized by get_database(backend), which only returns something if opts.db_driver_out == \"mysql\". So when a different DB type is chosen, bugsdb is None and causes this crash."},"comment":{"url":"https://api.github.com/repos/MetricsGrimoire/Bicho/issues/comments/159759760","html_url":"https://github.com/MetricsGrimoire/Bicho/issues/157#issuecomment-159759760","issue_url":"https://api.github.com/repos/MetricsGrimoire/Bicho/issues/157","id":159759760,"user":{"login":"jgbarah","id":1039693,"avatar_url":"https://avatars.githubusercontent.com/u/1039693?v=3","gravatar_id":"","url":"https://api.github.com/users/jgbarah","html_url":"https://github.com/jgbarah","followers_url":"https://api.github.com/users/jgbarah/followers","following_url":"https://api.github.com/users/jgbarah/following{/other_user}","gists_url":"https://api.github.com/users/jgbarah/gists{/gist_id}","starred_url":"https://api.github.com/users/jgbarah/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jgbarah/subscriptions","organizations_url":"https://api.github.com/users/jgbarah/orgs","repos_url":"https://api.github.com/users/jgbarah/repos","events_url":"https://api.github.com/users/jgbarah/events{/privacy}","received_events_url":"https://api.github.com/users/jgbarah/received_events","type":"User","site_admin":false},"created_at":"2015-11-25T23:53:19Z","updated_at":"2015-11-25T23:53:19Z","body":"> I think it might be useful for other users if this missing functionality was documented in the project readme, or in the help description of --db-password-out.\r\n\r\nI agree. Right now in README we have:\r\n\r\n> - mysqldb or psycopg2 or pysqlite2 (unstable with PostgreSQL; MySQL is recommended - default engine should be set to MYISAM)\r\n\r\nI suggest that we change this, removing the references to psycopg2 (and maybe pysqlite2) and to PostgreSQL, and include a new text stating that the data is stored only in MySQL.\r\n\r\n@sduenas what do you think? If you agree, I can do the change."}}