Install SQL Fairy:
sudo apt-get install sqlfairy
Create a database Dump:
mysqldump -u root -p -d databasename > database.sql
Create png file from database dump
sqlt-graph -f MySQL -o mydatabase.png -t png database.sql
I bought new hardware a week ago and I decided to try windows 7 64bit. After putting it all together I tried to install Windows 7 which was going for a while then it started to complain about the DVD Driver and the installation process stopped. This error usually happens when you have an old DVD drive which is no longer supported by Windows 7 64bit. Well I have a 5 year old Benq DW1620 DVD drive. After browsing the forums and finding no useful information on this apart from buying a Windows 7 compatible DVD Driver I decided to try a different approach: Installing Windows 7 from a USB key.
This magically solved the installation problem and the DVD drive is now working properly under Windows 7 without any additional tweaking.
To install Windows 7 from a USB key follow this guide
Please watch out for the following things while using this guide:
Installing the Motherboard
I have recently purchased Gigabyte h55m-ud2h motherboard as part of an upgrade kit. First of all the motherboard came with only 2 cables ( IDE, SATA ) so if I wouldn’t have cables like this lying around I wouldn’t have been able to connect my 3 SATA disks. I do not know if this is because it was part of the upgrade kit or the motherboard comes with these 2 cables by default but it is nowhere near sufficent.
The motherboard is very compact, needless to say that I couldn’t properly fit it to my 5 year old large chassis. The holes on the chassis simply were not on the right place for this motherboard… I managed to fit most of the screws though apart from those at the far end of the motherboard. So I had to be extra careful when I installed the memory modules not to break the motherboard. Apart from this problem and that I didn’t find my screwdriver kit for a while 🙂 it was very easy to install.
The Motherboard has the following built in stuff:
Built in Audio
Proper drivers for Windows 7 64bit
Detected by Ubuntu 9.04, 9.10 OK
Built in VGA H55 ( jaysus!!! )
This has been advertised as some superfast video. Well folks .. to put it mildly it is dreadful. Terrible graphics performance, and very ugly rendering. You definitely will need an additional video card if you plan to play games on it. Even World of Warcraft is terribly flickery so I had to set the graphics option way back.
The most annoying thing is that I wasn’t able to video card I have integrated and in fact I haven’t been able to determine it until I installed the drivers that came with the motherbord installation cd.
The videocard shows up in the windows device manager as: Intel (R) Graphics Media Accelerator HD
This actually not saying much, no model number or anything so it will be a bit of a w*nk to get the latest drivers downloaded 🙂
Video Driver Windows 7 64 Bit
The video driver is OK for windows
Video Driver Ubuntu 9.04, 9.10
Update: The driver works perfectly on 10.04 LTS and it installs automatically
Now this is a problem. When I started up Ubuntu 9.04 it didn’t recognize the video and to add a bit more drama to the situation the screen was shifted left on the monitor. I spend numerous hours trying to fix this problem but I never got to fix it on this Ubuntu version.
I tried to remove the previous Nvidia drivers – No Luck
I tried to download new intel drivers – Was already the latest
Upgraded to Kernel 2.6.30 as explained here – No Luck
Finally I decided to stop trying as I read on some forums that Ubuntu 9.10 is running fine this videocard so I kicked off an upgrade.. which to be honest with you was one of the smoothest operating system upgrade I ever had. Needless to say that it wasn’t working correctly on 9.10 neither. In fact the operating system did hang right after login.
Upgraded the kernel to the latest which is 2.6.32 at the time of writing but this again didn’t solve anything it was hanging after log in like kernel 2.6.31.
The lucky thing was that the kernel 2.6.30 was still installed and was working even though the screen was shifted. I logged in to it and removed any trace of any Nvidia product installed over Ubuntu.
After a restart all 3 installed kernels started to work but the sceen was shifted for all of them.. that was better than not being able to log in at all. I have defined the third party auto upgrade option found here then reinstalled some Nvidia stuff ( I was all over the place so I haven’t a clue which ones ) and voila it started to work on kernel 2.6.31, 32… the 2D part 3D part still doesn’t work. As I am not using Ubuntu for gaming at all I decided not to bother with fixing the 3D any longer.
Built in LAN
Detected by Windows 7 OK
Detected by Ubuntu 9.04, 9.10 OK
The bios menu is generally good apart from the fact that I do not see any option to disable the built in VGA… well I hope when I get myself a proper graphics card it will not interfere with it.
The other thing is if you want to boot from an USB key it detects it as a hard drive so when you go to the boot menu and select from the numerous USB options (USB Disk, USB FDA, etc ) none of them will be your USB key. To fix this just go to the Bios and select the USB key from the Hard Drive Priority option ( needs more exact explanation ).
To summarize my experience with h55m-ud2h well after spending a few days on fixing the above errors it works all right. If you have a bunch of cables already you can go ahead and buy it… but do not forget to get a proper graphics card.
You will need to install following to prepare a test environment on Ubuntu for Joomla:
Install Apache Web Server:
sudo apt-get install apache2
Install PHP5:
sudo apt-get install php5
Install PHP Apache libraries:
sudo apt-get install libapache2-mod-php5
Restart Webserver:
sudo /etc/init.d/apache2 restart
Instal MySQL Server:
sudo apt-get install mysql-server
Install PHP Module for MySQL5:
sudo apt-get install php5-mysql
Installing phpMyAdmin:
Download latest package from
Create a directory phpmyadmin in your web server root ( usually it is /var/www )
Create the config directory in /var/www/phpmyadmin/
Change permissions on config:
sudo chmod 777 /var/www/phpmyadmin/config
Open the following page in a browser http://localhost/phpmyadmin/setup/install.php
Add your server configration and save the config file
Install Mcrypt:
sudo apt-get install php5-mcrypt
Restart apache server:
sudo /etc/init.d/apache2 restart
Open the following page in a browser http://localhost/phpmyadmin/index.php
Remove config directory from /var/www/phpmyadmin/
Install MySQL Admin:
sudo apt-get install mysql-admin
Create and Download latest cpanel backup from your host.
Create a directory in /var/www/ which will contain your website.
copy the joomla files from the backup file to the directory what you have created remember you should copy your site’s document root
Open configuration.php and modify the following values:
$mosConfig_absolute_path = ‘/var/www/[directory what you have created]’;
$mosConfig_cachepath = ‘/var/www/[directory what you have created]/cache’;
$mosConfig_live_site = ‘http://localhost/[directory what you have created]’;
Note the value of these 3 variables:
$mosConfig_db <- This will be the MySQL database associated with your website. $mosConfig_user <- This will the MySQL user. $mosConfig_password <- This will be the password for your MySQL user. Now it is time to create the MySQL database from the backup. Look for the database SQL file in the backup. The filename should be the same as the database name so it would be something like [database name].sql.
Now start the MySQL admin graphical interface: ./mysql-admin
After logging in click on Restore Backup the click on Change Path to select the path to your MySQL backup file
Select the mysql backup file, select the relevant encoding and create a New Schema for your database. This should be the same as your database name.
Click on Restore Backup
Once the backup is restored create the database user id and password, and grant all rights to the database for this user.
I have moved country and was looking for a way to set the time zone from the command line.
Run the following command and it will pop up the timezone configuration window:
sudo dpkg-reconfigure tzdata
I have recently run into this problem. The navigator tree was rebuilding/changing constantly resulting the TEPS Console to be nearly unusable. To fix this I set the following variables in cq.ini ( TEPS ini file location under $CANDLEHOME/config/)
KFW_CMW_DETECT_AGENT_ADDR_CHANGE=N
The Navigator function detects when the IP address for an agent is discovered. If the agent environment is constantly changing or has improper configurations that generate excessive Navigator tree rebuilding, consider adding this environment variable to have any discovery of changes or additions of IP address ignored.
KFW_CMW_DETECT_AGENT_HOSTNAME_CHANGE=N
This variable is like the one for detect agent address change except that it prevents the Navigator rebuilding if an agent hostname is changed.
KFW_CMW_DETECT_AGENT_PROPERTY_CHANGE=N
This is like the detect agent address change except that it prevents the Navigator rebuilding if an agent affinity or affinity version changes.
References/Documentation on TEPS environment variables:
[ad#Google Adsense-1]
The table below lists some of the most important directories used by ITM. This is far from being complete. I will add new information to this whenever I find an other directory worth mentioning 🙂
| Number | Location | Description | NodeType |
| 1 | $CANDLEHOME/logs | ITM log files | ALL |
| 2 | $CANDLEHOME/bin | ITM binary files | ALL |
| 3 | $CANDLEHOME/config | ITM ini files. Constructing additonal product configuration values using the environment variable and product specific settings. | ALL |
| 4 | $CANDLEHOME/config/.ConfigData | ITM environment variables. contains values set at configuration time. | ALL |
| 5 | $CANDLEHOME/tables/[tems name]/ATTRLIB | ITM Attribute files. If you have a seeding problem you can check if the required attr file is in this directory. If it is not the seeding wasn’t successful. | TEMS |
| 6 | $CANDLEHOME/tables/cicatrsq/ATTRLIB | Historical data and attrib files ready to be seeded. Once you install TEMS support for a new product the attrib and historical data files are being copied here first. Once you do the seeding it all being copied over to the directory shown above this entry. | TEMS |
| 7 | $CANDLEHOME/tables/[tems name]/depot | In this directory there is a parent directory called PACKAGES Sub-directories contain all the packages in that depot. | TEMS |
| 8 | $CANDLEHOME/[architecture type]/iw/profiles/ITMProfile/logs | Embedded WebSphere log files | TEPS |
| 9 | $CANDLEHOME/[architecture]/ui/jars/resources | TEPS server resource files. If you have teps support problems check if the relevant .jar file is in this directory | TEPS |
| 10 | $CANDLEHOME/[architecture]/cw/classes | TEPS Browser client resource files, If you have teps support problems check if the relevant .jar files are in this directory | TEPS Browser Client |
| 11 | $CANDLEHOME/tables/[tems name] | Location for historical data collection files if the collection is enabled on TEMS level | TEMS |
| 12 | $CANDLEHOME/[architecture]/[agentcode]/hist | Location for historical data collection files if the collection is enabled on TEMA level | TEMA |
| 13 | $CANDLEHOME/tmaitm6/agentdepot | Latest installation logs. This directory keeps details of the latest ITM product installation | ALL |
| 14 | $CANDLEHOME/[architecture]/cw/classes/candle/[agencode]/resources/advice/[lang] | Location for Expert Advice HTML files | TEPS |
When you install ITM agents on a HACMP solution you need to make sure that the OS agents are running on both Physical nodes and the application agents are running on the active one. The application agent has to be installed on the shared volume group so when a takeover happens it moves with the application. The OS agents to the local filesystem on the physical nodes this way you have both nodes ( Active/Passive ) monitored.
After installation you have to modify the monitoring agent’s .ini file that is located in the [itmroot]/config directory. For example if you try to configure the Unix OS Agent you need to modify the ux.ini.
Set/Modify the following values:
KDEB_INTERFACELIST=!10.10.10.1 This instructs the product to bind to ONLY the 10.10.10.1 interface
attached to the system and publish IP address 10.10.10.1 for the Tivoli service.
CTIRA_HOSTNAME=[hostname]
CTIRA_SYSTEM_NAME=[hostname]
Repeat this step for all agents in scope then restart the agents and after a while they should show up on the TEPS Console under the correct hostname.
References:
I run into this problem recently. The DB2 9.5 installer doesn’t automatically set the instance to autostart at installation time. To solve this problem run the following:
db2iauto -on [instancename]
At default installation this command is located in /opt/IBM/db2/V9.5/bin/
I just installed Ubuntu 9.04 paralell with WinXP.
I found the following software useful to get similar functionalities as you would on windows: