Archive for the ‘Windows’ Category

This is a list of handy MySQL commands that I use frequently.

Below when you see # it means from the unix shell. When you see mysql> it means from a MySQL prompt after logging into MySQL.

To login (from unix shell) use -h only if needed.
# [mysql dir]/bin/mysql -h hostname -u root -p

Create a database on the sql server.
mysql> create database [databasename];

List all databases on the sql server.
mysql> show databases;

Switch to a database.
mysql> use [db name];

To see all the tables in the db.
mysql> show tables;

To see database’s field formats.
mysql> describe [table name];

To delete a db.
mysql> drop database [database name];

To delete a table.
mysql> drop table [table name];

Show all data in a table.
mysql> SELECT * FROM [table name];

Returns the columns and column information pertaining to the designated table.
mysql> show columns from [table name];

Show certain selected rows with the value “whatever”.
mysql> SELECT * FROM [table name] WHERE [field name] = "whatever";

Show all records containing the name “Bob” AND the phone number ‘3444444′.
mysql> SELECT * FROM [table name] WHERE name = "Bob" AND phone_number = '3444444';

Show all records not containing the name “Bob” AND the phone number ‘3444444′ order by the phone_number field.
mysql> SELECT * FROM [table name] WHERE name != "Bob" AND phone_number = '3444444' order by phone_number;

Show all records starting with the letters ‘bob’ AND the phone number ‘3444444′.
mysql> SELECT * FROM [table name] WHERE name like "Bob%" AND phone_number = '3444444';

Show all records starting with the letters ‘bob’ AND the phone number ‘3444444′ limit to records 1 through 5.
mysql> SELECT * FROM [table name] WHERE name like "Bob%" AND phone_number = '3444444' limit 1,5;

Use a regular expression to find records. Use “REGEXP BINARY” to force case-sensitivity. This finds any record beginning with a.
mysql> SELECT * FROM [table name] WHERE rec RLIKE "^a";

Show unique records.
mysql> SELECT DISTINCT [column name] FROM [table name];

Show selected records sorted in an ascending (asc) or descending (desc).
mysql> SELECT [col1],[col2] FROM [table name] ORDER BY [col2] DESC;

Return number of rows.
mysql> SELECT COUNT(*) FROM [table name];

Sum column.
mysql> SELECT SUM(*) FROM [table name];

Join tables on common columns.
mysql> select lookup.illustrationid, lookup.personid,person.birthday from lookup left join person on lookup.personid=person.personid=statement to join birthday in person table with primary illustration id;

Creating a new user. Login as root. Switch to the MySQL db. Make the user. Update privs.
# mysql -u root -p
mysql> use mysql;
mysql> INSERT INTO user (Host,User,Password) VALUES('%','username',PASSWORD('password'));
mysql> flush privileges;

Change a users password from unix shell.
# [mysql dir]/bin/mysqladmin -u username -h hostname.blah.org -p password 'new-password'

Change a users password from MySQL prompt. Login as root. Set the password. Update privs.
# mysql -u root -p
mysql> SET PASSWORD FOR 'user'@'hostname' = PASSWORD('passwordhere');
mysql> flush privileges;

Recover a MySQL root password. Stop the MySQL server process.
Start again with no grant tables.
Login to MySQL as root.
Set new password.
Exit MySQL and restart MySQL server.
# /etc/init.d/mysql stop
# mysqld_safe --skip-grant-tables &
# mysql -u root
mysql> use mysql;
mysql> update user set password=PASSWORD("newrootpassword") where User='root';
mysql> flush privileges;
mysql> quit
# /etc/init.d/mysql stop
# /etc/init.d/mysql start

Set a root password if there is on root password.
# mysqladmin -u root password newpassword

Update a root password.
# mysqladmin -u root -p oldpassword newpassword

Allow the user “bob” to connect to the server from localhost using the password “passwd”. Login as root. Switch to the MySQL db. Give privs. Update privs.
# mysql -u root -p
mysql> use mysql;
mysql> grant usage on *.* to bob@localhost identified by 'passwd';
mysql> flush privileges;

