Sunday, April 27, 2014

Enable "Other User" Option For The Login Manager In Ubuntu 12.04

Enable "Other User" Option For The Login Manager In Ubuntu 12.04
1. Login as a normal user which you have created during Installation.
2. Edit the /etc/lightdm/lightdm.conf file

3. First of all Please take backup of original file 
         # cp -p /etc/lightdm/lightdm.conf /etc/lightdm/lightdm.conf.orig
4. Execute Following command :-
#/usr/lib/lightdm/lightdm-set-defaults -m true
       #/etc/init.d/lightdm restart
                           OR
4. Edit the /etc/lightdm/lightdm.conf file
         # vi /etc/lightdm/lightdm.conf
Now Please enter following line to [SeatDefaults] Selection:-
        greeter-show-manual-login=true

Check And Clear Memory On Ubuntu

Check Memory Usage On Ubuntu :  free -m
Clear Cached Memory On Ubuntu : sudo echo 3 > /proc/sys/vm/drop_caches

Friday, April 11, 2014

Terminal Connection Exceed The Limit

Sometimes when we try to take Remote Desktop of an another machine, it shows an error "Terminal Connection Exceeds the Limit"
                      mstsc.exe /v:IP Address /f -admin

Eg : mstsc.exe /v:192.168.172.233 /f -admin

Quickly Create Large File On A Windows

Create Large File On A Windows:
             fsutil file createnew filename length
                                Where length is in bytes.                               
Eg: A 500 MB Text file is creating on C Drive
C:\>fsutil file createnew hari.txt 500000000
File C:\hari.txt is created

Wednesday, April 2, 2014

Connecting MYSQL Database Via Remotely

Connecting MYSQL Database From a Particular Remote Machine
GRANT ALL PRIVILEGES ON *.* TO 'USERNAME'@'IP' IDENTIFIED BY 'PASSWORD';
                                            Where IP is the IP you want to allow access and USERNAME is the user you use to connect.
Connecting MYSQL Database From Any Remote Machine
If you want to allow access from any IP just put % instead of your IP
GRANT ALL PRIVILEGES ON *.* TO 'USERNAME'@'%' IDENTIFIED BY 'PASSWORD';
FLUSH PRIVILEGES;
Eg :- DB Name :- test / MySql Server IP :- 10.3.3.111 /  Client IP:-- 192.168.172.17
1. For accessing DB remotely Disabled the Skip Networking Options From my.inf file on Server
2. Want to Create the user name ictops and password ictops
3. Enter MYSQL Prompt mysql -u root -p
mysql> GRANT ALL PRIVILEGES ON test.* to 'ictops'@'192.168.172.17' identified by 'ictops';
Above line for that IP only. For Full network
mysql> GRANT ALL PRIVILEGES ON test.* to 'ictops'@'192.168.172.%' identified by 'ictops';

Tuesday, April 1, 2014

Web Based Terminal Accessing For Ubuntu

For accessing a Ubuntu machine via Web Based Install-Configure install shellinabox package

1. Update the Ubuntu Server
root@ubuntu:~# apt-get update

2. Download & install shellinabox package

For 32-bit:
wget http://archive.ubuntu.com/ubuntu/pool/universe/s/shellinabox/shellinabox_2.14-1_i386.deb
For 64-bit
wget http://archive.ubuntu.com/ubuntu/pool/universe/s/shellinabox/shellinabox_2.14-1_amd64.deb

3. Install Package
root@ubuntu:~# dpkg -i shellinabox_2.14-1_i386.deb
4. For Checking the service status
root@ubuntu:~# /etc/init.d/shellinabox status
Shell In A Box Daemon is not running

5. Services Manages Commands
sudo service shellinabox start
sudo service shellinabox stop
sudo service shellinabox reload
6. Accessing Via Browser
htps ://ip :4200

Foreign Key Constraint Fails Error

A Foreign Key Constraint Fails Error, when trying to delete a MYSQL Database
         mysql> SET foreign_key_checks = 0;
         mysql> drop database
         mysql> SET foreign_key_checks = 1;
bloggerwidgets