|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.
Junior Software Engineer
Belledonne Communications, the company behind Linphone
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
Description: OpenPGP digital signature
|[Prev in Thread]||Current Thread||[Next in Thread]|