Give user privilages for a db. Login as root. Switch to the MySQL db. Grant privs. Update privs.
# mysql -u root -p
mysql> use mysql;
mysql> INSERT INTO db (Host,Db,User,Select_priv,Insert_priv,Update_priv,Delete_priv,Create_priv,Drop_priv) VALUES ('%','databasename','username','Y','Y','Y','Y','Y','N');
mysql> flush privileges;

or

mysql> grant all privileges on databasename.* to username@localhost;
mysql> flush privileges;

To update info already in a table.
mysql> UPDATE [table name] SET Select_priv = 'Y',Insert_priv = 'Y',Update_priv = 'Y' where [field name] = 'user';

Delete a row(s) from a table.
mysql> DELETE from [table name] where [field name] = 'whatever';

Update database permissions/privilages.
mysql> flush privileges;

Delete a column.
mysql> alter table [table name] drop column [column name];

Add a new column to db.
mysql> alter table [table name] add column [new column name] varchar (20);

Change column name.
mysql> alter table [table name] change [old column name] [new column name] varchar (50);

Make a unique column so you get no dupes.
mysql> alter table [table name] add unique ([column name]);

Make a column bigger.
mysql> alter table [table name] modify [column name] VARCHAR(3);

Delete unique from table.
mysql> alter table [table name] drop index [colmn name];

Load a CSV file into a table.
mysql> LOAD DATA INFILE '/tmp/filename.csv' replace INTO TABLE [table name] FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (field1,field2,field3);

Dump all databases for backup. Backup file is sql commands to recreate all db’s.
# [mysql dir]/bin/mysqldump -u root -ppassword --opt >/tmp/alldatabases.sql

Dump one database for backup.
# [mysql dir]/bin/mysqldump -u username -ppassword --databases databasename >/tmp/databasename.sql

Dump a table from a database.
# [mysql dir]/bin/mysqldump -c -u username -ppassword databasename tablename > /tmp/databasename.tablename.sql

Restore database (or database table) from backup.
# [mysql dir]/bin/mysql -u username -ppassword databasename < /tmp/databasename.sql

Create Table Example 1.
mysql> CREATE TABLE [table name] (firstname VARCHAR(20), middleinitial VARCHAR(3), lastname VARCHAR(35),suffix VARCHAR(3),officeid VARCHAR(10),userid VARCHAR(15),username VARCHAR(8),email VARCHAR(35),phone VARCHAR(25), groups VARCHAR(15),datestamp DATE,timestamp time,pgpemail VARCHAR(255));

Create Table Example 2.
mysql> create table [table name] (personid int(50) not null auto_increment primary key,firstname varchar(35),middlename varchar(50),lastnamevarchar(50) default 'bato');

Read the rest of this entry »

From : SevenForums.com

By default Quick Launch is disabled in Windows 7. This will show you how to enable or disable Quick Launch on the taskbar in Windows 7 as a toolbar with small or large icons.

Quick Launch is used to open a program quickly from a shortcut on the taskbar. In this case in a toolbar The Quick Launch folder is located at the hidden system folder location (step 2) of:

C:\Users\(user-name)\AppData\Roaming\Microsoft\Internet Explorer\Quick Launch

read more …

Hope this help

Bye
Riccardo

This post is not for a sort of “religion war” between Microsoft and VMware.

I’m using daily both Microsoft products with satisfaction (not every time) and VMware.

I love VMware products, and this is not a secret, but before today, I’ve read everything about Microsoft Hyper-V, so I’ve decided to download it and test it.

The following is my opinion about VMware ESXi and Hyper-V comparison, this because Microsoft trying to tell us that his Hypervisor is similar (or better) than VMware one, and because I don’t think so, you can read here the main reasons.

Read the rest of this entry »

This post will explain how to do create a VMware ESXi bootable USB pen drive, note that it will not be an installer, but a live system running on an USB drive.
First of all you should use it for testing hardware systems for compatibility, avoiding to install the hypervisor on the system, or you can use it to play (as I’m doing) with it on your notebook or desktop.

The following is the two procedure to follow to create it based on Linux and Windows operating systems :

This post will assume you’ve already have an ISO image of the latest VMware ESXi hypervisor on your system, if you don’t have it, please download it for free at http://www.vmware.com

Linux :

Locate the ISO image.
Mount it in a directory on your system (if you don’t know how, look here : http://www.riccardoriva.com/archives/64) and extract the file you need with the following commands :

sudo mkdir /tmp/iso
sudo mount -o loop -t iso9660 VMware-VMvisor-InstallerCD-3.5.0_Update_4-153875.i386.iso /tmp/iso/
sudo cp /tmp/iso/install.tgz /tmp/
sudo umount /dev/loop0

sudo tar -xzvf /tmp/install.tgz usr/lib/vmware/installer/VMware-VMvisor-big-3.5.0_Update_4-153875.i386.dd.bz2
cd /tmp/usr/lib/vmware/installer/
sudo bunzip2 VMware-VMvisor-big-3.5.0_Update_4-153875.i386.dd.bz2

Now insert your USB Pen Drive (at least 2 GB) in your system and locate it (tipically /dev/sdb).

Copy to it the image with the following command :

sudo dd if=/tmp/usr/lib/vmware/installer/VMware-VMvisor-big-3.5.0_Update_4-153875.i386.dd of=/dev/sdb BS=1M

Umount your en Drive

sudo umount /dev/sdb

Reboot your system and check your BIOS configuration for enabling “Boot from USB devices”, and check if something goes wrong.

Windows :

For windows system you should need two free software (portable) to do all works :
7-Zip Portable : http://portableapps.com/apps/utilities/7-zip_portable
DD For Windows : http://www.chrysocome.net/dd

Open the ISO file with 7zip, locate “install.tgz” and open it, locate “install.tar” and open it,
locate the folder “\usr\lib\vmware\installer\”, locate the fle : “VMware-VMvisor-big-3.5.0_Update_4-153875.i386.dd.bz2″ and open it.
Extract the file “VMware-VMvisor-big-3.5.0_Update_4-153875.i386.dd” in a temporary directory of your system (i.e. C:\temp).

Insert your pen drive (at least 2 GB) on your system and wait a couple of seconds.

Check the device ID of your pen drive using DD for Windows (by opening a command prompt on the DD directory) with the following comand :

dd –list

Then use the following syntax to copy the dd image on your removable device :

dd bs=1M if=VMware-VMvisor-big-3.5.0_Update_4-153875.i386.dd of=\\?\Device\Harddisk1\Partition0 –progress

You’ve done

Hope this help

Bye
Riccardo

Print This Post Print This Post

At some customer sites I have to shutdown all Virtual Machines and all ESX hosts when a power failure occurs, but I didn’t find a place in which collect all informations needed to let all works.
Finally I collect all the information needed and adjust some script find all over the internet and the following is the result.

I’ve tested it on ESX Server 3.5 Update 4 with APC PowerChute Agent v2.2.3 and APC SMART-UPS 5000i UPS

The goal was to :
If a power failure occurs then wait some minutes to check if power come back, and if not :
- try to shutdown all virtual machines running on esx host with a soft shutdown command
- if soft shutdown above fail, shut them down with a hard shutdon command
- wait for virtual machine to shutdown (300 sec).
- if virtual machine is already running then do hard power off
- shutdown esx host

Read the rest of this entry »

In this post I am going to talk about a very particular piece of hardware, unique on the market at this moment and that should be very useful for virtualization or clustering purpose, with a very low budget.

This product is called DamVirtualOne.

DamVirtualOne is a modular server (not a Blade) and have some very interesting feature :

- Fully redundant hot swap power supply.
- Fully redundant hot swap Gigabit ethernet switches with failover.
- Fully redundant hot swap storage controller, with multipathing and failover support.
- Up to six (6) compute module double socket (for Intel Xeon 5400 or 5500 CPU family).
- Up to 96GB of RAM each compute module.
- Up to 14 HDD SAS.
- Up to two redundant external SAS connection to storage expansion or SAS device connection (i.e. Tape Unit).

But the more important things that lead me to write this post is that storage is shared between the compute module, but not as other Blade Server on the market right now, with DamVirtualOne you should create a Virtual Disk (similar to a SAN LUN) and share it between all compute module if you need it.

At this time only IBM Blade Center S should have the same possibility, but it’s a Blade server, not a modular server, and there is a big price difference.

I had the luck to test the DamVirtualOne for few days (a lot) and I’ve installed the following :

- VMware ESXi 3.5
- VMware ESX 3.5
- Red Hat Enterprise Linux 5.3
- Microsoft Windows Server 2003
- Microsoft Windows Server 2008

I’ve created some fully function, and very performance VMware HA and DRS Cluster, and some Linux Cluster based on RHEL, and a large number of my previous post was written based on the installation above.

The standard server virtualization or clustering best practices require shared storage to use all benefits of the technology and this lead to buy SAN, Storage array (tipically Fibre Channel) who is very expensive, difficult to maintain and create a very complex infrastructure.

So you should know why I’m so excited about DamVirtualOne, because it’s a “single package” that contains all things you need for virtualization or clustering purpose : servers, storage and network a real datacenter all in one.

With the maximum configuration this machine should support up tp two hundred (200) Virtual Machine !! And his price will be very similar to two or three phisical server (as you are useful to see) and a shared storage, so you should understand that is a beautiful “piece of iron”.

I truly believe that modular server is sometimes under valuated, but in my opinion there is an enormous potential in it and it will be beautiful if this post lead some people to find out a solution, cheaper than other more famous one, using this piece of technology.

You should found more details about DamVirtualOne at the following websites.

http://www.damvirtualone.it

Feel free to ask, they will answer you !

Riccardo

Print This Post Print This Post

This how to explain how to configure Microsoft Windows Vista disk space for Automatic System Recovery.
For doing so, open a command prompt with administrative rights, you can do it by right clicking on the command prompt icon and choose “run as admin…”.

At the prompt digit :

VSSadmin List ShadowStorage

The output will show the disk space usage for ASR (Automatic System Recovery).

To change the value above you could use :

VSSadmin Resize ShadowStorage /For=C: /On=C: /MaxSize=1GB

Where :
/For=C: is the volume interested for ASR
/On=C: is the volume on which you want to save the ASR
/MaxSize=1GB is the max size assigned.

—- Supported Command —-

List Providers        – Show registered shadow copy providers list
List Shadows          – SHow existing sgadow copy volumes
List ShadowStorage    – List archiving association for shadow copy volumes
List Volumes          – List all volumes on which is possible to use ASR
List Writers          – List shadow copy writing process for which exist a subscription
Resize ShadowStorage  – Resize the space available for ASR

Hope this help

Bye
Riccardo

Print This Post Print This Post

Another great job from Massimo Re Ferrè (as usual).

After “Enterprise Virtualization in a Box” which was essentially an example of how to create a BladeCenter-contained VMware-enabled data center in a box (including servers, storage and networking), he accept Giorgio Malusardi challenge to create something similar using the Hyper-V Server R2 Beta.

So, here to you “Hyper-V Server R2 on BladeCenter S Tutorial“.

Thank you Massimo for your beautiful post.

Bye

Riccardo

I get a lot of customer ask me to deploy Windows XP VMs on ESX.
By default, ESX will use the LSI Logic driver when deploying a new Windows XP virtual machine.
The LSI Logic driver is not found on the CD-ROM media, so Windows XP will not continue with the installation if this driver is not found.

The steps:

* Create a new Windows XP Virtual Machine
* Upload a Windows XP .iso file to your datastore/ISOstore (preferably a VLK version) and link it via the CD-ROM options in your Virtual Machine. Make sure it is connected / at power on
* Go to http://www.lsilogic.com/cm/DownloadSearch.do and search for a driver for the LSI20320-R controller.
* Extract all files in the symmpi_wXP_1201800.ZIP
* Use a program such as WinImage to create an LSILogic.flp file and include the extracted files in the .flp image.
* Upload the newly created LSILogic.flp to your datastore/ISO store
* Link the .flp file via the Floppy options => use existing floppy image in datastore in your Virtual Machine. Do NOT connect it yet.
* Power On your Windows XP machine. The installation of Windows XP should begin.
* During setup, press F6 to select additional SCSI drivers
* Now is the time to connect your floppy and use S during Windows Setup when prompted to connect to the floppy drive.

* The LSILogic drive should appear. Press ENTER to continue
* Setup will continue as normal
* Install VMware tools
* Done!

NOTE: when using the BusLogic driver instead, you can download & use a preconfigured .flp file from the VMware site:
http://download3.vmware.com/software/vmscsi-1.2.0.4.flp
Follow the same procedure as described above.
The driver should be name VMware SCSI Controller in Windows XP.

Hope this help

Bye
Riccardo

This has been written to detail how to generate a CPU load in a Virtual Machine..

Some tipical scenarios where you may wish to generate CPU load within a virtual machine include stress testing an ESX server and triggering DRS VirtualMachines migrations for demonstration or testing purposes.

The simple scripts below can be used to generate CPU load in Windows and Unix\Linux virtual machines and will run continuously until terminated.

  • Windows Virtual Machines
    The VBscript script below should be saved as cpubusy.vbs.
    Start it by double clicking it and terminate it by ending the wscript.exe process in Task Manager.

Dim goal
Dim before
Dim x
Dim y
Dim i
goal = 2181818
Do While True
before = Timer
For i = 0 to goal
x = 0.000001
y = sin(x)
y = y + 0.00001
Next
y = y + 0.01
Loop

  • Unix\Linux Virtual Machines
    The Perl script below should be saved as cpubusy.pl
    Start it by opening a terminal window, changing to the directory where it is saved and typing the following:

chmod 744 cpubusy.pl
./cpubusy.pl

Terminate it pressing CTRL-C.

#!/usr/bin/perl

$goal = 2181818;
while (TRUE) {
for ($i=0; $i<=$goal; $i++) {
$x = 0.000001;
$y = sin($x);
$y = $y + 0.00001;
}
next;
$y = $y + 0.01;
}

Hope this help

Bye
Riccardo

This article explain ho to manually crash a Windows System (it works with Windows XP and Windows Vista, and I haven’t try other versions).

Open Registry,

open the following key :

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\kbdhid\Parameters

If you are using a USB Keyboard, or

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\i8042prt\Parameters

if you are using a PS/2 keyboard

and add a new DWORD key with the following content :

CrashOnCtrlScroll

and set it to “1″.

Reboot your machine and try the following combination :

Right CTRL and Scroll Lock twice.

Happy BSOD

Bye
Riccardo

This interesting Tips let you made a simple connectivity test for a lot of device in a subnet in a very little time:

It could be useful to look at all device reachable in a network.

I’m using the command “FOR” as you can see :

FOR /L %g IN (1,1,254) DO ping -n 2 192.168.0.%g

%g, seems that you want to “ping” devices in the range 1-254, this value is specified by the syntax (start,step,end).
Start is the initial value that you want to test.
Step is the incremental value from the different operation.
End is the last value you want to test.

The “-n 2″ option specifies the number of ICMP packet to send before pass to the next test.

You can run it unattended and redirect the output to a log file using the following syntax :

FOR /L %g IN (1,1,254) DO ping -n 2 192.168.0.%g >> your_output_file.log

Hope this help.

Bye
Riccardo

I am looking for a hardware solution that supports sharing USB over IP (aka USB Servers).
Here is information about 5 hardware devices, that I obtained from their websites:
Keyspan – model U2S-2A (2-port)
- supported OS: WinXP or Vista (32bit), MacOS X v10.3.9 or greater
- supports 8 connections???
- does not currently support attachment of USB hubs (expected in future firmware)
- PROS: claims it can support any USB device that is NOT an isochronous device or an ILOK dongle by PACE
CONS: Limited documentation for this model
Silex technology – model SX-2000U2 (1-port)
- supported OS: W2K, WinXP, Vista, MacOS X
- supports 15 connections (incl. hub)
- PROS: Frequent firmware updates, supports more connections
- CONS: only one port
Lantronix – model UBox 2100 (2-port)
- supported OS: W2K, WinXP
- supports 8 connections???
- Isochronous audio/video support
- PROS: First and currently only to claim to support isochronous transfers
- CONS: Limited documentation on this model
Belkin – model F5L009 (5-port)
- supported OS: WinXP,Vista (incl 64bit), MacOS 10.4 (beta)
- supports 16 connections
- PROS: Sexy looking, supports more connections, comes already with 5 ports, claims it may supported isochronous transfers in future update
- CONS: reports suggests poor performance with drives, but this may be a perception issue
IOGear – model GMFPSU22W6 (2-Port)
- supported OS: W2K, WinXP
- supports 5 connections
- PROS: supports a storage server mode, allowing multiple user access
- CONS: don’t have any info yet on this model
I am only comparing USB2.0 hi-speed (upto 480Mbps) models, even though most of these mfg have full-speed (upto 12 Mbps) models too. All seem to sell for approximately $130 and support common features like WLAN compatible, printer auto-connect share, 500mA power per port. Plus some mfg are looking to add more features in future firmware and driver releases. Early testing suggest that these units perform marginally better than USB1.1 devices, due to the network connection (latency), but I am curious about the performance of the Lantronix model that claims to support isochronous transfers.

Very very good and clear article written by Massimo Re Ferrè on his Blog (IT 2.0) about VMware HA Vs Microsoft Cluster Server

As always, thank you Massimo, Great Job !

http://it20.info/blogs/main/archive/2007/11/26/83.aspx

I toke me a long time on getting this to work right because of a number
of things like the firewall in ESX 3 and what BE Linux agent to use..
so that is why I have made this webpage so you can save time on this
when you setup a new ESX 3 server and don’t have the time to fight with
this.

Remote Agent for Linux and UNIX Servers (RALUS) 10.x

First the RALUS 10.x does not work on ESX because it can not see the
VMFS file system and Veritas will not fix this before next version
because it do not understand “links” in the file system.. so don’t use
time on.

you can see this Veritas
href=”http://support.veritas.com/docs/278671″>KB
id=”DOCUMENT_ID”>278671 about it and
her is what they write

Symantec
Corporation has acknowledged that the issue is present in the current
version(s) of the product(s),
There are no plans to address this issue by way of
a patch or hotfix in the current or previous versions of the software
at the present time. However, the issue is currently
scheduled to be addressed in the next major revision of the product.

Backup Exec UNIX Agent 5.0 revision 5.046

This is the Linux agent to use as it works and it can be download on
this Veritas
href=”http://support.veritas.com/docs/262592″>KB262592
or if you have Backup Exec 9.1 installed on your Windows server then is
found in a subfolder of the app.

Backup Exec on remote Windows server

This howto and the “Backup Exec UNIX Agent 5.0 revision 5.046″ is
working with Backup Exec 9.1, 10.x and 10D for Windows
Here is how to install it on the VMware ESX 3.0 and setup
Backup Exec for Windows

1. Download the linux agent software to a folder on the ESX 3.0 server

2. Login as Root on the ESX server

3. Change to folder and verify the TAR file is there

[root@ESX3
backupexec]# tar -xvf be_agent_91_for_linux.tar

BE_IDENTINSTALL

common/

common/init.d.agentcommon/sp.plist

common/VERSION

common/agent.aix

common/aix.excl

common/agent.hpux

common/hpux.excl

common/agent.linux

common/linux.excl

common/agent.linux24

common/linux24.excl

common/agent.sol_x86

common/sol_x86.excl

common/agent.solaris

common/solaris.excl

common/agent.uware7

common/uware7.excl

english/

english/SETUP

english/CONFIG

english/agent.cfg

5. Starting the Installation

[root@ESX3
tbj]# ./INSTALL
Backup Exec Unix Agent Language Selection v4.3Backup Exec UNIX Agent Install v3.7Copyright 2001 VERITAS Software Corporation. All Rights
Reserved.

6. Select OS as Linux 2.4 (number 5)

Operating
systems supported:
1. Solaris Sparc 2.6, 2.7, 8, 92. Solaris Intel x86 2.6, 7, 83. HP UX 10.20, 11.x4. IBM AIX 4.3.x, 5.x5. Linux 2.4 (RedHat7.1+, SuSE7.1+, Caldera3.1+, Turbo7.0+,
Mandrake8.0+)6. Linux 2.2, 2.0 (RedHat7.0-, SuSE7.1-, Caldera2.4-, Turbo6.5-,
Mandrake7.2-)

7. SCO UnixWare 7.x

Operating system detected:

Linux
2.4 (RedHat7.1+, SuSE7.1+, Caldera3.1+, Turbo7.0+, Mandrake8.0+)

Is
this correct? (y/n)

lang=”da”> y

Operating
system selected:

Linux
2.4 (RedHat7.1+, SuSE7.1+, Caldera3.1+, Turbo7.0+, Mandrake8.0+)

Installing
the Backup Exec UNIX Agent for system type: linux24

7. Type Y to install in the default folder

Please
enter the full directory path where the Backup Exec Agent should
be
installed: [/etc/bkupexec]
/etc/bkupexec
does not exist. Should this directory be created? (y/n)

xml:lang=”da” lang=”da”>y

8. Hit Enter to continue

Your
system’s initialization procedure has been modified to
automatically
start the Agent the next time your system is started.
Adding
the following line to /etc/services:
grfs
6101/tcp
# Backup Exec AgentAll
necessary Backup Exec Agent files have been copied to:
/etc/bkupexec
The
configuration for the Backup Exec Agent is stored in
/etc/bkupexec/agent.cfg.
You may edit this file at any time to change the configuration for the
Agent.

You
will now be prompted to enter the initial values for the Agent
configuration.

Press
Enter to continue

9. Type in the host and domain name of this ESX server

0+1
records in0+1 records out
Please
enter the name for this workstation [ESX3.company.tld]:

xml:lang=”da” lang=”da”> ESX3.company.tld

10. Select N (can be changed later if you like)


lang=”da”> Do you require a password for this workstation?
(y/n)
lang=”da”> n

11. No matter how many netcards you have select Y two times and enter
the IP number of the ESX COS IP

Does
this workstation have 2 or more network interfaces? (y/n)

xml:lang=”da” lang=”da”> y
Do you
want to specify which one to use? (y/n)

xml:lang=”da” lang=”da”> y
Enter
the IP address of the interface:

xml:lang=”da” lang=”da”>172.16.17.3

12. Select the / to be export and then wait with other paths as we type
them into the config file later!

Please
enter a directory path you want to export as a published path:

/
Please
enter a unique resource name for this published path: [root]

root
Do you
want to allow files to be restored to this published path? (y/n)

y
Do you
require a password for this published path? (y/n)

xml:lang=”da” lang=”da”> n
Do you
want to publish another directory path? (y/n)

n

13. Enter the IP number of the remote Backup Exec 9.1, 10.x or 10D
server that you like to backup this server.

You
must enter the names of the Backup Exec media servers which willaccess this workstation. The media server’s internet
addresses must bedefined in the /etc/hosts file or accessible via a naming service.
Please
enter a media server name:

xml:lang=”da” lang=”da”> 172.16.0.200
Locating
172.16.0.200….located and added to media server list.
Do you
want to add another media server? (y/n)

xml:lang=”da” lang=”da”>n

14. Enter 30 as the advertisement time, note that if you select another
value there is maybe a regkey on the windows server you need to change
also but Veritas write about it in the documentation.

The
Backup Exec Agent must periodically send advertisement messagesto the media servers to inform them that this workstation isaccessible. Please enter the frequency (in seconds) that these
advertisements
should be sent: [30]

lang=”da”> 30

15. Just select 1 and go on

Symbolic
links to directories may be backed up in one of two ways.
Method
1: The symbolically linked directory is handled as a special
file
and only the information required to recreate the symboliclink is backed up.Method
2: The symbolically linked directory is backed up as a normal
directory. All files and subdirectories within thesymbolically linked directory are also backed up.

Method
1 is preferred because it minimizes the amount of data which must

be backed up.

Which
method do you want to use? (1 or 2) [1]

xml:lang=”da” lang=”da”>1

16. Now the software is installed and pre config

Backup
Exec Agent configuration complete.
Note:
You may edit the file /etc/bkupexec/agent.cfg to change your Backup
Exec Agent configuration at any time. Configuration changes
for theBackup Exec Agent will take effect after the host is restarted. [root@ESX3
tbj]#

17. Goto the remote Backup Exec server and into the options, then
change the settings to be like this.

BEoption

18. Now on the ESX server again, Config the ESX firewall to allow
Backup exec Linux agent to talk with the remote backup exec server

[root@ESX3
backupexec]#esxcfg-firewall -o 6101,tcp,out,Backupexec[root@ESX3 backupexec]#esxcfg-firewall -o 6102,tcp,out,Backupexec[root@ESX3 backupexec]#

19. Config the ESX firewall to allow the remote Backup exec server to
talk with the agent on the ESX server.

#esxcfg-firewall -o 8192,tcp,in,Backupexec
#esxcfg-firewall -o 8193,tcp,in,Backupexec
#esxcfg-firewall -o 8194,tcp,in,Backupexec
#esxcfg-firewall -o 8195,tcp,in,Backupexec
#esxcfg-firewall -o 8196,tcp,in,Backupexec
#esxcfg-firewall -o 8197,tcp,in,Backupexec
#esxcfg-firewall -o 8198,tcp,in,Backupexec

20. Reload the firewall config

#esxcfg-firewall –load[root@ESX3 backupexec]#

21. open and edit the agent config file

# nano /etc/bkupexec/agent.cf

22. Change the config file to match your setup and write the file to
disk

# Set
the name to be the host and domain name of this ESX server

xml:lang=”da” lang=”da”>name ESX3.company.tld# Set this to be the IP number of ESX COSforce_address 172.16.17.3# To backup content from the VMFS volumes, then it is best to have this
setfollow_symdirs# This export the ESX OS so it can be backup up

export / as ESX_OS

# This export the the VMFS file system, you can export down to VMFS
storage name lavel

# but i will not awise that because if you change the name some day it
will crash the backup

# agent and you have to reconfig the agent every time..

# I found this to work best and on all server without isues

export /vmfs/volumes/ as VMFS_volumes include_remote

# This is to tell the remote backup servers about the agent, just
change the ip numbers to be

# the ip number of the remote backup exec server.

# for safty you can tell more then one server about the agent and i
allways do this as if one

# backup server brack down, you can just use the other server to backup
the ESX

# server until you have fix it

tell 172.16.0.200

tell 172.16.0.201

# This interval is default 30 and if you change this to some else, then
be sure to read the

# Backup exec manual as there in some case also need to change a regkey
on the

# remote backup server

tell_interval 30

# This is folder not to export to the remote backup server..

# I found this list to work well on the ESX 3.0 server

exclude_dir /dev

exclude_dir /proc

exclude_dir /tmp

exclude_dir /var/run/vmware

21. Restart the Backup Exec agent so it read the new config

[root@ESX3
backupexec]# /etc/init.d/agent.init stop[root@ESX3 backupexec]# /etc/init.d/agent.init start
Backup Exec — Unix Agent, Version 5.01 Revision 5.046Copyright 2001 VERITAS Software Corporation. All Rights
Reserved.[root@ESX3 backupexec]#

22. Now go to the remote backup server and make a test backup job where
you select some folders to backup with a lot of data so you can see
that it is stabile.

job

23. Monitor it is backup the file and the speed is what you expect it
to be, I have a LTO3 autoloader and the network is 1gbit and I can see
the network traffic is around 250mbit between the server so that is
just fine.

backup

24. Now monitor the verify, note the high speed is because it just
verifying checksums and there for fast, the network is also note
showing any trafic at all.

verifyNow Backup exec Linux agent is installed on the ESX 3.0 server
and works well

Investigating to deploy an MSCS on VMWare VI3 I’ve finally found that :

Virtual Machine (Cluster Node) have forementioned boundaries

  • Only LSI Logic virtual SCSI Card
  • Only VMXnet
  • Only 32-Bit VMs
  • 2-Node Clustering only
  • Nic teaming is not supported
  • iSCSI clustering is not supported
  • Boot from SAN is not supported
  • VMs part of clustering cannot be part of VMHA & DRS
  • Cannot VMotion on VMs using clustering software
  • ESX 2.5 and ESX 3.0 is not supported
  • Different HBA’s card manufacturer not supported
  • When using N+I SCSIPort Miniport driver must be present on Physical Node and not Storport Miniport driver, also there must be no powerpath software installed on physical node.

Take care of this.

Riccardo

IT employer or System Administrator usually have a lot of remote connections to work with and usually had to remeber all parameters or write and save it on the most different way.

Today I found on sourceforge this beautiful tool, MRemote, a MultiTab connections manager.

The current release support the following connection types :

All connections are saved in an XML file, simply to move to another machines or to share with colleagues.

Follow a MRemote screenshot.

mremote_screenshot.jpg

Contacts
Look at me at Linkedin Follow me on Twitter
My Flickr Albums My Facebook profile My YouTube Videos
SkypeMe My Linux Counter GMail me
Search
Google Search
Categories
Tag Cloud 3D
FeedBurner RSS

Visitors
Locations of visitors to this page
VMware related Blogs
The following are Blog sites with feeds I personally follow. When I'll have some spare time I will complete all Feed and Twitter links.