??????t?? ???? ?p?st?????? S???e???, ??pa?de?t???? ?a? ?a??t?? st? ???

1
??????t?? ???? ?p?st?????? S???e???,
??pa?de?t???? ?a? ?a??t?? st? ???µ? ??a t?
??F???? S??????, ??e? ?p??es?e? ?a?e???????
S??????? ???t??? ?a? St????? t?? ??F????? S???????
???s? ?8 ??a?t??? e?pa?de?s? t?? p??s?p????
e?d?s??????? te?????? ?p?st?????? ?p??es?e?
?a?e??????? S??????? ???t??? ??17 - ??µ??????a
?a? s??t???s? ?st?t?p?? µe ???s? Joomla!
2
???ep?s??p?s? ?a???s?as????µ??????a ?a?
s??t???s? ?st?t?p?? µe ???s? Joomla!

• ??sa????
• ???sµ??
• ?a?a?t???st??? Joomla!
• ?etaf??? a??e??? µe ???s? FTP efa?µ????
• WinSCP
• FileZilla
• ???at?stas? Joomla! st? ?S?
• ??t?µat? e??at?stas?
• ?e???????t? e??at?stas?
• ?etaf??? Joomla! d??t?a??? t?p?? se d?a??µ?st?
  web t?? ?S?
• ??t?µet?p?s? p??ß??µ?t??
• T?µata asfa?e?a? d??t?a??? t?p??

3
???sµ????µ??????a ?a? s??t???s? ?st?t?p?? µe
???s? Joomla!

• S?st?µa ??a?e???s?? ?e??e??µ????
• ??ad??t?a?? efa?µ??? ??a t?? d?ad??t?a??
  t??p?p???s? t?? pe??e??µ???? e??? d??t?a??? t?p??
  
• ??e????s? ?st?se??d?? (URL)
• ???a? ? d?e????s? p?? ???s?µ?p??e?ta? ??a t??
  ep?s?e?? t?? ?st?se??d?? ap? ta p?????µµata
  f????µet??t?? (web browsers)
• ??a??µ?st?? web
• ???a? ? d?a??µ?st?? (server) ??a t?? d?µ?s?e?s?
  t?? se??d??
• ?fa?µ??? ftp
• ?fa?µ??? ??a t?? µetaf??? a??e??? µeta?? e???
  sta?µ?? e??as?a? ?a? t?? d?a??µ?st? web

4
??sa??????µ??????a ?a? s??t???s? ?st?t?p?? µe
???s? Joomla!

• ?? ?S? pa???e?
• ???at?t?ta d?µ??????a? ?st?se??d?? µe ???s? t??
  Joomla!
• ??st?p???µ???? ???ste?
• Joomla!
• ???e?? s?st?µa d?a?e???s?? pe??e??µ????
• ???pt??? d??aµ???? ?st?se??d??
• ??a?e???s? pe??e??µ???? t??? ap? ??af???
  pe??ß?????
• ???s?µ?p??e? t?? pa?a??t? te???????e?
• ??a??µ?st? web te???????a? Apache.
• G??ssa p????aµµat?sµ?? PHP.
• ??s? ded?µ???? MySQL.

5
?a?a?t???st??? Joomla!??µ??????a ?a? s??t???s?
?st?t?p?? µe ???s? Joomla!

• ???t?pa
• ?e???
• ??????s? pe??e??µ????
• ?at?????e? ???st??
• Plugins
• Components
• Modules

6
?etaf??? a??e??? µe ???s? t?? WinSCP??µ??????a
?a? s??t???s? ?st?t?p?? µe ???s? Joomla!

• St???e?a s??des??
• ?? ???µa t?? d?a??µ?st? web (host name)
• ?? ???µa ???st? (username)
• ? ??d???? p??sßas?? (password)
• St?? ep????? File protocol
• ?p????te p??t?µ?te?a SFTP
• ?at?te login ??a ?a e?s???ete

7
?etaf??? a??e??? µe ???s? t?? Filezilla??µ??????a
?a? s??t???s? ?st?t?p?? µe ???s? Joomla!

• St???e?a s??des??
• ?? ???µa t?? d?a??µ?st? web (node)
• ?? ???µa ???st? (username)
• ? ??d???? p??sßas?? (password)

