mirror of
https://github.com/Termix-SSH/Termix.git
synced 2026-08-29 18:31:33 +00:00
ZacharyZcR
5f55289e00
* feat: 1Password Connect secret sources for SSH credentials Hosts and credentials can hold op://vault/item/field references instead of secrets; they are resolved at connect time from the user's secret source (1Password Connect) at the single point where every subsystem receives plaintext credentials, so terminal, SFTP, Docker, metrics and tunnels all work without per-subsystem changes. Sources are per user, optionally shared, with the access token encrypted under the owner's data key; resolved values are cached briefly in memory. * style: format secret source changes
15 lines
746 B
SQL
15 lines
746 B
SQL
CREATE TABLE `secret_sources` (
|
|
`id` varchar(255) NOT NULL,
|
|
`user_id` varchar(255) NOT NULL,
|
|
`name` varchar(255) NOT NULL,
|
|
`kind` text NOT NULL DEFAULT ('onepassword-connect'),
|
|
`base_url` text NOT NULL,
|
|
`token` text NOT NULL,
|
|
`shared` boolean NOT NULL DEFAULT false,
|
|
`created_at` varchar(255) NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
|
`updated_at` varchar(255) NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
|
CONSTRAINT `secret_sources_id` PRIMARY KEY(`id`)
|
|
);
|
|
--> statement-breakpoint
|
|
ALTER TABLE `secret_sources` ADD CONSTRAINT `secret_sources_user_id_users_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
|
CREATE INDEX `idx_secret_sources_user` ON `secret_sources` (`user_id`); |