프로그램 사용/wiki2018. 4. 20. 15:00

걍.. 백업이 잘못되서

watchlist 관련 테이블이 복원이 안되서 그런 듯?

[링크 : https://www.mediawiki.org/wiki/Manual:Upgrading]



--

1.19는 LTS 구버전이다.


일단.. 1.19 이후에는 1.23과, 1.27 이 LTS로 존재하니..

1.19 -> 1.23 을 시도해보면 될 듯?


[링크 : https://en.wikipedia.org/wiki/MediaWiki_version_history]


구버전 다운로드

[링크 : https://releases.wikimedia.org/mediawiki/]



---

woobi 측

phpmyadmin 2.11.11

mysql 5.0.95



odroid u3

phpmyadmin 4.5.4

mariaddb 10.0.34



#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 21

[링크 : https://stackoverflow.com/.../1064-error-in-create-table-type-myisam]


You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=HEAP MAX_ROWS=25000'

[링크 : https://stackoverflow.com/.../mysql-server-version-for-the-right-syntax-to-use-near-type-heap-at-line-1]



+

phpmyadmin을 통하지 말고 그냥

phpmyadmin 에서 dump 한 다음 로컬에서 데이터 복구하고

sudo php maintenance/update.php 로 실행하니 끝

odroid@odroid_2:/var/www/html/mediawiki/maintenance$ sudo php update.php

MediaWiki 1.27.4 Updater


Your composer.lock file is up to date with current dependencies!

Going to run database updates for minimonk-mw_

Depending on the size of your database this may take a while!

Abort with control-c in the next five seconds (skip this countdown with --quick) ... 0

Turning off Content Handler DB fields for this part of upgrade.

...have ipb_id field in ipblocks table.

...have ipb_expiry field in ipblocks table.

...already have interwiki table

...indexes seem up to 20031107 standards.

...have rc_type field in recentchanges table.

...index new_name_timestamp already set on recentchanges table.

...have user_real_name field in user table.

...querycache table already exists.

...objectcache table already exists.

...categorylinks table already exists.

...have pagelinks; skipping old links table updates

...il_from OK

...have rc_ip field in recentchanges table.

...index PRIMARY already set on image table.

...have rc_id field in recentchanges table.

...have rc_patrolled field in recentchanges table.

...logging table already exists.

...have user_token field in user table.

...have wl_notificationtimestamp field in watchlist table.

...watchlist talk page rows already present.

...user table does not contain user_emailauthenticationtimestamp field.

...page table already exists.

...have log_params field in logging table.

...logging table has correct log_title encoding.

...have ar_rev_id field in archive table.

...have page_len field in page table.

...revision table does not contain inverse_timestamp field.

...have rev_text_id field in revision table.

...have rev_deleted field in revision table.

...have img_width field in image table.

...have img_metadata field in image table.

...have user_email_token field in user table.

...have ar_text_id field in archive table.

...page_namespace is already a full int (int(11)).

...ar_namespace is already a full int (int(11)).

...rc_namespace is already a full int (int(11)).

...wl_namespace is already a full int (int(11)).

...qc_namespace is already a full int (int(11)).

...log_namespace is already a full int (int(11)).

...have img_media_type field in image table.

...already have pagelinks table.

...image table does not contain img_type field.

...already have unique user_name index.

...user_groups table exists and is in current format.

...have ss_total_pages field in site_stats table.

...user_newtalk table already exists.

...transcache table already exists.

...have iw_trans field in interwiki table.

...wl_notificationtimestamp is already nullable.

...index times already set on logging table.

...have ipb_range_start field in ipblocks table.

...no page_random rows needed to be set

...have user_registration field in user table.

...templatelinks table already exists

...externallinks table already exists.

...job table already exists.

...have ss_images field in site_stats table.

...langlinks table already exists.

...querycache_info table already exists.

...filearchive table already exists.

...have ipb_anon_only field in ipblocks table.

...index rc_ns_usertext already set on recentchanges table.

...index rc_user_text already set on recentchanges table.

...have user_newpass_time field in user table.

...redirect table already exists.

...querycachetwo table already exists.

...have ipb_enable_autoblock field in ipblocks table.

...index pl_namespace on table pagelinks includes field pl_from.

...index tl_namespace on table templatelinks includes field tl_from.

...index il_to on table imagelinks includes field il_from.

...have rc_old_len field in recentchanges table.

...have user_editcount field in user table.

...page_restrictions table already exists.

...have log_id field in logging table.

...have rev_parent_id field in revision table.

...have pr_id field in page_restrictions table.

...have rev_len field in revision table.

...have rc_deleted field in recentchanges table.

...have log_deleted field in logging table.

...have ar_deleted field in archive table.

...have ipb_deleted field in ipblocks table.

...have fa_deleted field in filearchive table.

...have ar_len field in archive table.

...have ipb_block_email field in ipblocks table.

...index cl_sortkey on table categorylinks includes field cl_from.

...have oi_metadata field in oldimage table.

...index usertext_timestamp already set on archive table.

...index img_usertext_timestamp already set on image table.

...index oi_usertext_timestamp already set on oldimage table.

...have ar_page_id field in archive table.

...have img_sha1 field in image table.

...protected_titles table already exists.

...have ipb_by_text field in ipblocks table.

...page_props table already exists.

...updatelog table already exists.

...category table already exists.

...category table already populated.

...have ar_parent_id field in archive table.

...have user_last_timestamp field in user_newtalk table.

...protected_titles table has correct pt_title encoding.

...have ss_active_users field in site_stats table.

...ss_active_users user count set...

...have ipb_allow_usertalk field in ipblocks table.

...pl_namespace, tl_namespace, il_to indices are already UNIQUE.

...change_tag table already exists.

...tag_summary table already exists.

...valid_tag table already exists.

...user_properties table already exists.

...log_search table already exists.

...have log_user_text field in logging table.

...l10n_cache table already exists.

...index ls_field_val already set on log_search table.

...index change_tag_rc_tag already set on change_tag table.

...have rd_interwiki field in redirect table.

...transcache tc_time already converted.

...*_mime_minor fields are already long enough.

...iwlinks table already exists.

...index iwl_prefix_title_from already set on iwlinks table.

...have ul_value field in updatelog table.

...have iw_api field in interwiki table.

...iwl_prefix key doesn't exist.

...have cl_collation field in categorylinks table.

...categorylinks up-to-date.

...module_deps table already exists.

...ar_page_revid key doesn't exist.

...index ar_revid already set on archive table.

...ll_lang is up-to-date.

...user_last_timestamp is already nullable.

...index user_email already set on user table.

...up_property in table user_properties already modified by patch patch-up_property.sql.

...uploadstash table already exists.

...user_former_groups table already exists.

...index type_action already set on logging table.

...have rev_sha1 field in revision table.

...batch conversion of user_options: nothing to migrate. done.

...user table does not contain user_options field.

...have ar_sha1 field in archive table.

...index page_redirect_namespace_len already set on page table.

...have us_chunk_inx field in uploadstash table.

...have job_timestamp field in job table.

Adding index page_user_timestamp to table revision ...done.

Adding ipb_parent_block_id field to table ipblocks ...done.

Adding index ipb_parent_block_id to table ipblocks ...done.

Table category contains cat_hidden field. Dropping ...done.

Adding rev_content_format field to table revision ...done.

Adding rev_content_model field to table revision ...done.

Adding ar_content_format field to table archive ...done.

Adding ar_content_model field to table archive ...done.

Adding page_content_model field to table page ...done.

Content Handler DB fields should be usable now.

Table site_stats contains ss_admins field. Dropping ...done.

Table recentchanges contains rc_moved_to_title field. Dropping ...done.

Creating sites table ...done.

Adding fa_sha1 field to table filearchive ...done.

Adding job_token field to table job ...done.

Adding job_attempts field to table job ...done.

Adding us_props field to table uploadstash ...done.

Modifying ug_group field of table user_groups ...done.

Modifying ufg_group field of table user_former_groups ...done.

Adding index pp_propname_page to table page_props ...done.

Adding index img_media_mime to table image ...done.

Making iwl_prefix_title_from index non-UNIQUE ...done.

Adding index iwl_prefix_from_title to table iwlinks ...done.

Adding ar_id field to table archive ...done.

Adding el_id field to table externallinks ...done.

Adding rc_source field to table recentchanges ...done.

Adding index log_user_text_type_time to table logging ...done.

Adding index log_user_text_time to table logging ...done.

Adding page_links_updated field to table page ...done.

Adding user_password_expires field to table user ...done.

Adding pp_sortkey field to table page_props ...done.

Table recentchanges contains rc_cur_time field. Dropping ...done.

Adding index wl_user_notificationtimestamp to table watchlist ...done.

Adding page_lang field to table page ...done.

Adding pl_from_namespace field to table pagelinks ...done.

Adding tl_from_namespace field to table templatelinks ...done.

Adding il_from_namespace field to table imagelinks ...done.

Modifying img_major_mime field of table image ...done.

Modifying oi_major_mime field of table oldimage ...done.

Modifying fa_major_mime field of table filearchive ...done.

Making user_id unsigned int ...done.

Modifying rc_comment field of table recentchanges ...done.

Dropping table hitcounter ...done.

Table site_stats contains ss_total_views field. Dropping ...done.

Table page contains page_counter field. Dropping ...done.

Dropping table msg_resource_links ...done.

Dropping table msg_resource ...done.

Creating bot_passwords table ...done.

Adding wl_id field to table watchlist ...done.

Dropping cl_collation index from table categorylinks ...done.

Adding index cl_collation_ext to table categorylinks ...done.

...collations up-to-date.

...site_stats is populated...done.

Checking existence of old default messages...done.

Populating rev_len column

...doing rev_id from 13 to 212

...doing rev_id from 213 to 412

...doing rev_id from 413 to 612

...doing rev_id from 613 to 812

...doing rev_id from 813 to 1012

...doing rev_id from 1013 to 1212

...doing rev_id from 1213 to 1412

...doing rev_id from 1413 to 1612

...doing rev_id from 1613 to 1812

...doing rev_id from 1813 to 2012

...doing rev_id from 2013 to 2212

...doing rev_id from 2213 to 2412

Populating ar_len column

...archive table seems to be empty.

rev_len and ar_len population complete [0 revision rows, 0 archive rows].

Populating rev_sha1 column

...doing rev_id from 13 to 212

...doing rev_id from 213 to 412

...doing rev_id from 413 to 612

...doing rev_id from 613 to 812

...doing rev_id from 813 to 1012

...doing rev_id from 1013 to 1212

...doing rev_id from 1213 to 1412

...doing rev_id from 1413 to 1612

...doing rev_id from 1613 to 1812

...doing rev_id from 1813 to 2012

...doing rev_id from 2013 to 2212

...doing rev_id from 2213 to 2412

Populating ar_sha1 column

...archive table seems to be empty.

Populating ar_sha1 column legacy rows

rev_sha1 and ar_sha1 population complete [0 revision rows, 0 archive rows].

Populating img_sha1 field


Done 0 files in 0.0 seconds

Fixing protocol-relative entries in the externallinks table...

Done, 0 rows updated.

Populating fa_sha1 field from fa_storage_key


Done 0 files in 0.0 seconds

Updating *_from_namespace fields in links tables.

...doing page_id from 1 to 200

Purging caches...done.


Done in 5.2 s. 


[링크 : http://chongmoa.com/sql/630]

Posted by 구차니

skip-grant어쩌구 우회해서 접속하고 변경해도 안되길래

마구마구 검색을 해봤는데


mysql과 mariadb의 보안정책상 db에 root 계정 접속시에는

계정도 root로(그러니까 sudo 쓰던가) 접근해야 한다.

라는 결론


$ sudo mysql -uroot -p

[sudo] password for odroid:

Enter password:

Welcome to the MariaDB monitor.  Commands end with ; or \g.

Your MariaDB connection id is 34

Server version: 10.0.34-MariaDB-0ubuntu0.16.04.1 Ubuntu 16.04


Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.


Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.


MariaDB [(none)]> 


[링크 : https://stackoverflow.com/.../access-denied-for-user-rootlocalhost-using-password-yes-after-new-instal]



+

라즈베리 파이는 5.5.59 버전으로 root에 로그인시 root 권한이 필요없다.

5.5~8.0 사이에 변화가 있었던거 같은데 changelog에서 뒤지다가 포기..

$ mysql --version

mysql  Ver 14.14 Distrib 5.5.59, for debian-linux-gnu (armv7l) using readline 6.3 


$ mysql -uroot -p

Enter password:

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 367

Server version: 5.5.59-0+deb8u1 (Raspbian)


Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.


Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.


Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.


mysql>


mysql은

5.5/5.6/5.7->8.0 으로 점프했고


mariadb는 

5.5->10.0 으로 점프했다.

Posted by 구차니

핸드폰에서 보다 보니 보여서 검색하는데 들어갈데가 애매해서 일단 kodi에 넣어둠..


wifi direct는 DLNA와 연동해서 쓰기도 하는데 딱히 상관은 없다.

ad-hoc 방식으로 서로 연결하는 비슷한 느낌이고

별도의 IP stack을 이용해서 구현하는 것으로 보인다.


그리고.. 라즈베리 파이 3의 경우 Wifi가 있긴한데

해당 칩셋(리얼텍)이 wifi direct로는 정상작동하지 않아서 작업중인 것으로 보인다.


[링크 : http://hamait.tistory.com/300] << 안드로이드 프로그래밍

[링크 : https://ko.m.wikipedia.org/wiki/와이파이_다이렉트]

'프로그램 사용 > kodi(xbmc)' 카테고리의 다른 글

kodi 전체화면 / 창화면  (0) 2020.07.05
kodi 단축키  (0) 2020.03.29
KODI / DLNA 설정  (0) 2018.04.02
openelec 블루투스 연결하기  (0) 2018.03.07
libreelec  (0) 2018.02.21
Posted by 구차니

Airplay (apple)

Allshare (samsung)

Smartshare (lg)


업체별로 DLNA를 표기하는 명칭이 다르다.

아무튼.. 이걸 설정하면 다른 출력기기로 영상을 보내버릴수 있다.

편의상(?) DLNA는 Wifi-direct나 유/무선 네트워크와 연동이 된다.


[링크 : https://kodi.wiki/view/UPnP]

[링크 : https://kodi.wiki/view/Settings/Services/UPnP_DLNA]


[링크 : http://iptime.com/iptime/?pt=231&page_id=67&uid=7408&mod=document]

[링크 : https://giverhell.com/2017/01/15/how-to-stream-from-iphone-ipad-or-android-to-kodi/]

[링크 : http://www.lg.com/.../wifidirect_all/kora/w14__share__wifidirect_all__kora.html]




'프로그램 사용 > kodi(xbmc)' 카테고리의 다른 글

kodi 단축키  (0) 2020.03.29
Wifi direct  (0) 2018.04.02
openelec 블루투스 연결하기  (0) 2018.03.07
libreelec  (0) 2018.02.21
openELEC HDMI CEC  (0) 2018.02.19
Posted by 구차니
프로그램 사용/Blender2018. 3. 19. 13:12

'프로그램 사용 > Blender' 카테고리의 다른 글

블렌더 강좌? (유료)  (0) 2021.08.07
blender 포켓몬 애니메이션  (0) 2020.08.08
blender netrender 잠시 된건가..  (0) 2016.11.23
blender netrender / incorrect master version  (0) 2016.11.22
blender netrender 구조  (0) 2016.11.19
Posted by 구차니

System - OpenELEC - Services - Bluetooth 사용

System - OpenELEC - Bluetooth - 페어링

그나저나 PIN치기 빡세겠구만.. ㄷㄷ


[링크 : http://misapuntesde.com/post.php?id=333]


+

집에와서 해보니 키보드로 치는거라 편함 ㅋ

'프로그램 사용 > kodi(xbmc)' 카테고리의 다른 글

Wifi direct  (0) 2018.04.02
KODI / DLNA 설정  (0) 2018.04.02
libreelec  (0) 2018.02.21
openELEC HDMI CEC  (0) 2018.02.19
openELEC 8.0 관련  (0) 2017.05.16
Posted by 구차니
프로그램 사용/MAME2018. 3. 7. 13:19

retropie

GUI 상에서 제공하진 않고 콘솔상에서 CUI를 통해 제공

[링크 : https://github.com/RetroPie/RetroPie-Setup/wiki/Bluetooth-Controller]



결국 콘솔인가?

recalbox

On keyboard

Tape F4

ALT+F2

Need root access : LOGIN(root) Password (recalboxroot)

hcitool scan

aa:bb:cc:dd:ee:ff Name:Bluetooth HID

hidd --connect aa:bb:cc:dd:ee:ff /etc/init.d/S31emulationstation start 

[링크 : https://github.com/recalbox/recalbox-os/wiki/Connect-Bluetooth-Controller-HID-with-hcitool---hidd]

수동으로 연결하기

[링크 : https://github.com/recalbox/recalbox-os/wiki/Connect-bluetooth-controller-manually-(EN)]


리콜박스 호환성 목록(동글 및 조이스틱 등)

[링크 : https://github.com/recalbox/recalbox-os/wiki/Compatibility-%28EN%29]


+

2018.03.08

recalbox는 openelec 포함인데.. 여기서 설정하면 recalbox에도 적용 되려나?


'프로그램 사용 > MAME' 카테고리의 다른 글

레트로 파이 coin select GPIO로 연결하기  (0) 2018.05.16
retropie spi lcd  (0) 2018.05.16
MAME 조이스틱 설정  (0) 2018.03.03
어트랙트 모드  (0) 2018.02.27
recalbox 스플래시 음악 끄기  (0) 2018.02.23
Posted by 구차니
프로그램 사용/MAME2018. 3. 3. 22:19

설정파일 어디 없나..

오늘 획득한(!) 조이스틱이 PS3 호환인거 같은데(형태와 키만)

Trigger와 shoulder를 어떻게 써야 하려나?


[링크 : https://github.com/RetroPie/RetroPie-Setup/wiki/Controller-Configuration]

[링크 : https://retropie.org.uk/docs/RetroArch-Configuration/]

'프로그램 사용 > MAME' 카테고리의 다른 글

retropie spi lcd  (0) 2018.05.16
relcabox / retropie 블루투스 연결  (0) 2018.03.07
어트랙트 모드  (0) 2018.02.27
recalbox 스플래시 음악 끄기  (0) 2018.02.23
mess - Multi Emulator Super System  (0) 2018.02.22
Posted by 구차니
프로그램 사용/MAME2018. 2. 27. 16:29

월광보합이라는 애가 어트랙트 모드를 이용해서

UI를 하나 덧 씌운거였구나..


[링크 : http://www.ppomppu.co.kr/zboard/view.php?id=gamer&no=27290]

'프로그램 사용 > MAME' 카테고리의 다른 글

relcabox / retropie 블루투스 연결  (0) 2018.03.07
MAME 조이스틱 설정  (0) 2018.03.03
recalbox 스플래시 음악 끄기  (0) 2018.02.23
mess - Multi Emulator Super System  (0) 2018.02.22
MAME 버전 정리  (0) 2018.02.22
Posted by 구차니
프로그램 사용2018. 2. 27. 09:47

증상 : 이미지 크기가 작은데 이상하게 PSD 파일 용량이 큼

원인 : 특정 이미지에서 얻어온 EXIF 정보 중 XMP 데이터 오염(?)

자세히 : photoshop:DocumentAncestors하위의 rdf:Bag 세부 내용이 넘쳐남

<?xpacket begin="" id="..."?>

<x:xmpmeta xmlns:x="adobe:ns:meta/" x:xmptk="Adobe XMP Core 5.0-c060 61.134777, 2010/02/12-17:32:00        ">

   <rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#">

      <rdf:Description rdf:about=""

            xmlns:xmp="http://ns.adobe.com/xap/1.0/">

         <xmp:CreatorTool>Adobe Photoshop CC 2014 (Windows)</xmp:CreatorTool>

         <xmp:CreateDate>2018-02-27T09:17:54+09:00</xmp:CreateDate>

         <xmp:MetadataDate>2018-02-27T09:17:55+09:00</xmp:MetadataDate>

         <xmp:ModifyDate>2018-02-27T09:17:55+09:00</xmp:ModifyDate>

      </rdf:Description>

      <rdf:Description rdf:about=""

            xmlns:photoshop="http://ns.adobe.com/photoshop/1.0/">

         <photoshop:ColorMode>3</photoshop:ColorMode>

         <photoshop:ICCProfile>sRGB IEC61966-2.1</photoshop:ICCProfile>

         <photoshop:DocumentAncestors>

            <rdf:Bag>

               <rdf:li/>

               <rdf:li>0</rdf:li>

               <rdf:li>...</rdf:li>

               <rdf:li>...</rdf:li> 



해결방법

1. PSD 파일

File - Script - Script Events Manager


remove.jsx 로 저장 후(adobe javascript) export나 save에 연결해주면 끝!

// https://forums.adobe.com/message/8511978#8511978

function deleteDocumentAncestorsMetadata() {  

    whatApp = String(app.name);//String version of the app name  

    if(whatApp.search("Photoshop") > 0)  { //Check for photoshop specifically, or this will cause errors  

        //Function Scrubs Document Ancestors from Files  

        if(!documents.length) {  

        alert("There are no open documents. Please open a file to run this script.")  

        return;   

        }  

        if (ExternalObject.AdobeXMPScript == undefined) ExternalObject.AdobeXMPScript = new ExternalObject("lib:AdobeXMPScript");   

        var xmp = new XMPMeta( activeDocument.xmpMetadata.rawData);   

        // Begone foul Document Ancestors!  

            xmp.deleteProperty(XMPConst.NS_PHOTOSHOP, "DocumentAncestors");  

            app.activeDocument.xmpMetadata.rawData = xmp.serialize();  

         }  

}  

//Now run the function to remove the document ancestors  

deleteDocumentAncestorsMetadata();

[링크 : http://prepression.blogspot.com/2017/06/metadata-bloat-photoshopdocumentancestors.html]

  [링크 : https://forums.adobe.com/thread/2340460]


2. JPEG 파일

File - Save as Web - Metadata : None

[링크 : https://photographylife.com/how-to-delete-exif-data]



+

해결하고 나서 보긴 했는데 댓글에 조금 도움이 되는 내용 있음

[링크 : https://brunch.co.kr/@mrlees/9]

Posted by 구차니