8
??t?µat? e??at?stas? Joomla! st? ?S???µ??????a
?a? s??t???s? ?st?t?p?? µe ???s? Joomla!

• S??d?este st?? d??t?a?? ??µß? t?? ?S? www.sch.gr
  ?a? ep????ete d?ad?????
• t?? s??desµ? MySch
• t?? s??desµ? ???a?a? ???????
• t?? s??desµ? ??µ??????a/??a?e???s? ?st?se??d??
• St?? t?p? ?st?se??da? Joomla!, ep????ete
• t?? e????e?a ??µ??????a ?st?se??da? Joomla!

9
??t?µat? e??at?stas? Joomla! st? ?S???µ??????a
?a? s??t???s? ?st?t?p?? µe ???s? Joomla!

• St?? s????e?a ?a p??pe? ?a s?µp????sete ta
  pa?a??t? st???e?a
• ???µa ?st?t?p?? t? ???µa t?? ?st?t?p?? p?? ?a
  eµfa???eta? st?? ?efa??da t?? se??da?.
• ??s? ded?µ???? ? ß?s? ded?µ???? t?? ?p??a ?a
  ???s?µ?p??e? ? ?st?se??da
• ?a??t? Joomla! ta d?a??s?µa pa??ta e??a? ta
  pa?a??t?
• Joomla! 1.5 (p??d?aµ??f?µ??? e??at?stas? ??a
  s???e?a)
• Joomla! 1.5 (µ? p??d?aµ??f?µ??? e??at?stas?)
• Joomla! 1.7 (µ? p??d?aµ??f?µ??? e??at?stas?)
• Joomla! 2.5 (µ? p??d?aµ??f?µ??? e??at?stas?)
• S????µat??? d?a?e???st? ????e?ta? ??a t?
  s????µat??? t?? d?a?e???st? t?? ?st?se??da?, ?
  ?p???? e??a? d?af??et???? ap? t? s????µat??? p??
  ??ete st? ?S?.

10
?e???????t? e??at?stas? Joomla! st? ?S?
(1)??µ??????a ?a? s??t???s? ?st?t?p?? µe ???s?
Joomla!

• ?ateß?ste t? a??e?? t?? te?e?ta?a? ??d?s?? t??
  Joomla!
• ?p?s?µp??ste t? a??e?? t?? Joomla! se ??a f??e??
  st?? ?p?????st? sa?.
• ?etaf??ete ta a??e?a p?? ß??s???ta? st? f??e??,
  st? ???? t?? ?st?se??da? sa? st? ?S?.
• ??st?p????e?te sa? ???st?? st? www.sch.gr
• ???????e?te st? "MySch????a?a? e??????????µ?se??
  ß?s?? ded?µ???? MySQL"
• Se a?t? t? se??da d?µ??????ste µ?a ??a ß?s?
  ded?µ???? ?a? ??d??? p??sßas??.

11
?e???????t? e??at?stas? Joomla! st? ?S?
(2)??µ??????a ?a? s??t???s? ?st?t?p?? µe ???s?
Joomla!

• ?ta? ?????????e? ? µetaf??? t?? a??e??? st??
  ?st?se??da sa?
• ep?s?efte?te t?? ?st?se??da sa?
• ?a p??pe? ?a eµfa??ste? ??a? ?d????
• a??????e?ste ß?µata ?d????
• ?a?aµet??p???s? ?a? e??at?stas? Joomla!

12
?e???????t? e??at?stas? Joomla! st? ?S? (3)
??µ??????a ?a? s??t???s? ?st?t?p?? µe ???s?
Joomla!

• ?? eµfa??ste? t? µ???µa "configuration.php µ?
  e??????µ?"
• ??µ??????ste ??a a??e?? µe t? ???µa
  "configuration.php
• ??ste d??a??µata e???af??
• S??e??ste ta ß?µata t?? ?d????
• ?et? t?? ????????s? t?? e??at?stas??
• ???pe? ?a d?a????ete t? f??e?? "installation"
• ???s?eta? st?? ?at????? t?? Joomla! st?? ?st?????
  sa? st? ?S?
• ?? ? e??at?stas? ??e? p?a?µat?p????e? ep?t????
• ?µf???s? p??ep??e?µ???? ?st?se??da? t?? Joomla!

