Masalah ini berlaku semasa cuba bootstrap nod pertama galera cluster selepas konfigurasi my.cnf
InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes
InnoDB: than specified in the .cnf file 0 536870912 bytes!
Buang fail yang bermasalah
sudo rm /var/lib/mysql/ib_logfile*
Bootstrap semula nod tadi
sudo mysqld --wsrep_cluster_address=gcomm://
IP target (sumber storan):
192.168.56.212
Logical volume yang hendak digunakan: /dev/vgtarget00/lvtarget00
IP initiator(dari mana akan diakses):
192.168.56.213
192.168.56.214
Pasang iscsitarget pada sumber
sudo apt-get install iscsitarget iscsitarget-dkms
Contoh tetapan pada /etc/default/iscsitarget
[code lang=’plain’]ISCSITARGET_ENABLE=true
ISCSITARGET_OPTIONS=”–address 192.168.56.212″[/code]
Contoh tetapan pada /etc/iet/ietd.conf
[code lang=’plain’]Target iqn.2015-01.iscsi:target00
Lun 0 Path=/dev/vgtarget00/lvtarget00,Type=blockio
initiator-address 192.168.56.213
initiator-address 192.168.56.214[/code]
Contoh tetapan pada /etc/iet/initiators.allow
ALL ALL
Mulakan semula servis iscsitarget
sudo /etc/init.d/iscsitarget restart
Pasang iscsi-initiator pada server yang akan mengakses storan iscsi (initiator)
sudo apt-get install open-iscsi
Contoh tetapan pada /etc/iscsi/iscsid.conf
[code lang=’plain’]iscsid.startup = /usr/sbin/iscsid
node.startup = automatic
node.leading_login = No
node.session.timeo.replacement_timeout = 120
node.conn[0].timeo.login_timeout = 15
node.conn[0].timeo.logout_timeout = 15
node.conn[0].timeo.noop_out_interval = 5
node.conn[0].timeo.noop_out_timeout = 5
node.session.err_timeo.abort_timeout = 15
node.session.err_timeo.lu_reset_timeout = 30
node.session.err_timeo.tgt_reset_timeout = 30
node.session.initial_login_retry_max = 8
node.session.cmds_max = 128
node.session.queue_depth = 32
node.session.xmit_thread_priority = -20
node.session.iscsi.InitialR2T = No
node.session.iscsi.ImmediateData = Yes
node.session.iscsi.FirstBurstLength = 262144
node.session.iscsi.MaxBurstLength = 16776192
node.conn[0].iscsi.MaxRecvDataSegmentLength = 262144
node.conn[0].iscsi.MaxXmitDataSegmentLength = 0
discovery.sendtargets.iscsi.MaxRecvDataSegmentLength = 32768
node.session.nr_sessions = 1
node.session.iscsi.FastAbort = Yes[/code]
Mulakan semula servis initiator
sudo /etc/init.d/open-iscsi restart
Akses storan pada target
sudo iscsiadm -m discovery -t sendtargets -p 192.168.56.212
sudo iscsiadm -m node --login
Jika anda set negara sebagai Malaysia semasa pemasangan Ubuntu, setiap kali memasang pakej anda terlihat mesej berikut
[code lang=’plain’]perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
LANGUAGE = “en_US:en”,
LC_ALL = (unset),
LC_TIME = “ms_MY.UTF-8”,
LC_MONETARY = “ms_MY.UTF-8”,
LC_ADDRESS = “ms_MY.UTF-8”,
LC_TELEPHONE = “ms_MY.UTF-8”,
LC_NAME = “ms_MY.UTF-8”,
LC_MEASUREMENT = “ms_MY.UTF-8”,
LC_IDENTIFICATION = “ms_MY.UTF-8”,
LC_NUMERIC = “ms_MY.UTF-8”,
LC_PAPER = “ms_MY.UTF-8”,
LANG = “en_US.UTF-8”
are supported and installed on your system.
perl: warning: Falling back to the standard locale (“C”).
locale: Cannot set LC_ALL to default loc
le: No such file or directory[/code]
Penyelesaiannya:
$ sudo locale-gen ms_MY.UTF-8
Generating locales...
ms_MY.UTF-8... done
Generation complete.
OS: Ubuntu 14.04
Untuk situasi dimana kita hanya ada 2 server yang boleh digunakan.
2 node mariadb + 1 node garb/arbiter (elak split-brain)
Pastikan /etc/hosts ada entri ketiga-tiga node. Contoh:
[code lang=’plain’]127.0.0.1 localhost
127.0.1.1 ubuntu
192.168.56.215 db1
192.168.56.216 db2
192.168.56.217 garb[/code]
Pasang mariadb pada kedua-dua node mariadb
sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xcbcb082a1bb943db
sudo add-apt-repository 'deb http://mariadb.nethub.com.hk//repo/10.0/ubuntu trusty main'
sudo apt-get update
sudo apt-get install mariadb-galera-server galera
Pasang garbd pada node garb
sudo apt-get install galera
Matikan service mariadb pada kedua-dua node
sudo service mysql stop
Contoh setting /etc/mysql/my.cnf. Sesuaikan untuk setiap node. srep_cluster_address="gcomm://db2?pc.wait_prim=no" perlu set terbalik seperti ditunjukkan.
[code lang=’plain’][client]
port = 3306
socket = /var/run/mysqld/mysqld.sock
[mysqld_safe]
nice = 0
socket = /var/run/mysqld/mysqld.sock
[mysqld]
basedir = /var/lib/mysql
bind-address = 192.168.56.215
binlog_format = ROW
character_set_server = utf8
collation_server = utf8_general_ci
datadir = /var/lib/mysql
default-storage-engine = InnoDB
expire_logs_days = 10
innodb_autoinc_lock_mode = 2
innodb_buffer_pool_size = 1G
innodb_log_file_size = 512M
innodb_doublewrite = 1
innodb_file_per_table = 1
innodb_flush_log_at_trx_commit = 2
innodb_lock_wait_timeout = 60
innodb_locks_unsafe_for_binlog = 1
innodb_stats_on_metadata = 0
key_buffer = 256M
lc-messages-dir = /usr/share/mysql
lock_wait_timeout = 300
max_allowed_packet = 128M
max_binlog_size = 128M
max_connections = 64
myisam-recover = BACKUP
myisam_sort_buffer_size = 64M
net_buffer_length = 8K
open-files-limit = 65535
pid-file = /var/run/mysqld/mysqld.pid
port = 3306
query_cache_limit = 8M
query_cache_size = 16M
read_buffer_size = 8M
read_rnd_buffer_size = 8M
skip-external-locking
socket = /var/run/mysqld/mysqld.sock
sort_buffer_size = 16M
table_cache = 2M
table_definition_cache = 65535
table_open_cache = 65535
thread_cache_size = 8
thread_concurrency = 8
tmpdir = /tmp
user = mysql
wsrep_provider=/usr/lib/galera/libgalera_smm.so
wsrep_cluster_address=”gcomm://db2?pc.wait_prim=no”
wsrep_sst_method=rsync
wsrep_cluster_name=”joomla_db_cluster”
[mysqldump]
max_allowed_packet = 16M
quick
quote-names
[mysql]
[isamchk]
!includedir /etc/mysql/conf.d/
key_buffer = 256M
read_buffer = 16M
sort_buffer_size = 256M
write_buffer = 16M
[/code]
Pada node db1, mulakan cluster mariadb
mysqld --wsrep_cluster_address=gcomm://
Pada nod db1, salin fail debian.cnf ke nod db2
scp /etc/mysql/debian.cnf user1@192.168.56.216:/home/user1/debian.cnf
sudo cp debian.cnf /etc/mysql/
Mulakan mariadb pada node2
sudo service mysql start
Cuba mulakan garbd pada nod garb
sudo garbd -a gcomm://db1:4567,db2:4567?pc.wait_prim=no -g "joomla_db_cluster"
Contoh setting /etc/default/garb pada node garb
[code lang=’plain’]GALERA_NODES=”db1:4567 db2:4567″
GALERA_GROUP=”joomla_db_cluster”
GALERA_OPTIONS=”pc.wait_prim=no”
LOG_FILE=”/var/log/garbd.log”[/code]
Mulakan garbd pada node garb
sudo service garb start
Matikan mariadb pada node db1
sudo service mysql stop
Mulakan semula mariadb pada node db1
sudo service mysql start
Contoh log cluster dengan kesemua node berjalan (semak dalam /var/log/garb.log)
[code lang=’plain’]2015-01-28 22:46:37.658 INFO: Quorum results:
version = 3,
component = PRIMARY,
conf_id = 6,
members = 3/3 (joined/total),
act_id = 0,
last_appl. = 0,
protocols = 0/5/3 (gcs/repl/appl),
group UUID = 1828d0b2-a6ef-11e4-bf0a-3217c0075751
2015-01-28 22:46:37.658 INFO: Flow-control interval: [9999999, 9999999]
2015-01-28 22:46:37.665 INFO: Member 2.0 (db1) synced with group.[/code]
Contoh berikut menggunakan Android Jelly Beans pada Nokia X
Andaian:
Pilih Settings
Pilih Add account
Pilih Corporate
Nama pengguna dengan backslash sebelum nama. Tandakan Accept all SSL certificates jika menggunakan self-signed certificate.
Perkara yang diperlukan untuk migrasi Domino 8.5 ke Zimbra Collaboration 8.5 dengan mengambil kira perkara berikut
Berikut keperluannya:
[code lang=’plain’][Notes]
KitType=1
SharedDataDirectory=C:\ProgramData\Lotus\Notes\Data\Shared
InstallType=6
InstallMode=1
NotesProgram=c:\Program Files (x86)\IBM\Lotus\Notes\
FaultRecovery_Build=Release 8.5.3
Timezone=-8
DST=0
DSTLAW=4,1,1,10,-1,1
Directory=C:\Program Files (x86)\IBM\Lotus\Notes
USING_LOCAL_SHARED_MEM=1
LOCAL_SHARED_MEM_SESSION_ID=2
FileDlgDirectory=C:\Users\MyDomain\Documents
CONSOLE_ZCSDOMINOMIGRATIONWIZARD-8=80 300 7 150 150 827 492
KeyFileName=C:\Users\MyDomain\Desktop\Administrator.id
KeyFileName_Owner=CN=Administrator/O=MYDOMAIN
MailType=1
$$HasLANPort=1
Log=log.nsf, 1, 0, 7, 40000
PhoneLog=2
CONSOLE_Administrator/MyDomain=80 300 7 100 100 777 442
LOCAL_SHARED_MEM_SESSION_ID=2
SU_IN_PROGRESS=0
SU_NEXT_UPDATE=09/12/2014 12:24:45 PM
SU_FILE_CLEANUP=C:\Users\Administrator\AppData\Roaming\smkits
SUT_NEXT_UPDATE=09/12/2014 12:24:45 PM
FontIncrease=0
StandardWorkspace=1
DST=1
MailType=0
$$HasLANPort=1
$IEVersionMajor=6
$IEVersionMinor=1
WWWDSP_SYNC_BROWSERCACHE=1
WWWDSP_PREFETCH_OBJECT=1
EnableJavaApplets=1
EnablePlugins=1
Preferences=134257
PrefAPIVer=197
AltNameLanguage=en
ContentLanguage=en-US
WeekStart=1
ViewWeekStart=2
NavWeekStart=1
XLATE_CSID=52
SPELL_LANG=1033
SPELL_PREFERENCES=0
Region=en-US
DatePickerDirection=0
EnableBiDiNotes=0
GlobalTextDir=1
ScriptRTFVisualCaretMovement=0
Passthru_LogLevel=4
Console_LogLevel=2
VIEWIMP1=Lotus 1-2-3,0,_IWKSV,,.123,.WK1,.WK3,.WK4,.WKS,.WR1,.WRK,,4,
VIEWIMP2=Structured Text,0,_ISTR,,.CGN,.LTR,.STR,._UNKNOWN,,,1,
VIEWIMP3=Tabular Text,0,_ITAB,,.PRN,.RPT,.TAB,.TXT,.TSV,,1,
VIEWIMP4=vCard,0,_IVCRD,,.VCF,,1,
VIEWIMP5=Calendar File (.ics),0,_IICAL,,.ICS,.VCS,,1,
VIEWIMP6=Comma Separated Value,0,_ICSV,,.CSV,,1,
VIEWEXP1=Comma Separated Value,0,_XCSV,,.CSV,,1,
VIEWEXP2=Lotus 1-2-3,0,_XWKS,,.123,.WK1,.WK3,.WK4,.WKS,.WR1,.WRK,,4,
VIEWEXP3=Structured Text,0,_XSTR,,.CGN,.LTR,.STR,._UNKNOWN,,1,
VIEWEXP4=Tabular Text,1,_XTAB,,.CGN,.LTR,.RPT,.TAB,.TXT,,1,
VIEWEXP5=vCard,0,_XVCRD3,,.VCF,,1,
VIEWEXP6=Calendar File (.ics),0,_XICAL,,.ICS,,1,
EDITIMP1=ASCII Text,0,_ITEXT,,.C,.H,.PRN,.RIP,.TXT,,1,
EDITIMP2=Binary with Text,0,_ISTRNGS,,.*,,1,
EDITIMP3=BMP Image,0,_IBMP,,.BMP,,18,
EDITIMP4=CGM Image,0,_IFL,,.CGM,.GMF,,8,
EDITIMP5=GIF Image,0,_IGIF,,.GIF,,18,
EDITIMP6=HTML File,0,_IHTML,,.HTM,.HTML,,1,
EDITIMP7=JPEG Image,0,_IJPEG,,.JPG,.JPEG,,18,
EDITIMP8=Lotus 1-2-3,0,_IW4W,_IWKSE,.123,.WK1,.WK3,.WK4,.WKS,.WR1,.WRK,,4,
EDITIMP9=Lotus PIC,0,_IPIC,,.PIC,,8,
EDITIMP10=Lotus Word Pro,0,_IW4W,,.LWP,,2,
EDITIMP11=Microsoft Excel,0,_IW4W,,.XLS,,4,
EDITIMP12=Microsoft RTF,0,_IRTF,_IW4W,.RTF,,2,
EDITIMP13=Microsoft Word,0,_IW4W,,.DOC,,2,
EDITIMP14=Network Portable Graphics,0,_IW4W,,.PNG,,18,
EDITIMP15=PCX Image,0,_IPCX,,.PCX,,18,
EDITIMP16=TIFF 5.0 Image,0,_ITIFF,,.TIF,,18,
EDITIMP17=WordPerfect,0,_IW4W,,.WPD,.WPT,,2,
EDITIMP18=Unsupported File as Text,0,_ITEXT,,.*,._UNKNOWN,,1,
EDITIMP19=Symphony Document (.ODT),0,_IW4W,,.ODT,,2,
EDITIMP20=Symphony Spreadsheet (.ODS),0,_IW4W,,.ODS,,2,
EDITIMP21=Symphony Presentation (.ODP),0,_IW4W,,.ODP,,2,
EDITIMP22=Microsoft Word 2007,0,_IW4W,,.DOCX,,2,
EDITIMP23=Microsoft Excel 2007,0,_IW4W,,.XLSX,,2,
EDITEXP1=ASCII Text,2,_XTEXT,,.C,.H,.PRN,.RIP,.TXT,._UNKNOWN,,1,
EDITEXP2=CGM Image,2,_XCGM,,.CGM,.GMF,,8,
EDITEXP3=Microsoft RTF,2,_XRTF,,.DOC,.RTF,,4,
EDITEXP4=TIFF 5.0 Image,2,_XTIFF,,.TIF,,18,
EDITEXP5=vCard,0,_XVCRD3,,.VCF,,1,
DDETimeout=10
NAMEDSTYLE0=030042617369630000000000000000000000000000000000000000000000000000000000000001010100000A0000000000000100A0050A0000006400A0050A0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000009404000000000000
NAMEDSTYLE0_FACE=Default Sans Serif
NAMEDSTYLE1=030042756C6C657400000000000000000000000000000000000000000000000000000000000001010100000A000000000000000008070A000000640008070A0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000049404000000000000
NAMEDSTYLE1_FACE=Default Sans Serif
NAMEDSTYLE2=0300486561646C696E6500000000000000000000000000000000000000000000000000000000010101010B0C0000000000000100A0050A0000006400A0050A0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000009404000000000000
NAMEDSTYLE2_FACE=Default Sans Serif
DefaultMailTemplate=mail85.ntf
TCPIP=TCP, 0, 15, 0
LAN0=NETBIOS, 0, 15, 0
Ports=TCPIP
DisabledPorts=LAN0
PhoneLog=2
SPELL_IMPORTED_UD=1
MailServer=10.0.10.9
NOTES_USER_POLICIES_SETUP_LEVEL=1
PoliciesLocalViewModTime=C1257D9B:0045C534
TemplateSetup=850300
VIEW_ICONPOPUP=1
Setup=850300
Location=Online,9EE,CN=Administrator/O=MYDOMAIN
IsUserUpgrade=0
LastProvisioningVersion=1363281176929
ECLSetup=3
MailUpgradeCheckTime=39BEE8
$headlineClientId=80B0757F:396CB990-88257A13:005D64F1
DontCheckDefaultMail=1
$USE_WCT_IM=1
$USE_ST_IM=0
SYMPHONY_INSTALLED=0
IDVAULT_COUNT1=0
IDVAULT_STAMP1=11/26/2014 03:02:04 AM
LastHistoryPruneTime=11/25/2014 01:49:58 PM
NewMailSeqNum=8
NewMailSeqNum88257957:003A606A=8
RoamingServerHasPolicy=0
ExitNotesPrompt=0
DESKWINDOWSIZE=41 42 1230 874
WINDOWSIZEWIN=25 19 1230 893
MAXIMIZED=0
WindowSizeBrowse=550 134 499 287
URLAddress1=Notes:///0000000000000E00/MailFS?OpenFrameset
WindowSizeChooseServers=474 134 331 309
WindowSizeOtherServer=471 134 337 212
WindowSizeChooseLocation=663 134 274 157
NAMES=names.nsf
Win32InfoboxPos=32 110
DisableMultiUserSwitchIDPrompt=1
BCASE_SITEMAP_DISPLAY=13
ReplDefFullDocs=1
ReplDefPartDocsLimit=0
ReplDefPartDocsLimitAmt=40
ReplDefPartAtchLimit=0
ReplDefPartAtchLimitAmt=40
ReplDefFullText=0
ReplDefEncrypt=1
ReplDefEncryptType=2
ReplDefReplImmed=1
LOCAL_DB_ENCRYPT_ENABLE=1
LOCAL_DB_ENCRYPT_DEFAULT=2
$headlineDisableHeadlines=0
PromptForLocation=0
EmptyTrash=0
AltCalendar=0
AdditionalTZMainCal=0
AdditionalTZSideCal=0
FooterWeekNo=0
FirstDayInYear=1
MinDaysInFirstWeek=1
MIMEPromptMultilingual=1
MIMEMultilingualMode=1
QuotePrefix=>
QuoteLineLength=70
EnableJavaScript=1
EnableJavaScriptErrorDialogs=1
EnableLiveConnect=1
BackgroundPrinting=1
ShowAccelerators=1
DisableImageDithering=1
MailSetup=850300
MailUpgradeFolder=850300
URLAddress2=notes:///ClientBookmark?OpenDatabases
SelectNamesDialogSize=320,959,134,497,
NameAddressingDlgLastViewName=0,List by name
WindowSizeReplSettings=355 134 569 405
WindowSizeReplHistory=348 134 583 232
SelectNameDialogSize=380,900,134,497,
TYPEDROPDOWNATTR=InternetAddress
TCPIP_TcpConnectTimeout=0,5
PURGE_DUPLICATE_CONTACTS=5
$DialogMode=0
SelectAddressesDialogSize=475,1125,134,470,
LAST_RECENT_CONTACT_CHECK=C1257C62:00469222
$DPABVersion=1.4
$EnableAlarms=0
CalendarTimeSlotStart=420
CalendarTimeSlotEnd=1140
CalendarTimeSlotDuration=60
$DontCheckDeleteConversation=0
NEXTDPABSYNC=01/23/2014 01:50:49 PM
StrIXDocSepCode=12
FindPeopleDlgSize=509,1091,134,495,
$CSBroadcast=0
NeedDPABcache=1
SU_DELAY_DAYS=0
WindowSizeCategorize=648 134 304 258[/code]
Tips tambahan:
BaseDN adalah nama domain. Contoh jika domain adalah mydomain.com, maka BaseDN adalah O=MYDOMAIN
Untuk DN, jika nama pengguna admin adalah Administrator dan domain adalah mydomain.com, DN adalah CN=Administrator O=MYDOMAIN
Bagaimana nak main spider solitaire pada Ubuntu?
Cari solitaire (tekan butang gambar logo Windows dan taip solitaire)
Klik “Play a different game” (gambar tangan atas kertas)
Pilih Spider
OS: Ubuntu 14.04 amd64
Pasang pakej-pakej diperlukan
sudo apt-get install deluged
sudo apt-get install deluge-console
Tetapkan pengguna dan katalaluan untuk akses remote. Anda mestilah telah log masuk sebagai pengguna yang bakal ditetapkan. segala arahan tanpa sudo dilakukan sebagai pengguna tersebut.
deluged
echo "username:password:10" >> ~/.config/deluge/auth
Tetapkan untuk akses remote
deluge-console "config -s allow_remote True"
deluge-console "config -s move_completed_path /home/username/deluge/completed"
deluge-console "config -s download_location /home/username/deluge/download"
deluge-console "config -s torrentfiles_location /home/username/deluge/torrents"
mkdir -p deluge/completed
mkdir deluge/download
mkdir deluge/torrents
Mulakan
deluge-console &
Pada klien, lumpuhkan classic mode
Tutup dan buka semula klien deluge
Tambahkan pelayan deluge yang ditetapkan tadi.
Hijau maknanya boleh disambungkan.
Tetapan dilakukan pada Ubuntu 14.04 64-bit
Tambah berikut di dalam /etc/apt/sources.list
deb http://download.virtualbox.org/virtualbox/debian trusty contrib
Pasang VirtualBox
wget -q http://download.virtualbox.org/virtualbox/debian/oracle_vbox.asc -O- | sudo apt-key add -
sudo apt-get install linux-headers-$(uname -r) build-essential virtualbox-4.3 dkms -y
sudo VBoxManage extpack install Oracle_VM_VirtualBox_Extension_Pack-4.3.18-96516.vbox-extpack
Tetapan servis web virtualbox pada /etc/default/virtualbox
VBOXWEB_USER="vbox"
VBOXWEB_TIMEOUT=0
VBOXWEB_LOGFILE="/var/log/vboxwebservice.log"
VBOXWEB_HOST="192.168.1.200"
Sediakan pengguna vbox
sudo useradd -g vboxusers vbox
sudo passwd vbox
sudo touch /var/log/vboxwebservice.log
sudo chown vbox:vboxusers /var/log/vboxwebservice.log
sudo mkdir -p /home/vbox/.VirtualBox
sudo service vboxweb-service start
Cara pemasangan GUI remote access VirtualBox (RemoteBox) pada Windows boleh didapati di http://remotebox.knobgoblin.org.uk/documentation.cgi
Untuk sambung ke servis remote virtualbox, klik Connect pada RemoteBox
Selepas cipta ‘guest’ bernama debian7-32bit
sudo su - vbox
mkdir /home/vbox/iso
Simpan iso (debian-7.1.0-i386-CD-1.iso) ke dalam /home/vbox/iso
Setakat versi 1.8.1, tiada lagi pilihan untuk menggunakan iso untuk pemasangan. gunakan cli sebagai pengguna vbox (ssh ke server virtualbox)
VBoxManage storageattach debian7-32bit –storagectl “IDE Controller” –port 0 –device 0 –type hdd –medium /home/vbox/iso/debian-7.1.0-i386-CD-1.iso
Beberapa ‘dependency’ perlu didapatkan
apt-get install libc6-i386
dpkg --add-architecture i386
apt-get update
apt-get install ia32-libs