Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Topics - efko

Pages: 1 2 [3] 4 5 ... 8
31
Java / MySQL log
« on: 24 August 2020, 11:00:15 »
Beginning configuration step: Writing configuration file

Saving my.ini configuration file...
Saved my.ini configuration file.
Ended configuration step: Writing configuration file

Beginning configuration step: Updating Windows Firewall rules

Adding a Windows Firewall rule for MySQL57 on port 3306.
Attempting to add a Windows Firewall rule with command: netsh.exe advfirewall firewall add rule name="Port 3306" protocol=TCP localport=3306 dir=in action=allow
Ok.


Successfully added the Windows Firewall rule.
Ended configuration step: Updating Windows Firewall rules

Beginning configuration step: Adjusting Windows service

Attempting to grant Network Service require filesystem permissions.
Granted permissions.
Adding new service
New service added
Ended configuration step: Adjusting Windows service

Beginning configuration step: Initializing database (may take a long time)

Deleting the data directory from a previous (failed) configuration...
Attempting to run MySQL Server with --initialize-insecure option...
Starting process for MySQL Server 5.7.30...
Starting process with command: C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.7\my.ini" --console --initialize-insecure=on --lower-case-table-names=1...
2020-08-24T08:57:03.934239Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-08-24T08:57:03.949839Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2020-08-24T08:57:10.700251Z 0 [Warning] InnoDB: New log files created, LSN=45790
2020-08-24T08:57:11.698653Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2020-08-24T08:57:11.979453Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: cc8620a7-e5e7-11ea-989c-002618d7868e.
2020-08-24T08:57:11.995053Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2020-08-24T08:57:16.051061Z 0 [Warning] CA certificate ca.pem is self signed.
2020-08-24T08:57:21.027469Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
Process for mysqld, with ID 2704, was run successfully and exited with code 0.
Successfully started process for MySQL Server 5.7.30.
MySQL Server 5.7.30 intialized the database successfully.
Ended configuration step: Initializing database (may take a long time)

Beginning configuration step: Starting the server

Attempting to start service MySQL57...
Successfully started service MySQL57.
Waiting until a connection to MySQL Server 5.7.30 can be established (with a maximum of 10 attempts)...
Retry 1: Attempting to connect to Mysql@localhost:3306 with user root with no password...
MySQL error 0: Authentication to host 'localhost' for user 'root' using method 'mysql_native_password' failed with message: Reading from the stream has failed.
Waiting 5 seconds before the next connection attempt...
Retry 2: Attempting to connect to Mysql@localhost:3306 with user root with no password...
MySQL error 0: Authentication to host 'localhost' for user 'root' using method 'mysql_native_password' failed with message: Reading from the stream has failed.
Waiting 5 seconds before the next connection attempt...
Retry 3: Attempting to connect to Mysql@localhost:3306 with user root with no password...
MySQL error 0: Authentication to host 'localhost' for user 'root' using method 'mysql_native_password' failed with message: Reading from the stream has failed.
Waiting 5 seconds before the next connection attempt...
Retry 4: Attempting to connect to Mysql@localhost:3306 with user root with no password...
MySQL error 0: Authentication to host 'localhost' for user 'root' using method 'mysql_native_password' failed with message: Reading from the stream has failed.
Waiting 5 seconds before the next connection attempt...
Retry 5: Attempting to connect to Mysql@localhost:3306 with user root with no password...
MySQL error 0: Authentication to host 'localhost' for user 'root' using method 'mysql_native_password' failed with message: Reading from the stream has failed.
Waiting 5 seconds before the next connection attempt...
Retry 6: Attempting to connect to Mysql@localhost:3306 with user root with no password...
MySQL error 0: Authentication to host 'localhost' for user 'root' using method 'mysql_native_password' failed with message: Reading from the stream has failed.
Waiting 5 seconds before the next connection attempt...
Retry 7: Attempting to connect to Mysql@localhost:3306 with user root with no password...
MySQL error 0: Authentication to host 'localhost' for user 'root' using method 'mysql_native_password' failed with message: Reading from the stream has failed.
Waiting 5 seconds before the next connection attempt...
Retry 8: Attempting to connect to Mysql@localhost:3306 with user root with no password...
MySQL error 0: Authentication to host 'localhost' for user 'root' using method 'mysql_native_password' failed with message: Reading from the stream has failed.
Waiting 5 seconds before the next connection attempt...
Retry 9: Attempting to connect to Mysql@localhost:3306 with user root with no password...
MySQL error 0: Authentication to host 'localhost' for user 'root' using method 'mysql_native_password' failed with message: Reading from the stream has failed.
Waiting 5 seconds before the next connection attempt...
Retry 10: Attempting to connect to Mysql@localhost:3306 with user root with no password...
MySQL error 0: Authentication to host 'localhost' for user 'root' using method 'mysql_native_password' failed with message: Reading from the stream has failed.
Failed to connect to MySQL Server 5.7.30 after 10 attempts.