13
?etaf??? e??? t?p???? Joomla! d??t?a??? t?p?? se
d?a??µ?st? web t?? ?S???µ??????a ?a? s??t???s?
?st?t?p?? µe ???s? Joomla!

• ?etaf??? t?p???? a??e??? Joomla!
• ???s? p?????µµat?? FTP
• ??a???? t?? t?p???? ß?s?? ded?µ????
• S??des? st?? t?p??? efa?µ??? phpMyAdmin s??????
  http//localhost/phpmyadmin/
• ?p????? ß?s?? ded?µ???? e?a???? se a??e?? .sql
• ?pe?e??as?a t?? .sql a??e???
• ??a??af? e?t???? CREATE DATABASE
  ???µa_t?p????_??
• ??sa???? t?? t?p???? ß?s?? ded?µ???? st?? ß?s?
  t?? ?S?
• S??des? st?? efa?µ??? phpMyAdmin
• ??sa???? t?? ß?s?? (a??e?? .sql)
• ?pe?e??as?a t?? configuration.php
• ???s? FTP p?????µµat??
• ???a?? se s???e???µ??e? µetaß??t??

?etaß??t??
var user '?? ???µa ???st? ??a t?? ?? t?? ?S?
var password ??d???? p??sßas?? ??a t?? ?? t?? ?S?'
var db '?? ???µa t?? ?? st?? ?p??a ????e e?sa???? t?? .sql a??e???'
var host 'userdb'
var log_path '?? ap???t? path t?? d??t?a??? sa? t?p??/logs'
var tmp_path '?? ap???t? path t?? d??t?a??? sa? t?p??/tmp'
14
??t?µet?p?s? ???ß??µ?t???pa?af??? ??d????
d?a?e???st? Joomla! (1)

• S??de?e?te st?? MySQL ß?s? ded?µ???? µ?s? t??
  phpMyAdmin
• ?et? t?? s??des? ep????te t?? ß?s? ded?µ???? p??
  ???s?µ?p??e? t? Joomla!

15
??t?µet?p?s? ???ß??µ?t???pa?af??? ??d????
d?a?e???st? Joomla! (2)

• ?p????te st? a??ste?? µ???? t?? p??a?a t?? µ??f??
  prefix_users, ?p?? prefix ß??ete t? p???eµa t??
  ß?s?? p.?., j15, jos, j25c, a?????a µe t?? ??d?s?
  Joomla! p?? ??ete e??atast?se? ?a? st?? s????e?a
  t? Browse distinct Values.
• S?µe??ste t? ???µa t?? d?a?e???st? - s??????
  e??a? Super Administrator st?? 1? e???af?).

16
??t?µet?p?s? ???ß??µ?t???pa?af??? ??d????
d?a?e???st? Joomla! (3)

• ?p????te t?? ?a?t??a SQL ?a? e?te??ste t??
  a??????? e?t???
• UPDATE prefix_users SET passwordMD5('????
  ??d???? ed?') WHERE usertype 'Super
  Administrator'
• ?p?? prefix ß??ete t? s?st? p???eµa t??
  p??a?a users p.?., jos, j15, j25c ?t?.
• ?? ?p?????? pe??ss?te??? t?? e??? 'Super
  Administrator' d?a?e???st?? ?a? ???ete ?a
  a????ete t?? ??d??? ??a ??a? ap? a?t??? t?te
  e?te?e?te t?? pa?a??t? e?t???
• UPDATE ???µa_??s??_ded?µ????.prefix_users SET
  password MD5('????_??d????') WHERE
  prefix_users.username '???µa_???st?_d?a?e???s
  t?_Joomla!'

17
??t?µet?p?s? ???ß??µ?t???? ?????? ???µa t??
ß?s?? ded?µ????

• St? a??e??
• ltf??e??? Joomla!gt/installation/installer/models/
  model.php
• ?a p??pe? st? ??aµµ? 328 ?a ???e?
  a?t??at?stas? t??
• if (!preg_match( "a-zA-Za-zA-Z0-9_",
  DBname ))
• µe t?
• if (!preg_match( "a-zA-Z0-9_-a-zA-Z0-9_-
  ", DBname ))
• St? a??e??
• ltf??e??? Joomla!gt/installation/template/tmpl/dbc
  onfig.html
• ?a p??pe? st? ??aµµ? 21 ?a ???e?
  a?t??at?stas? t??
• var regex/a-zA-Za-zA-Z0-9_/
• µe t?
• var regex/a-zA-Z0-9_-a-zA-Z0-9_-/

18
??t?µet?p?s? ???ß??µ?t??S????? e??t?µata (1)

• ???at?st?sa t? Joomla! ???s?µ?p????ta? t?? ?d???
  a?t?µat?p???µ???? e??at?stas??.
• ??? µp??? ?a a????? t? p??ep??e?µ??? ????t?p?
• ??? µp??? ?a t? d?a?e???st?
• ??? µp??? ?a t?? ape?e???p???s?
• ?? ???eta? µe t?? pa?a?? µ?? d??t?a?? t?p?
• ?? e??a? ? se??da autoschindex.php ?a? ?
  ?at?????? autosch p?? ß???a st?? d??t?a?? µ??
  t?p? ????? ?a ta t?p??et?s? e??
• St?? d??t?a?? µ?? t?p? ß??s?? (e?t?? ap? t?
  se??da autoschindex.php ?a? t?? ?at????? autosch)
  ?a? ???e? se??de?, e????e? ?a? ?p??ata?????? p??
  de? t?? t?p???t?sa e??. ?p??? ?a t?? d?a?????
• ??sa st?? ?at????? autosch ß???a e????e? ? a??e?a
  p?? µ?? f????a? ???s?µa. ?p??? ?a ???? desµ???
  p??? a?t? ??a ?a ???s?µ?p???s? st?? d??t?a?? t?p?
  p?? ?atas?e???? µ???? µ??
• ?p??? ?a ße?t??s? t?? e????a t?? a?t?µata
  ?atas?e?asµ???? d??t?a??? µ?? t?p?? ?????ta?
  a??a??? st?? ?at????? autosch

19
T?µata asfa?e?a? d??t?a??? t?p?? (1)??µ??????a
?a? s??t???s? ?st?t?p?? µe ???s? Joomla!

• ?ta? ep??????µe t?? web efa?µ??? p?? ?a
  ???s?µ?p???s??µe, ?a ?aµß????µe ?p??? t??
  ?p?st????? p?? a?t? pa???e? se ??µata asf??e?a?
• ???a??? a?t?µet?p?s? p??ß??µ?t?? asf??e?a?
• ??????a e??at?stas?? t?? s?et???? d?????se??
• ?a pa?a????????µe ??e?t??????? ?µ?de? s???t?se??
  (forum) p?? as??????ta? µe t?? asf??e?a
  t??????st?? ??a t? ????sµ??? p?? ???s?µ?p????µe,
  ?ste ?a e??µe????µaste ???a??a ?ta? ?p?????? ??e?
  e?d?se?? p?? a?t?µet?p????? ep?ßeßa??µ??e?
  e?p??e?e?.
• ???? t?? e??at?stas? p??s?et?? p????aµµ?t??
  (components, plugins) ?a ?????µe ??e??? ??a t????
  ?e?? asfa?e?a?.

20
T?µata asfa?e?a? d??t?a??? t?p?? (2)??µ??????a
?a? s??t???s? ?st?t?p?? µe ???s? Joomla!

• ?a f???t????µe ??a t?? e??µ???s? t?? ????sµ????
  µa? ?a? t?? ep?µ????? p????aµµ?t?? p??
  ???s?µ?p??e?, ?p?? components/plugins aµ?s??
  µ???? d?µ?s??p????e? t??p?? a?t?µet?p?s?? ??p??a?
  e?p??e?a?.
• ?a µ?? ap??a??pt??µe d?µ?s?a t?? a???ße??
  e?d?se?? t?? efa?µ???? p?? ???s?µ?p????µe
• ??e????????µe t?? a?a??t?s? e?pa??? s?st?µ?t?? µe
  ???s? µ??a??? a?a??t?s?? ap? ?a??ß?????? ???ste?
• ?a e?e???p????µe µ??? ta ?a?a?t???st??? p?? e??a?
  ap???t?? apa?a?t?ta st?? efa?µ???? a?t??
• ?a ap?fe????µe t?? e?e???p???s? t?? ?µ?d??
  s???t?se?? (phpBB) sta CMS, ??at? s???? ap?te????
  st??? ep??es??

21
???t?se????µ??????a ?a? s??t???s? ?st?t?p?? µe
???s? Joomla!