LifeUML

What you need:
- DBConvert for MS Access and MySQL 6.2.1: here
- Translator tool: DbfontConvert (Vietfont converter for database): here

TuyenT Uncategorized

Reference: NoteBookReview

I got this info about the program in case it’s any help. I’m in the new Vista version of MSConfig and the button used to disable this thing at boot is greyed out

File Name: TCrdMain.exe
Display Name: TOSHIBA Flash Cards
Description: TOSHIBA Flash Cards
Publisher: TOSHIBA Corporation
Digitally Signed By: VeriSign Class 3 Code Signing 2004 CA
File Type: Application
Startup Value: C:\Program Files\TOSHIBA\FlashCards\TCrdMain.exe
File Path: C:\Program Files\TOSHIBA\FlashCards\TCrdMain.exe
File Size: 530552
File Version: 1.0.0.7
Date Installed: 11/12/2006 18:27:12
Startup Type: Registry: Local Machine
Location: Software\Microsoft\Windows\CurrentVersion\Run
Classification: Permitted
Ships with Operating System: No
SpyNet Voting: Not applicable

…….

OK, for some reason the disable button is lit up now, I’ve disabled it, rebooted and I’m happy to say I’ve solved the problem. The instrcutions from star to finish (in Vista) are:

Click Start
Click on Control Panel (make sure there’s a dot next to “Control Panel Home” on the left hand side of the Control Panel window)
Click “Change Startup Programs” (Under Programs)
Change the Category drop-down menu to “Startup Programs”
Scroll down the list until you see Toshiba Flash Cards under the Toshiba Corporation heading, then click on it
Click the Disable button at the bottom-right of the window
Reboot
Login
Press Fn+F6
Breathe deep sigh of relief
Go to bed

Spiderpig, spiderpig, does whatever a spiderpig does….

TuyenT Tips

Original Post From: StringOfThoughts

Adding a script

First of all write a script, say test.sh and put it in the directory /etc/init.d . Next we need to make it executable so.

$ sudo chmod +x test.sh

You can check if the script is working by issuing

$ sudo ./test.sh

Assuming the script is working as expected, to make the script run at startup / reboot.

$ sudo update-rc.d -f test.sh start 99 2 3 4 5 . // Run at startup
$ sudo update-rc.d -f test.sh start 1 0 6 .      // Run at reboot

Just a reminder there is dot (.) at the end of command. Don’t forget that!! Now you are done adding a script to run at startup.

Removing a script.

Just a reminder for new users, don’t just go to /etc/init.d and delete the script file that wouldn’t help and may cause you trouble. We need a nice little application called rcconf (Debian runlevel configuration tool)

$ sudo apt-get install rcconf

then run rcconf (only root can run rcconf)

$ sudo rcconf

The interface is very simple. It lists the scripts so all you need to do is find out where is your script and toggle “*” using space bar and then select OK. That’s all. The script is now removed but still present in the directory /etc/init.d but you can safely delete it now.

Bonus: My shell script to launch JasperServer at start up:

#!/bin/sh
/opt/jasperserver-3.1/jasperctl.sh start

TuyenT Coding add, remove, script, shell, start up, Ubuntu

Do you want a virtual CD/DVD software like MagicDisc or DAEMON Tools in Windows for your Ubuntu/Linux machine? I can introduce you an acceptable (and free) one: AcetoneISO

AcetoneISO, is a feature-rich and complete software application to manage CD/DVD images. Thanks to powerful open source tools such as fuseiso, AcetoneISO will let You mount typical proprietary images formats of the Windows world such as ISO BIN NRG MDF IMG and do plenty of other things.

- From AcetoneISO Homepage

The use of AcetoneISO is pretty easy and much similar to DAEMON Tools. Just give AcetoneISO a try, and save time of burning a CD/DVD

P/S: By the way, you can find some interesting information of how to mount a ISO file at UbuntuForums.

TuyenT Administration, Tips AcetoneISO, CD, DVD, Ubuntu, Virtual

Original Post From: prash-babu.com

In case you use Yahoo with Pidgin, you may sometimes find this error saying “Could not establish a connection with the server: Error resolving scs.msg.yahoo.com. Name or service not known”. Sometimes trying to connect multiple times may solve the issue, but sometimes it may never connect. Now this can get very irritating, so there is a fix for it. If you carefully look at the error, it says “Error resolving ..”. Now this is mostly some communication problem with the pager server scs.msg.yahoo.com. So the fix is like this :

Step 1: Open Pidgin, then go to Accounts -> Add/Edit (or just press Ctrl+A)

Step 2: Then select your Yahoo account and Click on Modify

Step 3: Then Go to Advanced

Step 4: Now under Pager Server, replace scs.msg.yahoo.com with 66.163.181.166 or 66.163.181.173.

This ip you get when you ping scs.msg.yahoo.com

$ ping scs.msg.yahoo.com
PING scs.msg.yahoo.com (66.163.181.166) 56(84) bytes of data.
64 bytes from cs101.msg.mud.yahoo.com (66.163.181.166): icmp_seq=1 ttl=52 time=321 ms
64 bytes from cs101.msg.mud.yahoo.com (66.163.181.166): icmp_seq=2 ttl=51 time=320 ms
64 bytes from cs101.msg.mud.yahoo.com (66.163.181.166): icmp_seq=3 ttl=52 time=323 ms

Step 5: Now click on Save and and Enable Your yahoo account again, this time you hopefully should be able to connect. In case you still cant try the second, i have mentioned 2 IPs.

Note: Basically what you are doing is directly providing the IP address of scs.msg.yahoo.com thereby saving time and the need to resolve scs.msg.yahoo.com.

Update: If the above instruction doesn’t work with you, try to update your Pidgin version. You can check out getdeb.net or launchpad.net for the newest one.

TuyenT Tips connect, establish, Pidgin, resolving, Yahoo

Original Post From: GiannisTsakiris.com

It is easy to open and view Microsoft Compiled HTML Help files (.chm) from Ubuntu. You actually have at least two options: xchm or gnochm.

To install xchm run the following command:

$ sudo apt-get install xchm

To install gnochm run:

$ sudo apt-get install gnochm

To view a .chm file using xchm you just have to run:

$ xchm chm-file

Alternative to open it with gnochm simply run:

$ gnochm chm-file

Or in a simplier way, you can just double-click on the file’s icon.

TuyenT Tips CHM, Ubuntu

Hello everybody,

Today, my task is configuring a MySQL server to allow connections from remote computers. The problem I has met is that although port 3306 on the router was already opened, users from internet still could not connect to my MySQL Server. Here is my error message:

tuyent@local:~$ mysql -u tuyent -p -h remote-computer
Enter password: 
ERROR 1045 (28000): Access denied for user 'tuyent'@'local' (using password: YES)

Well, here is my solution:
- Step 1: Double check that the port 3306 is already opened.
- Step 2: Open MySQL configuration file (/etc/mysql/my.cnf), comment the line

# bind-address            = 127.0.0.1

- Step 3: Restart the MySQL server

$ sudo /etc/init.d/mysql restart

- Step 4: Go to mysql command line and grant permission for user

mysql> grant all on *.* to 'tuyent'@'%' identified by 'password';
mysql> grant all on *.* to 'tuyent'@'localhost' identified by 'password';
mysql> flush privileges;

Note: Remember to grant permission on both from localhost and from anywhere (’%’ indicator), and flush all privileges.

Works fine for me

TuyenT Administration, Coding Access denined, error, Linux, MySQL, permission, Ubuntu

Original post from: devshed.com

Do you need to change your web host or switch your database server? This is probably the only time when you really think of backing up your MySQL data. If you’ve got a website with a database or your custom database running for your applications, it is imperative that you make regular backups of the database.

The easiest way to backup your database would be to telnet to the your database server machine and use the mysqldump command to dump your whole database to a backup file.

Playing with mysqldump

If you have either a shell or telnet access to your database server, you can backup the database using mysqldump. By default, the output of the command will dump the contents of the database in SQL statements to your console. This output can then be piped or redirected to any location you want. If you plan to backup your database, you can pipe the output to a sql file, which will contain the SQL statements to recreate and populate the database tables when you wish to restore your database. There are more adventurous ways to use the output of mysqldump.

A Simple Database Backup:

You can use mysqldump to create a simple backup of your database using the following syntax.

mysqldump -u [username] -p [password] [databasename] > [backupfile.sql]

• [username] – this is your database username
• [password] – this is the password for your database
• [databasename] – the name of your database
• [backupfile.sql] – the file to which the backup should be written.

The resultant dump file will contain all the SQL statements needed to create the table and populate the table in a new database server. To backup your database ‘Customers’ with the username ’sadmin’ and password ‘pass21′ to a file custback.sql, you would issue the command:

mysqldump -u sadmin -p pass21 Customers > custback.sql

You can also ask mysqldump to add a drop table command before every create command by using the option –add-drop-table. This option is useful if you would like to create a backup file which can rewrite an existing database without having to delete the older database manually first.

mysqldump --add-drop-table -u sadmin -p pass21 Customers > custback.sql

Backing up only specified tables

If you’d like restrict the backup to only certain tables of your database, you can also specify the tables you want to backup. Let’s say that you want to backup only customer_master & customer_details from the Customers database, you do that by issuing

