{"id":1572,"date":"2017-02-25T18:23:52","date_gmt":"2017-02-25T17:23:52","guid":{"rendered":"http:\/\/www.guion78.com\/wordpress\/?p=1572"},"modified":"2017-05-22T20:24:36","modified_gmt":"2017-05-22T18:24:36","slug":"installare-sbot-passi","status":"publish","type":"post","link":"https:\/\/www.guion78.com\/wordpress\/blog\/2017\/02\/25\/installare-sbot-passi\/","title":{"rendered":"Installare {S}Bot in passi"},"content":{"rendered":"<p>Su un server Linux per installare <a href=\"http:\/\/sbot.opensipa.it\/\">{S}Bot<\/a> dovete seguire i seguenti passi:<br \/>\nsudo apt-get install apache2<br \/>\nsudo apt-get install mysql-server mysql-client<br \/>\nsudo apt-get install php7.0-mysql php7.0-curl php7.0-json php7.0-cgi\u00a0 php7.0 libapache2-mod-php7.0 php-mcrypt<br \/>\nsudo apt-get install php-mbstring php7.0-mbstring php-gettext<br \/>\nsudo a2enmod ssl<br \/>\nsudo service apache2 restart<\/p>\n<p># Guide: http:\/\/blog.sfsoft.it\/2016\/11\/24\/creare-un-certificato-ssl-per-apache-su-ubuntu-16-04\/<br \/>\nopenssl req -x509 -nodes -days 1825 -newkey rsa:2048 -keyout \/etc\/ssl\/private\/apache-selfsigned.key -out \/etc\/ssl\/certs\/apache-selfsigned.crt<\/p>\n<p>sudo service apache2 restart<\/p>\n<p>Per cancellare la modalit\u00e0 di SQL in modo esplicito, impostarlo su una stringa vuota utilizzando \u2013sql-mode=\u201d\u201d sulla linea di comando, o sql-mode=\u201d\u201d in un file di opzioni.<\/p>\n<p>Ho aggiunto il sql-mode=\u201d\u201d opzione per \/etc\/my.cnf e ha funzionato.<\/p>\n<p>Questa soluzione SO discute i modi per scoprire quale my.cnf file sia utilizzato da MySQL.<\/p>\n<p>Non dimenticate di riavviare MySQL dopo aver apportato modifiche.<\/p>\n<p>Ora copiate i file di <a href=\"http:\/\/sbot.opensipa.it\/\">{S}Bot<\/a> nella cartella \/var\/www\/html\/ ed eseguite in phpMyadmin il file telegram.sql<\/p>\n<p>Buon Bot Telegram a tutti!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Su un server Linux per installare {S}Bot dovete seguire i seguenti passi: sudo apt-get install apache2 sudo apt-get install mysql-server mysql-client sudo apt-get install php7.0-mysql php7.0-curl php7.0-json php7.0-cgi\u00a0 php7.0 libapache2-mod-php7.0 php-mcrypt sudo apt-get install php-mbstring php7.0-mbstring php-gettext sudo a2enmod ssl sudo service apache2 restart # Guide: http:\/\/blog.sfsoft.it\/2016\/11\/24\/creare-un-certificato-ssl-per-apache-su-ubuntu-16-04\/ openssl req -x509 -nodes -days 1825 -newkey rsa:2048 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"ngg_post_thumbnail":0,"footnotes":""},"categories":[4],"tags":[859,852,853,790],"class_list":["post-1572","post","type-post","status-publish","format-standard","hentry","category-informazioni","tag-udinebot","tag-opensipa","tag-sbot","tag-telegram"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Installare {S}Bot in passi - Guion Matteo<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.guion78.com\/wordpress\/blog\/2017\/02\/25\/installare-sbot-passi\/\" \/>\n<meta property=\"og:locale\" content=\"it_IT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Installare {S}Bot in passi - Guion Matteo\" \/>\n<meta property=\"og:description\" content=\"Su un server Linux per installare {S}Bot dovete seguire i seguenti passi: sudo apt-get install apache2 sudo apt-get install mysql-server mysql-client sudo apt-get install php7.0-mysql php7.0-curl php7.0-json php7.0-cgi\u00a0 php7.0 libapache2-mod-php7.0 php-mcrypt sudo apt-get install php-mbstring php7.0-mbstring php-gettext sudo a2enmod ssl sudo service apache2 restart # Guide: http:\/\/blog.sfsoft.it\/2016\/11\/24\/creare-un-certificato-ssl-per-apache-su-ubuntu-16-04\/ openssl req -x509 -nodes -days 1825 -newkey rsa:2048 [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.guion78.com\/wordpress\/blog\/2017\/02\/25\/installare-sbot-passi\/\" \/>\n<meta property=\"og:site_name\" content=\"Guion Matteo\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/BlogMatteoGuion\/\" \/>\n<meta property=\"article:published_time\" content=\"2017-02-25T17:23:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-05-22T18:24:36+00:00\" \/>\n<meta name=\"author\" content=\"Gua78\" \/>\n<meta name=\"twitter:label1\" content=\"Scritto da\" \/>\n\t<meta name=\"twitter:data1\" content=\"Gua78\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tempo di lettura stimato\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.guion78.com\\\/wordpress\\\/blog\\\/2017\\\/02\\\/25\\\/installare-sbot-passi\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.guion78.com\\\/wordpress\\\/blog\\\/2017\\\/02\\\/25\\\/installare-sbot-passi\\\/\"},\"author\":{\"name\":\"Gua78\",\"@id\":\"https:\\\/\\\/www.guion78.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/dc866ea65964583c162e5476e0ed60e9\"},\"headline\":\"Installare {S}Bot in passi\",\"datePublished\":\"2017-02-25T17:23:52+00:00\",\"dateModified\":\"2017-05-22T18:24:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.guion78.com\\\/wordpress\\\/blog\\\/2017\\\/02\\\/25\\\/installare-sbot-passi\\\/\"},\"wordCount\":177,\"commentCount\":0,\"keywords\":[\"@UdineBot\",\"Opensipa\",\"Sbot\",\"Telegram\"],\"articleSection\":[\"Informazioni\"],\"inLanguage\":\"it-IT\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.guion78.com\\\/wordpress\\\/blog\\\/2017\\\/02\\\/25\\\/installare-sbot-passi\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.guion78.com\\\/wordpress\\\/blog\\\/2017\\\/02\\\/25\\\/installare-sbot-passi\\\/\",\"url\":\"https:\\\/\\\/www.guion78.com\\\/wordpress\\\/blog\\\/2017\\\/02\\\/25\\\/installare-sbot-passi\\\/\",\"name\":\"Installare {S}Bot in passi - Guion Matteo\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.guion78.com\\\/wordpress\\\/#website\"},\"datePublished\":\"2017-02-25T17:23:52+00:00\",\"dateModified\":\"2017-05-22T18:24:36+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.guion78.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/dc866ea65964583c162e5476e0ed60e9\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.guion78.com\\\/wordpress\\\/blog\\\/2017\\\/02\\\/25\\\/installare-sbot-passi\\\/#breadcrumb\"},\"inLanguage\":\"it-IT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.guion78.com\\\/wordpress\\\/blog\\\/2017\\\/02\\\/25\\\/installare-sbot-passi\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.guion78.com\\\/wordpress\\\/blog\\\/2017\\\/02\\\/25\\\/installare-sbot-passi\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.guion78.com\\\/wordpress\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Installare {S}Bot in passi\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.guion78.com\\\/wordpress\\\/#website\",\"url\":\"https:\\\/\\\/www.guion78.com\\\/wordpress\\\/\",\"name\":\"Guion Matteo\",\"description\":\"Il Blog ? finalizzato a dare una mano nei problemi informatici di tutti i giorni a tutti quelli a cui pu\u00f2 essere utile, spiegato in modo semplice e passo a passo\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.guion78.com\\\/wordpress\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"it-IT\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.guion78.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/dc866ea65964583c162e5476e0ed60e9\",\"name\":\"Gua78\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"it-IT\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4e4699b3c931feae00228b34007799d5331f707aa1cfd35b40d0e0637d82cf18?s=96&d=mm&r=pg\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4e4699b3c931feae00228b34007799d5331f707aa1cfd35b40d0e0637d82cf18?s=96&d=mm&r=pg\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4e4699b3c931feae00228b34007799d5331f707aa1cfd35b40d0e0637d82cf18?s=96&d=mm&r=pg\",\"caption\":\"Gua78\"},\"description\":\"Amministratore del Portale\",\"sameAs\":[\"http:\\\/\\\/www.guion78.com\"],\"url\":\"https:\\\/\\\/www.guion78.com\\\/wordpress\\\/blog\\\/author\\\/administrator\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Installare {S}Bot in passi - Guion Matteo","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.guion78.com\/wordpress\/blog\/2017\/02\/25\/installare-sbot-passi\/","og_locale":"it_IT","og_type":"article","og_title":"Installare {S}Bot in passi - Guion Matteo","og_description":"Su un server Linux per installare {S}Bot dovete seguire i seguenti passi: sudo apt-get install apache2 sudo apt-get install mysql-server mysql-client sudo apt-get install php7.0-mysql php7.0-curl php7.0-json php7.0-cgi\u00a0 php7.0 libapache2-mod-php7.0 php-mcrypt sudo apt-get install php-mbstring php7.0-mbstring php-gettext sudo a2enmod ssl sudo service apache2 restart # Guide: http:\/\/blog.sfsoft.it\/2016\/11\/24\/creare-un-certificato-ssl-per-apache-su-ubuntu-16-04\/ openssl req -x509 -nodes -days 1825 -newkey rsa:2048 [&hellip;]","og_url":"https:\/\/www.guion78.com\/wordpress\/blog\/2017\/02\/25\/installare-sbot-passi\/","og_site_name":"Guion Matteo","article_publisher":"https:\/\/www.facebook.com\/BlogMatteoGuion\/","article_published_time":"2017-02-25T17:23:52+00:00","article_modified_time":"2017-05-22T18:24:36+00:00","author":"Gua78","twitter_misc":{"Scritto da":"Gua78","Tempo di lettura stimato":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.guion78.com\/wordpress\/blog\/2017\/02\/25\/installare-sbot-passi\/#article","isPartOf":{"@id":"https:\/\/www.guion78.com\/wordpress\/blog\/2017\/02\/25\/installare-sbot-passi\/"},"author":{"name":"Gua78","@id":"https:\/\/www.guion78.com\/wordpress\/#\/schema\/person\/dc866ea65964583c162e5476e0ed60e9"},"headline":"Installare {S}Bot in passi","datePublished":"2017-02-25T17:23:52+00:00","dateModified":"2017-05-22T18:24:36+00:00","mainEntityOfPage":{"@id":"https:\/\/www.guion78.com\/wordpress\/blog\/2017\/02\/25\/installare-sbot-passi\/"},"wordCount":177,"commentCount":0,"keywords":["@UdineBot","Opensipa","Sbot","Telegram"],"articleSection":["Informazioni"],"inLanguage":"it-IT","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.guion78.com\/wordpress\/blog\/2017\/02\/25\/installare-sbot-passi\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.guion78.com\/wordpress\/blog\/2017\/02\/25\/installare-sbot-passi\/","url":"https:\/\/www.guion78.com\/wordpress\/blog\/2017\/02\/25\/installare-sbot-passi\/","name":"Installare {S}Bot in passi - Guion Matteo","isPartOf":{"@id":"https:\/\/www.guion78.com\/wordpress\/#website"},"datePublished":"2017-02-25T17:23:52+00:00","dateModified":"2017-05-22T18:24:36+00:00","author":{"@id":"https:\/\/www.guion78.com\/wordpress\/#\/schema\/person\/dc866ea65964583c162e5476e0ed60e9"},"breadcrumb":{"@id":"https:\/\/www.guion78.com\/wordpress\/blog\/2017\/02\/25\/installare-sbot-passi\/#breadcrumb"},"inLanguage":"it-IT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.guion78.com\/wordpress\/blog\/2017\/02\/25\/installare-sbot-passi\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.guion78.com\/wordpress\/blog\/2017\/02\/25\/installare-sbot-passi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.guion78.com\/wordpress\/"},{"@type":"ListItem","position":2,"name":"Installare {S}Bot in passi"}]},{"@type":"WebSite","@id":"https:\/\/www.guion78.com\/wordpress\/#website","url":"https:\/\/www.guion78.com\/wordpress\/","name":"Guion Matteo","description":"Il Blog ? finalizzato a dare una mano nei problemi informatici di tutti i giorni a tutti quelli a cui pu\u00f2 essere utile, spiegato in modo semplice e passo a passo","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.guion78.com\/wordpress\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"it-IT"},{"@type":"Person","@id":"https:\/\/www.guion78.com\/wordpress\/#\/schema\/person\/dc866ea65964583c162e5476e0ed60e9","name":"Gua78","image":{"@type":"ImageObject","inLanguage":"it-IT","@id":"https:\/\/secure.gravatar.com\/avatar\/4e4699b3c931feae00228b34007799d5331f707aa1cfd35b40d0e0637d82cf18?s=96&d=mm&r=pg","url":"https:\/\/secure.gravatar.com\/avatar\/4e4699b3c931feae00228b34007799d5331f707aa1cfd35b40d0e0637d82cf18?s=96&d=mm&r=pg","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4e4699b3c931feae00228b34007799d5331f707aa1cfd35b40d0e0637d82cf18?s=96&d=mm&r=pg","caption":"Gua78"},"description":"Amministratore del Portale","sameAs":["http:\/\/www.guion78.com"],"url":"https:\/\/www.guion78.com\/wordpress\/blog\/author\/administrator\/"}]}},"views":1578,"_links":{"self":[{"href":"https:\/\/www.guion78.com\/wordpress\/wp-json\/wp\/v2\/posts\/1572","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.guion78.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.guion78.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.guion78.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.guion78.com\/wordpress\/wp-json\/wp\/v2\/comments?post=1572"}],"version-history":[{"count":0,"href":"https:\/\/www.guion78.com\/wordpress\/wp-json\/wp\/v2\/posts\/1572\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.guion78.com\/wordpress\/wp-json\/wp\/v2\/media?parent=1572"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.guion78.com\/wordpress\/wp-json\/wp\/v2\/categories?post=1572"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.guion78.com\/wordpress\/wp-json\/wp\/v2\/tags?post=1572"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}