32
Around the world / Epic quotes
« on: 20 August 2020, 00:06:42 »
Quote
"A date is an experience with another person that makes you appreciate being alone."
~ Larry David

33
Forum News and Info / Signature length has been increased
« on: 26 July 2020, 00:41:00 »
Since beginning we had 300 characters limit and this might be bad in some situations especially if modders want to put more links to their topics, or to gameplay, tutorials, etc. So the new value is 600 and this should be improvement if used properly. At first I wanted to increase this even more, but then it might affect topics, like adds effect on social networks and we definitely don't want that feeling while reading. This is experimental value, so if there is a need it can be decreased or increased even more.

34
Country Boards / Here we can teach people about languages
« on: 19 June 2020, 22:56:00 »
After watching one video that can easily teach people some language basics, I got an idea to have topic for that purpose, so why not to post some comparison that can help people learn.


35
Java / JS projekat geografija
« on: 29 May 2020, 05:36:55 »
OSVEZIVANJE

Link ka JS i QA parovima :slightly_smiling_face:
Kartica JS + QA :smile:
https://docs.google.com/spreadsheets/d/19uKbHYcBjlMM36u3FeMJifKgnn9WJgrSC8Ao0lR_Vro/edit?usp=sharing

Ovo je link ka folderu u kome se nalaze planovi rada i zahtevi :slightly_smiling_face:
https://drive.google.com/open?id=1mw61tGUsdi_YQhvbsU6xnB-ggfYIdMTI

Da li neko moze da prosledi link ka video materijalu

https://photos.app.goo.gl/7xV3XVFPXARXuyQL9








36
Java / Postman 1 projekat
« on: 29 May 2020, 05:25:45 »
Primer zapazanja za rutu /register:
Opis:
Poziva se pri registraciji novog korisnika. Od podataka se salje: Ime i prezime, email i password (sva  polja su obavezna)
Zakljucak/Opazanje:
Uspesna registracija vraca status 201, i u responsu imamo token i podatke za usera.
Kada se korisnik registruje podrazumevano mu je role = "user".
Nakon registarcije se dobija email za verifikaciju.
Pokusaj registracije korisnika sa istim email-om vraca status 422 i gresku EMAIL_ALREADY_EXISTS.
Sigurno moze jos nesto da se doda, ali ovo je na primer za mene dovoljno.
Kao dodatak, kad probate u postmenu kombinacije sa parametrima
Npr:
Ako email nije poslat dobija se response sa statusom 422 i greskama email MISSING i email IS_EMPTY.

Milane, kako da odradimo /token GET request. Svaki user ima svoj token, ali sta bi tu trebalo napisati u tabeli?
Potrebno je da se provali sta se salje tom zahtevu
Imas u dokumentaciji

Mozes da vidis kako neki api pozivi nisu dostupni ukoliko nisi ulogovan. Upoznaj se sa jwt tokenom, i videces kako to ide
Gledam vaše tabele, i neki od vas baš dobro napreduju. Dao bih vam jedan savet, da za svaki api poziv napišete da li je potrebno da korisnik bude ulogovan na aplikaciju. Pozz

Problem od danas vezan za reset lozinke:
Posto je to moguce istestirati samo u test okruzenju, a nasa aplikacija je u production ne mozemo to da radimo preko postmena.
Jedino resenje je da pre nego sto pozovemo taj api poziv iskopiramo onaj id iz email-a tj. moracemo rucno to da resimo.

kada exportujemo folder iz postman-a kod nas na kompu, gde da ga posle upload-ujemo da ti pregledas?
Kreirao sam foldere sa vasim imenima, molim vas proverite da li svi imate pristup svom folderu