mysqldump --add-drop-table -u sadmin -p pass21 Customers customer_master customer_details > custback.sql

So the syntax for the command to issue is:

mysqldump -u [username] -p [password] [databasename] [table1 table2 ....]

• [tables] – This is a list of tables to backup. Each table is separated by a space.

Read more…

TuyenT Administration, Coding Back up, Command, MySQL, Restore

After a bundle of trying and testing, here is my final version of send a HTML email with attachment using JavaMail API and GMail’s SMTP Server.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77

import java.util.Properties;
import javax.mail.*;
import javax.mail.internet.*;
import javax.activation.*;
 
public class Mail {
	public void sendMail() throws Exception {
		String SMTP_SERVER = "smtp.gmail.com";
		String SMTP_PORT = "587";
 
		final String from = "your-email@gmail.com";
		final String password = "your-password";
		String to = "your-friend@somewhere.com";
		String fileAttachment = "/path/to/attachment/file";
 
		String mailSubject = "JavaMail API with Attachment";
		String mailContent = "Hello buddy," +
				"<p>This is an example of sending an HTML email with attachment by JavaMail API.</p>" +
				"<p>Enjoy the code,</p>Your name.";
		String mailFileName = "attachment-name";
 
		// Get system properties
		Properties props = System.getProperties();
 
		// Setup mail server
		props.put("mail.smtp.host", SMTP_SERVER);
		props.put("mail.smtp.port", SMTP_PORT);
		props.put("mail.smtp.starttls.enable","true");
		props.put("mail.smtp.auth", "true");
 
		Authenticator pa = null;
		pa = new Authenticator (){
			public PasswordAuthentication getPasswordAuthentication() {
				return new PasswordAuthentication(from, password);
			}
		};
 
		// Get session
		Session session = Session.getInstance(props, pa);
 
		// Define message
		MimeMessage message = new MimeMessage(session);
		message.setFrom(new InternetAddress(from));
		message.addRecipient(Message.RecipientType.TO, new InternetAddress(to));
		message.setSubject(mailSubject);
 
		// create the message part 
		MimeBodyPart messageBodyPart = new MimeBodyPart();
 
		//fill message
		messageBodyPart.setContent(mailContent, "text/html");
 
		Multipart multipart = new MimeMultipart();
		multipart.addBodyPart(messageBodyPart);
 
		// Part two is attachment
		messageBodyPart = new MimeBodyPart();
		DataSource source = new FileDataSource(fileAttachment);
		messageBodyPart.setDataHandler(new DataHandler(source));
		messageBodyPart.setFileName(mailFileName);
		multipart.addBodyPart(messageBodyPart);
 
		// Put parts in message
		message.setContent(multipart);
 
		// Send the message
		Transport.send(message);
	}
 
	public static void main(String args[])  {
		try {
			new Mail().sendMail();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
}

Tested and works like a charm

TuyenT Coding Attachment, Email, GMail, HTML, Java, JavaMail, SMTP

I am responsible for couple of windows servers and windows xp workstations too. When I work from home, I need a way to get into Windows XP/2000/Vista/2003 server for work.

Since I have Debain Linux at home, I needed a way to login into Microsoft windows desktop from Linux OS. Many of us working at tech support use rdesktop to connect to customers’ windows XP box.

Especially it is very useful to configure Outlook or something else when customers do not understand how to configure or troubleshoot problem. This is the best way to fix a problem.

Fortunately, Linux has rdesktop utility. It is a client for remote desktop protocol (RDP), used in a number of Microsoft products including Windows NT Terminal Server, Windows 2000 Server, Windows XP and Windows 2003 Server. You do not need to install VNC server. All you need is rdesktop client on Linux or BSD workstation.

Install rdesktop

$ sudo apt-get install rdesktop

Connect to MS Windows 2000/2003 server from Linux, type the following command at a shell prompt (connect to Windows server called mw2sn100.mycorp.com)

$ rdesktop mw2sn100.mycorp.com

Or connect to windows XP/Vista workstation having IP 192.168.1.17:

$ rdesktop 192.168.1.17

Please note that you must first enable remote desktop connection under Windows Server/XP.

* Go to Windows XP Desktop
* Right Click on My Computer
* Select properties
* Select Remote tab
* Enable Remote desktop.
* Save the changes.

Make sure enterprise firewall allows incoming connection on TCP port 3389. rdesktop supports many other options, see man page of rdesktop or visit main website of rdesktop for more information.

Original Post from: cyberciti.biz

TuyenT Administration Linux, rdesktop, Remote Desktop, Ubuntu, Windows