starred/modoboa-modoboa
1
0
Fork 0
mirror of https://github.com/modoboa/modoboa.git synced 2026-04-26 17:36:01 +03:00
Code Issues 60 Projects Releases 10 Packages Wiki Activity

[GH-ISSUE #1396] Create / update core database #1109

New issue
Closed
opened 2026-02-27 11:15:20 +03:00 by kerem · 2 comments
kerem commented 2026-02-27 11:15:20 +03:00
Owner
Copy link

Originally created by @mkkeck on GitHub (Feb 15, 2018).
Original GitHub issue: https://github.com/modoboa/modoboa/issues/1396

How can I create, alter , update or re-init the Modoboa core database? Some thing goes wrong after re-install, and I've not a current sql-dump file. Is there a mysql-dump file available?

Impacted versions

  • Modoboa: 1.10.2 (upgraded from 1.9.x)
  • installer used: Yes
  • webserver: Apache
  • database: MariaDB 10.2.13 running on localhost

Behavior

E.g.: I can not update domains

DoesNotExist at /admin/domains/3/edit/
Users matching query does not exist.

Request Method: POST
Request URL: https://example.com/modoboa/admin/domains/3/edit/
Django Version: 1.11.10
Python Executable: /usr/bin/python
Python Version: 2.7.5
Python Path: ['/var/www/admin/modoboa/instance', '/var/www/admin/modoboa/env/lib/python2.7/site-packages', '/usr/lib64/python27.zip', '/usr/lib64/python2.7', '/usr/lib64/python2.7/plat-linux2', '/usr/lib64/python2.7/lib-tk', '/usr/lib64/python2.7/lib-old', '/usr/lib64/python2.7/lib-dynload', '/usr/lib64/python2.7/site-packages', '/usr/lib/python2.7/site-packages', '/var/www/admin/modoboa/instance/instance', '/var/www/admin/modoboa/instance']
Server time: Fr, 16 Feb 2018 08:11:41 +0100

Traceback:

File "/var/www/admin/modoboa/env/lib/python2.7/site-packages/django/core/handlers/exception.py" in inner
  41.             response = get_response(request)

File "/var/www/admin/modoboa/env/lib/python2.7/site-packages/django/core/handlers/base.py" in _get_response
  187.                 response = self.process_exception_by_middleware(e, request)

File "/var/www/admin/modoboa/env/lib/python2.7/site-packages/django/core/handlers/base.py" in _get_response
  185.                 response = wrapped_callback(request, *callback_args, **callback_kwargs)

File "/var/www/admin/modoboa/env/lib/python2.7/site-packages/django/utils/decorators.py" in inner
  185.                     return func(*args, **kwargs)

File "/var/www/admin/modoboa/env/lib/python2.7/site-packages/django/utils/decorators.py" in inner
  185.                     return func(*args, **kwargs)

File "/var/www/admin/modoboa/env/lib/python2.7/site-packages/django/contrib/auth/decorators.py" in _wrapped_view
  23.                 return view_func(request, *args, **kwargs)

File "/var/www/admin/modoboa/env/lib/python2.7/site-packages/django/contrib/auth/decorators.py" in _wrapped_view
  23.                 return view_func(request, *args, **kwargs)

File "/var/www/admin/modoboa/env/lib/python2.7/site-packages/reversion/revisions.py" in do_revision_context
  323.                 return func(*args, **kwargs)

File "/var/www/admin/modoboa/env/lib/python2.7/site-packages/modoboa/admin/views/domain.py" in editdomain
  170.     return DomainForm(request, instances=instances).process()

File "/var/www/admin/modoboa/env/lib/python2.7/site-packages/modoboa/lib/form_utils.py" in process
  348.                 self.save()

File "/var/www/admin/modoboa/env/lib/python2.7/site-packages/modoboa/admin/forms/domain.py" in save
  397.             f["instance"].save(self.request.user, **options)

File "/var/www/admin/modoboa/env/lib/python2.7/site-packages/modoboa_amavis/forms.py" in save
  66.                 u = Users.objects.get(email="@%s" % self.domain.name)

File "/var/www/admin/modoboa/env/lib/python2.7/site-packages/django/db/models/manager.py" in manager_method
  85.                 return getattr(self.get_queryset(), name)(*args, **kwargs)

File "/var/www/admin/modoboa/env/lib/python2.7/site-packages/django/db/models/query.py" in get
  380.                 self.model._meta.object_name

Exception Type: DoesNotExist at /admin/domains/3/edit/
Exception Value: Users matching query does not exist.

Many thanks :)

Originally created by @mkkeck on GitHub (Feb 15, 2018). Original GitHub issue: https://github.com/modoboa/modoboa/issues/1396 How can I `create`, `alter` , `update` or `re-init` the _Modoboa core database_? Some thing goes wrong after re-install, and I've not a current sql-dump file. Is there a _mysql-dump file_ available? #### Impacted versions * Modoboa: 1.10.2 (upgraded from 1.9.x) * installer used: Yes * webserver: Apache * database: MariaDB 10.2.13 running on `localhost` #### Behavior E.g.: I can not update domains ``` DoesNotExist at /admin/domains/3/edit/ Users matching query does not exist. Request Method: POST Request URL: https://example.com/modoboa/admin/domains/3/edit/ Django Version: 1.11.10 Python Executable: /usr/bin/python Python Version: 2.7.5 Python Path: ['/var/www/admin/modoboa/instance', '/var/www/admin/modoboa/env/lib/python2.7/site-packages', '/usr/lib64/python27.zip', '/usr/lib64/python2.7', '/usr/lib64/python2.7/plat-linux2', '/usr/lib64/python2.7/lib-tk', '/usr/lib64/python2.7/lib-old', '/usr/lib64/python2.7/lib-dynload', '/usr/lib64/python2.7/site-packages', '/usr/lib/python2.7/site-packages', '/var/www/admin/modoboa/instance/instance', '/var/www/admin/modoboa/instance'] Server time: Fr, 16 Feb 2018 08:11:41 +0100 ``` #### Traceback: ``` File "/var/www/admin/modoboa/env/lib/python2.7/site-packages/django/core/handlers/exception.py" in inner 41. response = get_response(request) File "/var/www/admin/modoboa/env/lib/python2.7/site-packages/django/core/handlers/base.py" in _get_response 187. response = self.process_exception_by_middleware(e, request) File "/var/www/admin/modoboa/env/lib/python2.7/site-packages/django/core/handlers/base.py" in _get_response 185. response = wrapped_callback(request, *callback_args, **callback_kwargs) File "/var/www/admin/modoboa/env/lib/python2.7/site-packages/django/utils/decorators.py" in inner 185. return func(*args, **kwargs) File "/var/www/admin/modoboa/env/lib/python2.7/site-packages/django/utils/decorators.py" in inner 185. return func(*args, **kwargs) File "/var/www/admin/modoboa/env/lib/python2.7/site-packages/django/contrib/auth/decorators.py" in _wrapped_view 23. return view_func(request, *args, **kwargs) File "/var/www/admin/modoboa/env/lib/python2.7/site-packages/django/contrib/auth/decorators.py" in _wrapped_view 23. return view_func(request, *args, **kwargs) File "/var/www/admin/modoboa/env/lib/python2.7/site-packages/reversion/revisions.py" in do_revision_context 323. return func(*args, **kwargs) File "/var/www/admin/modoboa/env/lib/python2.7/site-packages/modoboa/admin/views/domain.py" in editdomain 170. return DomainForm(request, instances=instances).process() File "/var/www/admin/modoboa/env/lib/python2.7/site-packages/modoboa/lib/form_utils.py" in process 348. self.save() File "/var/www/admin/modoboa/env/lib/python2.7/site-packages/modoboa/admin/forms/domain.py" in save 397. f["instance"].save(self.request.user, **options) File "/var/www/admin/modoboa/env/lib/python2.7/site-packages/modoboa_amavis/forms.py" in save 66. u = Users.objects.get(email="@%s" % self.domain.name) File "/var/www/admin/modoboa/env/lib/python2.7/site-packages/django/db/models/manager.py" in manager_method 85. return getattr(self.get_queryset(), name)(*args, **kwargs) File "/var/www/admin/modoboa/env/lib/python2.7/site-packages/django/db/models/query.py" in get 380. self.model._meta.object_name Exception Type: DoesNotExist at /admin/domains/3/edit/ Exception Value: Users matching query does not exist. ``` Many thanks :)
kerem closed this issue 2026-02-27 11:15:20 +03:00
kerem commented 2026-02-27 11:15:20 +03:00
Author
Owner
Copy link

@tonioo commented on GitHub (Mar 2, 2018):

@mkkeck The problem is not with your modoboa database but with the amavis one. Looks like some records are missing... Can you check if a record exists in the users table (amavis database) for the domain you're trying to update?

<!-- gh-comment-id:369846300 --> @tonioo commented on GitHub (Mar 2, 2018): @mkkeck The problem is not with your modoboa database but with the amavis one. Looks like some records are missing... Can you check if a record exists in the ``users`` table (amavis database) for the domain you're trying to update?
kerem commented 2026-02-27 11:15:20 +03:00
Author
Owner
Copy link

@mkkeck commented on GitHub (Mar 7, 2018):

That's it.
Many thanks.

