DB config error with Account manager DB

[Mickey Mouse]

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