flexisip-account-manager issueshttps://gitlab.linphone.org/BC/public/flexisip-account-manager/-/issues2023-12-11T10:57:41Zhttps://gitlab.linphone.org/BC/public/flexisip-account-manager/-/issues/131Drop the aliases table2023-12-11T10:57:41ZTimothée JaussoinDrop the aliases tableThe aliases table was completely abstracted by the `phone` attribute on the accounts object.
Two Flexisip related queries will be affected by this change.
```sql
soci-users-with-phones-request=
(SELECT username, domain, ''
FROM accoun...The aliases table was completely abstracted by the `phone` attribute on the accounts object.
Two Flexisip related queries will be affected by this change.
```sql
soci-users-with-phones-request=
(SELECT username, domain, ''
FROM accounts
WHERE
(activated = "1" AND username IN (:phones))
) UNION (SELECT ac.username, ac.domain, al.alias
FROM accounts ac, aliases al
WHERE (activated = "1" AND ac.id = al.account_id AND alias in (:phones))
);
soci-user-with-phone-request=
SELECT username
FROM accounts
WHERE activated = "1" AND (username = :phone OR id=(SELECT account_id FROM aliases WHERE alias = :phone));
```1.5Timothée JaussoinTimothée Jaussoinhttps://gitlab.linphone.org/BC/public/flexisip-account-manager/-/issues/69MySQL migration error with 2014_10_12_100000_create_password_resets_table2023-11-13T14:10:08ZTimothée JaussoinMySQL migration error with 2014_10_12_100000_create_password_resets_table```
2014_10_12_100000_create_password_resets_table
SQLSTATE[HY000]: General error: 3750 Unable to create or change a table without a primary key, when the system variable 'sql_require_primary_key' is set. Add a primary key to the table o...```
2014_10_12_100000_create_password_resets_table
SQLSTATE[HY000]: General error: 3750 Unable to create or change a table without a primary key, when the system variable 'sql_require_primary_key' is set. Add a primary key to the table or unset this variable to avoid this message. Note that tables without a primary key can cause performance problems in row-based replication, so please consult your DBA before changing this setting.
```
See https://github.com/BookStackApp/BookStack/issues/30521.5Peio RigauxPeio Rigauxhttps://gitlab.linphone.org/BC/public/flexisip-account-manager/-/issues/27Migrate and re-organize the database2023-11-13T14:10:08ZTimothée JaussoinMigrate and re-organize the database- Merge the admins table in accounts
- Merge the activation_expirations in accounts
- Drop the domain column from aliases
- Merge the email_changed table in accounts
- Merge the phone_change_code table in accounts- Merge the admins table in accounts
- Merge the activation_expirations in accounts
- Drop the domain column from aliases
- Merge the email_changed table in accounts
- Merge the phone_change_code table in accounts1.5Timothée JaussoinTimothée Jaussoinhttps://gitlab.linphone.org/BC/public/flexisip-account-manager/-/issues/53Implement external-account-creation-token2023-11-13T14:10:08ZTimothée JaussoinImplement external-account-creation-tokenExternal applications would like to track the registration of a new user made on the FAM platform.
To do so the application could create a token and follow the account creation process from it.
## New endpoints
`POST /external_account_...External applications would like to track the registration of a new user made on the FAM platform.
To do so the application could create a token and follow the account creation process from it.
## New endpoints
`POST /external_account_creation_token (public)`
This endpoint will create an EACT in the DB, the token will expire in a short time-frame if not used (~10min)
`GET /external_account_creation_token/{token} (public)`
Retrieve the token current state, the application can request this endpoint each few seconds until the account is properly registered. Once this is done the endpoint will return a `provisioning_token`.
## Adjustments in FlexiAPI Web interface
The registration process will now accept a EACT as a URL parameter. If an account is successfully registered to it and if the EACT is valid the account will then be linked to the token allowing the app to know that the flow has been successfull.1.5Timothée JaussoinTimothée Jaussoinhttps://gitlab.linphone.org/BC/public/flexisip-account-manager/-/issues/71storage/ directory rights not corretly setup in the packages2023-11-13T14:10:08ZTimothée Jaussoinstorage/ directory rights not corretly setup in the packagesIt seems that the `storage/` directory is still created as root:root, should be www-data/apache
Complete path is `/opt/belledonne-communications/share/flexisip-account-manager/flexiapi/storage` (it's a symbolic link)It seems that the `storage/` directory is still created as root:root, should be www-data/apache
Complete path is `/opt/belledonne-communications/share/flexisip-account-manager/flexiapi/storage` (it's a symbolic link)1.5Timothée JaussoinTimothée Jaussoinhttps://gitlab.linphone.org/BC/public/flexisip-account-manager/-/issues/112Setup the Apache config at the root of the subdomain2023-11-13T14:10:07ZTimothée JaussoinSetup the Apache config at the root of the subdomainDiscuss about it and propose some configuration changesDiscuss about it and propose some configuration changes1.5Timothée JaussoinTimothée Jaussoin