Rok za predaju projekta je sreda 20.05 do 20h. Projekat postavljate preko Publish Docs (kao na slici) i meni šaljete link do te postman dokumentacije.
Preporuka je da napravite git repozitorijum na svom git nalogu, i da tu postavite osnovne podatke projekta kao i link do postman dokumentacije.
Pozz :
. . . - tri tackice i Publish Docs


Drustvo, kada stavljate projekat na git, u readme fajlu ubacite neke osnovne podatke za projekat. Ideja je da kada neko pogleda vas repositorijum ima predstavu o tome koliko slozen api ste testirali.
Podatke mozete naci sa ovog linka https://github.com/davellanedam/vue-skeleton-mvp
Takodje ubacite da ste za testiranje koristili Chai Assertion Library
3 slike dodate

stavite yaml fajl koji imate postavljen za projekat
i na kraju link do vase postman dokumentacije
mozete da postavite i postman verziju

Drusto, dobio sam informaciju od odbora da je za sve one koji nisu zavrsili projekat drugi rok za predaju subota 23.05 do 18h.
Ukoliko ne zavrsite projekat do tog roka, Milena ce vas pozvati da vidi zbog cega niste odradili u odredjenom roku.

Pozdrav svima, trenutno je u toku JavaScript ojačavanje i svaki od polaznika razvija svoju verziju projekta "Zanimljiva geografija". Ideja je da pomognemo kolegama da im projekti budu kvalitetniji i sa što manje grešaka. Pustiću vam anketu da vidim koliko vas je zainteresovano da radi testiranje tih aplikacija, u pitanju je Selenium testiranje.

37
https://titanquestfans.net/index.php?topic=1090.0

Since we got info that mod was created in past and it was playable, I wanna check if mod still exist. If anyone knows something please post. Maybe could be some info on German forum or some other source on FR or ES, searching on google is not giving expected info.
Also info like Legion of Champions Lilith IT could be awesome - in case if someone created it.

38
Java / Postman
« on: 05 May 2020, 17:12:44 »
//   Jejson je obicni tekstualni fajl (Json)
//   restfullAPI
//   deli se na front end i back end developere
//   dokumentacija struktura apija i base podataka
//   get i post poruke se najvise koriste
//   get je previse otvoren, sve putuju kroz url i otvoren je, sto znaci da ne zelimo da se vide broj kartice za placanje
//   slicno pa se koristi vise post
//   delete
//   morpheus znaci vodja
//   sa svakom porukom server vraca odgovor
//   postman je dobra dokumentacija, kad se radi sa servisima imamo dokumentaciju API liste poziva za sve sta se desava
//   https://www.getpostman.com/
//   https://developer.mozilla.org/en-US/docs/Web/HTTP/Status
//   https://learning.getpostman.com/docs/postman/launching-postman/introduction/

Napisati tri zahteva u postmanu, objasniti ih uz jednu recenicu i postaviti na drajvu.
Literatura i API
https://jsonplaceholder.typicode.com/

https://developer.mozilla.org/en-US/docs/Web/HTTP/Status

https://reqres.in/






Automatizacija API testova pomoću Postmena

Test API https://vue-demo.daniel-avellaneda.com/
   
Klijent za API koji se testira https://vue-demo.daniel-avellaneda.com/

Dokumentacija Rest API-a je yaml fajl, koji otvarate u Swagger editoru tako što izaberete File > Import File > izaberete pomenuti yaml fajl

Koristan video trening: Testiranje API-a pomoću Postmena možete kupiti na udemy-u ili skinuti sa ovo linka.

Da bismo uspešno istestirali API, moramo se prvo upoznati sa logikom i videti u kojim situacijama se koriste dati API pozivi. U tome će nam dosta pomoći analiza same klijentske aplikacije. Potrebno je upoznati se sa aplikacijom, i saznati što više informacija za svaki od navedenih api poziva. Sve potrebne informacije možete naći u Network prozoru kao na slici 1.



Slika 1. Praćenje API poziva iz Network prozora

Na kraju dolazimo do prvog zadatka, a to je:
U eksel tabeli, klonirajte sheet Sablon i nazovite ga svojim imenom a zatim popunite tabelu.
   
Za razmevanje procesa prijavljivanja i svrhe u koju se koristi token, potrebno je upoznati se sa JWT tokenom. Koristan video trening na tu temu možete pogledati na youtube-u.


2.   Pisanje API-poziva u Postmenu
   
Smernice kojima bi se trebali voditi:
●   imena poziva su ista kao imena ruta
 
