[kamailio/kamailio] permissions - database examples in 4.4 for postgresql and mysql is not updated to version 6 (#556)
The database schemas has version 5, the module requires version 6. It seems like the schemas in master is up-to-date
--- You are receiving this because you are subscribed to this thread. Reply to this email directly or view it on GitHub: https://github.com/kamailio/kamailio/issues/556
I guess we need to cherry-pick commit 6b76de9f7d991ed3fdc5f2f28dde7bcb1962108b to 4.4
--- You are receiving this because you are subscribed to this thread. Reply to this email directly or view it on GitHub: https://github.com/kamailio/kamailio/issues/556#issuecomment-203902930
I see it also in branch 4.4, if you refer to sql creating scripts from kamctl/kamdbct. That change was before branching 4.4, iirc.
--- You are receiving this because you are subscribed to this thread. Reply to this email directly or view it on GitHub: https://github.com/kamailio/kamailio/issues/556#issuecomment-203903569
Well, the module requires a database structure that we haven't got in /utils/kamctl :-)
--- You are receiving this because you are subscribed to this thread. Reply to this email directly or view it on GitHub: https://github.com/kamailio/kamailio/issues/556#issuecomment-203905550
This is from branch 4.4:
``` CREATE TABLE `trusted` ( `id` INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL, `src_ip` VARCHAR(50) NOT NULL, `proto` VARCHAR(4) NOT NULL, `from_pattern` VARCHAR(64) DEFAULT NULL, `ruri_pattern` VARCHAR(64) DEFAULT NULL, `tag` VARCHAR(64), `priority` INT DEFAULT 0 NOT NULL );
CREATE INDEX peer_idx ON trusted (`src_ip`);
INSERT INTO version (table_name, table_version) values ('trusted','6'); ```
If it is wrong, what shout it be there?
--- You are receiving this because you are subscribed to this thread. Reply to this email directly or view it on GitHub: https://github.com/kamailio/kamailio/issues/556#issuecomment-203906211
We had two checkouts saying otherwise, but now mine says the same as yours. Arrrggghh.
--- You are receiving this because you are subscribed to this thread. Reply to this email directly or view it on GitHub: https://github.com/kamailio/kamailio/issues/556#issuecomment-204045937
Closed #556.
--- You are receiving this because you are subscribed to this thread. Reply to this email directly or view it on GitHub: https://github.com/kamailio/kamailio/issues/556#event-610163751
-
Daniel-Constantin Mierla -
Olle E. Johansson