Created
March 14, 2019 10:30
-
-
Save emilfolino/b717f6618a72c8943475d45b0ccfd521 to your computer and use it in GitHub Desktop.
log-gui-main.ansi
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [0;30;42m>>> ======= GUI Inspect =======[0m | |
| Thu Mar 14 11:26:22 CET 2019 | |
| algn18 kmom06 | |
| download, docker | |
| Inspect GUI v1.3.1 (2019-03-12) | |
| http://www.student.bth.se/~algn18/dbwebb-kurser/databas/me/redovisa | |
| [0;30;42m>>> ======= Feedback =======[0m | |
| Då tar vi kmom06, det sista innan examinationen. | |
| Jag kör en dbwebb inspect. | |
| Jag läser igenom redovisningstexten. | |
| Jag tittar över din eshop så att den uppfyller kraven från uppgiften. | |
| Oavsett vad, när du nått så här långt så är du riktigt nära. Bra gjort. | |
| // Emil ([email protected]) | |
| [32;01m---> Vanliga feedbacksvar[0m | |
| FIX. Du har valideringsfel som gör att det inte går att rätta din inlämning. Kör dbwebb update följt av dbwebb inspect och laga felen. | |
| FIX. Din databasdump saknar lagrade procedurer, se https://dbwebb.se/t/8371. Uppdatera din backup.sql så kör vi igen. | |
| KOMMENTAR. Länken eshop/index fungerade inte (enligt uppgiften), men det löste sig. Tänk dock att ibland är det väldigt viktigt att följa uppgiftens spec. | |
| FIX. Du har mixat små och stora bokstäver i din SQL-kod. Vår kodstandard säger bara små bokstäver, se forumet: https://dbwebb.se/t/8379. Uppdatera din kod, var konsistent i användandet av små och stora bokstäver och undvik stora bokstäver. | |
| FIX. Dina databas-funktioner har inte karaktäristik angiven så de går inte att ladda från backup-filen. Se forumet: https://dbwebb.se/t/8419. Uppdatera dina funktioner med karaktäristik och skapa en ny backupfil. | |
| Executing: mysql -udbwebb eshop < me/kmom06/eshop2/sql/eshop/backup.sql | |
| ERROR 1418 (HY000) at line XXX: This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration a | |
| nd binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable) | |
| [0;30;42m>>> ======= Download (and potato) =======[0m | |
| Doing a silent download, potatoe if needed. | |
| [0;30;42m>>> ======= Docker Run Extra (pre) =======[0m | |
| >>> -------------- Pre inspect ------------------------- | |
| Open localhost:1337/eshop/index in browser | |
| [0;30;42m>>> ======= dbwebb inspect =======[0m | |
| Do dbwebb inspect in the background and write output to logfile 'log-gui-inspect.ansi'. | |
| [0;30;42m>>> ======= Docker Run Extra =======[0m | |
| make docker-run-server container="server" what="bash .dbwebb/script/inspect/kmom.d/run.bash $kmom" | |
| [32;01m---> Run --service-ports container= with what= one off command.[0m | |
| [ ! -f docker-compose.yaml ] || docker-compose -f docker-compose.yaml run --service-ports server bash .dbwebb/script/inspect/kmom.d/run.bash kmom06 | |
| Pulling server (dbwebb/courserepo:cli)... | |
| cli: Pulling from dbwebb/courserepo | |
| >>> -------------- Start ------------------------- | |
| >>> Running all scripts in '/home/dbwebb/repo/.dbwebb/script/inspect/kmom.d/kmom06'. | |
| >>> -------------- 00_npm-install.bash ------------------------- | |
| Doing a silent 'npm --quiet install' | |
| [0;30;42mOK[0m 00_npm-install.bash | |
| >>> -------------- 01_eshop2-npm-install.bash ------------------------- | |
| Doing a silent 'npm --quiet install' | |
| [0;30;42mOK[0m 01_eshop2-npm-install.bash | |
| >>> -------------- 10_eshop2-config-json.bash ------------------------- | |
| total 4 | |
| -rwxrwxrwx 1 dbwebb dbwebb 129 Feb 23 10:22 eshop.json | |
| { | |
| "host": "localhost", | |
| "user": "user", | |
| "password": "pass", | |
| "database": "eshop", | |
| "multipleStatements": true | |
| } | |
| { | |
| "host": "mysql", | |
| "user": "user", | |
| "password": "pass", | |
| "database": "eshop", | |
| "multipleStatements": true, | |
| "port": 3306 | |
| } | |
| [0;30;42mOK[0m 10_eshop2-config-json.bash | |
| >>> -------------- 15_eshop2-ls.bash ------------------------- | |
| . | |
| |-- [-rwxrwxrwx] cli.js | |
| |-- [drwxrwxrwx] config | |
| | `-- [drwxrwxrwx] db | |
| | |-- [-rwxrwxrwx] eshop.json | |
| | `-- [-rwxr-xr-x] eshop_.json | |
| |-- [-rwxrwxrwx] gulpfile.js | |
| |-- [-rwxrwxrwx] index.js | |
| |-- [-rwxrwxrwx] package-lock.json | |
| |-- [-rwxrwxrwx] package.json | |
| |-- [drwxrwxrwx] public | |
| | |-- [drwxrwxrwx] css | |
| | | `-- [-rwxrwxrwx] main.min.css | |
| | `-- [drwxrwxrwx] js | |
| | |-- [-rwxrwxrwx] editHandler.js | |
| | `-- [-rwxrwxrwx] orderHandler.js | |
| |-- [drwxrwxrwx] router | |
| | |-- [-rwxrwxrwx] all.js | |
| | |-- [-rwxrwxrwx] api.js | |
| | |-- [-rwxrwxrwx] eshop.js | |
| | `-- [-rwxrwxrwx] root.js | |
| |-- [drwxrwxrwx] sql | |
| | |-- [drwxrwxrwx] csv | |
| | | |-- [-rwxrwxrwx] kategori.csv | |
| | | |-- [-rwxrwxrwx] kund.csv | |
| | | |-- [-rwxrwxrwx] lager.csv | |
| | | |-- [-rwxrwxrwx] produkt.csv | |
| | | |-- [-rwxrwxrwx] produkt2kategori.csv | |
| | | `-- [-rwxrwxrwx] produkt2lager.csv | |
| | `-- [drwxrwxrwx] eshop | |
| | |-- [-rwxrwxrwx] backup.sql | |
| | |-- [-rwxrwxrwx] backupOLD.sql | |
| | |-- [-rwxrwxrwx] ddl.sql | |
| | |-- [-rwxrwxrwx] functions.sql | |
| | |-- [-rwxrwxrwx] insert.sql | |
| | |-- [-rwxrwxrwx] manual_insert.sql | |
| | |-- [-rwxrwxrwx] procedures.sql | |
| | `-- [-rwxrwxrwx] setup.sql | |
| |-- [drwxrwxrwx] src | |
| | |-- [drwxrwxrwx] less | |
| | | `-- [-rwxrwxrwx] main.less | |
| | |-- [drwxrwxrwx] sql | |
| | | `-- [-rwxrwxrwx] eshop.js | |
| | `-- [-rwxrwxrwx] tableify.js | |
| `-- [drwxrwxrwx] views | |
| `-- [drwxrwxrwx] eshop | |
| |-- [-rwxrwxrwx] about.ejs | |
| |-- [-rwxrwxrwx] category.ejs | |
| |-- [-rwxrwxrwx] createOrder.ejs | |
| |-- [-rwxrwxrwx] customer.ejs | |
| |-- [drwxrwxrwx] includes | |
| | |-- [-rwxrwxrwx] menu.ejs | |
| | `-- [-rwxrwxrwx] meta.ejs | |
| |-- [-rwxrwxrwx] index.ejs | |
| |-- [-rwxrwxrwx] log.ejs | |
| |-- [-rwxrwxrwx] order.ejs | |
| |-- [-rwxrwxrwx] orderDetails.ejs | |
| `-- [-rwxrwxrwx] product.ejs | |
| 15 directories, 42 files | |
| [0;30;42mOK[0m 15_eshop2-ls.bash | |
| >>> -------------- 20_dbwebb-load-database.bash ------------------------- | |
| OM PROBLEM: | |
| 1. ERROR 1231 (42000) at line 179: Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER' | |
| https://dbwebb.se/t/8381 | |
| Executing: mysql -udbwebb < example/sql/inspect/setup_eshop.sql | |
| ERROR 2005 (HY000): Unknown MySQL server host 'mysql' (-2) | |
| Executing: mysql -udbwebb eshop < me/kmom06/eshop2/sql/eshop/backup.sql | |
| ERROR 2005 (HY000): Unknown MySQL server host 'mysql' (-2) | |
| [0;37;41mFAILED[0m 20_dbwebb-load-database.bash | |
| >>> -------------- 30_eshop2-index-run.bash ------------------------- | |
| FÖLJANDE SKALL FUNGERA via localhost:1337 | |
| ---------------------- | |
| eshop/index - Välkomstsida, gemensam header footer och navigering | |
| eshop/about - Namn på de som jobbat i gruppen | |
| eshop/customer - Visa kunder | |
| eshop/order - Översikt av ordrar | |
| CRUD för att skapa order, orderrader och beställa order. | |
| Tydligt visa att orderns status ändras. | |
| (servern startas i bakgrunden och dödas senare) | |
| (var med på att utskrift från servern krockar med annan utskrift) | |
| Press enter to continue...[32mWebserver is online![39m | |
| (node:69) UnhandledPromiseRejectionWarning: Error: getaddrinfo ENOTFOUND mysql mysql:3306 | |
| at GetAddrInfoReqWrap.onlookup [as oncomplete] (dns.js:57:26) | |
| -------------------- | |
| at Protocol._enqueue (/home/dbwebb/repo/me/kmom06/eshop2/node_modules/mysql/lib/protocol/Protocol.js:144:48) | |
| at Protocol.handshake (/home/dbwebb/repo/me/kmom06/eshop2/node_modules/mysql/lib/protocol/Protocol.js:51:23) | |
| at Connection.connect (/home/dbwebb/repo/me/kmom06/eshop2/node_modules/mysql/lib/Connection.js:118:18) | |
| at connect (/home/dbwebb/repo/me/kmom06/eshop2/node_modules/promise-mysql/lib/connection.js:18:33) | |
| at /home/dbwebb/repo/me/kmom06/eshop2/node_modules/promise-mysql/lib/connection.js:52:9 | |
| at Promise._execute (/home/dbwebb/repo/me/kmom06/eshop2/node_modules/bluebird/js/release/debuggability.js:313:9) | |
| at Promise._resolveFromExecutor (/home/dbwebb/repo/me/kmom06/eshop2/node_modules/bluebird/js/release/promise.js:483:18) | |
| at new Promise (/home/dbwebb/repo/me/kmom06/eshop2/node_modules/bluebird/js/release/promise.js:79:10) | |
| at new connection (/home/dbwebb/repo/me/kmom06/eshop2/node_modules/promise-mysql/lib/connection.js:51:12) | |
| at Object.exports.createConnection (/home/dbwebb/repo/me/kmom06/eshop2/node_modules/promise-mysql/index.js:6:12) | |
| at /home/dbwebb/repo/me/kmom06/eshop2/src/sql/eshop.js:73:22 | |
| at Object.<anonymous> (/home/dbwebb/repo/me/kmom06/eshop2/src/sql/eshop.js:84:3) | |
| at Module._compile (internal/modules/cjs/loader.js:689:30) | |
| at Object.Module._extensions..js (internal/modules/cjs/loader.js:700:10) | |
| at Module.load (internal/modules/cjs/loader.js:599:32) | |
| at tryModuleLoad (internal/modules/cjs/loader.js:538:12) | |
| (node:69) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). (rejection id: 1) | |
| (node:69) [DEP0018] DeprecationWarning: Unhandled promise rejections are deprecated. In the future, promise rejections that are not handled will terminate the Node.js process with a non-zero exit code. | |
| [0;30;42mOK[0m 30_eshop2-index-run.bash | |
| >>> -------------- 40_eshop2-cli-run.bash ------------------------- | |
| FÖLJANDE SKALL FUNGERA | |
| ---------------------- | |
| menu - Visa en meny | |
| about - Visa namnet på de i gruppen | |
| order <search> - Visa samtliga (eller matchande) ordrar | |
| picklist <order_id> - Skapa en plocklista för en order | |
| ship <order_id> - Skeppa/skicka en order | |
| exit - Avsluta | |
| ESHOP1 | |
| log <number> - Visa visst antal senaste rader i loggtabellen | |
| shelf - Översikt av lagrets alla hyllor | |
| inventory - Visa vilka produkter som finns i lagret | |
| inventory <str> - Filtrera utskriften | |
| invadd <productid> <shelf> <number> - Lägg ett antal av produkterna på en hylla i lagret. | |
| invdel <productid> <shelf> <number> - Plocka bort ett antal av produkterna på en hylla i lagret. | |
| (node:83) UnhandledPromiseRejectionWarning: Error: getaddrinfo ENOTFOUND mysql mysql:3306 | |
| at GetAddrInfoReqWrap.onlookup [as oncomplete] (dns.js:57:26) | |
| -------------------- | |
| at Protocol._enqueue (/home/dbwebb/repo/me/kmom06/eshop2/node_modules/mysql/lib/protocol/Protocol.js:144:48) | |
| at Protocol.handshake (/home/dbwebb/repo/me/kmom06/eshop2/node_modules/mysql/lib/protocol/Protocol.js:51:23) | |
| at Connection.connect (/home/dbwebb/repo/me/kmom06/eshop2/node_modules/mysql/lib/Connection.js:118:18) | |
| at connect (/home/dbwebb/repo/me/kmom06/eshop2/node_modules/promise-mysql/lib/connection.js:18:33) | |
| at /home/dbwebb/repo/me/kmom06/eshop2/node_modules/promise-mysql/lib/connection.js:52:9 | |
| at Promise._execute (/home/dbwebb/repo/me/kmom06/eshop2/node_modules/bluebird/js/release/debuggability.js:313:9) | |
| at Promise._resolveFromExecutor (/home/dbwebb/repo/me/kmom06/eshop2/node_modules/bluebird/js/release/promise.js:483:18) | |
| at new Promise (/home/dbwebb/repo/me/kmom06/eshop2/node_modules/bluebird/js/release/promise.js:79:10) | |
| at new connection (/home/dbwebb/repo/me/kmom06/eshop2/node_modules/promise-mysql/lib/connection.js:51:12) | |
| at Object.exports.createConnection (/home/dbwebb/repo/me/kmom06/eshop2/node_modules/promise-mysql/index.js:6:12) | |
| at /home/dbwebb/repo/me/kmom06/eshop2/src/sql/eshop.js:73:22 | |
| at Object.<anonymous> (/home/dbwebb/repo/me/kmom06/eshop2/src/sql/eshop.js:84:3) | |
| at Module._compile (internal/modules/cjs/loader.js:689:30) | |
| at Object.Module._extensions..js (internal/modules/cjs/loader.js:700:10) | |
| at Module.load (internal/modules/cjs/loader.js:599:32) | |
| at tryModuleLoad (internal/modules/cjs/loader.js:538:12) | |
| (node:83) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). (rejection id: 1) | |
| (node:83) [DEP0018] DeprecationWarning: Unhandled promise rejections are deprecated. In the future, promise rejections that are not handled will terminate the Node.js process with a non-zero exit code. | |
| [0;30;42mOK[0m 40_eshop2-cli-run.bash | |
| >>> -------------- 50_express-sql-bash.bash ------------------------- | |
| Do manual stuff, if needed (write exit to exit)? | |
| total 200 | |
| -rwxrwxrwx 1 dbwebb dbwebb 3113 Mar 7 12:21 cli.js | |
| drwxrwxrwx 3 dbwebb dbwebb 96 Mar 4 13:24 config | |
| -rwxrwxrwx 1 dbwebb dbwebb 446 Feb 27 23:16 gulpfile.js | |
| -rwxrwxrwx 1 dbwebb dbwebb 865 Mar 14 10:05 index.js | |
| drwxr-xr-x 479 dbwebb dbwebb 15328 Mar 14 10:27 node_modules | |
| -rwxrwxrwx 1 dbwebb dbwebb 186384 Mar 14 10:27 package-lock.json | |
| -rwxrwxrwx 1 dbwebb dbwebb 680 Mar 6 14:30 package.json | |
| drwxrwxrwx 4 dbwebb dbwebb 128 Mar 4 13:24 public | |
| drwxrwxrwx 6 dbwebb dbwebb 192 Mar 4 13:24 router | |
| drwxrwxrwx 4 dbwebb dbwebb 128 Mar 4 13:24 sql | |
| drwxrwxrwx 5 dbwebb dbwebb 160 Mar 4 13:24 src | |
| drwxrwxrwx 3 dbwebb dbwebb 96 Mar 7 12:24 views | |
| ]0;dbwebb@fb27bb30b9ec: ~/repo/me/kmom06/eshop2dbwebb@fb27bb30b9ec:~/repo/me/kmom06/eshop2$ ^C | |
| ]0;dbwebb@fb27bb30b9ec: ~/repo/me/kmom06/eshop2dbwebb@fb27bb30b9ec:~/repo/me/kmom06/eshop2$ ^C | |
| ]0;dbwebb@fb27bb30b9ec: ~/repo/me/kmom06/eshop2dbwebb@fb27bb30b9ec:~/repo/me/kmom06/eshop2$ ^C | |
| ]0;dbwebb@fb27bb30b9ec: ~/repo/me/kmom06/eshop2dbwebb@fb27bb30b9ec:~/repo/me/kmom06/eshop2$ ^C | |
| ]0;dbwebb@fb27bb30b9ec: ~/repo/me/kmom06/eshop2dbwebb@fb27bb30b9ec:~/repo/me/kmom06/eshop2$ ^C | |
| ]0;dbwebb@fb27bb30b9ec: ~/repo/me/kmom06/eshop2dbwebb@fb27bb30b9ec:~/repo/me/kmom06/eshop2$ ^C | |
| ]0;dbwebb@fb27bb30b9ec: ~/repo/me/kmom06/eshop2dbwebb@fb27bb30b9ec:~/repo/me/kmom06/eshop2$ ^C | |
| ]0;dbwebb@fb27bb30b9ec: ~/repo/me/kmom06/eshop2dbwebb@fb27bb30b9ec:~/repo/me/kmom06/eshop2$ ^C | |
| ]0;dbwebb@fb27bb30b9ec: ~/repo/me/kmom06/eshop2dbwebb@fb27bb30b9ec:~/repo/me/kmom06/eshop2$ exit | |
| exit | |
| [0;37;41mFAILED[0m 50_express-sql-bash.bash | |
| >>> -------------- 60_express-sql-kill-server.bash ------------------------- | |
| [0;30;42mOK[0m 60_express-sql-kill-server.bash | |
| [1;37;40mDONE[0m All scripts were executed. | |
| >>> -------------- Summary ------------------------- | |
| [0;30;42mOK[0m 00_npm-install.bash | |
| [0;30;42mOK[0m 01_eshop2-npm-install.bash | |
| [0;30;42mOK[0m 10_eshop2-config-json.bash | |
| [0;30;42mOK[0m 15_eshop2-ls.bash | |
| [0;37;41mFAILED[0m 20_dbwebb-load-database.bash | |
| [0;30;42mOK[0m 30_eshop2-index-run.bash | |
| [0;30;42mOK[0m 40_eshop2-cli-run.bash | |
| [0;37;41mFAILED[0m 50_express-sql-bash.bash | |
| [0;30;42mOK[0m 60_express-sql-kill-server.bash | |
| [0;30;42m>>> ======= Docker Run Extra (post) =======[0m | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment