sudo ifconfig wlan0 up

So, I am going to discuss about configuring MSSQL 2005 database mail in this topic. It is actually a function in MSSQL 2005 configured for sending email. However, MSSQL database mail function will connect to the configured mail relay service for relaying mail.

Configuration Steps of Database Mail (Log in via Windows Authentication mode)

Yeah… Pictures tell thousand of words.

Choose Set up Database Mail in Database Mail Configuration Wizard

A message saying Database Mail feature is not available will be prompted. Click Yes to enable it.

Create a new Database Mail profile

At the next wizard page, entering the SMTP relay server information. You could use IIS SMTP, mail server, etc.

Managing Profile Security

The profile can be either Public or Private. Assiging to Public means every users can use this profile. A private profile is accessible by specific users or roles only.

Configuring System parameters - Place for configuring the Database Mail parameters

Click Next to complete the configuring.

After finish, open a Query screen and entering below sql command to test the Database Mail function.

EXEC msdb.dbo.sp_send_dbmail @profile_name = ‘DBMailProfile’, @recipients = ‘recipient@domain.com’, @body = ‘This is a sample email’, @subject = ‘Subject: Database Mail’

Can always use View Database Mail Log function to check the sending process.

Note : Above SQL query is executable by sa user only. How if a specific users that need to execute this query? To allow specific user uses above created profile for sending email, this user must be a user in msdb database and a member of the DatabaseMailUserRole database role in msdb database. Once this permission has been granted, execute below sql query

EXEC msdb.dbo.sp_addrolemember @rolename = ‘DatabaseMailUserRole’
,@membername = ‘<user or role name>’;
GO

Done. This particular user can log in SQL Server Management Studio to execute MSSQL 2005 Database Mail sql command.

Enjoy reading.

As mine after finish installing, some errors occurred when executed vmware

/usr/lib/vmware/bin/vmware: /usr/lib/vmware/lib/libgcc_s.so.1/libgcc_s.so.1: version `GCC_3.4′ not found (required by /usr/lib/libcairo.so.2)
/usr/lib/vmware/bin/vmware: /usr/lib/vmware/lib/libgcc_s.so.1/libgcc_s.so.1: version `GCC_4.2.0′ not found (required by /usr/lib/libstdc++.so.6)
/usr/lib/vmware/bin/vmware: /usr/lib/vmware/lib/libgcc_s.so.1/libgcc_s.so.1: version `GCC_3.4′ not found (required by /usr/lib/libcairo.so.2)
/usr/lib/vmware/bin/vmware: /usr/lib/vmware/lib/libgcc_s.so.1/libgcc_s.so.1: version `GCC_4.2.0′ not found (required by /usr/lib/libstdc++.so.6)
/usr/lib/vmware/bin/vmware: /usr/lib/vmware/lib/libgcc_s.so.1/libgcc_s.so.1: version `GCC_3.4′ not found (required by /usr/lib/libcairo.so.2)
/usr/lib/vmware/bin/vmware: /usr/lib/vmware/lib/libgcc_s.so.1/libgcc_s.so.1: version `GCC_4.2.0′ not found (required by /usr/lib/libstdc++.so.6)

It was fixed by just simply executing below commands

sudo cp /usr/lib/libpng12.so.0 /usr/lib/vmware/lib/libpng12.so.0/

sudo cp /usr/lib/gcc/i486-linux-gnu/4.2.3/libgcc_s.so /usr/lib/vmware/lib/libgcc_s.so.1/libgcc_s.so.1

After some research, I learned to install tnef. Once tnef has been installed, execute tnef winmail.dat . A rar file will be output to the directory that consists winmail.dat . Thats it, extract the rar file to find the content inside winmail.dat .

Original guide from http://blog.andrewbeacock.com/2007/07/opening-winmaildat-tnef-files-in.html .

Keep wondering why my subtitle (srt) cant be displayed when I watch my avi movie with VLC. Though it was not compatible in Ubuntu whereby I was using XP last time which displayed well. Ah Hah. I got the luck solving the problem by edting a file /usr/share/applications/vlc.desktop .

Just need to edit vlc.desktop with su privileges and replace %U for Exec=vlc with %m .

Here we go, double click your avi file and the subtitle will be displaying well.

Without editing this file, you actually can get this problem done by drag the avi file straight into opened VLC. Kinda annoying. Why dont try this way to save the trouble.

I was trying to install conky to monitor my laptop process as I found that my firefox keep hogging. The installation is pretty simple and straight forward as any ubuntu users knew

Unfortunately, I got problem for this installation whereby some MPD error was throwing after I executed conky.

$ conky
Conky: desktop window (12000c1) is subwindow of root window (59)
Conky: window type – override
Conky: drawing to created window (3400001)
Conky: drawing to double buffer
Conky: MPD error: problems getting a response from “localhost” on port 6600 : Connection refused

Conky: MPD error: problems getting a response from “localhost” on port 6600 : Connection refused

Conky: MPD error: problems getting a response from “localhost” on port 6600 : Connection refused

Conky: MPD error: problems getting a response from “localhost” on port 6600 : Connection refused