●   Upotreba globalnih promenljivi ili promenljivi okruženja za:
○   naziv host-a, npr: {{base_url}}/registracija (udemy, Writing tests and scripts using variables)
○   tokene (udemy, Authentication / Authorization > JSON Web Tokens (JWT))
○   promenljive podatke, npr: login podaci, id-evi,
●   Podatke iz dokumentacije koji se šalju kao formData, šaljite u body kao x-www-form-urlencoded
Napomena 1: Validne vrednosti za user role su “admin” i “user”
Napomena 2: Token je deo zaglavlja i mora se unositi u formatu sa ključnom rečju Bearer {{token}}

3.   Pisanje API testova

U Postmenu testovi se pišu u JavaScript-u, tako da bi bilo dobro upoznati se malo sa tim programskim jezikom (udemy:  JavaScript fundamentals, Writing tests and scripts, Writing tests and scripts using variables, Advanced assertions, Running a request multiple times with different data sets, ...)

Primeri nekih osnovnih testova link (Otvorite u Postmanu klikom na dugme Run in Postman). Neki od njih su zastareli ali je moguce naći novu veriju na linku.

Postoji mnogo načina za kreiranje testova, ali moja stroga preporuka je koristiti Chai Assertion Library (udemy:  Advanced assertions )

U početku će vam biti teže da se povežete sa testiranjem u Postmanu, preporuka je  da za debugiranje koristite konzolu (udemy:  Writing tests and scripts using variables > Debugging tests )
Potrebno je implementirati testove koji su navedeni u daljem tekstu. Postoje 4 logičke grupe testova:
●   auth testovi
●   city testovi
●   profile testovi
●   user testovi
Auth testovi



Primer zapazanja za rutu /register:
Opis:
Poziva se pri registraciji novog korisnika. Od podataka se salje: Ime i prezime, email i password (sva  polja su obavezna)
Zakljucak/Opazanje:
Uspesna registracija vraca status 201, i u responsu imamo token i podatke za usera.
Kada se korisnik registruje podrazumevano mu je role = "user".
Nakon registarcije se dobija email za verifikaciju.
Pokusaj registracije korisnika sa istim email-om vraca status 422 i gresku EMAIL_ALREADY_EXISTS.
Sigurno moze jos nesto da se doda, ali ovo je na primer za mene dovoljno.

39
Announcement from Pieces - Richard#8751 on discord:

Console players! We are looking for people who are experiencing this issue: https://redmine.thqnordic.com/issues/41121 We are interested in further details (and save data) related to it so if you have this issue and want to help out, give me a shout!

40
FMC / What is FMC? - Full Manipulation Contest
« on: 28 March 2020, 03:49:03 »
Full Manipulation Contest

This is advanced editing, require knowledge to get some quality. We have similar game and that is PMC where playing ground is limited on given picture and where resizing of original picture is not allowed. For FMC is everything allowed, original picture can be resized, can be added to some book page or can be used as tattoo on some nice body or whatever you imagine.

- you need to leave at least 1 major object/shape/part from original picture.
- adding, removing parts is allowed if there is at least 1 visible part from original picture.

Forbidden to do:
- You are not allowed to use works from other participants.
- You are not allowed to just cut part of the picture and to paste on another existing picture which you find on the internet. You have to do at least some small modification since this is advanced editing for given picture.



Examples:

Original
Spoiler for Hiden:

My work
Spoiler for Hiden:


Original
Spoiler for Hiden:

My work
Spoiler for Hiden:


Original
Spoiler for Hiden:

My work
Spoiler for Hiden:


Original
Spoiler for Hiden:

My work
Spoiler for Hiden:


Original
Spoiler for Hiden:

My work
Spoiler for Hiden:

41
PMC / What is PMC? - Picture Manipulation Contest
« on: 28 March 2020, 03:48:46 »
Picture Manipulation Contest

This is advanced editing, require knowledge to get some quality. We have similar game and that is FMC where literally everything is allowed. PMC is harder because you are using part of original piece where that part must remain static and changes are done around it.

- Resizing original picture is not allowed. Playing ground is limited on given picture.
- You need to leave at least 1 major object/shape/part from original picture, but color of it can be changed.
- Adding, removing parts is allowed if there is at least 1 visible part from original picture.

Forbidden to do:
- You are not allowed to use works from other participants.
- You are not allowed to just cut part of the picture and to paste on another existing picture which you find on the internet. You have to do at least some small modification since this is advanced editing for given picture.