<!-- gh-comment-id:371047424 --> @mkkeck commented on GitHub (Mar 7, 2018): That's it. Many thanks.
Sign in to join this conversation.
No Branch/Tag specified
Branches Tags
master
fix/sievefilters-allow-email-in-rule-name
dependabot/npm_and_yarn/frontend/axios-1.15.0
translations_04c0b653215cb5fa48ab101eae1a1917_ja_JP
translations_5d93982e9fd6dab991db4faf93ce9ded_ja_JP
fix/login-issue-3995
fix/sievefilters-issues
add-vitepress-openapi
2974-dmarc-empty-email
2.3.x
updated-doc-2.3.0
feature/OIDC
delete-all-alarms
translations_modoboa-admin-locale-en-lc-messages-djangojs-po--master_af_ZA
translations_modoboa-admin-locale-en-lc-messages-djangojs-po--master_ar
translations_modoboa-admin-locale-en-lc-messages-djangojs-po--master_ca
1.x
translations_modoboa-admin-locale-en-lc-messages-djangojs-po--master_sk
translations_modoboa-admin-locale-en-lc-messages-djangojs-po--master_tr
translations_modoboa-admin-locale-en-lc-messages-djangojs-po--master_es_ES
translations_modoboa-admin-locale-en-lc-messages-djangojs-po--master_uk
translations_modoboa-admin-locale-en-lc-messages-djangojs-po--master_zh_CN
translations_modoboa-admin-locale-en-lc-messages-djangojs-po--master_de_DE
translations_modoboa-admin-locale-en-lc-messages-djangojs-po--master_da_DK
1.8.x
1.7.x
1.6.x
1.4.x
1.3.x
1.2.x
2.8.2
2.8.1
2.8.0
2.7.2
2.7.1
2.7.0
2.6.5
2.6.4
2.6.3
2.6.2
2.6.1
2.6.0
2.5.1
2.5.0
2.4.11
2.4.10
2.4.9
2.4.8
2.4.7
2.4.6
2.4.5
2.4.4
2.4.3
2.4.2
2.4.1
2.4.0
2.3.6
2.3.5
2.3.4
2.3.3
2.3.2
2.3.1
2.3.0
2.3.0-beta.4
2.3.0-beta.3
2.3.0-beta.2
2.3.0-beta.1
2.2.4
2.2.3
2.2.2
2.2.1
2.2.0
2.1.2
2.1.1
2.1.0
2.0.5
2.0.4
2.0.3
2.0.2
2.0.1
2.0.0
2.0.0-beta.3
2.0.0-beta.2
2.0.0-beta.1
1.17.0
1.16.1
1.16.0
1.15.0
1.14.0
1.13.1
1.13.0
1.12.2
1.12.1
1.12.0
1.11.1
1.11.0
1.10.7
1.10.6
1.10.5
1.10.4
1.10.3
1.10.2
1.10.1
1.10.0
1.9.1
1.9.0
1.8.3
1.8.2
1.8.1
1.8.0
1.7.4
1.7.3
1.7.2
1.7.1
1.7.0
1.6.3
1.6.2
1.6.1
1.6.0
1.5.3
1.5.2
1.5.1
1.5.0
1.4.5
1.4.4
1.4.3
1.4.2
1.4.1
1.4.0
1.3.5
1.3.4
1.2.2
1.3.3
1.3.2
1.3.1
1.3.0
1.2.1
1.2.0
1.2.0-rc2
1.2.0-rc1
1.1.7
1.1.6
1.1.5
1.1.4
1.1.3
1.1.2
1.1.1
1.1.0
1.0.1
1.0.0
0.9.5
0.9.4
0.9.3
0.9.2
0.9.1
0.9
0.8.8
0.8.7
0.8.6.1
0.8.6
0.8.5
0.8.4
0.8.3
0.8.3-rc1
0.8.2
0.8.1
0.8
0.8-rc2
0.8-rc1
0.7.2
0.7.1
0.7
0.6.1
0.6
0.5
0.3
0.2
0.1
Labels
Clear labels   
bug

   
bug

   
dependencies

   
design

   
documentation

   
duplicate

   
enhancement

   
enhancement

   
enhancement

   
feedback-needed

   
help-needed

   
help-needed

   
installer

   
invalid

   
looking-for-sponsors

   
modoboa-contacts

   
new-ui

   
new-ui

   
pr

   
pull-request

Mirrored from GitHub Pull Request

  
pyconfr

   
python

   
question

   
security

   
stale

   
webmail

   
wontfix
No labels
bug
bug
dependencies
design
documentation
duplicate
enhancement
enhancement
enhancement
feedback-needed
help-needed
help-needed
installer
invalid
looking-for-sponsors
modoboa-contacts
new-ui
new-ui
pr
pull-request
pyconfr
python
question
security
stale
webmail
wontfix
Milestone
Clear milestone
No items
No milestone
Projects
Clear projects
No items
No project
Assignees
Clear assignees
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
starred/modoboa-modoboa#1109
No description provided.