Re: DB config error with Account manager DB

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.

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

Regards,

Chris

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