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');
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
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.
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
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
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.
Feel free to ask, they will answer you !
Riccardo
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
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 !
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]# ./INSTALLBackup 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 Is Operating Linux Installing |
7. Type Y to install in the default folder
| Please enter the full directory path where the Backup Exec Agent shouldbe 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 toautomatically 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 Press |
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”> yDo you want to specify which one to use? (y/n) xml:lang=”da” lang=”da”> yEnter 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] rootDo you want to allow files to be restored to this published path? (y/n) yDo you require a password for this published path? (y/n) xml:lang=”da” lang=”da”> nDo 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.200Locating 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 fileand only the information required to recreate the symboliclink is backed up.Method 2: The symbolically linked directory is backed up as a normaldirectory. All files and subdirectories within thesymbolically linked directory are also backed up. Method be backed up. Which |
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 BackupExec 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.

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 # but i will not awise that because if you change the name some day it # 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 # the ip number of the remote backup exec server. # for safty you can tell more then one server about the agent and i # backup server brack down, you can just use the other server to backup # 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 # Backup exec manual as there in some case also need to change a regkey # 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.

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.

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.
Now 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 :
- RDP (Remote Desktop)
- VNC (Virtual Network Computing)
- ICA (Citrix ICA)
- SSH (Secure Shell)
- Telnet (TELecommunication NETwork)
- HTTP/S (Hypertext Transfer Protocol)
- Rlogin (Rlogin)
- RAW
All connections are saved in an XML file, simply to move to another machines or to share with colleagues.
Follow a MRemote screenshot.
























