Server 2008R2 Standard giving "This copy of windows is not genuine" error, cannot run windows activation

I was wonder why my old server giving error to windows is not genuine... Some how this old server was activate with licence.

Here is the problem:
There is few services which is not started:

• Software Protection

• SPP Notification Service

Clean Microsoft WSUS Content Folder

1) Correct any settings above or disapprove any approved updates.

2) Close any open WSUS consoles.

3) Go to Administrative Tools – Services and STOP the Update Services service.

4) In Windows Explorer browse to the WSUSContent folder (typically D:\WSUS\WSUSContent or C:\WSUS\WSUSContent)

5) Delete ALL the files and folders in the WSUSContent folder.

6) Go to Administrative Tools – Services and START the Update Services service.

7) Open a command prompt and navigate to the folder: C:\Program Files\Update Services\Tools.

8) Run the command WSUSUtil.exe RESET

Refference: http://blogs.technet.com/b/gborger/archive/2009/02/27/what-to-do-when-your-wsuscontent-folder-grows-too-large.aspx

Very Bery Busy

It takes along time not updating new post. Its doesn't mean that I am not gaining any new technology/knowledge but to much work but less resource cause me have no time to update and share the information to all readers.

Here are the list of info that I should update to my blog; 

1. Amazon hardisk static and magnetic

2. How to install SCCM which I already done last year.. but still have no time to share.

3. Attending SCCM training at infotech

4. Direct Access to allow end user to auto receive changes of their password from the their domain laptop outside from office. (Done and work with charm)

5.  Backup PC installation

6. Voip Technology -Setup for new building

Currently... MSSQL cluster.. still study on it... but not sure will finish since I need to migrate few apps in win 2003 which already end of life this April 2015. 

Huuuh many thing to write.. and many task to be done as well.. 

Will update all of you later. 

Bye.. 

Vbulletin 4 change URL

step vb4

1. change config.php

                disable can cache

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

                //$config['Datastore']['class'] = 'vB_Datastore_Memcached';

                enable kan

                ----------

                $config['Datastore']['class'] = 'vB_Datastore_Filecache';

2. http-vhost & etc\host (PC) ke apps tuh..

change old.contoso.com

utk check dia pi tak kat folder tuh.. letak laa file nih..

pening.php

< ? php
echo "new.contoso.com!";
? >

Browse vb.mediu.edu.my/pening.php -> kalu betol.. sila masuk vb.mediu.edu.my/admincp & terus ke step bawah ni

3. You can change the primary URL of your vBulletin installation via:

AdminCP > vBulletin Options > vBulletin Options > Site Name/URL/Contact Details

4. Afterward you need to reset Cookie path and Domain to the dafault values using

AdminCP -> vBulletin Options -> Cookies and HTTP Header Options

Lepas tuh.. jangan logout dulu.. pi ke browser lain.. login new.contoso.com/admincp -> kalu dapat masuk… TAHNIAH J kalu tak Berjaya.. tak tau la NASIB laa tuh..

Cannot run basic command in linux/unix

Sometime you have problem to run simple command like :
ifconfig, adduser etc..

If you have problem like that, you can run from /sbin/ifconfig or etc..

Mysql Check

1. Check a Specific Table in a Database

If your application gives an error message saying that a specific table is corrupted, execute the mysqlcheck command to check that one table.

The following example checks TableName table in DBNAME database.

# mysqlcheck -c DBNAME TableName -u root -p

Enter password:

DBNAME.TableName    OK

You should pass the username/password to the mysqlcheck command. If not, you’ll get the following error message.

# mysqlcheck -c DBNAME TableName

mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect

Please note that myisamchk command that we discussed a while back works similar to the mysqlcheck command. However, the advantage of mysqlcheck command is that it can be executed when the mysql daemon is running. So, using mysqlcheck command you can check and repair corrupted table while the database is still running.

2. Check All Tables in a Database

To check all the tables in a particular database, don’t specify the table name. Just specify the database name.

The following example checks all the tables in the DBNAME2 database.

# mysqlcheck -c DBNAME2  -u root -p

Enter password:

DBNAME2.JBPM_ACTION                               OK

DBNAME2.JBPM_BYTEARRAY                            OK

DBNAME2.JBPM_BYTEBLOCK                            OK

DBNAME2.JBPM_COMMENT                              OK

DBNAME2.JBPM_DECISIONCONDITIONS                   OK

DBNAME2.JBPM_DELEGATION                           OK

DBNAME2.JBPM_EVENT                                OK

..

3. Check All Tables and All Databases

To check all the tables and all the databases use the “–all-databases” along with -c option as shown below.

# mysqlcheck -c  -u root -p --all-databases

Enter password:

DBNAME.TableName                              OK

DBNAME2.JBPM_ACTION                               OK

DBNAME2.JBPM_BYTEARRAY                            OK

DBNAME2.JBPM_BYTEBLOCK                            OK

..

..

mysql.help_category

error    : Table upgrade required. Please do "REPAIR TABLE `help_category`" or dump/reload to fix it!

mysql.help_keyword

error    : Table upgrade required. Please do "REPAIR TABLE `help_keyword`" or dump/reload to fix it!

..

If you want to check all tables of few databases, specify the database names using “–databases”.

The following example checks all the tables in DBNAME and DBNAME2 database.

# mysqlcheck -c  -u root -p --databases DBNAME DBNAME2

Enter password:

DBNAME.TableName                              OK

DBNAME2.JBPM_ACTION                               OK

DBNAME2.JBPM_BYTEARRAY                            OK

DBNAME2.JBPM_BYTEBLOCK                            OK

..

4. Analyze Tables using Mysqlcheck

The following analyzes TableName table that is located in DBNAME database.

# mysqlcheck -a DBNAME TableName -u root -p

