How to accept remote connections on MySQL

Configuration changes on MySQL to accept remote connections from a particular ipaddress

If you are using Debian Linux file is located at /etc/mysql/my.cnf location
If you are using Red Hat Linux/Fedora/Centos Linux file is located at /etc/my.cnf location
If you are using FreeBSD you need to create a file /var/db/mysql/my.cnf

now edit my.cnf depending on your Linux

vi /etc/mysql/my.cnf

Make sure line skip-networking is commented

Add line

bind-address=YOUR-SERVER-IP

exit my.cnf file after saving...

/etc/init.d/mysql restart

 open mysql prompt

 mysql -u root -p mysql

 GRANT ALL ON yourdatabasename.* TO username@'your-ipaddress' IDENTIFIED BY 
'PASSWORD';

*yourdatabasename is replace by your database name

*your-ipaddress  is replaced by ip address of remote machine from

                which you want to connect to MySql database

Migrating mantis to Redmine step by step separate servers or same server

If you are migration of same servers then its not a problem you can follow the below method

but if you are doing on different servers,

then make sure you configure Mantis MySql server to accept remote connections so that data
can be migrated remotely and when it asks for

Please enter settings for your Mantis database

adapter [mysql]:
host [localhost]: ( enter the IP address of Mantis server ) ( make sure MySql accept remote connections)

How to accept Remote connections on MySql

database [bugtracker]: mantis
username [root]: XXXX
password []: XXXX
encoding [UTF-8]:

rake redmine:migrate_from_mantis RAILS_ENV="production"
(in /opt/redmine)

WARNING: Your Redmine data will be deleted during this process.
Are you sure you want to continue ? [y/N] y

Please enter settings for your Mantis database
adapter [mysql]:
host [localhost]:
database [bugtracker]: mantis
username [root]: XXXX
password []: XXXX
encoding [UTF-8]:

Migrating users...................................................................................................................................................
Migrating projects..
Migrating bugs...................................................................................................................................................................................................................................................................................................................................
Migrating bug relations................
Migrating news.
Migrating custom fields

Users: 147/217
Projects: 2/2
Memberships: 1/1
Versions: 8/8
Categories: 0/0
Bugs: 323/463
Bug notes: 595/1553
Bug files: 28/60
Bug relations: 16/39
Bug monitors: 20/51
News: 1/2
Custom fields: 0/0

Ubunt Desktop startx error "exec: 5: /usr/bin/X11/X: not found"

startx
xauth: /home/serv01/.Xauthority not writable, changes will be ignored]xauth: error in locking authority file /home/serv01/.Xauthority (repeated 3 times)
exec: 5: /usr/bin/X11/X: not found
xinit: server error.
same as line 3
exec: 5: /usr/bin/X11/X: not found
xinit: server error

Solution is to install following packages

apt-get install xinit
apt-get install ubuntu-desktop

unzip tar.gz files

tar xzvf filename.tar.gz

Solution for : Error in my VM “SIOCSIFADDR: No such device eth0 after cloning

Actually when you clone a Virtual machine IP address conflict will come.

So we must be care full in production environment when turning on both the

Production and cloned virtual machines.

If you create a new Virtual machine before cloning and then add vmdk file

( cloned from vm) then there will be

a problem " SIOCSIFADDR: No such device eth0 " this is because cloned

vmdk file has one MAC address and when VM is created it generates another

MAC address so both address will be added so no device will be added to

solve this probelem

Go to

# Ubuntu
sudo mv /etc/udev/rules.d/70-persistent-net.rules

 /etc/udev/rules.d/70-persistent-net.rules.old

#Debian
sudo mv /etc/udev/rules.d/z25_persistent-net.rules

/etc/udev/rules.d/z25_persistent-net.rules.old

or you can simply remove 70-persistent-net.rules after

giving it a new static ip address

or go to /etc/udev/rules.d/70-persistent-net.rules

its content will be like this

# PCI device 0x1022:0x2000 (pcnet32)
SUBSYSTEM=="net", ACTION=="add", DRIVERS=="?*",

ATTR{address}=="00:0c:29:50:XX:XX", ATTR{type}=="1", NAME="eth0"

# PCI device 0x1022:0x2000 (pcnet32)
SUBSYSTEM=="net", ACTION=="add", DRIVERS=="?*",

ATTR{address}=="00:0c:29:36:XX:XX", ATTR{type}=="1", NAME="eth1"

now go and delete the first line eth0 this is created by the

cloned vm and not by vmware when creating a vm

so delete that line change the second line eth1 to eth0 and reboot

the machine

this will solve your problem....

Any queries post in comments section i will be replying

How to check hard disk health in linux step by step

First check for I/O errors in /var/log/messages if you found any error then there is something wrong with hard disk.

There is SMART utility for monitoring hard disks

SMART stands for Self-Monitoring, Analysis, and Reporting Technology

for using this SMART utilities first we should make sure that feature is enabled in BIOS

there are some tools that need to be installed for using this feature

to check weather SMART tools are installed and SMART commands work use this command

smartctl -i /dev/sda1 or sda2 etc...

In ubuntu we can install tools by

sudo apt-get install smartmontools

for checking health use

smartctl -a /dev/hda

example output

-------------------------------------------------------------------------------------

smartctl version 5.37 [i686-pc-linux-gnu] Copyright (C) 2002-6 Bruce Allen
Home page is http://smartmontools.sourceforge.net/

=== START OF INFORMATION SECTION ===
Model Family:     Western Digital Caviar SE family
Device Model:     WDC WD3200JB-00KFA0
Serial Number:    WD-WCAMR2493175
Firmware Version: 08.05J08
User Capacity:    320,072,933,376 bytes
Device is:        In smartctl database [for details use: -P show]
ATA Version is:   6
ATA Standard is: Exact ATA specification draft version not indicated
Local Time is:    Sat Apr 17 12:39:35 2010 CDT
SMART support is: Available - device has SMART capability.
SMART support is: Enabled

