Mysql Problem, Operating system error number 13 in a file operation

Posted by cikul | Posted in Linux, SQL | Posted on 31-07-2017-05-2008

0

Mysql Fail to start, check in /var/log/mysqld.log :


170731 16:56:50 InnoDB: Initializing buffer pool, size = 8.0M
170731 16:56:50 InnoDB: Completed initialization of buffer pool
170731 16:56:50 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.
170731 16:56:50 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

 

Cause :

Permission problem in /var/lib/mysql

Solutions :

  1. Ensure user and group permission on /var/lib/mysql is mysql
  2. Check SELINUX Configuration : getenforce
  3. If SELINUX enabled, disabled with command : setenforce 0
  4. For permanent disable, edit /etc/selinux/config and set SELINUX=disabled
  5. Try to restart mysql service

Create Bootable CentOS USB from Mac OS

Posted by cikul | Posted in Linux, Mac OS | Posted on 22-06-2017-05-2008

0

Create img file from downloaded iso :

Fors-MacBook-Air:Downloads cikul$ hdiutil convert -format UDRW -o CentOS-69.img CentOS-6.9-x86_64-minimal.iso        
Reading CentOS_6.9_Final                 (Apple_ISO : 0)…
...............................................................................................................................................................................................
Reading  (Apple_Free : 1)…
Elapsed Time:  2.059s
Speed: 198.1Mbytes/sec
Savings: 0.0%
created: /Users/cikul/Downloads/CentOS-69.img.dmg

List All Devices, and umount USB before flashing new image

Fors-MacBook-Air:~ cikul$ diskutil list
/dev/disk0 (internal, physical):
   #:                       TYPE NAME                    SIZE       IDENTIFIER
   0:      GUID_partition_scheme                        *121.3 GB   disk0
   1:                        EFI EFI                     209.7 MB   disk0s1
   2:          Apple_CoreStorage For Sale                120.5 GB   disk0s2
   3:                 Apple_Boot Recovery HD             650.0 MB   disk0s3

/dev/disk1 (internal, virtual):
   #:                       TYPE NAME                    SIZE       IDENTIFIER
   0:                  Apple_HFS Dhika Cikul            +120.1 GB   disk1
                                 Logical Volume on disk0s2
                                 EC5A9E2D-8AD9-4317-8AA6-D42A92874136
                                 Unencrypted

/dev/disk2 (external, physical):
   #:                       TYPE NAME                    SIZE       IDENTIFIER
   0:     FDisk_partition_scheme                        *15.4 GB    disk2
   1:             Windows_FAT_32 NO NAME                 15.4 GB    disk2s1

Fors-MacBook-Air:~ cikul$ diskutil unmountDisk /dev/disk2
Unmount of all volumes on disk2 was successful

Use dd utility to copy the iso/img to USB Flash :

Fors-MacBook-Air:Downloads cikul$ time sudo dd if=CentOS-69.img.dmg of=/dev/disk2 bs=1m
Password:
408+0 records in
408+0 records out
427819008 bytes transferred in 120.542862 secs (3549103 bytes/sec)

real	2m3.909s
user	0m0.016s
sys	0m7.868s

Done…

Add Static Route Linux – Windows – Mac OS

Posted by cikul | Posted in Linux, Mac OS, Windows | Posted on 22-06-2017-05-2008

0

In Linux the command is :


route add -net 172.17.18.0/24 gw 172.17.2.1

In Windows the command is :


route add 172.17.18.0 mask 255.255.255.0 172.17.2.1

In Mac OS the command is :


route -n add -net 172.17.18.0/24 172.17.2.1

Fix CentOS USB Install Problem

Posted by cikul | Posted in Linux | Posted on 01-06-2016-05-2008

0

When installing CentOS using USB stick, i experienced problem with repository install after partition


Unable to read package metadata. This may be due to missing repodata directory. Please ensure that your install tree has been correctly generated. Failare: repodata/743fec56b2af0ce8d6ec82c47a4efafc2a4d18cddfa9683f29611cb18d1a33de-primary.sqlite.bz2 from anaconda-CentOS-201311271240.i386: [Ermo 256] No more mirrors to try.

