Searching Column Name From Table in Database

select table_name from information_schema.columns group by table_name


select table_name,column_name from information_schema.columns
where column_name like '%MGS_Groupcode%'

how to convert pdf file to word or excel

open this web  https://online2pdf.com/

and  then upload file pdf and convert file and finish.

nb: maximum file 50 Mb.

How to get all user accounts SQL Server

Get the list of all SQL User Accounts SQL Server:

SELECT name AS Login_Name, type_desc AS Account_Type
FROM sys.server_principals 
WHERE TYPE IN ('U', 'S', 'G')
and name not like '%##%'
ORDER BY name, type_desc


Get the list of all SQL User Accounts Database only

SELECT name
FROM sys.server_principals 
WHERE TYPE = 'S'
and name not like '%##%'

Get the list of all Windows User Accounts only
SELECT name
FROM sys.server_principals 
WHERE TYPE = 'U'

Get the list of all Windows Group User Accounts only
SELECT name
FROM sys.server_principals 
WHERE TYPE = 'G'

VLC is unable to open the MRL smb://

When I tried to open remote video files with VLC via a Samba share , but I got this error message:
Your input can't be opened:
VLC is unable to open the MRL 'smb://...'
It seems that this problem is related to credentials and can be fixed by entering the credentials for the Samba share in the VLC preferences

Tools > Preferences > Input / Codecs > Access Modules > SMB Input

insert user and password

user     :
password :
domain   :

good luck

Kernel panic - not syncing Attempted to kill init

Kernel panic  while installing Centos 6.2 / 6.3 / 6.5  x64 bit LiveCD / DVD.

The error like this :

Kernel panic - not syncing: Attempted to kill init!
Pid: 1, comm: init Not tainted 2.6.32-279.5.1.el6.x86_64 #1
Call Trace:
[<ffffffff814fd24a>] ? panic+0xa0/0x168
[<ffffffff81070bd2>] ? do_exit+0x862/0x870
[<ffffffff8117cba5>] ? fput+0x25/0x30
[<ffffffff81070c38>] ? do_group_exit+0x58/0xd0
[<ffffffff81070cc7>] ? sys_exit_group+0x17/0x20
[<ffffffff8100b0f2>] ? system_call_fastpath+0x16/0x1b


for solution :

please download iso Centos 6.5 full version here and then burning to DVD.

good luck.

How to Install VLC Player On Centos 6

Add Repository 

- First login with user “root”
- Next run the following commands


# cd /etc/yum.repos.d/

# wget http://pkgrepo.linuxtech.net/el6/release/linuxtech.repo



Check VLC version in Repo

# yum list *vlc*



Install VLC Player

- Run the command below to install vlc

# yum -y install vlc

membuat bilangan acak pada php

function yang digunakan  rand()

contoh ;

<?php
$bilangan = rand(2,18);
echo $bilangan;
?>

How to open winmail.dat file on centos

How to open winmail.dat file on centos

#yum install tnef

#tnef winmail.dat

How to open winmail.dat files on Ubuntu / Debian

install tnef
#sudo apt-get install tnef

extract file winmail.dat
#tnef winmail.dat

Install GCC Compiler on centos

Install gcc

[root@localhost /]# yum install gcc gcc-c++


check gcc version

[root@localhost /]# gcc --version
gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-11)
Copyright (C) 2010 Free Software Foundation, Inc.
This is free software; see the source for copying conditions.  There is NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.


Test gcc C compiler with a sample foo.c program

Create a file called test.c :
#vim test.c

add text like this :

#include<stdio.h>
int main(void){
printf("Hello World!\n");
return 0;
}


To compile test.c into foo executable file, type:
# cc test.c -o test


To execute foo program, type:

# ./test
Hello World!

instlal compiler on centos

Setup a basic development environment  on CentOS Enterprise Linux  :

1. autoconf
2. automake
3. binutils
4. bison
5. flex
6. gcc
7. gcc-c++
8. gettext
9. libtool
10. make
11. patch
12. pkgconfig
13. redhat-rpm-config
14. rpm-build
15. rpm-sign
16. libstdc++-devel 
17. libstdc++
18. c++
19. wxGTK-devel
20. wxGTK

#yum install wxGTK-devel wxGTK autoconf automake binutils bison flex gcc gcc-c++ gettext libtool make patch pkgconfig redhat-rpm-config rpm-build rpm-sign libstdc++-devel libstdc++ c++

Remote Desktop (rdesktop) in Redhat/Fedora/CentOS

About Rdesktop

Rdesktop application is use to connect RDP (Remote Desktop Protocol) of any Operating System like Windows XP, Window NT, Windows 2003/2008, Windows Vista and Windows 7 from Linux machine. It’s a client utility for Remote Desktop Protocol (RDP). In this article we are going to view how we can take remote desktop of Windows Terminal using Hostname and IP Address.

Please make sure following points before connecting to remote host.

1. Enable RDP port no. 3389 in Firewall.
2. Enable remote desktop under Windows Operating System.
3. Require at least one user with password.
4. Under MS-Windows desktop >> Right Click on My Computer >> Select properties >> Select Remote tab >> Enable Remote desktop >> Save the changes.

Install rdesktop (Remote Desktop)

#rpm -qa rdesktop

#yum -y install rdesktop


How to use rdesktop with hostname
To connect Windows host from Linux desktop type following command using -u parameter as username (narad) and (ft2) as hostname of my Windows host. To resolve host name make entry at /etc/hosts file if you don’t have DNS Server in your environm


rdesktop -u user_login IP_Host

example :

#rdesktop -u administrator 192.168.1.7