[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: DB config error with Account manager DB

From: Peio Rigaux
Subject: Re: DB config error with Account manager DB
Date: Wed, 17 Jun 2020 10:26:30 +0200
User-agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Thunderbird/68.6.0


First things first, please make sure that the flexisip_accounts database exists and that mariadb is running.

There is a script to create tables for account manager located in "/opt/belledonne-communications/share/flexisip-account-manager/tools/" by default. Use it if you find no tables in your database.

Your soci request seems also wrong regarding the default schema (no "password" column in account table, you have to join with "passwords" table) . Make sure that the SQL request is working for your schema before defining it in flexisip.conf

Eventually send me your database schema compared to your flexisip.conf file, so I can give you more detailed help.


Peio Rigaux
Junior Software Engineer
Belledonne Communications, the company behind Linphone

Le 16/06/2020 à 23:20, Mickey Mouse a écrit :
Bonjour,  Hi,

I have installed account manager with a new front end interface aswell.  ALl seems working and fine with that.  My problem is when I enter the DB and SOCI info in my current flexisip cluster flexisip.conf file, I then get this error in the logs.

I was expecting this error because im under the impression flexisp is looking for specific colums in traditional db, but account manager db has different colums.

[SOCI] MySQL error after 3ms: 1054 Unknown column 'password' in 'field list' while executing "select passwor                                  d, algorithm from accounts where login = :id and domain = :domain" with :id="chris", :domain="sip.blackcomm.world", :authid="chris".
2020-06-16 17:10:09:024 flexisip-error-[SOCI] Trying close/reconnect session
2020-06-16 17:10:09:032 flexisip-debug-[SOCI] Session mysql successfully reconnected
2020-06-16 17:10:09:032 flexisip-debug-Replying Request SIP message: 500 Internal error


Attachment: 0x99D28356FED78143.asc
Description: application/pgp-keys

Attachment: signature.asc
Description: OpenPGP digital signature

reply via email to

[Prev in Thread] Current Thread [Next in Thread]