프로그램 사용/wiki2017. 1. 9. 14:55

미디어위키 db구조 보려고 하는데

어라 설치중이라 로고가 다른가? ㅋ


아무튼 설치하려는데 개체 캐싱을 활성화 못하다는 에러와

유니코드 정규화 어쩌구 하길래 삽질을 해보니

두개 패키지를 설치하면 되는 듯 하다.

$ sudo apt-get install xcache php5-intl  



+

Xcache의 영향인가..


LocalSetting.php 에서 CACHE_ACCEL을 CACHE_ANYTHING로 바꾸어주면 로그인은 된다..

다만, 로그인 이미되어 있다고 이상 작동을 할뿐?

 69 ## Shared memory settings

 70 #$wgMainCacheType = CACHE_ACCEL;

 71 $wgMainCacheType = CACHE_ANYTHING;

 72 $wgMemCachedServers = [];

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

  [링크 : http://stackoverflow.com/.../cant-log-in-to-mediawiki-canceled-as-a-precaution-against-session-hijacking]


+ 테이블 전부가 UTF-8 encoding이라는데. 그거 영향인가?

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


일단 테이블 자체는 binary 정렬방식이고 user_name은 varbinary(255)


user_name은.. 16진수로 써있지만 Minimonk 로 첫자가 대문자로 입력되어 있다.


---

$ sudo apt-cache search xcache

php-horde-cache - Horde Caching API

php5-xcache - Fast, stable PHP opcode cacher 


$ sudo apt-get install php5-intl 

[링크 : https://ibeblog.com/2013/01/21/installing-pecl-intl-ubuntu-12-04/]


$ sudo apt-cache search pecl | grep -i pecl

dh-make-php - Creates Debian source packages for PHP PEAR and PECL extensions

dh-php5 - debhelper add-on to handle PHP PECL extensions

libghc-byteable-dev - typeclass for byte sequences

libghc-byteable-doc - typeclass for byte sequences; documentation

libghc-byteable-prof - typeclass for byte sequences; profiling libraries

libghc-chunked-data-dev - typeclasses for dealing with various chunked data representations

libghc-chunked-data-doc - typeclasses for dealing with various chunked data representations; documentation

libghc-chunked-data-prof - typeclasses for dealing with various chunked data representations; profiling libraries

libghc-classy-prelude-dev - typeclass-based prelude

libghc-classy-prelude-doc - typeclass-based prelude; documentation

libghc-classy-prelude-prof - typeclass-based prelude; profiling libraries

libghc-convertible-dev - Typeclasses and instances for converting between types, GHC package

libghc-convertible-doc - Typeclasses and instances for converting between types, documentation

libghc-convertible-prof - Typeclasses and instances for converting between types, GHC profiling package

libghc-convertible-text-doc - typeclasses and instances for converting between types; documentation

libghc-mono-traversable-dev - typeclasses for mapping/folding/traversing monomorphic containers

libghc-mono-traversable-doc - typeclasses for mapping/folding/traversing monomorphic containers; documentation

libghc-mono-traversable-prof - typeclasses for mapping/folding/traversing monomorphic containers; profiling libraries

libghc-newtype-dev - A typeclass for working with newtypes

libghc-newtype-doc - A typeclass for working with newtypes; documentation

libghc-newtype-prof - A typeclass for working with newtypes; profiling libraries

libtarantool-php - PECL PHP driver for Tarantool/Box

php5-pecl-http - pecl_http module for PHP 5 Extended HTTP Support

php5-pecl-http-dev - pecl_http module for PHP 5 Extended HTTP Support development headers

php5-radius - PECL radius module for PHP 5

php5-remctl - PECL module for Kerberos-authenticated command execution 


$ sudo apt-get install php5-pecl-http php5-xcache

Reading package lists... Done

Building dependency tree

Reading state information... Done

The following extra packages will be installed:

  php-pear php5-propro php5-raphf

Suggested packages:

  php5-dev

The following NEW packages will be installed:

  php-pear php5-pecl-http php5-propro php5-raphf php5-xcache

0 upgraded, 5 newly installed, 0 to remove and 2 not upgraded.

Need to get 486 kB of archives.

After this operation, 2,712 kB of additional disk space will be used.

Do you want to continue? [Y/n] 


[링크 : https://www.liquidweb.com/kb/how-to-install-xcache-on-ubuntu-14-04-lts/]

Posted by 구차니