Dear maddy author, please tell me about the function of batch creating users.

[cplasfwst]

Dear maddy author, please tell me about the function of batch creating users. I currently have a requirement to have the golang program automatically create users. I tried to directly insert the database credentials.db, but the inserted database user could not log in normally. I would like to ask for guidance on how I should do this so that I can automatically generate users without having to manually go to the terminal to create new users.

I inserted this picture using the program, but I can't log in normally

[cplasfwst]

about code: `package main

import ( "crypto/rand" "database/sql" "fmt" "log" "math/big"

_ "github.com/mattn/go-sqlite3"
"golang.org/x/crypto/bcrypt"

)

const ( emailDomain = "@xxxx.org" // 邮箱后缀 numAccounts = 10 // 要生成的账号数量 password = "123456" // 统一密码 dbPath = "credentials.db" // 数据库路径 )

// 生成随机的5位数字用户名 func generateRandomUsername() (string, error) { const digits = "0123456789" length := 5 username := make([]byte, length)

for i := 0; i < length; i++ {
	num, err := rand.Int(rand.Reader, big.NewInt(int64(len(digits))))
	if err != nil {
		return "", err
	}
	username[i] = digits[num.Int64()]
}

return string(username), nil

}

// 生成 bcrypt 哈希密码并添加前缀 func hashPassword(password string) (string, error) { hashedPassword, err := bcrypt.GenerateFromPassword([]byte(password), bcrypt.DefaultCost) if err != nil { return "", err } // 添加 "bcrypt:" 前缀 return "bcrypt:" + string(hashedPassword), nil }

// 添加用户到数据库 func addUser(db *sql.DB, key, value string) error { query := INSERT INTO passwords (key, value) VALUES (?, ?) _, err := db.Exec(query, key, value) return err }

func main() { // 打开数据库连接 db, err := sql.Open("sqlite3", dbPath) if err != nil { log.Fatalf("Failed to open database: %v", err) } defer db.Close()

// 开始生成用户
for i := 0; i < numAccounts; i++ {
	username, err := generateRandomUsername()
	if err != nil {
		log.Printf("Failed to generate username: %v\n", err)
		continue
	}

	email := username + emailDomain // 构造邮箱账号

	hashedPassword, err := hashPassword(password)
	if err != nil {
		log.Printf("Failed to hash password for %s: %v\n", email, err)
		continue
	}

	err = addUser(db, email, hashedPassword)
	if err != nil {
		log.Printf("Failed to add user %s: %v\n", email, err)
	} else {
		fmt.Printf("User %s added successfully\n", email)
	}
}

} `

[hugmouse]

You can do something what I did with the password reset for Maddy specifically: https://github.com/hugmouse/maddy-password-reset/blob/master/main.go#L269

Instead of handling SQL yourself - use CLI that Maddy provides: https://maddy.email/tutorials/setting-up/#user-accounts-and-maddy-command

[foxcpp]

Created a minimal config to test it:

imap tcp://127.0.0.1:4444 {
        auth pass_table sql_table {
                driver sqlite3
                dsn credentials.db
                table_name passwords
        }
        storage imapsql sqlite3 test.db
}

$ sqlite3 credentials.db
sqlite>insert into passwords values ('[email protected]', 'bcrypt:$2a$10$HKhtEhpiroRvtJzcLicGAuRh8pEz6mux4qu6SRHIRsVtM7WgFk/9y');

bcrypt value is of "12345", generated using https://www.bcryptcalculator.com/encode I am able to login to IMAP using [email protected]:12345.