1 Topic by fbesnard

  • fbesnard
  • Member
  • Offline
  • Registered: 2023-06-22
  • Posts: 2

Topic: vmail Databases not found

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 1.6.3
- Deployed with iRedMail Easy or the downloadable installer? : downloadable installer
- Linux/BSD distribution name and version: Ubuntu Server 22.04
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MariaDB
- Web server (Apache or Nginx): Nginx
- Manage mail accounts with iRedAdmin-Pro?
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

Hello,

I need to mass create mail accounts in the SQL database. I was able to generate the sql file with the script provided in "tools". But when I connect to MySQL to import into Vmail, the database is not found (see attached screenshot). I specify that I am installing Iredmail with the default settings.
Manually created user mailboxes work fine.
Can you help me please? THANKS.

Post's attachments

sql-databases-iredmail.png 212.09 kb, file has never been downloaded. 

You don't have the permssions to download the attachments of this post.

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by dave.opc

  • dave.opc
  • Member
  • Offline
  • Registered: 2019-07-08
  • Posts: 103

Re: vmail Databases not found

guess you need to create at least 1 domain so vmail is created

3 Reply by Cthulhu (edited by Cthulhu 2023-06-23 00:01:44)

  • Cthulhu
  • Member
  • Offline
  • Registered: 2019-06-04
  • Posts: 907

Re: vmail Databases not found

when was the last time vmail database was taken a sucessfull backup of?
you get daily mail from the script

edit: the database is created on installation, it must be there or something went horribly wrong

4 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,082

Re: vmail Databases not found

Did you install iRedMail with OpenLDAP backend?

5 Reply by fbesnard

  • fbesnard
  • Member
  • Offline
  • Registered: 2023-06-22
  • Posts: 2

Re: vmail Databases not found

ZhangHuangbin wrote:

Did you install iRedMail with OpenLDAP backend?

I did the default install but it actually looks like I have LDAP enabled.
In the "tips" file I have lots of LDAP configuration elements

6 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,082

Re: vmail Databases not found

LDAP backend doesn't have SQL database "vmail" at all. You have to re-install iRedMail with a SQL backend.