{"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\/et\/blog\/administrirovanie\/podnimaem-server-1s-s-publikatsiej-bazy-i-veb-servisov-na-linux","title":{"rendered":"Seame 1C server koos andmebaasi ja veebiteenuste publikatsiooniga Linuxil","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

\"Seame
\n
\nT\u00e4na tahaksin r\u00e4\u00e4kida sellest, kuidas t\u00f5sta 1C server Linux Debian 9-le web-teenuste avaldamisega. <\/p>\n

Mis on 1C web-teenused? <\/p>\n

Web-teenused<\/a><\/noindex> on \u00fcks platvormi mehhanisme, mida kasutatakse teiste infotehnoloogiliste s\u00fcsteemidega integreerimiseks. See toetab SOA (Service-Oriented Architecture) \u2014 teenusele orienteeritud arhitektuur, mis on kaasaegne rakenduste ja infotehnoloogiliste s\u00fcsteemide integreerimise standard. Sisuliselt on see v\u00f5imalus luua HTML-leht andmetega, millele saavad teised rakendused juurdep\u00e4\u00e4su ja need k\u00e4tte saada. <\/p>\n

Plussid \u2014 t\u00f6\u00f6tab kiiresti (isegi suurte andmemahtude korral), on suhteliselt mugav.<\/p>\n

Miinused \u2014 teie 1C programmeerija kurdab teie \u00fcle kaua ja p\u00f5hjalikult, kui kirjutab veebiteenust teie andmebaasi jaoks. See on kirjutamisel v\u00e4ga omamoodi asi.<\/p>\n

Ma ei hakka r\u00e4\u00e4kima, kuidas kirjutada veebiteenus<\/a><\/noindex>\u2026 ma r\u00e4\u00e4gin, kuidas seda Linuxis serveri konsoolist avaldada, ja natuke 1C serveri installimisest Linuxile.
\n<\/a><\/noindex>
\nNii, meil on Debian 9 netinst, alustame:<\/p>\n

Paigaldame PostgresPro (t\u00e4helepanu, et see ei ole tasuta ja jagatakse ainult v\u00f5imaluste tutvustamiseks):<\/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
\n\u00dctleme, et postgresql kuulab k\u00f5iki aadresse, mitte ainult localhost'i<\/p>\n
# nano \/var\/lib\/pgpro\/std-11\/data\/postgresql.conf<\/code><\/pre>\n
Vahetame ja kaotame kommentaarid, milliseid aadresse kuulata:<\/p>\n
\u2026
\n#listen_addresses = ‘localhost’
\n\u2026\n<\/p><\/blockquote>\n
\nVDS-l on v\u00f5imalik installida:<\/p>\n
\u2026
\nlisten_addresses = '*' 
\n\u2026\n<\/p><\/blockquote>\n
Seej\u00e4rel lubame kasutajatel meie v\u00f5rgust sisse logida<\/p>\n
# nano \/var\/lib\/pgpro\/std-11\/data\/pg_hba.conf<\/code><\/pre>\n
\nMuudame:<\/p>\n
# IPv4 local connections:
\nhost all all 127.0.0.1\/32 md5\n<\/p><\/blockquote>\n
\nj\u00e4rgnevaga <\/p>\n
host all all 192.168.188.0\/24 md5
\nhost all all 127.0.0.1\/32 md5\n<\/p><\/blockquote>\n
Rohkem teavet Postgresi erinevate seadistuste kohta 1c jaoks saab lugeda siin<\/a><\/noindex>.<\/p>\n
Seej\u00e4rel installime 1c serveri.<\/p>\n
Laadime serverisse failiarhiivi, mis on alla laaditud 1c lehelt (minu puhul 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
\nveel paar v\u00e4ikest asja:<\/p>\n
# apt install imagemagick unixodbc libgsf-bin<\/code><\/pre>\n
N\u00fc\u00fcd installime Apache2<\/p>\n
# apt install apache2<\/code><\/pre>\n
Kasutades halduskonsooli v\u00f5i 1c klienti, loomeme andmebaasi ja laadime \u00fcles meie konfiguratsiooni\u2026 <\/p>\n
N\u00fc\u00fcd avaldame andmebaasi: <\/p>\n
liigume 1c kausta.<\/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
Uurime var\/www\/test\/ ja vaatame, mis seal on ilmunud.<\/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
Need on skeemid, mis on vajalikud 1C veebikliendi k\u00e4ivitamiseks... n\u00fc\u00fcd on meie testibaasi v\u00f5imalik brauseri kaudu aadressilt \u00abhttp :\/\/ServeriAadress\/Test\u00bb (t\u00e4htsus on oluline! see on ju Linux) v\u00f5i m\u00e4\u00e4rata kliendis \u00abbaasi asukoha t\u00fc\u00fcp\u00bb aadress \u00abhttp :\/\/ServeriAadress\/Test\u00bb, ja klient t\u00f6\u00f6tab avaldatud baasi selles aadressis.<\/p>\n
KUID<\/p>\n
Aga mis on veebiteenuste osas? (minu testkonfiguratsioonis on need kaks: WebBuh raamatupidamise andmete vahetamiseks ja toplog integraatsioon vastava ettev\u00f5tte WMS s\u00fcsteemiga).<\/p>\n
Lisame m\u00f5ne rea meie vrd failile...<\/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=\u00abSrvr=IP_aadress;Ref=TestWebServ\u00bb>
\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" # Veebiteenuse nimi konfigureerijas 
\n alias=\"Web_buh.1cws\" # Web_buh.1cws - veebiteenuse alias brauseris
\n enable=\"true\" # edasi on read ja nii arusaadavad
\n reuseSessions=\"autouse\"
\n sessionMaxAge=\"20\"
\n poolSize=\"10\"
\n poolTimeout=\"5\"\/>
\n <point name="TopLog" # teine veebiteenus
\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
\nsalvestame.<\/p>\n
Ja n\u00fc\u00fcd on meie veebiteenus saadaval aadressil \u00abhttp :\/\/ServeriAadress\/Test\/Web_buh.1cws?\u00bb<\/p>\n
Miks oli vajalik seda k\u00e4sitsi teha? <\/p>\n
Kuna meie serveril puudub graafiline liides, ei saa me sellel k\u00e4ivitada konfigureeritavat \u2014 seega ei ole v\u00f5imalik avaldamist l\u00e4bi tavap\u00e4raste vahendite teostada. Kaugkonfigureerija, mis t\u00f6\u00f6tab kliendi peal, ei avalda serveris veebiteenuseid. Seet\u00f5ttu peame k\u00e4sitsi konfigureerima vastavalt eespool mainitud mallile.<\/p>\n
Skript .vrd genereerimiseks<\/a><\/noindex> \u2014 ait\u00e4h TihonV<\/a><\/noindex>
\n
Allikas: 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\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\udd47T\u00f5stame 1C serveri koos andmebaasi ja veebiteenuste avaldamisega Linuxis | ProHoster","description":"T\u00e4na tahaksin r\u00e4\u00e4kida.","canonical_url":"https:\/\/prohoster.info\/et\/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":"et_EE","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\/et\/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\/et\/wp-json\/wp\/v2\/posts\/36969","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/comments?post=36969"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts\/36969\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/media\/27704"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/media?parent=36969"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/categories?post=36969"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/tags?post=36969"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}