Original
Spoiler for Hiden:

My work
Spoiler for Hiden:


Original
Spoiler for Hiden:

My work
Spoiler for Hiden:


Original
Spoiler for Hiden:

My work
Spoiler for Hiden:


Original
Spoiler for Hiden:

My work
Spoiler for Hiden:


42
BMC / What is BMC? - Banner Maker Contest
« on: 28 March 2020, 03:47:09 »
Banner Maker Contest

Banner must be created from 3 main parts: Background/s, Renders/s & text/Letters. Letters/text must be related with given subject. Banners are important because we can use it at top of everything, example our site have banners that we change from time to time and that banner we can see wherever we click on the top of every page.

Size:
- default dimension for banner for special event is 720x220 px  >>> ? should be checked and corrected
Rules:
- banner must be created from 3 main parts: background/s, renders/s & text/letters.
- background can be transparent so banner must to have some picture inside except letters, and more than 60% must to be covered.
- when creating banner, you are allowed to use any available tool.
- you can use text which already exist on internet.
- keep background & renders in your PC, so on our request you are obligated to provide resources.

43
SDC / What is SDC? - Signature Design Contest
« on: 28 March 2020, 03:33:50 »
Signature Design Contest

Signatures can tell more about us, they are cool to have on profile, it doesn't need to be some picture so it can be text instead, but in our case, SDC is about picture. Usually small size makes signatures what they are, so to get some quality, participant will have to use huge size while working and later will resize.

- Dimensions of the signature must be max 500x300, both horizontal and vertical signatures are allowed >> size will be corrected
- Signature must be created from at least 2 parts, 2 pictures:
1. background - user can make it as he wish
2. render picture - picture which is placed on background - related with the theme event

44
IMC / What is IMC? - Icon Maker Contest
« on: 28 March 2020, 03:21:44 »
Icon Maker Contest

Icons are something special, every forum that has icons has additional way to reward its users and visual effect makes forum to be unique. Idea is to reward forum users and especially participants with icons for their achievements.

Icon/award must have next parts:
- must to be posted in 2 different sizes: 340x340 px and 34x34 px. >>> size is not final, we will have to test for more details
- borders
- can have transparent and visible part, but also there is no need for transparency, so that is your choice
- even if transparent, icon must to have some picture which cover more than 60% of its size, so more than 60% must to be covered otherwise we won't be able to see what is on icon in small size
- borders must not be transparent
- avoid using pictures with high turbidity. This means it is better to find better quality picture/s for icon
- usage of finished icon from the internet and proclaiming as your work is forbidden, do some work around it
- you are allowed to use any picture which you find on the internet related with given theme, but we recommend you to do some changes before using. That means you can combine pictures, you can use backgrounds, renders or just single picture

Notes, questions and answers (F.A.Q.):
*When working always create your icon in bigger size because you can easily resize it to required size, so it is optionally in which size you will create it [depends on your monitor screen]. For us are important only 2 required dimensions.
* Why in 2 different sizes? - Purpose of bigger icons is to be shown to everyone's eye, so it can help a lot when voting since small icon is usually not visible. Big icons can also fit nicely into your gallery. Small icons may be used as awards later. When we upload icons as awards, we will always upload big icon and small icon, so on click on icon you will see how it actually looks like and there will be included a list of owners of each icon. Optionally you can post bigger icons on forum with nice quality.
* Transparent borders on icon will have an influence on reducing visible parts of small icon and that must not happen.
* Keep background or renders in your PC, so on our request you are obligated to provide resources.

45
LDC / What is LDC? - Logo Design Contest
« on: 28 March 2020, 02:52:32 »
Logo Design Contest

Logo can define, its the watermark of something special, identity. Every company has personal logo, every product, almost every site and so on. This usually request advanced photo-editing skills, or personal design, but newbie users can make nice works as well.

- background for Logo must be transparent. This is the only rule, everything else is pure magic, your magic
- working background size will be defined soon, there are horizontal but as well vertical Logo can exist.
- since your work can be really huge, participation may demand usage of defined not so big sized work while voting.
- it must be your work, if you find something on the internet and you just change colors in 10 seconds and nothing else, then nothing is done and work is not yours.

Pages: 1 2 [3] 4 5 ... 8

SimplePortal 2.3.7 © 2008-2024, SimplePortal