{"type":"rich","version":"1.0","provider_name":"phorkie","provider_url":"https:\/\/p.cweiske.de\/","title":"opengeodb-installer","author_name":"Anonymous","cache_age":86400,"width":900,"height":900,"html":"<!-- embedding all files of https:\/\/p.cweiske.de\/13 -->\n<link rel=\"stylesheet\" href=\"https:\/\/p.cweiske.de\/css\/embed.css\"\/>\n<div class=\"phork\" id=\"13\">\n    <div class=\"phork-file\">\n <div class=\"phork-content\">\n  <style type=\"text\/css\">\/**\n * GeSHi (C) 2004 - 2007 Nigel McNie, 2007 - 2008 Benny Baumann\n * (http:\/\/qbnz.com\/highlighter\/ and http:\/\/geshi.org\/)\n *\/\n.bash .de1, .bash .de2 {font: normal normal 1em\/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;}\n.bash  {font-family:monospace;}\n.bash .imp {font-weight: bold; color: red;}\n.bash li, .bash .li1 {color: #DDD;}\n.bash .ln {width:1px;text-align:right;margin:0;padding:0 2px;vertical-align:top;}\n.bash .kw1 {color: #000000; font-weight: bold;}\n.bash .kw2 {color: #c20cb9; font-weight: bold;}\n.bash .kw3 {color: #7a0874; font-weight: bold;}\n.bash .co0 {color: #666666; font-style: italic;}\n.bash .co1 {color: #800000;}\n.bash .co2 {color: #cc0000; font-style: italic;}\n.bash .co3 {color: #000000; font-weight: bold;}\n.bash .es1 {color: #000099; font-weight: bold;}\n.bash .es2 {color: #007800;}\n.bash .es3 {color: #007800;}\n.bash .es4 {color: #007800;}\n.bash .es5 {color: #780078;}\n.bash .es_h {color: #000099; font-weight: bold;}\n.bash .br0 {color: #7a0874; font-weight: bold;}\n.bash .sy0 {color: #000000; font-weight: bold;}\n.bash .st0 {color: #ff0000;}\n.bash .st_h {color: #ff0000;}\n.bash .nu0 {color: #000000;}\n.bash .re0 {color: #007800;}\n.bash .re1 {color: #007800;}\n.bash .re2 {color: #007800;}\n.bash .re4 {color: #007800;}\n.bash .re5 {color: #660033;}\n.bash span.xtra { display:block; }\n<\/style><div class=\"code\"><table class=\"bash\"><tbody><tr class=\"li1\"><td class=\"ln\"><pre class=\"de1\">1\n2\n3\n4\n5\n6\n7\n8\n9\n10\n11\n12\n13\n14\n15\n16\n17\n18\n19\n20\n21\n22\n23\n24\n25\n26\n27\n28\n29\n30\n31\n32\n33\n34\n35\n36\n37\n38\n39\n40\n41\n42\n43\n44\n45\n46\n47\n48\n49\n50\n51\n52\n53\n54\n55\n56\n57\n58\n59\n60\n61\n62\n63\n64\n65\n66\n67\n68\n69\n70\n71\n72\n73\n74\n75\n76\n77\n78\n79\n80\n81\n82\n83\n84\n85\n86\n87\n88\n89\n90\n91\n92\n93\n94\n95\n96\n97\n98\n99\n100\n101\n102\n103\n104\n105\n106\n107\n108\n109\n110\n111\n112\n113\n114\n115\n116\n117\n118\n119\n120\n<\/pre><\/td><td class=\"de1\"><pre class=\"de1\"><span class=\"co0\">#!\/bin\/bash<\/span>\n&#160;\n<span class=\"co0\"># - INSTALL instructions:<\/span>\n<span class=\"co0\"># mkdir \/your\/preferred\/path\/opengeodb<\/span>\n<span class=\"co0\"># cd \/your\/preferred\/path\/opengeodb<\/span>\n<span class=\"co0\"># - copy this script to install_opengeodb.sh<\/span>\n<span class=\"co0\"># - make script executable:<\/span>\n<span class=\"co0\"># chmod +x install_opengeodb.sh<\/span>\n<span class=\"co0\"># - edit you mysql credentials<\/span>\n<span class=\"co0\">#<\/span>\n<span class=\"co0\"># IMPORTANT:<\/span>\n<span class=\"co0\"># This script uses wget to retrieve requested files, verify that wget is installed on your system.<\/span>\n<span class=\"co0\">#<\/span>\n<span class=\"co0\"># before you start installing opengeodb you have to download:<\/span>\n<span class=\"co0\"># setup_innodb_geodb.sql from gist https:\/\/gist.github.com\/3942251 in the same directory than this script<\/span>\n<span class=\"co0\"># or<\/span>\n<span class=\"co0\"># setup_myisam_geodb.sql from gist https:\/\/gist.github.com\/3942244 in the same directory than this script<\/span>\n<span class=\"co0\"># and<\/span>\n<span class=\"co0\"># CREATE_ZIP_SQL from gist https:\/\/gist.github.com\/3942008 as create_zip.sql in the same directory than this script<\/span>\n<span class=\"co0\">#<\/span>\n&#160;\n<span class=\"co0\">#<\/span>\n<span class=\"co0\"># start install process:<\/span>\n<span class=\"co0\"># .\/install_opengeodb.sh<\/span>\n&#160;\n<span class=\"co0\"># edit your mysql credentials<\/span>\n<span class=\"re2\">DB<\/span>=dbname\n<span class=\"re2\">DB_USER<\/span>=dbuser\n<span class=\"re2\">DB_PASS<\/span>=xxx\n&#160;\n<span class=\"co0\"># do not touch<\/span>\n<span class=\"re2\">URL<\/span>=http:<span class=\"sy0\">\/\/<\/span>fa-technik.adfc.de<span class=\"sy0\">\/<\/span>code<span class=\"sy0\">\/<\/span>opengeodb<span class=\"sy0\">\/<\/span>\n<span class=\"re2\">ALTER_SQL<\/span>=opengeodb-end.sql\n<span class=\"re2\">EXTRA_SQL<\/span>=extra.sql\n<span class=\"re2\">CREATE_ZIP_SQL<\/span>=create_zip.sql\n<span class=\"co0\"># CREATE_ZIP_SQL from gist https:\/\/gist.github.com\/3942008<\/span>\n&#160;\n<span class=\"kw2\">read<\/span> <span class=\"re5\">-n1<\/span> <span class=\"re5\">-p<\/span> <span class=\"st0\">&quot;This script is installing the opengeodb schema and is importing lot of data. Do you really want to proceed? y|n &quot;<\/span> key\n<span class=\"kw3\">echo<\/span>\n<span class=\"kw1\">case<\/span> <span class=\"re1\">$key<\/span> <span class=\"kw1\">in<\/span>\n<span class=\"st0\">&quot;Y&quot;<\/span> <span class=\"sy0\">|<\/span> <span class=\"st0\">&quot;y&quot;<\/span><span class=\"br0\">&#41;<\/span> <span class=\"kw2\">true<\/span> <span class=\"sy0\">;;<\/span>\n<span class=\"st0\">&quot;N&quot;<\/span> <span class=\"sy0\">|<\/span> <span class=\"st0\">&quot;n&quot;<\/span><span class=\"br0\">&#41;<\/span> <span class=\"kw3\">echo<\/span> <span class=\"st_h\">'Installation aborted'<\/span>; <span class=\"kw3\">exit<\/span><span class=\"sy0\">;;<\/span>\n<span class=\"sy0\">*<\/span><span class=\"br0\">&#41;<\/span> <span class=\"kw3\">exit<\/span>; <span class=\"kw3\">echo<\/span> <span class=\"st_h\">' '<\/span> <span class=\"sy0\">;;<\/span>\n<span class=\"kw1\">esac<\/span>\n&#160;\n<span class=\"kw2\">read<\/span> <span class=\"re5\">-p<\/span> <span class=\"st0\">&quot;Do you want to install a InnoDB or MyISAM driven opengeodb driven schema? [myisam] &quot;<\/span> engine\n<span class=\"kw1\">case<\/span> <span class=\"st0\">&quot;<span class=\"es2\">$engine<\/span>&quot;<\/span> <span class=\"kw1\">in<\/span>\n&#160; &#160; &#160; &#160; innodb<span class=\"br0\">&#41;<\/span> <span class=\"re2\">SCHEMA<\/span>=setup_innodb_geodb.sql\n&#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; <span class=\"kw3\">echo<\/span> <span class=\"st0\">&quot;creating InnoDB opengeodb schema&quot;<\/span>\n&#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; <span class=\"kw3\">echo<\/span> <span class=\"st0\">&quot; &quot;<\/span>\n&#160; &#160; &#160; &#160; <span class=\"sy0\">;;<\/span>\n&#160; &#160; &#160; &#160; <span class=\"sy0\">*<\/span><span class=\"br0\">&#41;<\/span> &#160; &#160; &#160;<span class=\"re2\">SCHEMA<\/span>=setup_myisam_geodb.sql\n&#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; <span class=\"kw3\">echo<\/span> <span class=\"st0\">&quot;creating MyISAM opengeodb schema&quot;<\/span> \n&#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; <span class=\"kw3\">echo<\/span> <span class=\"st0\">&quot; &quot;<\/span>\n&#160; &#160; &#160; &#160; <span class=\"sy0\">;;<\/span>\n<span class=\"kw1\">esac<\/span>\n&#160;\nmysql <span class=\"re5\">-u<\/span> <span class=\"re1\">$DB_USER<\/span> <span class=\"re5\">-p<\/span> <span class=\"re1\">$DB_PASS<\/span> <span class=\"re1\">$DB<\/span> <span class=\"sy0\">&lt;<\/span> <span class=\"re1\">$SCHEMA<\/span>\n&#160;\n<span class=\"kw2\">read<\/span> <span class=\"re5\">-p<\/span> <span class=\"st0\">&quot;Which country data do you want to import? (comma separated) [AT,BE,CH,DE,LI] &quot;<\/span> country\n&#160;\n<span class=\"kw1\">if<\/span> <span class=\"br0\">&#91;<\/span> <span class=\"st0\">&quot;<span class=\"es2\">$country<\/span>&quot;<\/span> == <span class=\"st0\">&quot;&quot;<\/span> <span class=\"br0\">&#93;<\/span>; <span class=\"kw1\">then<\/span>\n&#160; &#160; &#160; &#160; <span class=\"re2\">country<\/span>=<span class=\"st0\">&quot;AT,BE,CH,DE,LI&quot;<\/span>\n<span class=\"kw1\">fi<\/span>\n&#160;\n<span class=\"re2\">IFS<\/span>=<span class=\"st_h\">','<\/span>\n<span class=\"kw1\">for<\/span> sql <span class=\"kw1\">in<\/span> <span class=\"re1\">$country<\/span>\n<span class=\"kw1\">do<\/span>\n&#160; &#160; &#160; &#160; <span class=\"kw3\">echo<\/span> <span class=\"st0\">&quot;downloading <span class=\"es2\">$sql<\/span>.sql&quot;<\/span>\n&#160; &#160; &#160; &#160; <span class=\"kw2\">wget<\/span> <span class=\"re1\">$URL<\/span><span class=\"re1\">$sql<\/span>.sql\n&#160; &#160; &#160; &#160; <span class=\"kw3\">echo<\/span> <span class=\"st0\">&quot;importing <span class=\"es2\">$sql<\/span> data&quot;<\/span>\n&#160; &#160; &#160; &#160; mysql <span class=\"re5\">-u<\/span> <span class=\"re1\">$DB_USER<\/span> <span class=\"re5\">-p<\/span> <span class=\"re1\">$DB_PASS<\/span> <span class=\"re1\">$DB<\/span> <span class=\"sy0\">&lt;<\/span> <span class=\"re1\">$sql<\/span>.sql\n<span class=\"kw1\">done<\/span>\n&#160;\n<span class=\"kw3\">echo<\/span> <span class=\"st0\">&quot;Downloading metadata, creating indices&quot;<\/span>\n<span class=\"kw2\">wget<\/span> <span class=\"re1\">$URL<\/span><span class=\"re1\">$ALTER_SQL<\/span>\n<span class=\"kw3\">echo<\/span> <span class=\"st0\">&quot;Inserting metadata, creating indices&quot;<\/span>\nmysql <span class=\"re5\">-u<\/span> <span class=\"re1\">$DB_USER<\/span> <span class=\"re5\">-p<\/span> <span class=\"re1\">$DB_PASS<\/span> <span class=\"re1\">$DB<\/span> <span class=\"sy0\">&lt;<\/span> <span class=\"re1\">$ALTER_SQL<\/span>\n&#160;\n<span class=\"kw2\">read<\/span> <span class=\"re5\">-p<\/span> <span class=\"st0\">&quot;Do you want to install extra information (H\u00f6henangaben, Kontinente, Daten mit Versionierung etc.)? y|n &quot;<\/span> extra\n<span class=\"kw3\">echo<\/span>\n<span class=\"kw1\">case<\/span> <span class=\"re1\">$extra<\/span> <span class=\"kw1\">in<\/span>\n<span class=\"st0\">&quot;Y&quot;<\/span> <span class=\"sy0\">|<\/span> <span class=\"st0\">&quot;y&quot;<\/span><span class=\"br0\">&#41;<\/span> &#160; &#160; &#160;<span class=\"kw3\">echo<\/span> <span class=\"st0\">&quot;Downloading <span class=\"es2\">$EXTRA_SQL<\/span>&quot;<\/span>\n&#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; <span class=\"kw2\">wget<\/span> <span class=\"re1\">$URL<\/span><span class=\"re1\">$EXTRA_SQL<\/span>\n&#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; <span class=\"kw3\">echo<\/span> <span class=\"st0\">&quot;Inserting extra informations&quot;<\/span>\n&#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; mysql <span class=\"re5\">-u<\/span> <span class=\"re1\">$DB_USER<\/span> <span class=\"re5\">-p<\/span> <span class=\"re1\">$DB_PASS<\/span> <span class=\"re1\">$DB<\/span> <span class=\"sy0\">&lt;<\/span> <span class=\"re1\">$EXTRA_SQL<\/span>\n<span class=\"sy0\">;;<\/span>\n<span class=\"sy0\">*<\/span><span class=\"br0\">&#41;<\/span> &#160; &#160; &#160;<span class=\"kw3\">echo<\/span> <span class=\"st0\">&quot;No extra data will be installed&quot;<\/span>\n<span class=\"sy0\">;;<\/span>\n<span class=\"kw1\">esac<\/span>\n&#160;\n<span class=\"kw2\">read<\/span> <span class=\"re5\">-p<\/span> <span class=\"st0\">&quot;Do you want to install hierachy informations? y|n &quot;<\/span> location\n<span class=\"kw3\">echo<\/span>\n<span class=\"kw1\">case<\/span> <span class=\"re1\">$location<\/span> <span class=\"kw1\">in<\/span>\n<span class=\"st0\">&quot;Y&quot;<\/span> <span class=\"sy0\">|<\/span> <span class=\"st0\">&quot;y&quot;<\/span><span class=\"br0\">&#41;<\/span> &#160; &#160; &#160;<span class=\"kw3\">echo<\/span> <span class=\"st0\">&quot;Downloading hierarchy data for selected countries&quot;<\/span>\n&#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; <span class=\"kw1\">for<\/span> sql <span class=\"kw1\">in<\/span> <span class=\"re1\">$country<\/span>\n&#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; <span class=\"kw1\">do<\/span>\n&#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; <span class=\"kw3\">echo<\/span> <span class=\"st0\">&quot;Downloading <span class=\"es3\">${sql}<\/span>hier.sql&quot;<\/span>\n&#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; <span class=\"kw2\">wget<\/span> <span class=\"re1\">$URL<\/span><span class=\"co1\">${sql}<\/span>hier.sql\n&#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; <span class=\"kw3\">echo<\/span> <span class=\"st0\">&quot;Importing <span class=\"es3\">${sql}<\/span>hier data&quot;<\/span>\n&#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; mysql <span class=\"re5\">-u<\/span> <span class=\"re1\">$DB_USER<\/span> <span class=\"re5\">-p<\/span> <span class=\"re1\">$DB_PASS<\/span> <span class=\"re1\">$DB<\/span> <span class=\"sy0\">&lt;<\/span> <span class=\"co1\">${sql}<\/span>hier.sql\n&#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; <span class=\"kw1\">done<\/span>\n<span class=\"sy0\">;;<\/span>\n<span class=\"sy0\">*<\/span><span class=\"br0\">&#41;<\/span>&#160; &#160; &#160; <span class=\"kw3\">echo<\/span> <span class=\"st0\">&quot;No hierachy data will be installed&quot;<\/span>\n<span class=\"sy0\">;;<\/span>\n<span class=\"kw1\">esac<\/span>\n&#160;\n<span class=\"kw2\">read<\/span> <span class=\"re5\">-p<\/span> <span class=\"st0\">&quot;Do you want to create a single zip table for better radius search? y|n &quot;<\/span> single\n<span class=\"kw3\">echo<\/span>\n<span class=\"kw1\">case<\/span> <span class=\"re1\">$single<\/span> <span class=\"kw1\">in<\/span>\n<span class=\"st0\">&quot;Y&quot;<\/span> <span class=\"sy0\">|<\/span> <span class=\"st0\">&quot;y&quot;<\/span><span class=\"br0\">&#41;<\/span> &#160; &#160; &#160;<span class=\"kw3\">echo<\/span> <span class=\"st0\">&quot;Installing zip table&quot;<\/span>\n&#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; mysql <span class=\"re5\">-u<\/span> <span class=\"re1\">$DB_USER<\/span> <span class=\"re5\">-p<\/span> <span class=\"re1\">$DB_PASS<\/span> <span class=\"re1\">$DB<\/span> <span class=\"sy0\">&lt;<\/span> <span class=\"re1\">$CREATE_ZIP_SQL<\/span>\n<span class=\"sy0\">;;<\/span>\n<span class=\"sy0\">*<\/span><span class=\"br0\">&#41;<\/span> &#160; &#160; &#160;<span class=\"kw3\">echo<\/span> <span class=\"st0\">&quot;No zip table will be installed&quot;<\/span>\n<span class=\"sy0\">;;<\/span>\n<span class=\"kw1\">esac<\/span>\n&#160;\n<span class=\"kw3\">echo<\/span>\n<span class=\"kw3\">echo<\/span> <span class=\"st0\">&quot;Installing opengeodb finished&quot;<\/span>\n<span class=\"kw3\">echo<\/span><\/pre><\/td><\/tr><\/tbody><\/table><\/div>\n <\/div>\n <div class=\"phork-meta\">\n  <a href=\"https:\/\/p.cweiske.de\/13\/rev-raw\/f3065e237787c92498a42768a990902dfd8eb562\/install_opengeodb.sh\" style=\"float: right\">view raw source<\/a>\n  <a href=\"https:\/\/p.cweiske.de\/13#install_opengeodb.sh\">install_opengeodb.sh<\/a>\n <\/div>\n<\/div>\n<\/div>\n"}