{"id":36969,"date":"2019-10-31T22:15:01","date_gmt":"2019-10-31T19:15:01","guid":{"rendered":"https:\/\/prohoster.info\/blog\/podnimaem-server-1s-s-publikatsiej-bazy-i-veb-servisov-na-linux\/"},"modified":"2019-10-31T22:15:01","modified_gmt":"2019-10-31T19:15:01","slug":"podnimaem-server-1s-s-publikatsiej-bazy-i-veb-servisov-na-linux","status":"publish","type":"post","link":"https:\/\/prohoster.info\/pt\/blog\/administrirovanie\/podnimaem-server-1s-s-publikatsiej-bazy-i-veb-servisov-na-linux","title":{"rendered":"Configurando o servidor 1C com publica\u00e7\u00e3o de banco de dados e servi\u00e7os web no Linux","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

\"Configurando
\n
\nHoje, gostaria de falar sobre como configurar um servidor 1C no Linux Debian 9 com a publica\u00e7\u00e3o de web services. <\/p>\n

O que s\u00e3o web services 1C? <\/p>\n

Web Services<\/a><\/noindex> \u2014 \u00e9 um dos mecanismos da plataforma, usado para integra\u00e7\u00e3o com outros sistemas de informa\u00e7\u00e3o. \u00c9 um meio de suportar a SOA (Arquitetura Orientada a Servi\u00e7os) \u2014 arquitetura orientada a servi\u00e7os, que \u00e9 o padr\u00e3o moderno para integra\u00e7\u00e3o de aplicativos e sistemas de informa\u00e7\u00e3o. Basicamente, \u00e9 a possibilidade de criar uma p\u00e1gina HTML com dados, a qual pode ser acessada por qualquer outro aplicativo para recuper\u00e1-los. <\/p>\n

Vantagens \u2014 funciona rapidamente (mesmo com um volume consider\u00e1vel de dados), relativamente conveniente.<\/p>\n

Desvantagens \u2014 seu programador 1C vai reclamar bastante enquanto escreve o web service para seu banco de dados. A coisa \u00e9 bastante peculiar de se escrever.<\/p>\n

N\u00e3o vou falar sobre como escrever um web service<\/a><\/noindex>\u2026 eu vou falar sobre como public\u00e1-lo no Linux a partir do console do servidor e tamb\u00e9m um pouco sobre a instala\u00e7\u00e3o do servidor 1C no Linux.
\n<\/a><\/noindex>
\nEnt\u00e3o, temos o Debian 9 netinst, vamos come\u00e7ar:<\/p>\n

Instalamos o PostgresPro (Por favor, note que n\u00e3o \u00e9 gratuito, e \u00e9 distribu\u00eddo apenas dentro da limita\u00e7\u00e3o de teste de suas funcionalidades):<\/p>\n

# apt-get update -y<\/code><\/pre>\n
<\/p>\n
# apt-get install -y wget gnupg2 || apt-get install -y gnupg<\/code><\/pre>\n
<\/p>\n
# wget -O - http:\/\/repo.postgrespro.ru\/keys\/GPG-KEY-POSTGRESPRO | apt-key add -<\/code><\/pre>\n
<\/p>\n
# echo deb http:\/\/repo.postgrespro.ru\/pgpro-archive\/pgpro-11.4.1\/debian stretch main > \/etc\/apt\/sources.list.d\/postgrespro-std.list<\/code><\/pre>\n
<\/p>\n
# apt-get update -y<\/code><\/pre>\n
# apt-get install -y postgrespro-std-11-server<\/code><\/pre>\n
# \/opt\/pgpro\/std-11\/bin\/pg-setup initdb<\/code><\/pre>\n
# \/opt\/pgpro\/std-11\/bin\/pg-setup service enable<\/code><\/pre>\n
# service postgrespro-std-11 start<\/code><\/pre>\n
# su - postgres<\/code><\/pre>\n
# \/opt\/pgpro\/std-11\/bin\/psql -U postgres -c \"alter user postgres with password '\u0412\u0430\u0448\u041f\u0430\u0440\u043e\u043b\u044c';\"<\/code><\/pre>\n
\nVamos dizer que o postgresql escute todos os endere\u00e7os e n\u00e3o apenas o localhost<\/p>\n
# nano \/var\/lib\/pgpro\/std-11\/data\/postgresql.conf<\/code><\/pre>\n
Descomentamos e mudamos quais endere\u00e7os escutar:<\/p>\n
\u2026
\n#listen_addresses = ‘localhost’
\n\u2026\n<\/p><\/blockquote>\n
\nSobre<\/p>\n
\u2026
\nlisten_addresses = '*' 
\n\u2026\n<\/p><\/blockquote>\n
Em seguida, permitimos que usu\u00e1rios da nossa rede se autentiquem<\/p>\n
# nano \/var\/lib\/pgpro\/std-11\/data\/pg_hba.conf<\/code><\/pre>\n
\nAlteramos para:<\/p>\n
# IPv4 local connections:
\nhost all all 127.0.0.1\/32 md5\n<\/p><\/blockquote>\n
\npara <\/p>\n
host all all 192.168.188.0\/24 md5
\nhost all all 127.0.0.1\/32 md5\n<\/p><\/blockquote>\n
Voc\u00ea pode ler mais sobre as diferentes configura\u00e7\u00f5es do Postgres para 1C aqui<\/a><\/noindex>.<\/p>\n
Em seguida, instalamos o servidor 1C.<\/p>\n
Fazemos o upload do arquivo compactado baixado do site 1C (no meu caso deb64_8_3_15_1534.tar.gz)<\/p>\n
\n# tar -xzf deb64_8_3_15_1534.tar.gz\n<\/code><\/pre>\n
<\/p>\n
# dpkg -i *.deb<\/code><\/pre>\n
\nmais algumas pequenas coisas:<\/p>\n
# apt install imagemagick unixodbc libgsf-bin<\/code><\/pre>\n
Agora, vamos instalar o Apache2<\/p>\n
# apt install apache2<\/code><\/pre>\n
Atrav\u00e9s do console administrativo ou pelo cliente 1C, criamos um banco e carregamos nossa configura\u00e7\u00e3o\u2026 <\/p>\n
Agora vamos publicar o banco: <\/p>\n
navegamos at\u00e9 a pasta do 1C.<\/p>\n
# cd \/opt\/1C\/v8.3\/x86_64\/<\/code><\/pre>\n
\n. \/webinst -publish -apache24 -wsdir Test -dir \/var\/www\/test\/ -connstr  \"Srvr=10.7.12.108;Ref=test;\" -confPath \/etc\/apache2\/apache2.conf<\/code><\/pre>\n
Vamos em var\/www\/test\/ e vemos o que foi criado l\u00e1.<\/p>\n
# cd \/var\/www\/test<\/code><\/pre>\n
# nano default.vrd<\/code><\/pre>\n
\u00ab
\n<?xml version=\u00ab1.0\u00bb encoding=\u00abUTF-8\u00bb?>
\nv8.1c.ru\/8.2\/virtual-resource-system<\/a><\/noindex>\u00bb
\n  href=\"http:\/\/www.w3.org\/2001\/XMLSchema\">www.w3.org\/2001\/XMLSchema<\/a><\/noindex>\u00bb
\n  href=\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\">www.w3.org\/2001\/XMLSchema-instance<\/a><\/noindex>\u00bb
\n base=\"\/Test\"
\n ib=\"Srvr=192.168.188.150;Ref=Test;\">
\n <standardOdata enable="false"
\n reuseSessions=\"autouse\"
\n sessionMaxAge=\"20\"
\n poolSize=\"10\"
\n poolTimeout=\"5\"\/>\n<\/p><\/blockquote>\n
\u00ab<\/p>\n
Esses s\u00e3o os esquemas necess\u00e1rios para iniciar o cliente web 1C\u2026 agora podemos acessar nossa base de teste pelo navegador no endere\u00e7o \"http:\/\/Endere\u00e7oDoServidor\/Test\" (a caixa alta \u00e9 importante! \u00e9 Linux) ou especificar no cliente o \"tipo de localiza\u00e7\u00e3o da base\" como \"http:\/\/Endere\u00e7oDoServidor\/Test\", e o cliente funcionar\u00e1 com a base publicada.<\/p>\n
MAS<\/p>\n
E quanto aos servi\u00e7os web? (na minha configura\u00e7\u00e3o de teste, h\u00e1 dois: WebBuh para troca de dados com a contabilidade e a integra\u00e7\u00e3o toplog com o sistema WMS da mesma empresa).<\/p>\n
Bem, vamos adicionar algumas linhas ao nosso arquivo vrd\u2026<\/p>\n
<?xml version=\u00ab1.0\u00bb encoding=\u00abUTF-8\u00bb?>
\nv8.1c.ru\/8.2\/virtual-resource-system<\/a><\/noindex>\u00bb
\n  href=\"http:\/\/www.w3.org\/2001\/XMLSchema\">www.w3.org\/2001\/XMLSchema<\/a><\/noindex>\u00bb
\n  href=\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\">www.w3.org\/2001\/XMLSchema-instance<\/a><\/noindex>\u00bb
\n base=\"\/TestWeb\"
\n ib=\"Srvr=IP_endere\u00e7o;Ref=TestWebServ\">
\n <standardOdata enable="false"
\n reuseSessions=\"autouse\"
\n sessionMaxAge=\"20\"
\n poolSize=\"10\"
\n poolTimeout=\"5\"\/>
\n    
\n # \u0412\u043e\u0442 \u0442\u0443\u0442 \u043d\u0430\u0447\u0438\u043d\u0430\u0435\u0442\u0441\u044f \u043a\u043e\u0434 \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u043f\u0443\u0431\u043b\u0438\u043a\u0443\u0435\u0442 \u0432\u0435\u0431-\u0441\u0435\u0440\u0432\u0438\u0441\u044b
\n <point name="WebBuh" # Nome do servi\u00e7o web no configurador 
\n alias=\"Web_buh.1cws\" # Web_buh.1cws - alias do servi\u00e7o web no navegador
\n enable=\"true\" # a partir daqui, as linhas s\u00e3o entend\u00edveis
\n reuseSessions=\"autouse\"
\n sessionMaxAge=\"20\"
\n poolSize=\"10\"
\n poolTimeout=\"5\"\/>
\n <point name="TopLog" # segundo servi\u00e7o web
\n alias=\"toplog.1cws\" # toplog.1cws
\n enable=\"true\"
\n reuseSessions=\"autouse\"
\n sessionMaxAge=\"20\"
\n poolSize=\"10\"
\n poolTimeout=\"5\"\/>
\n <\/b><\/code>\n<\/p><\/blockquote>\n
\nvamos salvar.<\/p>\n
E agora, nosso servi\u00e7o web est\u00e1 dispon\u00edvel no endere\u00e7o \"http:\/\/Endere\u00e7oDoServidor\/Test\/Web_buh.1cws?\"<\/p>\n
Por que isso tinha que ser feito manualmente? <\/p>\n
Como nosso servidor n\u00e3o possui uma interface gr\u00e1fica, n\u00e3o ser\u00e1 poss\u00edvel executar o configurador nele, e, consequentemente, publicar com os meios padr\u00e3o. O configurador remoto, que est\u00e1 no cliente, tamb\u00e9m n\u00e3o publica os servi\u00e7os web no servidor. Portanto, temos que editar a configura\u00e7\u00e3o manualmente com o modelo descrito acima.<\/p>\n
Script para gera\u00e7\u00e3o de .vrd<\/a><\/noindex> \u2014 obrigado TihonV<\/a><\/noindex>
\n
Fonte: habr.com<\/a><\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"
\u0421\u0435\u0433\u043e\u0434\u043d\u044f \u044f \u0431\u044b \u0445\u043e\u0442\u0435\u043b \u0440\u0430\u0441\u0441\u043a\u0430\u0437\u0430\u0442\u044c, \u043a\u0430\u043a \u043f\u043e\u0434\u043d\u044f\u0442\u044c \u0441\u0435\u0440\u0432\u0435\u0440 1\u0441 \u043d\u0430 linux debian 9 \u0441 \u043f\u0443\u0431\u043b\u0438\u043a\u0430\u0446\u0438\u0435\u0439 web-\u0441\u0435\u0440\u0432\u0438\u0441\u043e\u0432. \u0427\u0442\u043e \u0442\u0430\u043a\u043e\u0435 web-\u0441\u0435\u0440\u0432\u0438\u0441\u044b 1\u0441? Web-\u0441\u0435\u0440\u0432\u0438\u0441\u044b \u2014 \u044d\u0442\u043e \u043e\u0434\u0438\u043d \u0438\u0437 \u043c\u0435\u0445\u0430\u043d\u0438\u0437\u043c\u043e\u0432 \u043f\u043b\u0430\u0442\u0444\u043e\u0440\u043c\u044b, \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u043c\u044b\u0445 \u0434\u043b\u044f \u0438\u043d\u0442\u0435\u0433\u0440\u0430\u0446\u0438\u0438 \u0441 \u0434\u0440\u0443\u0433\u0438\u043c\u0438 \u0438\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u043e\u043d\u043d\u044b\u043c\u0438 \u0441\u0438\u0441\u0442\u0435\u043c\u0430\u043c\u0438. \u041e\u043d \u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u0441\u0440\u0435\u0434\u0441\u0442\u0432\u043e\u043c \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u043a\u0438 SOA (Service-Oriented Architecture) \u2014 \u0441\u0435\u0440\u0432\u0438\u0441-\u043e\u0440\u0438\u0435\u043d\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u043e\u0439 \u0430\u0440\u0445\u0438\u0442\u0435\u043a\u0442\u0443\u0440\u044b, \u043a\u043e\u0442\u043e\u0440\u0430\u044f \u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u0441\u043e\u0432\u0440\u0435\u043c\u0435\u043d\u043d\u044b\u043c \u0441\u0442\u0430\u043d\u0434\u0430\u0440\u0442\u043e\u043c \u0438\u043d\u0442\u0435\u0433\u0440\u0430\u0446\u0438\u0438 \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u0439 \u0438 \u0438\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u043e\u043d\u043d\u044b\u0445 \u0441\u0438\u0441\u0442\u0435\u043c. \u041f\u043e \u0441\u0443\u0442\u0438 […]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":27704,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[688],"tags":[],"class_list":["post-36969","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-administrirovanie"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\n","aioseo_head_json":{"title":"\ud83e\udd47Levando o servidor 1C com publica\u00e7\u00e3o da base e servi\u00e7os web no Linux | ProHoster","description":"Hoje eu gostaria de.","canonical_url":"https:\/\/prohoster.info\/pt\/blog\/administrirovanie\/podnimaem-server-1s-s-publikatsiej-bazy-i-veb-servisov-na-linux","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"pt_PT","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47\u041f\u043e\u0434\u043d\u0438\u043c\u0430\u0435\u043c \u0441\u0435\u0440\u0432\u0435\u0440 1\u0441 \u0441 \u043f\u0443\u0431\u043b\u0438\u043a\u0430\u0446\u0438\u0435\u0439 \u0431\u0430\u0437\u044b \u0438 \u0432\u0435\u0431 \u0441\u0435\u0440\u0432\u0438\u0441\u043e\u0432 \u043d\u0430 Linux | ProHoster","og:description":"\u0421\u0435\u0433\u043e\u0434\u043d\u044f \u044f \u0431\u044b \u0445\u043e\u0442\u0435\u043b.","og:url":"https:\/\/prohoster.info\/pt\/blog\/administrirovanie\/podnimaem-server-1s-s-publikatsiej-bazy-i-veb-servisov-na-linux","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2019-10-31T19:15:01+00:00","article:modified_time":"2019-10-31T19:15:01+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"36969","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":"2026-01-22 05:34:19","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-03-01 01:35:27","updated":"2026-01-22 05:34:19","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/posts\/36969","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/comments?post=36969"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/posts\/36969\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/media\/27704"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/media?parent=36969"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/categories?post=36969"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/tags?post=36969"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}