The problem is because installer cannot found the file which described in repomd file located in /repodata folder

To fix the problem, go to /repodata folder on your usb stick, and change the file under repodata matched to the parameter configured in repomd file, for example :

in repomd location :

location href=”repodata/b124f0ec5323cfee56b420906a3103f0daef656dde3f7ac8220120aa7504e57a-primary.xml.gz”

so you must find the file under /repodata folder which matched with the configuration, and change the extension in accordance with the parameter configured in repomd file.

Change & Reset Mysql Password

Posted by cikul | Posted in Linux, SQL, Tips | Posted on 18-10-2015-05-2008

0

This tutorial explains how to change or reset your MySQL root password under Unix-Like Operating Systems (Linux, FreeBSD, OpenBSD, etc) over SSH. MySQL root account should be managed carefully.

As a system administrator, we must ensure that the password is safe and prevent from unauthorized access.

There are some method to change mysql password :

Type 1 : use mysqladmin

However, if you want to change mysql root/user password, mysql had tool to simplify the process using mysqladmin command, the syntax is :


$ mysqladmin -u root -p'oldpassword' password newpass
$ mysqladmin -u dbuser -p'oldpassword' password 'itsnewpassword';

Read the rest of this entry »

[CentOS] Merubah Gambar Background GRUB saat booting

Posted by cikul | Posted in Linux | Posted on 01-03-2015-05-2008

0

Gambar pada tampilan awal GRUB biasanya mengikuti distro linux yang kita gunakan, seperti contoh untuk CentOS maka Tampilan awal GRUB akan menampilkan gambar background dari CentOS seperti gambar berikut

grubCentOS

Tampilan Splash Screen GRUB

sekarang bagaimana cara kita mengganti background image default tersebut?

Read the rest of this entry »

Completely Uninstall Kloxo-MR

Posted by cikul | Posted in cpanel, Free Stuff, Internet, Linux | Posted on 13-11-2014-05-2008

2

Based on my experience, it’s easy to find tutorial how to install Kloxo-MR, but hard to find tutorial how to uninstall Kloxo-MR, lack of documentation for Kloxo-MR make the installation of Kloxomr difficult for some system administrators.

If you had problem during kloxo-mr installation, the easy way to troubleshoot is recreate your VPS container, but if you won’t do that, you can reinstalling kloxo-mr from scratch, but make sure the system has clean from previous install to avoid problem.

Read the rest of this entry »

Record Shell Session in Linux

Posted by cikul | Posted in Linux | Posted on 03-12-2013-05-2008

0

Sometimes we need to log all activity we do in linux terminal. That is no problem if your terminal client had the feature, but if your terminal client don’t have feature to log your session, you can use “script” command record everything you do in a terminal session.

it’s very simple to use script, you only type this command from your shell


script -a filename

Now everything you type, as well as everything that returns as output, will be saved into the filename you chose to output to.

To stop script session, type “exit”, and script daemon will stop to recording your session


[root@server ]# exit
exit
Script done

Incoming search terms:

acer z4 kaskus | 

Install MariaDB on CentOS

Posted by cikul | Posted in Linux | Posted on 28-11-2013-05-2008

0

MariaDB repositories doesn’t included by default on CentOS.
If you want to install MariaDB using YUM, you need to add MariaDB repository

nano /etc/yum.repos.d/MariaDB.repo

Read the rest of this entry »

[CentOS-RedHat] Linux /boot: Out of Disk Space While Installing Package kernel

Posted by cikul | Posted in Linux | Posted on 21-01-2013-05-2008

0

When updating Kernel using YUM, i got this error message :

Transaction Check Error:
  installing package kernel-2.6.32-379.14.1.lve1.1.9.9.el6.x86_64 needs 10MB on the /boot filesystem
Error Summary
-------------
Disk Requirements:
  At least 10MB more space needed on the /boot filesystem.

It means /boot partition is out of disk space. You need to verify this with the df command

Read the rest of this entry »

Incoming search terms:

JU0R | service1i7 |