{"action":"created","issue":{"url":"https://api.github.com/repos/modoboa/modoboa/issues/1255","repository_url":"https://api.github.com/repos/modoboa/modoboa","labels_url":"https://api.github.com/repos/modoboa/modoboa/issues/1255/labels{/name}","comments_url":"https://api.github.com/repos/modoboa/modoboa/issues/1255/comments","events_url":"https://api.github.com/repos/modoboa/modoboa/issues/1255/events","html_url":"https://github.com/modoboa/modoboa/issues/1255","id":261356087,"number":1255,"title":"Need to re-create modoboa's database","user":{"login":"sorcer1122","id":15838362,"avatar_url":"https://avatars1.githubusercontent.com/u/15838362?v=4","gravatar_id":"","url":"https://api.github.com/users/sorcer1122","html_url":"https://github.com/sorcer1122","followers_url":"https://api.github.com/users/sorcer1122/followers","following_url":"https://api.github.com/users/sorcer1122/following{/other_user}","gists_url":"https://api.github.com/users/sorcer1122/gists{/gist_id}","starred_url":"https://api.github.com/users/sorcer1122/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sorcer1122/subscriptions","organizations_url":"https://api.github.com/users/sorcer1122/orgs","repos_url":"https://api.github.com/users/sorcer1122/repos","events_url":"https://api.github.com/users/sorcer1122/events{/privacy}","received_events_url":"https://api.github.com/users/sorcer1122/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2017-09-28T15:13:08Z","updated_at":"2017-09-29T07:49:55Z","closed_at":null,"author_association":"NONE","body":"Hello,\r\n\r\nI was trying to install afterlogic webmail frontend but it messed up my MariaDB and I ended up loosing modoboa's database before I made a backup. So, I would appreciate if anyone could help me to recreate the database again. I have created a user already, created a DB, granted this user rights over the DB and now I am getting the following in postfix log:\r\n\r\nwarning: mysql query failed: Table 'modoboa.admin_domain' doesn't exist\r\n\r\nWhen I try to create this table, it asks me about columns and I have no idea how many columns I need.\r\n\r\nThanks in advance!"},"comment":{"url":"https://api.github.com/repos/modoboa/modoboa/issues/comments/333056913","html_url":"https://github.com/modoboa/modoboa/issues/1255#issuecomment-333056913","issue_url":"https://api.github.com/repos/modoboa/modoboa/issues/1255","id":333056913,"user":{"login":"sorcer1122","id":15838362,"avatar_url":"https://avatars1.githubusercontent.com/u/15838362?v=4","gravatar_id":"","url":"https://api.github.com/users/sorcer1122","html_url":"https://github.com/sorcer1122","followers_url":"https://api.github.com/users/sorcer1122/followers","following_url":"https://api.github.com/users/sorcer1122/following{/other_user}","gists_url":"https://api.github.com/users/sorcer1122/gists{/gist_id}","starred_url":"https://api.github.com/users/sorcer1122/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sorcer1122/subscriptions","organizations_url":"https://api.github.com/users/sorcer1122/orgs","repos_url":"https://api.github.com/users/sorcer1122/repos","events_url":"https://api.github.com/users/sorcer1122/events{/privacy}","received_events_url":"https://api.github.com/users/sorcer1122/received_events","type":"User","site_admin":false},"created_at":"2017-09-29T07:49:55Z","updated_at":"2017-09-29T07:49:55Z","author_association":"NONE","body":"@tonioo Thanks!\r\n\r\n**python manage.py migrate** gives me\r\nOperations to perform:\r\n  Apply all migrations: admin, auth, authtoken, contenttypes, core, lib, limits, modoboa_amavis, modoboa_contacts, modoboa_postfix_autoreply, relaydomains, reversion, sessions, sites\r\nRunning migrations:\r\n  No migrations to apply.\r\n\r\n**python manage.py load_initial_data** gives no output\r\n\r\n**python manage.py set_default_site mydomain.com** gives no output\r\n\r\nHowever, it did not help. So, I dropped DB, recreated it and gave permissions:\r\n\r\n+------------------------------------------------------------------------+\r\n| Grants for modoboa@%                                                   |\r\n+------------------------------------------------------------------------+\r\n| GRANT USAGE ON *.* TO 'modoboa'@'%'                                    |\r\n| GRANT ALL PRIVILEGES ON `modoboa`.* TO 'modoboa'@'%' WITH GRANT OPTION |\r\n+------------------------------------------------------------------------+\r\n\r\nHowever, it still does not work, here is what I see in DB:\r\n\r\nMariaDB [modoboa]> show tables;\r\nEmpty set (0.00 sec)\r\n\r\nAny ideas?\r\n\r\n"}}
{"actor":{"display_login":"sorcer1122"}}