1 a2enmod cgi 2 cd /var/www 3 ls -al 4 scp -r -p 5802 pi@renjie.rocks:/mnt/sandisk/Temp/mapserver . 5 scp -r -P 5802 pi@renjie.rocks:/mnt/sandisk/Temp/mapserver . 6 ls-al 7 ls -al 8 cd mapserver/ 9 ls -al 10 cd cgi-bin/ 11 ls -al 12 cd .. 13 ls -al 14 nano /etc/ld.so.conf.d/mapserver.conf 15 ldconfig 16 ldd cgi-bin/mapserv.cgi 17 cat /etc/os-release 18 cgi-bin/mapserv.cgi -v 19 ls -al 20 cd cgi-bin/ 21 ls -al 22 cd . 23 cd .. 24 ls -al 25 ldd ./mapserver_lib/mapserv.cgi 26 cp ./mapserver_lib/mapserv.cgi cgi-bin/mapserv.cgi 27 ldd cgi-bin/mapserv.cgi 28 cgi-bin/mapserv.cgi -v 29 ls -al cgi-bin/mapserv.cgi 30 ls -al 31 ls -al php_mapscript.so 32 updatedb 33 which php 34 locate php.ini 35 cd .. 36 ls -al 37 nano index.php 38 nano /etc/apache2/sites-available/000-default.conf 39 nano /etc/apache2/apache2.conf 40 service apache2 restart 41 ifconfig 42 cd ~/Share/ 43 ls -al 44 cd php-5.4.39 45 ls -al /usr/local/apache2/bin/ 46 which apache2 47 locate apxs 48 apt-get install apache2-dev 49 updatedb 50 locate apx 51 make clean 52 ./configure --with-regex=system --with-mysql --with-apxs2=/usr/bin/apxs2 53 php -v 54 cp php.ini-development /usr/local/lib/php.ini 55 updatedb 56 locate libphp 57 service apache2 restart 58 a2dismod mpm_event 59 service apache2 restart 60 a2enmod mpm_prefork 61 service apache2 restart 62 nano /etc/apache2/apache2.conf 63 nano /etc/apache2/mods-available/lo 64 nano /etc/apache2/apache2.conf 65 service apache2 restart 66 nano /etc/apache2/apache2.conf 67 tail -n 100 /var/log/apache2/error.log 68 nano /etc/apache2/apache2.conf 69 nan /var/www/index.php 70 nano /var/www/index.php 71 php /var/www/index.php 72 nano /etc/apache2/apache2.conf 73 service apache2 restart 74 ls -al 75 cd .. 76 cd ma 77 cd /var/www/mapserver/ 78 ls -al 79 pwd 80 ls -al /var/www/mapserver/php_mapscript.so 81 ldd /var/www/mapserver/php_mapscript.so 82 updatedb ; 83 locate php.ini 84 ls -al /var/www/mapserver/php_mapscript.so 85 nano /usr/local/lib/php.ini 86 service apache2 restart 87 nano /etc/apache2/apache2.conf 88 nano /etc/apache2/sites-available/000-default.conf 89 cd .. 90 mv index.php phpinfo.php 91 history 92 exit 93 mkdir ~/Share; 94 cd ~/Share; 95 apt-get update && apt-get install -y libxml2-dev mariadb-server locate nano wget curl git net-tools iputils-ping sudo gnupg2 default-libmysqlclient-dev; 96 apt-get install -y gcc 97 mysql -u root; 98 use mysql; 99 update user set plugin='' where User='root'; 100 flush privileges; 101 SET PASSWORD FOR 'root'@'localhost' = PASSWORD('password1!'); 102 create user boroger identified by 'password1!'; 103 grant all on *.* to boroger@'%' with grant option; 104 service mysql start 105 mysql -u root; 106 wget https://www.php.net/distributions/php-5.4.39.tar.gz 107 tar zxvf php-5.4.39.tar.gz 108 cd php-5.4.39 109 ./configure --with-regex=system --with-mysql 110 make && make install 111 php -v 112 cd .. 113 apt-get install apache2 114 bash 115 history 116 exit 117 cd ~/Share/ 118 ls -al 119 cd php-5.4.39 120 du -sh . 121 cd .. 122 rm -rf * 123 exit 124 service apache2 start 125 exit 126 cd ~/Share/ 127 ls -al 128 apt install -y libjpeg-dev libpng-dev 129 apt-cache search freet 130 apt-get install libfreetype6 libfreetype6-dev 131 wget https://www.php.net/distributions/php-5.4.39.tar.gz 132 tar zxvf php-5.4.39.tar.gz 133 cd php-5.4.39 134 nano ~/.bashrc 135 source ~/.bashrc 136 sms_when_job_done 137 make clean 138 ./configure --with-regex=system --with-mysql --with-apxs2=/usr/bin/apxs2 --with-gd --enable-gd-native-ttf --with-freetype-dir 139 make && make install && service apache2 restart && service mysql restart && sleep 3 && sms_when_job_done; 140 cd /var/www/mapserver/ 141 cd thematic/ 142 cd htdocs/ 143 ls -al 144 nano a.php 145 mv a.php phpinfo.php 146 scp pi@192.168.1.101:/mnt/sandisk/good_index_20210115_1219.php index.php 147 nano signup.php 148 mysql -uroot -p 149 nano signup.php 150 ls -al 151 nano signup.php 152 mysql -uroot -p 153 nano signup.php 154 tail -n 100 /var/log/apache2/error.log 155 nano signup.php 156 service mysql restart 157 tail -n 100 /var/log/apache2/error.log 158 locate mysql.sock 159 locate mysql 160 tail -n 100 /var/log/mysql/error.log 161 nano signup.php 162 nano test.php 163 php test.php 164 nano test.php 165 php test.php 166 nano test.php 167 php test.php 168 netstat -tnlup 169 nano test.php 170 ping localhost 171 nano test.php 172 ping localhost 173 php test.php 174 nano signup.php 175 nano shanghai.ovf 176 nano shanghai_accumulative.ovf 177 nano shanghai_sameday.ovf 178 cd /var/www/mapserver/thematic/htdocs/../etc/ 179 ls -al 180 rm -rf img/ 181 scp -r pi@192.168.1.1:/mnt/sandisk/img . 182 scp -r pi@192.168.1.101:/mnt/sandisk/img . 183 ls -al 184 cd ../htdocs/ 185 nano signup.php 186 ls -al 187 sed -i 's/jpg/png/' chart.php chart_accumulative.php chart_bar.php chart_pie.php 188 nano chart.php 189 nano chart_bar.php.php 190 nano chart_bar.php 191 sed -i 's/jpg/png/' layer_accumulative.php layer_number.php layer_ratio.php layer_sameday.php 192 cat layer_accumulative.php 193 clear 194 nano chart_bar.php 195 nano chart.php 196 nano chart_pie.php 197 nano chart_accumulative.php 198 nano chart_bar.php 199 ls -al 200 ls -aljpgraph 201 ls -al jpgraph 202 cd s 203 ls -al jpgraph/src/ 204 nano chart_bar.php 205 mkdir -p /usr/share/fonts/truetype 206 cd /usr/share/fonts/truetype 207 scp -r pi@192.168.1.101:/mnt/sandisk/simhei.ttf . 208 scp -r pi@192.168.1.101:/mnt/sandisk/verdana* . 209 cd - 210 cd index.php 211 nano index.php 212 ls -al /var/www/mapserver/tmp/719777.png 213 nano index.php 214 nano chart_bar.php 215 cd /var/www 216 ls -al 217 tar czvf mapserver_20210115.tar.gz mapserver/ 218 ls -al 219 scp ./mapserver_20210115.tar.gz pi@192.168.1.101: 220 scp ./mapserver_20210115.tar.gz pi@192.168.1.101:/mnt/sandisk/ 221 cd - 222 ls -al 223 nano chart.php 224 nano index.php 225 nano chart.php 226 nano index.php 227 nano layer_sameday.php 228 ls -al 229 nano shanghai_sameday.ovf 230 nano index.php 231 nano map.php 232 nano index.php 233 nano shanghai_sameday.ovf 234 mysql -uroot -ppassword1! 235 desc shanghai 236* 237 nano shanghai_sameday.ovf 238 ls -al 239 nano shanghai_sameday.ovf 240 nano thematic.map 241 ll 242 ls -la 243 man ll 244 which ll 245 nano layer_sameday.php 246 nano map.php 247 ls -al 248 ls -al shanghai_accumulative.ovf 249 nano shanghai_accumulative.ovf 250 nano shanghai_sameday.ovf 251 nano index.php 252 nano map.php 253 nano layer_sameday.php 254 nano map.php 255 nano -l index.php 256 nano -lslayer_accumulative.php 257 nano -l layer_accumulative.php 258 grep jpg *php 259 service apache2 restart 260 ls -al 261 cat ms_error.txt 262 nano shanghai_sameday.ovf 263 nano index.php 264 nano config.inc.php 265 nano index.php 266 nano map_accumulative.php 267 nano shanghai_sameday.ovf 268 ls -al ../etc/img/shanghai_reference.jpg 269 ls -al ../etc/img/shanghai_reference.* 270 ls -al 271 nano shanghai.ovf 272 nano shanghai_accumulative.ovf.ovf 273 nano shanghai_accumulative.ovf 274 nano thematic.map 275 nano layer_sameday.php 276 nano index.php 277 nano -l index.php 278 mysql -uroot -p 279 nano a 280 echo $LANG 281 locale 282 apt-cache search chinese 283 locale-gen en_US.UTF-8 284 locale 285 nano /etc/default/locale 286 nano index.php 287 cat 288 mysql -uroot -p 289 ls -al 290 cd .. 291 cd ... 292 cd .. 293 ls -al 294 cd thematic/ 295 ls -la 296 cd data/ 297 ls -al 298 locate data.sql 299 scp pi@192.168.1.101:/mnt/sandisk/data.sql . 300 mysql -uroot -p 301 mysql -uroot -p -D gis < data.sql 302 mysql -uroot -p -D gis 303 exit 304 cd /var/www 305 service apache2 start 306 service mysql start 307 cd mapserver/thematic/htdocs/ 308 nano index.php 309 ls -al 310 cat ms_error.txt 311 ls -al 312 rm ms_error.txt 313 ls -al 314 nano layer_accumulative.php 315 nano shanghai_accumulative.ovf 316 nano map.php 317 nano layer_accumulative.php 318 nano map_accumulative.php 319 nano shanghai_accumulative.ovf 320 ls -al 321 nano map_accumulative.php 322 fg 323 nano index.php 324 nano map_accumulative.php 325 ls -al 326 chmod 777 shanghai_accumulative.ovf 327 ls -al 328 cat shanghai_accumulative.ovf 329 nano map_accumulative.php 330 nano thematic.map 331 nano map_accumulative.php 332 nano shanghai_accumulative.ovf 333 nano map_accumulative.php 334 nano shanghai_accumulative.ovf 335 nano index.php 336 nano shanghai_accumulative.ovf 337 nano thematic.map 338 nano map_accumulative.php 339 nano shanghai_accumulative.ovf 340 ls -al 341 nano shanghai_accumulative.ovf 342 nano thematic.map 343 nano index.php 344 ls 0a 345 ls 346 ls -al 347 cat ms_error.txt 348 ls -al 349 clear 350 ls -al 351 nano shanghai_accumulative.ovf 352 nano thematic.map 353 service apache2 restart 354 nano shanghai_accumulative.ovf 355 nano thematic.map 356 nano map_accumulative.php 357 nano -l map_accumulative.php 358 clear 359 ls -al 360 cd .. 361 du -sh /tmp/ 362 du -sh /tmp 363 du -sh /tmp/* 364 cd tmp/ 365 ls -al 366 du -sh 367 rm * 368 cd .. 369 cd thematic/ 370 ls -al 371 cd htdocs/ 372 ls -al 373 nano index.php 374 nano map_accumulative.php 375 nano shanghai_accumulative.ovf 376 rm ms_error.txt 377 ls -al 378 nano thematic.map 379 nano map_accumulative.php 380 nano thematic.map 381 ls -al 382 nano map_accumulative.php 383 nano thematic.map 384 nano signup.php 385 nano map_accumulative.php 386 ls -al 387 nano thematic.map 388 ls -al 389 nano thematic.map 390 nano map_accumulative.php 391 ll 392 nano map_accumulative.php 393 nano thematic.map 394 nano shanghai_accumulative.ovf 395 nano shanghai.ovf 396 cd .. 397 cd . 398 cd .. 399 ls -al 400 cd .. 401 ls -al 402 cd mapserver 403 ls -al 404 cd thematic/ 405 cd htdocs/ 406 cp ../../hello.php . 407 nano hello.php 408 service apache2 restart 409 ls -al 410 cat ms_error.txt 411 rm ms_error.txt 412 ls -al 413 nano thematic.map 414 nano shanghai_accumulative.ovf 415 nano thematic.map 416 nano shanghai_accumulative.ovf 417 mysql -uroot -p 418 nano map_accumulative.php 419 nano shanghai_accumulative.ovf 420 mysql -uroot -p 421 mysql -uroot -p 422 cd .. 423 ls -al 424 cd data 425 ls -la 426 cat data.sql 427 PuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTY6cPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTY6cPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTY6cPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTY6cPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTY6cPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTY6cPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTY6cPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTY6cPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTYPuTTY 428 cp data.sql data.sql.20210115 429 iconv data.sql > data.sql 430 cat data.sql 431 ls -al 432 rm data.sql 433 cp data.sql.20210115 data.sql 434 file data.sql 435* 436 mysql -uroot -ppassword1! -D gis < data.sql 437 mysql -uroot -p 438 desc shanghai; 439 mysql -uroot -ppassword1! -D gis; 440 ls -al 441 mysql -uroot -p 442 scp -P 5802 pi@renjie.rocks:/mnt/sandisk/data*.sql . 443 scp pi@192.168.1.101:/mnt/sandisk/data*.sql . 444 ls 0al 445 ls -al 446 scp pi@192.168.1.101:/mnt/sandisk/data/data*.sql . 447 ls -al 448 mysql -uroot -p -D gis < data.sql 449 mysql -uroot -p -D gis < data2.sql 450 mysql -uroot -p 451 scp pi@192.168.1.101:/mnt/sandisk/data/data*.sql . 452 mysql -uroot -p -D gis < data3.sql 453 mysql -uroot -p 454 scp pi@192.168.1.101:/mnt/sandisk/data/shgb02.xml . 455 ls shgb02.xml 456 ls -al /var/www/mapserver/thematic/data/shgb02.xml 457 mysql -uroot -p 458 load 459 mysql -uroot -p 460 scp pi@192.168.1.101:/mnt/sandisk/data/shgb03.xml . 461 mysql -uroot p 462 mysql -uroot -p 463 scp pi@192.168.1.101:/mnt/sandisk/data/data*.sql . 464 mysql -uroot -p 465 service apache2 restart 466 cd /var/www/mapserver/thematic/htdocs/ 467 ls -al 468 nano index.php 469 tail -n 100 /var/log/mysql/error.log 470 tail -n 100 /var/log/apache2/error.log 471 df 472 tail -n 100 /var/log/apache2/error.log 473 df 474 cd /var/www 475 tar czvf mapserver_20210115_2317.tar.gz mapserver 476 scp mapserver_20210115_2317.tar.gz pi@192.168.1.101:/mnt/sandisk/ 477 mysqldump -uroot -ppassword1! gis > mysql_gis.dump; 478 ls -al 479 scp mysql_gis.dump pi@192.168.1.101:/mnt/sandisk/ 480 history 481 history > history_20210115_mapserver.txt