Even though MPD configuration is commented in conky configuration, the error is still throwing. Hmmm, what shall do? Lets install MPD through Synaptic Package Manager to solve problem. Yeah. my conky is rocking now

W: GPG error: http://ppa.launchpad.net intrepid Release: The following signatures couldn’t be verified because the public key is not available: NO_PUBKEY 28A8205077558DD0

After researching around, found a fix for this kind of situation.

Type in,

gpg –keyserver keyserver.ubuntu.com –recv 247D1CFF

However, you need to replace 247D1CFF with your NO_PUBKEY-key last eight digits from the error-message to import the key. In my case, I replace 247D1CFF with 77558DD0.

After that, add the key to the software source with below command,

gpg –export –armor 247D1CFF | sudo apt-key add -

Again, replace 247D1CFF with your NO_PUBKEY-key last eight digits from the error-message.

You should see some OK message for this 2 command. Then, try running apt-get update and it will be fine.

Create a file .my.cnf in /root .

Insert below detail to .my.cnf

[client]
user=root
pass=mysql root password

# mysql

# create user wpuser identified by ‘wppass’;

Note : wpuser is the mysql username and follow by wppass is the mysql user password.

Grant privileges to mysql db :

# grant all privileges on wordpress.* to ‘wpuser’@'localhost’ identified by ‘wppass’;

Check privileges :

show grants for ‘wpuser’@'localhost’;
+————————————————————————————–+
| Grants for wpuser@localhost                                                          |
+————————————————————————————–+
| GRANT USAGE ON *.* TO ‘wpuser’@'localhost’ IDENTIFIED BY PASSWORD ‘7171e928058581f3′ |
| GRANT ALL PRIVILEGES ON `wordpress`.* TO ‘wpuser’@'localhost’                        |
+————————————————————————————–+
2 rows in set (0.01 sec)

The error faced when compiling PHP module to Apache2.

Sorry, I cannot run apxs.  Possible reasons follow:

1. Perl is not installed
2. apxs was not found. Try to pass the path using –with-apxs2=/path/to/apxs
3. Apache was not built using –enable-so (the apxs usage page is displayed)

The output of /usr/local/apache/bin/apxs follows:
./configure: /usr/local/apache/bin/apxs: /replace/with/path/to/perl/interpreter: bad interpreter: No such file or directory
configure: error: Aborting

Replace first line of /usr/local/apache/bin/apxs from,

#!/replace/with/path/to/perl/interpreter

with

#!/usr/bin/perl -w

First of all, lets understand and differentiate some of the /etc/rc[0-6].d .

rc1.d >>> Single user mode

rc2.d >>> Custom user mode

rc3.d >>>Multiple user mode with networking availability

rc4.d >>> Custom user mode

rc5.d >>> Multiple user mode with networking availability that has GUI mode (xlogin)

# chkconfig –list
haldaemon       0:off   1:off   2:off   3:on    4:on    5:on    6:off
httpd           0:off   1:off   2:off   3:on    4:off   5:off   6:off
ip6tables       0:off   1:off   2:on    3:on    4:on    5:on    6:off
iptables        0:off   1:off   2:on    3:on    4:on    5:on    6:off
kudzu           0:off   1:off   2:off   3:on    4:on    5:on    6:off
lvm2-monitor    0:off   1:on    2:on    3:on    4:on    5:on    6:off
mcstrans        0:off   1:off   2:on    3:on    4:on    5:on    6:off
messagebus      0:off   1:off   2:off   3:on    4:on    5:on    6:off
multipathd      0:off   1:off   2:off   3:off   4:off   5:off   6:off
mysqld          0:off   1:off   2:off   3:off    4:off   5:off   6:off
netconsole      0:off   1:off   2:off   3:off   4:off   5:off   6:off
netfs           0:off   1:off   2:off   3:on    4:on    5:on    6:off
netplugd        0:off   1:off   2:off   3:off   4:off   5:off   6:off
network         0:off   1:off   2:on    3:on    4:on    5:on    6:off
rdisc           0:off   1:off   2:off   3:off   4:off   5:off   6:off
restorecond     0:off   1:off   2:on    3:on    4:on    5:on    6:off
sshd            0:off   1:off   2:on    3:on    4:on    5:on    6:off
syslog          0:off   1:off   2:on    3:on    4:on    5:on    6:off

Now, mysqld service was set to off for rc3.d . We are going to On it in rc3.d level with below command.

# chkconfig –levels 3 mysqld on

Will see S64mysqld in /etc/rc3.d in my case. I see K36mysqld when levels 3 was off in my case.

Add user:

# useradd ftpuser

Check user:

# less /etc/passwd

ftpuser:x:500:500::/home/ftpuser:/bin/bash

Add group:

# groupadd ftpgroup

Check group:

# less /etc/group

ftpgroup:x:500:

Assign user to group:

# vi /etc/group

change ftpgroup:x:500: to ftpgroup:x:500:ftpuser

Install pureftp:

1. Download pureftp installation file from ftp://ftp.pureftpd.org/pub/pure-ftpd/releases/ .
2. Extract the installation file at any directory.
3. Run ./configure –with-everything –with-paranoidmsg –without-capabilities -with-virtualchroot
4. Run make & make install
5. Done

