{"id":354,"date":"2020-09-22T11:18:07","date_gmt":"2020-09-22T09:18:07","guid":{"rendered":"http:\/\/tietokanta.dy.fi\/linux\/?p=354"},"modified":"2020-11-10T15:41:41","modified_gmt":"2020-11-10T12:41:41","slug":"phpbb3-asennus","status":"publish","type":"post","link":"http:\/\/tietokanta.dy.fi\/linux\/index.php\/2020\/09\/22\/phpbb3-asennus\/","title":{"rendered":"PhpBB3 asennus"},"content":{"rendered":"\n<p>Hae koneellesi tar paketti wget ohjelmalla:<\/p>\n\n\n\n<p>wget<a href=\" https:\/\/download.phpbb.com\/pub\/release\/3.3\/3.3.1\/phpBB-3.3.1.tar.bz2\"> https:\/\/download.phpbb.com\/pub\/release\/3.3\/3.3.1\/phpBB-3.3.1.tar.bz2<\/a><\/p>\n\n\n\n<p>Pura paketti tar -xvf paketinnimi.tar.bz2<\/p>\n\n\n\n<p>Purettu paketti tulee alihakemistoksi <\/p>\n\n\n\n<p>Siirr\u00e4 kansion sis\u00e4lt\u00f6 filezilla ohjelmalla palvelimelle<\/p>\n\n\n\n<p>Siirron j\u00e4lkeen tee tietokanta phpbb:lle seuraavasti.<\/p>\n\n\n\n<p>Kirjaudu mysql:\u00e4\u00e4n konsolilla: mysql -u root -p<\/p>\n\n\n\n<p>Tee tietokanta foorumdb ja sille k\u00e4ytt\u00e4j\u00e4 dbhemmo. Aseta my\u00f6s k\u00e4ytt\u00e4j\u00e4lle salasana, t\u00e4ss\u00e4 k\u00e4ytettiin salasanaa mekaanikko.<\/p>\n\n\n\n<figure class=\"wp-block-gallery columns-1 is-cropped\"><ul class=\"blocks-gallery-grid\"><li class=\"blocks-gallery-item\"><figure><a href=\"http:\/\/tietokanta.dy.fi\/linux\/wp-content\/uploads\/2020\/11\/phpbb3_tietokanta-1.gif\"><img loading=\"lazy\" width=\"875\" height=\"263\" src=\"http:\/\/tietokanta.dy.fi\/linux\/wp-content\/uploads\/2020\/11\/phpbb3_tietokanta-1.gif\" alt=\"\" data-id=\"485\" data-link=\"http:\/\/tietokanta.dy.fi\/linux\/index.php\/2020\/09\/22\/phpbb3-asennus\/phpbb3_tietokanta-1\/\" class=\"wp-image-485\"\/><\/a><\/figure><\/li><\/ul><\/figure>\n\n\n\n<p>Tietokannat voi listata show databases; komennolla<\/p>\n\n\n\n<figure class=\"wp-block-gallery columns-1 is-cropped\"><ul class=\"blocks-gallery-grid\"><li class=\"blocks-gallery-item\"><figure><a href=\"http:\/\/tietokanta.dy.fi\/linux\/wp-content\/uploads\/2020\/11\/tietokannat.gif\"><img loading=\"lazy\" width=\"381\" height=\"183\" src=\"http:\/\/tietokanta.dy.fi\/linux\/wp-content\/uploads\/2020\/11\/tietokannat.gif\" alt=\"\" data-id=\"494\" data-link=\"http:\/\/tietokanta.dy.fi\/linux\/index.php\/2020\/09\/22\/phpbb3-asennus\/tietokannat\/\" class=\"wp-image-494\"\/><\/a><\/figure><\/li><\/ul><\/figure>\n\n\n\n<p>Seuraavaksi avataan nettiselain ja avataan sivu serverin ip osoitteelta<\/p>\n\n\n\n<figure class=\"wp-block-gallery columns-1 is-cropped\"><ul class=\"blocks-gallery-grid\"><li class=\"blocks-gallery-item\"><figure><a href=\"http:\/\/tietokanta.dy.fi\/linux\/wp-content\/uploads\/2020\/11\/phpbb3_asennus.gif\"><img loading=\"lazy\" width=\"1021\" height=\"384\" src=\"http:\/\/tietokanta.dy.fi\/linux\/wp-content\/uploads\/2020\/11\/phpbb3_asennus.gif\" alt=\"\" data-id=\"467\" data-link=\"http:\/\/tietokanta.dy.fi\/linux\/index.php\/2020\/09\/22\/phpbb3-asennus\/phpbb3_asennus\/\" class=\"wp-image-467\"\/><\/a><\/figure><\/li><\/ul><\/figure>\n\n\n\n<p>Klikataan INSTALL v\u00e4lilehte\u00e4 ja avautuu seuraava sivu<\/p>\n\n\n\n<figure class=\"wp-block-gallery columns-1 is-cropped\"><ul class=\"blocks-gallery-grid\"><li class=\"blocks-gallery-item\"><figure><a href=\"http:\/\/tietokanta.dy.fi\/linux\/wp-content\/uploads\/2020\/11\/phpbb3_asennus1-1.gif\"><img loading=\"lazy\" width=\"1022\" height=\"559\" src=\"http:\/\/tietokanta.dy.fi\/linux\/wp-content\/uploads\/2020\/11\/phpbb3_asennus1-1.gif\" alt=\"\" data-id=\"472\" data-link=\"http:\/\/tietokanta.dy.fi\/linux\/index.php\/2020\/09\/22\/phpbb3-asennus\/phpbb3_asennus1-1\/\" class=\"wp-image-472\"\/><\/a><\/figure><\/li><\/ul><\/figure>\n\n\n\n<p>Defaulttina kansioiden oikeustasot eiv\u00e4t riit\u00e4 asennukseen, joten ne t\u00e4ytyy konfiguroida.<\/p>\n\n\n\n<figure class=\"wp-block-gallery columns-1 is-cropped\"><ul class=\"blocks-gallery-grid\"><li class=\"blocks-gallery-item\"><figure><a href=\"http:\/\/tietokanta.dy.fi\/linux\/wp-content\/uploads\/2020\/11\/phpbb3_asennus2-1.gif\"><img loading=\"lazy\" width=\"1024\" height=\"485\" src=\"http:\/\/tietokanta.dy.fi\/linux\/wp-content\/uploads\/2020\/11\/phpbb3_asennus2-1.gif\" alt=\"\" data-id=\"473\" data-link=\"http:\/\/tietokanta.dy.fi\/linux\/index.php\/2020\/09\/22\/phpbb3-asennus\/phpbb3_asennus2-1\/\" class=\"wp-image-473\"\/><\/a><\/figure><\/li><\/ul><\/figure>\n\n\n\n<p>Muutetaan oikeustasoja filezillan kautta seuraavasti<\/p>\n\n\n\n<figure class=\"wp-block-gallery columns-1 is-cropped\"><ul class=\"blocks-gallery-grid\"><li class=\"blocks-gallery-item\"><figure><a href=\"http:\/\/tietokanta.dy.fi\/linux\/wp-content\/uploads\/2020\/11\/filezilla_atribuutit.gif\"><img loading=\"lazy\" width=\"286\" height=\"468\" src=\"http:\/\/tietokanta.dy.fi\/linux\/wp-content\/uploads\/2020\/11\/filezilla_atribuutit.gif\" alt=\"\" data-id=\"474\" data-link=\"http:\/\/tietokanta.dy.fi\/linux\/index.php\/2020\/09\/22\/phpbb3-asennus\/filezilla_atribuutit\/\" class=\"wp-image-474\"\/><\/a><\/figure><\/li><\/ul><\/figure>\n\n\n\n<p>Oikeustason muuttaminen konsolen kautta<\/p>\n\n\n\n<figure class=\"wp-block-gallery columns-1 is-cropped\"><ul class=\"blocks-gallery-grid\"><li class=\"blocks-gallery-item\"><figure><a href=\"http:\/\/tietokanta.dy.fi\/linux\/wp-content\/uploads\/2020\/11\/konsolilla_atribuuttien_muuttaminen-1.gif\"><img loading=\"lazy\" width=\"531\" height=\"18\" src=\"http:\/\/tietokanta.dy.fi\/linux\/wp-content\/uploads\/2020\/11\/konsolilla_atribuuttien_muuttaminen-1.gif\" alt=\"\" data-id=\"489\" data-link=\"http:\/\/tietokanta.dy.fi\/linux\/index.php\/2020\/09\/22\/phpbb3-asennus\/konsolilla_atribuuttien_muuttaminen-1\/\" class=\"wp-image-489\"\/><\/a><\/figure><\/li><\/ul><\/figure>\n\n\n\n<p>Oikeustasojen muuttamisen j\u00e4lkeen p\u00e4\u00e4st\u00e4\u00e4n asettamaan tietokannan nimi, k\u00e4ytt\u00e4j\u00e4 ja salasana.<\/p>\n\n\n\n<figure class=\"wp-block-gallery columns-1 is-cropped\"><ul class=\"blocks-gallery-grid\"><li class=\"blocks-gallery-item\"><figure><a href=\"http:\/\/tietokanta.dy.fi\/linux\/wp-content\/uploads\/2020\/11\/phpbb3_asennus3.gif\"><img loading=\"lazy\" width=\"1024\" height=\"456\" src=\"http:\/\/tietokanta.dy.fi\/linux\/wp-content\/uploads\/2020\/11\/phpbb3_asennus3.gif\" alt=\"\" data-id=\"477\" data-link=\"http:\/\/tietokanta.dy.fi\/linux\/index.php\/2020\/09\/22\/phpbb3-asennus\/phpbb3_asennus3\/\" class=\"wp-image-477\"\/><\/a><\/figure><\/li><\/ul><\/figure>\n\n\n\n<p>Seuraavaksi tehd\u00e4\u00e4n foorumin admin k\u00e4ytt\u00e4j\u00e4 ja asetetaan sille salasana.<\/p>\n\n\n\n<figure class=\"wp-block-gallery columns-1 is-cropped\"><ul class=\"blocks-gallery-grid\"><li class=\"blocks-gallery-item\"><figure><a href=\"http:\/\/tietokanta.dy.fi\/linux\/wp-content\/uploads\/2020\/11\/phpbb3_asennus4.gif\"><img loading=\"lazy\" width=\"769\" height=\"457\" src=\"http:\/\/tietokanta.dy.fi\/linux\/wp-content\/uploads\/2020\/11\/phpbb3_asennus4.gif\" alt=\"\" data-id=\"478\" data-link=\"http:\/\/tietokanta.dy.fi\/linux\/index.php\/2020\/09\/22\/phpbb3-asennus\/phpbb3_asennus4\/\" class=\"wp-image-478\"\/><\/a><\/figure><\/li><\/ul><\/figure>\n\n\n\n<p>Seuraavaksi katsotaan serverin peruskonfiguraatiot<\/p>\n\n\n\n<figure class=\"wp-block-gallery columns-1 is-cropped\"><ul class=\"blocks-gallery-grid\"><li class=\"blocks-gallery-item\"><figure><a href=\"http:\/\/tietokanta.dy.fi\/linux\/wp-content\/uploads\/2020\/11\/phpbb3_asennus5-1.gif\"><img loading=\"lazy\" width=\"1022\" height=\"638\" src=\"http:\/\/tietokanta.dy.fi\/linux\/wp-content\/uploads\/2020\/11\/phpbb3_asennus5-1.gif\" alt=\"\" data-id=\"487\" data-link=\"http:\/\/tietokanta.dy.fi\/linux\/index.php\/2020\/09\/22\/phpbb3-asennus\/phpbb3_asennus5-1\/\" class=\"wp-image-487\"\/><\/a><\/figure><\/li><\/ul><\/figure>\n\n\n\n<figure class=\"wp-block-gallery columns-1 is-cropped\"><ul class=\"blocks-gallery-grid\"><li class=\"blocks-gallery-item\"><figure><a href=\"http:\/\/tietokanta.dy.fi\/linux\/wp-content\/uploads\/2020\/11\/phpbb3_asennus6.gif\"><img loading=\"lazy\" width=\"1023\" height=\"677\" src=\"http:\/\/tietokanta.dy.fi\/linux\/wp-content\/uploads\/2020\/11\/phpbb3_asennus6.gif\" alt=\"\" data-id=\"482\" data-link=\"http:\/\/tietokanta.dy.fi\/linux\/index.php\/2020\/09\/22\/phpbb3-asennus\/phpbb3_asennus6\/\" class=\"wp-image-482\"\/><\/a><\/figure><\/li><\/ul><\/figure>\n\n\n\n<figure class=\"wp-block-gallery columns-1 is-cropped\"><ul class=\"blocks-gallery-grid\"><li class=\"blocks-gallery-item\"><figure><a href=\"http:\/\/tietokanta.dy.fi\/linux\/wp-content\/uploads\/2020\/11\/phpbb3_asennus7.gif\"><img loading=\"lazy\" width=\"1023\" height=\"409\" src=\"http:\/\/tietokanta.dy.fi\/linux\/wp-content\/uploads\/2020\/11\/phpbb3_asennus7.gif\" alt=\"\" data-id=\"483\" data-link=\"http:\/\/tietokanta.dy.fi\/linux\/index.php\/2020\/09\/22\/phpbb3-asennus\/phpbb3_asennus7\/\" class=\"wp-image-483\"\/><\/a><\/figure><\/li><\/ul><\/figure>\n\n\n\n<p>Asetuksen j\u00e4lkeen tietokantaan tulee taulukot ja valmistellaan botit ja forum toimintaan.<\/p>\n\n\n\n<figure class=\"wp-block-gallery columns-1 is-cropped\"><ul class=\"blocks-gallery-grid\"><li class=\"blocks-gallery-item\"><figure><a href=\"http:\/\/tietokanta.dy.fi\/linux\/wp-content\/uploads\/2020\/11\/phpbb3_asennus8.gif\"><img loading=\"lazy\" width=\"1022\" height=\"342\" src=\"http:\/\/tietokanta.dy.fi\/linux\/wp-content\/uploads\/2020\/11\/phpbb3_asennus8.gif\" alt=\"\" data-id=\"491\" data-link=\"http:\/\/tietokanta.dy.fi\/linux\/index.php\/2020\/09\/22\/phpbb3-asennus\/phpbb3_asennus8\/\" class=\"wp-image-491\"\/><\/a><\/figure><\/li><\/ul><\/figure>\n\n\n\n<figure class=\"wp-block-gallery columns-1 is-cropped\"><ul class=\"blocks-gallery-grid\"><li class=\"blocks-gallery-item\"><figure><img loading=\"lazy\" width=\"1020\" height=\"378\" src=\"http:\/\/tietokanta.dy.fi\/linux\/wp-content\/uploads\/2020\/11\/phpbb3_asennus9.gif\" alt=\"\" data-id=\"492\" data-link=\"http:\/\/tietokanta.dy.fi\/linux\/index.php\/2020\/09\/22\/phpbb3-asennus\/phpbb3_asennus9\/\" class=\"wp-image-492\"\/><\/figure><\/li><\/ul><\/figure>\n\n\n\n<pre class=\"wp-block-code\"><code><\/code><\/pre>\n\n\n\n<p> <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hae koneellesi tar paketti wget ohjelmalla: wget https:\/\/download.phpbb.com\/pub\/release\/3.3\/3.3.1\/phpBB-3.3.1.tar.bz2 Pura paketti tar -xvf paketinnimi.tar.bz2 Purettu paketti tulee alihakemistoksi Siirr\u00e4 kansion sis\u00e4lt\u00f6 filezilla ohjelmalla palvelimelle Siirron j\u00e4lkeen tee tietokanta phpbb:lle seuraavasti. Kirjaudu mysql:\u00e4\u00e4n konsolilla: mysql -u root -p Tee tietokanta foorumdb ja sille k\u00e4ytt\u00e4j\u00e4 dbhemmo. Aseta my\u00f6s k\u00e4ytt\u00e4j\u00e4lle salasana, t\u00e4ss\u00e4 k\u00e4ytettiin salasanaa mekaanikko. Tietokannat voi listata show &hellip; <a href=\"http:\/\/tietokanta.dy.fi\/linux\/index.php\/2020\/09\/22\/phpbb3-asennus\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">PhpBB3 asennus<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"http:\/\/tietokanta.dy.fi\/linux\/index.php\/wp-json\/wp\/v2\/posts\/354"}],"collection":[{"href":"http:\/\/tietokanta.dy.fi\/linux\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/tietokanta.dy.fi\/linux\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/tietokanta.dy.fi\/linux\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/tietokanta.dy.fi\/linux\/index.php\/wp-json\/wp\/v2\/comments?post=354"}],"version-history":[{"count":12,"href":"http:\/\/tietokanta.dy.fi\/linux\/index.php\/wp-json\/wp\/v2\/posts\/354\/revisions"}],"predecessor-version":[{"id":495,"href":"http:\/\/tietokanta.dy.fi\/linux\/index.php\/wp-json\/wp\/v2\/posts\/354\/revisions\/495"}],"wp:attachment":[{"href":"http:\/\/tietokanta.dy.fi\/linux\/index.php\/wp-json\/wp\/v2\/media?parent=354"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/tietokanta.dy.fi\/linux\/index.php\/wp-json\/wp\/v2\/categories?post=354"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/tietokanta.dy.fi\/linux\/index.php\/wp-json\/wp\/v2\/tags?post=354"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}