=== START OF READ SMART DATA SECTION ===
SMART overall-health self-assessment test result: PASSED

General SMART Values:
Offline data collection status: (0x84) Offline data collection activity
                                        was suspended by an interrupting command                              from host.
                                        Auto Offline Data Collection: Enabled.
Self-test execution status:      (   0) The previous self-test routine completed
                                        without error or no self-test has ever
                                        been run.
Total time to complete Offline
data collection:                 (9600) seconds.
Offline data collection
capabilities:                    (0x7b) SMART execute Offline immediate.
                                        Auto Offline data collection on/off supp                             ort.
                                        Suspend Offline collection upon new
                                        command.
                                        Offline surface scan supported.
                                        Self-test supported.
                                        Conveyance Self-test supported.
                                        Selective Self-test supported.
SMART capabilities:            (0x0003) Saves SMART data before entering
                                        power-saving mode.
                                        Supports SMART auto save timer.
Error logging capability:        (0x01) Error logging supported.
                                        No General Purpose Logging support.
Short self-test routine
recommended polling time:        (   2) minutes.
Extended self-test routine
recommended polling time:        ( 116) minutes.
Conveyance self-test routine
recommended polling time:        (   6) minutes.

SMART Attributes Data Structure revision number: 16
Vendor Specific SMART Attributes with Thresholds:
ID# ATTRIBUTE_NAME          FLAG     VALUE WORST THRESH TYPE      UPDATED WHEN_                             FAILED RAW_VALUE
1 Raw_Read_Error_Rate     0x000f   200   200   051    Pre-fail Always       -                                    0
3 Spin_Up_Time            0x0003   247   188   021    Pre-fail Always       -                                    2633
4 Start_Stop_Count        0x0032   100   100   000    Old_age   Always       -                                    949
5 Reallocated_Sector_Ct   0x0033   186   186   140    Pre-fail Always       -                                    105
7 Seek_Error_Rate         0x000f   200   200   051    Pre-fail Always       -                                    0
9 Power_On_Hours          0x0032   074   074   000    Old_age   Always       -                                    19124
10 Spin_Retry_Count        0x0013   100   100   051    Pre-fail Always       -                                    0
11 Calibration_Retry_Count 0x0012   100   100   051    Old_age   Always       -                                    0
12 Power_Cycle_Count       0x0032   100   100   000    Old_age   Always       -                                    876
194 Temperature_Celsius     0x0022   116   103   000    Old_age   Always       -                                    34
196 Reallocated_Event_Count 0x0032   180   180   000    Old_age   Always       -                                    20
197 Current_Pending_Sector 0x0012   200   200   000    Old_age   Always       -                                    0
198 Offline_Uncorrectable   0x0010   200   200   000    Old_age   Offline      -                                    0
199 UDMA_CRC_Error_Count    0x003e   200   200   000    Old_age   Always       -                                    0
200 Multi_Zone_Error_Rate   0x0009   200   200   051    Pre-fail Offline      -                                    0

SMART Error Log Version: 1
No Errors Logged

SMART Self-test log structure revision number 1
No self-tests have been logged. [To run self-tests, use: smartctl -t]

SMART Selective self-test log data structure revision number 1
SPAN MIN_LBA MAX_LBA CURRENT_TEST_STATUS
    1        0        0 Not_testing
    2        0        0 Not_testing
    3        0        0 Not_testing
    4        0        0 Not_testing
    5        0        0 Not_testing
Selective self-test flags (0x0):
After scanning selected spans, do NOT read-scan remainder of disk.
If Selective self-test is pending on power-up, resume after 0 minute delay.

--------------------------------------------------------------------------------------------------------------------------------

smartctl -d ata -a /dev/sda

smartctl -d ata -H /dev/sdb

smartctl -t long /dev/sda

example output

-----------------smartctl version 5.37 [i686-pc-linux-gnu] Copyright (C) 2002-6 Bruce Allen Home page is http://smartmontools.sourceforge.net/ === START OF OFFLINE IMMEDIATE AND SELF-TEST SECTION === Sending command: "Execute SMART Extended self-test routine immediately in off-line mode". Drive command "Execute SMART Extended self-test routine immediately in off-line mode" successful. Testing has begun. Please wait 116 minutes for test to complete. Test will complete after Sat Apr 17 14:49:23 2010

Once the test is completed we can see the output by

sudo smartctl -d ata --attributes --log=selftest /dev/sda

Diffrence between bridging and Routing

both Bridging and routing are used for connecting two or more networks

when bridge is installed it gathers all the packets from one network
then repeat them on other network.
it have features like Broadcast filtering
it takes place in data link layer of OSI model

Routers do packets exchange
they work in network layer of OSI model
they provide various ways of filtering
like path control and traffic control.

How to Display total hard disk size in linux

fdisk -l | grep Disk

install GNU/GCC compiler tools collection command

apt-get install build-essential

Solve "session lasted 10 seconds" error in Ubuntu

session lasted 10 seconds

/etc/gdm/Xsession: Beginning session setup...
/etc/gdm/Xsession: line 73: ls: command not found
/etc/gdm/Xsession: Executing default failed, will try to run x-terminal-emulator /etc/gdm/Xsession: line 224: exec: x-terminal-emulator: not found

Have you installed any packages like JAVA etc then you probably done mistake in
setting the path variables so ...............

Check the PATH settings in
/etc/environment
and /etc/bash.bashrc

remove extra settings if any
this worked for me

Please post comments if this worked for you ....

LearnAdmin

Labels