Copy pureftp configuration to /etc :

# cp pure-ftpd-1.0.21/configuration-file/pure-ftpd.conf /etc

Copy pureftp startup script to /usr/local/sbin/ :

# cp pure-ftpd-1.0.21/configuration-file/pure-config.pl /usr/local/sbin/

Create a ftp user :

# pure-pw useradd test -u ftpuser -d /home/directoryname

• useradd > option of pure-pw
• test > the ftp username
• -u > linux username
• ftpuser > the linux user that created
• -d > path to the upload directory
• /home/directoryname > path name

Show ftp user detail :

# pure-pw show test

Output :

Login              : test
Password           : $1$h8ZLTun0$iYCeCgrYfMz0BrbLC/6Ca1
UID                : 500 (ftpuser)
GID                : 500 (ftpgroup)
Directory          : /home/directory/./
Full name          :
Download bandwidth : 0 Kb (unlimited)
Upload   bandwidth : 0 Kb (unlimited)
Max files          : 0 (unlimited)
Max size           : 0 Mb (unlimited)
Ratio              : 0:0 (unlimited:unlimited)
Allowed local  IPs :
Denied  local  IPs :
Allowed client IPs :
Denied  client IPs :
Time restrictions  : 0000-0000 (unlimited)
Max sim sessions   : 0 (unlimited)

Check ftp user option :

# pure-pw usermod test -h

Ftp user option normally stored in /etc/pureftpd.passwd . You will something like below when open this file.

test:$1$vrb6.MK0$/shIogHo4RVvQXr8bJSBe/:500:500::/home/directory/::::::::::::

Generate ftp database :

# pure-pw mkdb

The ftp database file will be created at /etc and named pureftpd.pdb .

Un-comment PureDB & AltLog varialble that store in /etc/pure-ftpd.conf .

Now, we can start the ftp service

# /usr/local/sbin/pure-config.pl /etc/pure-ftpd.conf

Done !!! Pureftp is installed. May try to connect to the ftp service via ftp client or ftp command.

Useful when working in some virtual OS to retrieve IP.

Even you can kill the process of dhclient if there is problem for retrieving new IP.

First of all, run

ps aux | grep dhclient

to grab the PID and kill it. After that, execute again dhclient eth0.

/usr/sbin/setenforce 0

sudo dpkg-reconfigure gdm

I experienced this caused I installed KDE to my system

root@servername [~]# service httpd start

(98)Address already in use: make_sock: could not bind to address 0.0.0.0:80

no listening sockets available, shutting down

Unable to open logs

Lets run the netstat to check the Apache process is hook up with which other process.

root@servername [~]# netstat -lnp | grep ‘0.0.0.0:80′

tcp        0      0 0.0.0.0:80                  0.0.0.0:*                   LISTEN      22666/exim

Next, run the ps command to check above listening process

root@servername [~]# ps 22666

PID TTY      STAT   TIME COMMAND

22666 ?        S<s    0:00 /usr/sbin/exim -Mc 1L5ryZ-0005tZ-T0

GotYa. Is confirmed that Apache process could not stop due to Exim process.

Run the service reboot command to Exim service. Give a shoot by restarting Exim and then start Apache will wake up your Apache service.

Note : This is an example situation which it does not really relates to Exim process. It could be other process. Do check with netstat command and you will find out.

Solution : Enable Server Services

Description : Supports file, print, and named-pipe sharing over the network for this computer. If this service is stopped, these functions will be unavailable. If this service is disabled, any services that explicitly depend on it will fail to start.

Example Url : http://localhost/directory/A+B+C/filename.html
 

By default, IIS 7.0 rejects URLs that contain a double escape sequence.

WorkAround

1. Open web.config and add

<system.webServer>
		<security>
			<requestFiltering allowDoubleEscaping="True"/>
		</security>
	</system.webServer>
</configuration>

2. Save

Now, I’m back to post, reply, view blog. Gzeee.

Above path is actually the Jailshell configuration path created by WHM when a Cpanel user was granted with shell access.

Note : Do not delete any data inside /home/virtfs/Cpanelusername as it can screw up your Cpanel server.

Reason : The /home/virtfs/ is created for user with Jailshell. Virtfs is hardlinked to some system files. By delete the data inside /home/virtfs/, you delete the actual system file they’re linked to. This is going to be bad and screw up your system file and delete other important data such as Mysql database. So, beware on this.
Shall you need to remove any shell access from any cpanel user, just navigate to WHM >> Manage Shell Access and disable Jailed Shell for users.

For your information, when we check the disk size for /home/virtfs/Cpanelusername. You will see some disk size. Imagine if there is few more cpanel user granted with Jailshell, there will few more directories create at /home/virtfs/. You will find there is more disk space after du -sh those directories. But don’t worry as it will not consume your actual server diskspace. Some advice which is /home/virtfs need to excluded from backup system.

Additionally, always be careful when run command ‘rm -rf *’. It will delete all the file with option of recursive and force. Need more information, visit here.

Hope this sharing could help someone to avoid causing error.