{"id":2432,"date":"2025-08-05T10:43:26","date_gmt":"2025-08-05T08:43:26","guid":{"rendered":"https:\/\/artheodoc.fr\/?page_id=2432"},"modified":"2025-08-05T10:43:26","modified_gmt":"2025-08-05T08:43:26","slug":"configuration-de-la-base-de-donnees-onlyoffice-installee-avec-le-script-docs-install-sh","status":"publish","type":"page","link":"https:\/\/artheodoc.fr\/index.php\/configuration-de-la-base-de-donnees-onlyoffice-installee-avec-le-script-docs-install-sh\/","title":{"rendered":"Configuration de la base de donn\u00e9es OnlyOffice install\u00e9e avec le script docs-install.sh"},"content":{"rendered":"\n

Sous Debian 12 vous pouvez vous connecter en administrateur root (su<\/strong>) et supprimer la commande sudo<\/strong>.<\/p>\n\n\n\n

Quand on installe OnlyOffice Document Server avec le script docs-install.sh, il utilise automatiquement PostgreSQL et configure la base de donn\u00e9es sans demander de mot de passe ni de nom d\u2019utilisateur personnalis\u00e9. Les param\u00e8tres par d\u00e9faut sont :<\/p>\n\n\n\n

Configuration de la base de donn\u00e9es<\/strong><\/p>\n\n\n\n

\u00c9l\u00e9ment<\/th>Valeur<\/th><\/tr>
Nom de la base<\/td>onlyoffice<\/td><\/tr>
Utilisateur DB<\/td>onlyoffice<\/td><\/tr>
Mot de passe<\/td>G\u00e9n\u00e9r\u00e9 al\u00e9atoirement (dans un fichier config)<\/td><\/tr>
H\u00f4te<\/td>localhost<\/td><\/tr>
Port<\/td>5432 (PostgreSQL par d\u00e9faut)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

1. O\u00f9 trouver le mot de passe de la base\u00a0?\u00a0:<\/h2>\n\n\n\n

Il est stock\u00e9 dans le fichier de configuration du OnlyOffice :<\/p>\n\n\n\n

sudo grep dbPass \/etc\/onlyoffice\/documentserver\/local.json<\/pre>\n\n\n\n
On voit le mot de passe exact utilis\u00e9 pour se connecter \u00e0 PostgreSQL.<\/p>\n\n\n\n
2. Acc\u00e8s manuel \u00e0 la base de donn\u00e9es pour tester (si n\u00e9cessaire)\u00a0:<\/h2>\n\n\n\n
sudo -u postgres psql -h localhost -U onlyoffice -d onlyoffice<\/pre>\n\n\n\n
Il demande un mot de passe \u2014 celui trouv\u00e9 dans local.json.<\/p>\n\n\n\n
La m\u00eame commande sous Debian en root (su<\/strong>) :<\/p>\n\n\n\n
psql -h localhost -U onlyoffice -d onlyoffice<\/pre>\n\n\n\n
Quittez PostgreSQL :<\/p>\n\n\n\n
\\q<\/pre>\n\n\n\n
3. Pour modifier le mot de passe de la base de donn\u00e9es PostgreSQL pour l\u2019utilisateur onlyoffice\u00a0:<\/h2>\n\n\n\n
Se connecter \u00e0 PostgreSQL comme superutilisateur (ex: postgres)<\/p>\n\n\n\n
sudo -u postgres psql<\/pre>\n\n\n\n
Ou en root :<\/p>\n\n\n\n
su - postgres -c psql<\/pre>\n\n\n\n
Ou si psql est d\u00e9j\u00e0 install\u00e9 sous votre utilisateur root :<\/p>\n\n\n\n
psql -U postgres<\/pre>\n\n\n\n
2. Modifier le mot de passe de l’utilisateur onlyoffice<\/p>\n\n\n\n
Une fois dans le shell PostgreSQL (psql), tapez :<\/p>\n\n\n\n
ALTER USER onlyoffice WITH PASSWORD 'NOUVEAU_MOT_DE_PASSE';<\/pre>\n\n\n\n
Remplacez NOUVEAU_MOT_DE_PASSE par le mot de passe de ton choix (entre guillemets simples ‘…’).<\/p>\n\n\n\n
Puis quittez PostgreSQL avec :<\/p>\n\n\n\n
\\q<\/pre>\n\n\n\n
3. Mettre \u00e0 jour la configuration de OnlyOffice<\/p>\n\n\n\n
\u00c9ditez le fichier suivant :<\/p>\n\n\n\n
sudo nano \/etc\/onlyoffice\/documentserver\/local.json<\/pre>\n\n\n\n
Et modifiez la ligne :<\/p>\n\n\n\n
\"dbPass\": \"ancien_mot_de_passe\"<\/pre>\n\n\n\n
Par :<\/p>\n\n\n\n
\"dbPass\": \"NOUVEAU_MOT_DE_PASSE\"<\/pre>\n\n\n\n
4. Red\u00e9marrez les services<\/p>\n\n\n\n
Ensuite, red\u00e9marrez les services pour OnlyOffice pour appliquer le changement :<\/p>\n\n\n\n
sudo systemctl restart ds-docservice.service<\/pre>\n\n\n\n
Et au besoin :<\/p>\n\n\n\n
sudo systemctl restart postgresql<\/pre>\n\n\n\n
Ou si on veut red\u00e9marrer la machine :<\/p>\n\n\n\n
sudo shutdown -r now<\/pre>\n\n\n\n
\n\n\n\n
Voir\u00a0: Les services Linux avec systemd<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Sous Debian 12 vous pouvez vous connecter en administrateur root (su) et supprimer la commande sudo. Quand on installe OnlyOffice Document Server avec le script docs-install.sh, il utilise automatiquement PostgreSQL et configure la base de donn\u00e9es sans demander de mot de passe ni de nom d\u2019utilisateur personnalis\u00e9. Les param\u00e8tres par d\u00e9faut sont : Configuration de la […]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"class_list":["post-2432","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/artheodoc.fr\/index.php\/wp-json\/wp\/v2\/pages\/2432","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/artheodoc.fr\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/artheodoc.fr\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/artheodoc.fr\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/artheodoc.fr\/index.php\/wp-json\/wp\/v2\/comments?post=2432"}],"version-history":[{"count":1,"href":"https:\/\/artheodoc.fr\/index.php\/wp-json\/wp\/v2\/pages\/2432\/revisions"}],"predecessor-version":[{"id":2433,"href":"https:\/\/artheodoc.fr\/index.php\/wp-json\/wp\/v2\/pages\/2432\/revisions\/2433"}],"wp:attachment":[{"href":"https:\/\/artheodoc.fr\/index.php\/wp-json\/wp\/v2\/media?parent=2432"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}