Enter password:

DBNAME.TableName   Table is already up to date

Internally mysqlcheck command uses “ANALYZE TABLE” command. While mysqlcheck is executing the analyze command the table is locked and available for other process only in the read mode.

5. Optimize Tables using Mysqlcheck

The following optimizes TableName table that is located in DBNAME database.

# mysqlcheck -o DBNAME TableName -u root -p

Enter password:

DBNAME.TableName         OK

Internally mysqlcheck command uses “OPTIMIZE TABLE” command. When you delete lot of rows from a table, optimizing it helps to get the unused space and defragment the data file. This might improve performance on huge tables that has gone through several updates.

6. Repair Tables using Mysqlcheck

The following repairs TableName table that is located in DBNAME database.

# mysqlcheck -r DBNAME TableName -u root -p

Enter password:

DBNAME.TableName        OK

Internally mysqlcheck command uses “REPAIR TABLE” command. This will repair and fix a corrupted MyISAM and archive tables.

7. Combine Check, Optimize, and Repair Tables

Instead of checking and repairing separately. You can combine check, optimize and repair functionality together using “–auto-repair” as shown below.

The following checks, optimizes and repairs all the corrupted table in DBNAME database.

# mysqlcheck -u root -p --auto-repair -c -o DBNAME

You an also check, optimize and repair all the tables across all your databases using the following command.

# mysqlcheck -u root -p --auto-repair -c -o --all-databases

If you want to know what the command is doing while it is checking, add the –debug-info as shown below. This is helpful while you are checking a huge table.

# mysqlcheck --debug-info -u root -p --auto-repair -c -o DBNAME TableName

Enter password:

DBNAME.TableName  Table is already up to date

User time 0.00, System time 0.00

Maximum resident set size 0, Integral resident set size 0

Non-physical pagefaults 344, Physical pagefaults 0, Swaps 0

Blocks in 0 out 0, Messages in 0 out 0, Signals 0

Voluntary context switches 12, Involuntary context switches 9

8. Additional Useful Mysqlcheck Options

The following are some of the key options that you can use along with mysqlcheck.

§  -A, –all-databases Consider all the databases

§  -a, –analyze Analyze tables

§  -1, –all-in-1 Use one query per database with tables listed in a comma separated way

§  –auto-repair Repair the table automatically it if is corrupted

§  -c, –check Check table errors

§  -C, –check-only-changed Check tables that are changed since last check

§  -g, –check-upgrade Check for version dependent changes in the tables

§  -B, –databases Check more than one databases

§  -F, –fast Check tables that are not closed properly

§  –fix-db-names Fix DB names

§  –fix-table-names Fix table names

§  -f, –force Continue even when there is an error

§  -e, –extended Perform extended check on a table. This will take a long time to execute.

§  -m, –medium-check Faster than extended check option, but does most checks

§  -o, –optimize Optimize tables

§  -q, –quick Faster than medium check option

§  -r, –repair Fix the table corruption

Setup HAProxy Load Balancer on Ubuntu

Today I need to setup HAProxy Load Balance on Ubuntu. I think this month most of my task is on the clustering, load balance and HA. Last 2 weeks, I just finish my cluster for hyper-v. Luckily it's working very well.

Ok let go to the point...

1. Install HAProxy into Ubuntu Server.

# apt-get install haproxy

2. Change the HAProxy configuration. 

# nano etc/haproxy/haproxy.cfg

3. Add following text to file and save it

global

        log 127.0.0.1   daemon debug

        #log 127.0.0.1  local0

        #log 127.0.0.1  local1 notice

        #log loghost    local0 info

        stats socket /tmp/stats

        maxconn 4096

        pidfile /var/run/haproxy.pid

        #chroot /usr/share/haproxy

        #user haproxy

        #group haproxy

        daemon

        #debug

        #quiet

defaults

        log     global

        mode    http

        option  httplog

        option  dontlognull

        retries 3

        option redispatch

        maxconn 3000

        contimeout      5000

        clitimeout      50000

        srvtimeout      50000

listen  webcluster *:80

        mode http

        stats enable

        stats uri /stats           //default using http://web.domain.com/haproxy?stats

        stats auth admin:p@ssw0rd

        balance roundrobin

        option httpchk HEAD / HTTP/1.0

        option forwardfor

        cookie LSW_WEB insert

        option httpclose

        server  192.18.250.22 192.18.250.22:80 check inter 5000 fastinter 1000 fall 1 weight 1

        #server web1 192.18.250.22:80 weight 1 fastinter 5000 rise 2 fall 3

        server  192.18.250.23 192.18.250.23:80 check inter 5000 fastinter 1000 fall 1 weight 1

        #server web2 192.18.250.23:80 weight 1 fastinter 5000 rise 2 fall 3

        option  httpclose               # disable keep-alive

        option  checkcache              # block response if set-cookie & cacheable

        rspidel ^Set-cookie:\ IP=       # do not let this cookie tell our internal IP address

        #errorloc       502     http://192.168.114.58/error502.html

        #errorfile      503     /etc/haproxy/errors/503.http

        errorfile       400     /etc/haproxy/errors/400.http

        errorfile       403     /etc/haproxy/errors/403.http

        errorfile       408     /etc/haproxy/errors/408.http

        errorfile       500     /etc/haproxy/errors/500.http

        errorfile       502     /etc/haproxy/errors/502.http

        errorfile       503     /etc/haproxy/errors/503.http

        errorfile       504     /etc/haproxy/errors/504.http

3. Setting startup parameter for HAProxy set enabled as 1 to start HAproxy

# nano /etc/default/haproxy

4. Start HAProxy form command line

# /etc/init.d/haproxy start

5. Access Web user interface from browser

http://web.domain.com/stats