Showing posts with label windows. Show all posts
Showing posts with label windows. Show all posts

Tuesday, June 14, 2011

Running Winbox in Snow Leopard

My everyday work are sometime using winbox to configure and manage routerboard device which running MikroTik OS, while using MacBook Pro, I need to prepare the environment since winbox are meant to be run on Windows environment. I can use either Darwine or wine package from macports, and I chose to use macports, since I'm more used to CLI environment.

All you need to do is:
1. choose the package according to Mac OS X version, download and install from here
2. for snow leopard (64-bit), you should install wine-devel instead of wine package, and add +universal
#  sudo port -v install wine-devel +universal

3. then you should be able to run winbox.exe from terminal
# /opt/local/bin/wine winbox.exe

4. you can also download this package, put it in your Applications and just double-click to run it

For complete references on other Mac OS X version, see here

Monday, June 6, 2011

How To Make Microsoft Office XP & 2003 able to open Microsoft Office 2007 and above File Formats

In order to be able to open Microsoft Office 2007 and above (.docx, .xlsx, .pptx, etc), Microsft Office 2003 and XP (2002) running on Windows XP must do several upgrade and install additional software.

For Microsoft Office XP,
1. You have to make sure that Service Pack 3 is installed, you can download it here
2. Start - Run, then copy - paste this: %programfiles%\Microsoft Office\Office10 and press ENTER
3. Find winword.exe, excel.exe and powerpnt.exe (for Standard version and above), right click on it - properties and click on Version tab
4. Upgrade your Microsoft Word (winword.exe) version to minimum of version 10.0.6804.0, from here
5. Upgrade your Microsoft Excel (excel.exe) version to minimum of version 10.0.6809.0, from here
6. Upgrade your Microsoft PowerPoint (powerpnt.exe) version to minimum of version 10.0.6804.0, from here
7. Download and install Compatibility Pack from here

For Microsoft Office 2003
1. Upgrade to Service Pack 3, download from here
2. Download and install Compatibility Pack from here

That's all you have to do on Windows XP. For any detail information, you can refer here

Friday, May 27, 2011

Accesing #webOS Device via WiFi using SFTP Client

I'm using this because I'm tired of connecting USB cable everytime I want to copy files between my Palm Pre and my MacBookPro. Actually there's only 5 simple steps to follow:

  1. Install Preware
  2. Use Preware to install SFTP and terminal application
  3. Use terminal application to generate keys for OpenSSH
  4. Transfer SSH keys to desktop via USB
  5. Configure SFTP client (I'm using Cyberduck on Mac OS X) on desktop and connect
1. Install Preware
You can see here for complete reference

2. Using Preware to install SFTP and Terminal application
Still, you can refer to previous link for usage guide. FYI, I'm using SDL Terminal, other options is Terminal and Terminus

3. Use terminal application to generate keys for openSSH
I just did these steps:
# cd /
# /opt/bin/ssh-keygen (press Enter key once to accept default filename, then Enter key twice for blank password)
# mv /home/root/.ssh/id_rsa.pub /home/root/.ssh/authorized_keys

Or you can read from wiki here

4. Transfer SSH keys to desktop via USB
First, run this command:
# mv /home/root/.ssh/id_rsa /media/internal/

Then connect your Pre to your desktop station via USB cable, and put it in Drive mode. Copy and save id_rsa file you've just copied to any safe place in your desktop station

5. Configure SFTP client on desktop and connect
First,you need to know your IP address on your Pre. Open Wifi and tap on current Wifi connection (SSID) to view the IP address.
Then, open your SFTP client. Since I'm using Cyberduck, for now I'm just explaining about how to use it on Cyberduck only. But, actually the steps are very similar on any SFTP client. 
1. Click on Open Connection
2. Choose SFTP (SSH File Transfer Protocol).
3. Fill in username: root
4. Leave the password blank
5. More options -> check "Use Public Key Autentication"
6. Click Connect

Just wait and see :D

Friday, May 20, 2011

Jailbreaking FU iOS Device

I put the title, so I am aware that what I'm about to write here works on almost any iOS device (which I already tried the same way for iPhone 3G/s and 1st generation of iPad). After reading on several blogs, and tried it on my iOS device myself, I choose the method using redsn0w. All you need to do first is make sure that newest update iOS version already been able to jailbreak, and all requirement files are downloaded and ready to use.

Actually you only need 2 files, redsn0w (mac and/or windows) and .ipsw files according to which version of iOS device you want to jailbreak. After you get those two files, execute redsn0w, choose the .ipsw files, check only at "Install Cydia", then just follow onscreen instruction at redsn0w window. That's it! :) And after rebooted, you'll find Cydia icon in your launcher.

Here are some of the snapshot I took, when jailbreak iPhone 3G:




Thursday, March 17, 2011

Grid Vs. Cluster Computing

Cloud Computing has been a new phenomenon recently, and while reading several articles about it, I just know that it can based on Grid or Cluster Computing. And to make it clear, here are some differences between them:




So just for you now about it :)

Mozilla Thunderbird Corrupted Folder Workaround

In the past 5 years, many colleague of mine have lost their emails (Thunderbird in Linux OS). So I take the step to overcome this. I've taken this post from here, just want to share this because not all people willing to search and read thoroughly long technical article like that. Editing a little bit to give more understanding (for myself, actually :D), so I hope you could understand it as well. Please keep in mind that I done these in Linux, but could be done in Windows as well, with a little adjustment of course :)

Here's a little quote and introduction:
If the corruption is severe, deleting the .msf files won't help much, and compacting the folder may just make it worse. You'll typically run into this only with the Inbox folder. It's much more vulnerable to corruption because many users tend to store lots of messages in it, and they also frequently delete messages in it. That's why it's recommended that you DON'T permanently store messages in your Inbox folder and instead move them to other folders. You can fix the problem by replacing the corrupt folder with a new known good folder into which you copy the messages from the corrupt folder.
Follow these steps:
1. Exit Thunderbird
2. Make a temporary backup of your profile folder (usually in /home/[username]/.mozilla-thunderbird/)
3. Start Thunderbird
4. Create new folder and name it (e.g. "TestFolder")
5. Open your seemingly corrupted folder (e.g. "Inbox"), selected all messages then copy them to your newly created folder
note: In extreme cases (if Thunderbird and/or the computer become extremely sluggish), you may have to choose only a few emails at a time.
6. Verify that all of the messages have been copied
7. Right-click on the new folder, then choose "Compact"
8. Go to you profile folder (/home/[username]/.mozilla-thunderbird/) to see if your new folder looks like it has been compacted. Compare the size with the original folder which you copied the messages.
9. On Thunderbird, check the new folder to make sure you still have all your messages (by looking at the Total message count at right below status bar of Thunderbird)
10. If it looks good, then do the following:
  • Go to profile folder, then rename your old directory (e.g. "Inbox") to "InboxOLD"
  • Delete its .msf file (e.g. "Inbox.msf")
  • Rename the "TestFolder" to "Inbox"
  • Delete "TestFolder.msf"
11. Restart Thunderbird and use as usual

note: This workaround will work ONLY if your seemingly corrupted folder hasn't corrupted at all. If it is corrupted, or already contains a lot of messages, Thunderbird will "hidden" the message and marked it "deleted". So compact-ing will only delete the messages.

Saturday, February 5, 2011

View Your Real X Display Using x11vnc,

I've been manage several servers with different operating systems for a couple of years. I used VNC to remotely view and manage Linux/ UNIX servers through their X displays. If you ever used and configure VNC server at Windows OS, you might find a slight differences with the one at Linux/ UNIX. In windows, you can configure VNC and use it with any display, yet you still can view your real desktop display, the one that you've been and always used. But in Linux/ UNIX, when you configure your VNC server, you can't configure it to connect to your real X display, indeed it always create a new display, so you can't view your existing open applications.

Recently I just found out a very simpe and right Linux/ UNIX application for that purpose, it called x11vnc. X11vnc is a VNC server for real X display, it allows one to view remotely and interact with real X display. With this tools, now I can view and control any X applications running on my server. The usage is very simple either.

First, you must install this tools. For I am using Ubuntu server, this is the command:
server# apt-get install x11vnc

And after it installed, execute this command to run VNC server:
server# x11vnc -display :0
You'll get some notifications upon execute the command, its for security purposes (access password, etc.), just read and customize it according to your server configuration.

After done with above command, you can view X server's display from your client using this command:
client# vncviewer server:0

That's it. If you run the command on server with no errors, right now you can view your real X server's display, with any X application already running on it. Cheers! :)

 

Monday, January 31, 2011

Cygwin: Coloring CLI

I've got this from someone who share it in the internet, so the credit should goes to him/ her :) This is just a note-taking, so I can search it on the archive in the future.

Add these lines to .vimrc file which located on your $HOME directory (or create one if you can't find one):

" Switch syntax highlighting on, when the terminal has colors
" Also switch on highlighting the last used search pattern.
if &t_Co > 2 || has("gui_running")
  syntax on
  set hlsearch
endif

And for your Cygwin CLI, so you can see clearly. Add this line to your .bashrc file on your $HOME directory:
alias ls="ls -CF --color"

That's it.. restart your Cygwin, and you'll find the differences :)

Wednesday, August 11, 2010

Reveal Hidden Apps In Add/Remove Windows Components

This works with Windows XP Professional or Home edition, any service packs. In Add/Remove Programs, on the sidebar you'll find Add/Remove Windows Components button. There, you can add/remove applications that belongs to Windows installation. The problem is, some of them are hidden, so you cannot remove them. By editing a file, you can reveal those apps. Here's how to do it:

1. Start -> Run, type: c:\windows\inf\sysoc.inf

2. On the new popup Notepad window, do ctrl-F and type 'hide' (without quote), then press Enter.
Press Esc button to close Find window and you'll find the first highlighted 'hide' word. Press Del button to eliminate it. Instead of repeating using Find window, you can press F3 button, it will find next 'hide' word. Press Del button - F3 button - Del button and so on.

3. Press Alt-F-X to close the Notepad window, you'll be prompted to save it, answer with 'Yes'

And you're done. Open Control Panel -> Add/Remove Programs -> Add/Remove Windows Components to choose the programs you need.

Saturday, August 7, 2010

Concurrent RDP on Windows XP 64-bit Using Same User Account

In this post, I will give you step-by-step guide to make you be able remote desktop concurrently to Windows XP Professional Edition 64-bit with only one user account. It's a little different with my previous post, where it only be able to do remote desktop concurrently using different user account.

Step 1.
Disable remote desktop.
a. Right-click on My Computer -> Properties -> Remote (uncheck both boxes).
b. Then go to Control Panel -> Administrative Tools -> Services and double click on Terminal Services and change the startup type to disabled.

Step 2.
Get files.
a. Get the files here Antiwpa-V3.4.6 for X64 and X86.zip (source) TS-NoRestr-Patch-x64.rar (source). If the links don't work the sources will, the site is AntiWPA and you need to register to download the files.

b. Extract the zip file to a new folder and run AntiWPA3.cmd (just double click) it will apply the patch.

c. Extract the rar to a new folder (single word no spaces [I used "new"] c:\windows\new) in c:\windows double click the TSfix.reg file and click ok.

Step 3.
Get the windows XP 64-bit disk and reboot from disk. Then go to the recovery console and type 1 for C:\WINDOWS

code:
cd system32
copy winlogon.exe winlogon.exe_backup
cd ..
cd new
copy winlogon.exe c:\windows\system32
y
exit

Step 4.
a. When the computer reboots reboot in safemode by hitting F8 at the right time, choose regular safemode.

b. Login as an administrator and make sure that terminal services are still off as set in Step 1.

c. make a backup of c:\windows\system32\termsrv.dll and c:\windows\system32\dllcache\termsrv.dll (dllcache is a hidden folder, so make sure you already change the setting to show hidden/ system files)

d. replace those two files with the termsrv.dll from the rar (which has been extracted to c:\windows\new in Step 2)

e. 'Click Start, then “Run…”, type “gpedit.msc” (without quotes) and press ENTER;
open Computer Configuration -> Administrative Templates -> Windows Components -> Terminal Services;
double click “Limit number of connections”, choose “Enabled” and set the maximum number of concurrent connections you want to allow'.

reboot to normal.

Step 5.
a. Log on to the normal windows XP 64 bit and enable the remote desktop similar to Step 1
b. Switch the Terminal Services to manual also similar to Step1.
c. Reboot

Step 6.
Try it out, you should be able to have multiple logins using remote desktop to the same system without kicking each other off.
I tried by creating on user account 'testing', and I can make all 10 colleagues in office login using the same user account :)

Please give some comments, or if you have difficulties just let me know, so I can edit the post accordingly. Thanks.

Thursday, July 22, 2010

OpenFire Server for Broadcast IM

These are some screenshoot of my OpenFire server configuration, I use this as an integrated service to communicate with all of my colleagues in my department. This way, we can share any update information in a more efficient and simple way :)





Tuesday, June 15, 2010

Concurrent Remote Desktop Connection On XP SP2 With Single Login

All you have to do is go to this website, then download the file specifically made for your system, then you'll enable two or more concurrent remote desktop connection to Windows XP Pro SP2 and SP3, as long as you have "fast user switching" active and you're not in a domain.

I need to add something here. This method allow you to be able to do remote desktop connection concurrently using different user account. If you want to use the same user account to concurrently remote desktop, that's another method and I'm not include it in this post :)

Friday, June 4, 2010

Internet Sharing on Windows Mobile

Sharing internet connection (GPRS, EDGE, 3G, HSDPA) in Windows Mobile platform is never been easier with Internet Sharing application that already include since Windows mobile 6.0. The option available is to connect PC or notebook/ netbook through USB cable (only working on Windows Platform) and Bluetooth PAN (working on all platforms Windows/ Mac/ Linux). You only need to choose PC Connection type, Network Connection you want to use, then click on 'connect' button. And you're done! :)

Wednesday, June 2, 2010

RRDTool & snmpd (net-snmp) on Linux, Windows and Mac

crucial dependencies for Cacti and Zenoss

* snmpd (net-snmp)
linux: snmpd, snmpwalk, snmp

on Ubuntu:
$ sudo apt-get install snmpd snmp
$ sudo vi /etc/snmp/snmpd.conf (configuration file for net-snmp snmp agent)
snmpd.conf#---------------------------------------------------------------
######################################
# Map the security name/networks into a community name.
# We will use the security names to create access groups
######################################

# sec.name               source                      community

com2sec my_sn1     localhost                   my_comnt
com2sec my_sn2     192.168.10.0/24     my_comnt

####################################
# Associate the security name (network/community) to the
# access groups, while indicating the snmp protocol version
####################################

# sec.model sec.name
group MyROGroup v1 my_sn1
group MyROGroup v2c my_sn1
group MyROGroup v1 my_sn2
group MyROGroup v2c my_sn2


group MyRWGroup v1
my_sn1
group MyRWGroup v2c my_sn1
group MyRWGroup v1 my_sn2
group MyRWGroup v2c my_sn2

#######################################
# Create the views on to which the access group will have access,
# we can define these views either by inclusion or exclusion.
# inclusion - you access only that branch of the mib tree
# exclusion - you access all the branches except that one
#######################################

# incl/excl subtree mask (opcional)
view my_vw1 included .1 80
view my_vw2 included .iso.org.dod.internet.mgmt.mib-2.system

#######################################
# Finaly associate the access groups to the views and give them
# read/write access to the views.
#######################################

# context sec.model sec.level match read write notif
access MyROGroup "" any noauth exact my_vw1 none none
access MyRWGroup "" any noauth exact my_vw2 my_vw2 none
# -----------------------------------------------------------------------------


$ sudo vi /etc/default/snmpd

find the line:

SNMPDOPTS='-Lsd -Lf /dev/null -u snmp -I -smux -p /var/run/snmpd.pid 127.0.0.1'
and change it to:

SNMPDOPTS='-Lsd -Lf /dev/null -u snmp -I -smux -p /var/run/snmpd.pid'


win: net-snmp
1. Download the binary of your windows version then install. Usually it will install to c:\usr
2. To check the installation, run this command from command prompt
c:\usr\bin>snmpd -v

3. Run snmp-agent as service
c:\usr>registeragent.bat


4. Create snmpd.conf file on c:\usr\etc\snmp\ and fill with this configuration:

## Of the following Net-SNMP agent features
## NONE are supported on Net-SNMP-5.1.1 Win32 platforms
## Process checks “proc” config token
## Executable scripts “exec” config token
## Disk checks “disk” config token
## Load average checks “load” config token
## Extensible sections “exec” config token with shelltest
## Pass-through control “pass” config token

#############################################################
#
# EXAMPLE.conf:
# An example configuration file for configuring the ucd-snmp snmpd agent.
#
#############################################################
#
# This file is intended to only be an example. If, however, you want
# to use it, it should be placed in c:/usr-mingw/etc/share/snmp/snmpd.conf.
# When the snmpd agent starts up, this is where it will look for it.
#
# You might be interested in generating your own snmpd.conf file using
# the “snmpconf” program (perl script) instead. It’s a nice menu
# based interface to writing well commented configuration files. Try it!
#
# Note: This file is automatically generated from EXAMPLE.conf.def.
# Do NOT read the EXAMPLE.conf.def file! Instead, after you have run
# configure & make, and then make sure you read the EXAMPLE.conf file
# instead, as it will tailor itself to your configuration.

# All lines beginning with a ‘#’ are comments and are intended for you
# to read. All other lines are configuration commands for the agent.

#
# PLEASE: read the snmpd.conf(5) manual page as well!
#

####################################################################
# Access Control
####################################################################

# YOU SHOULD CHANGE THE “COMMUNITY” TOKEN BELOW TO A NEW KEYWORD ONLY
# KNOWN AT YOUR SITE. YOU *MUST* CHANGE THE NETWORK TOKEN BELOW TO
# SOMETHING REFLECTING YOUR LOCAL NETWORK ADDRESS SPACE.

# By far, the most common question I get about the agent is “why won’t
# it work?”, when really it should be “how do I configure the agent to
# allow me to access it?”
#
# By default, the agent responds to the “public” community for read
# only access, if run out of the box without any configuration file in
# place. The following examples show you other ways of configuring
# the agent so that you can change the community names, and give
# yourself write access as well.
#
# The following lines change the access permissions of the agent so
# that the COMMUNITY string provides read-only access to your entire
# NETWORK (EG: 10.10.10.0/24), and read/write access to only the
# localhost (127.0.0.1, not its real ipaddress).
#
# For more information, read the FAQ as well as the snmpd.conf(5)
# manual page.

####
# First, map the community name (COMMUNITY) into a security name
# (local and mynetwork, depending on where the request is coming
# from):

# sec.name source community —-> **edit this part to match your requirement** com2sec local localhost [comm name]
com2sec mynetwork 192.168.13.0/24 [comm name]

####
# Second, map the security names into group names:

# sec.model sec.name
group MyRWGroup v1 local
group MyRWGroup v2c local
group MyRWGroup usm local
group MyROGroup v1 mynetwork
group MyROGroup v2c mynetwork
group MyROGroup usm mynetwork

####
# Third, create a view for us to let the groups have rights to:

# incl/excl subtree mask
view all included .1 80

####
# Finally, grant the 2 groups access to the 1 view with different
# write permissions:

# context sec.model sec.level match read write notif
access MyROGroup “” any noauth exact all none none
access MyRWGroup “” any noauth exact all all none

# —————————————————————–
##################################################################
# System contact information
#

# It is also possible to set the sysContact and sysLocation system
# variables through the snmpd.conf file. **PLEASE NOTE** that setting
# the value of these objects here makes these objects READ-ONLY
# (regardless of any access control settings). Any attempt to set the
# value of an object whose value is given here will fail with an error
# status of notWritable.

syslocation Solo.
syscontact Tunggul

# Example output of snmpwalk:
# % snmpwalk -v 1 -c public localhost system
# system.sysDescr.0 = “Windows NT 2000 SP4″
# system.sysObjectID.0 = OID: enterprises.ucdavis.ucdSnmpAgent.win32
# system.sysUpTime.0 = Timeticks: (595637548) 68 days, 22:32:55
# system.sysContact.0 = “Me ”
# system.sysName.0 = “name”
# system.sysLocation.0 = “Right here, right now.”
# system.sysServices.0 = 72

# —————————————————————
#################################################################
# Subagent control
#

# The agent can support subagents using a number of extension mechanisms.
# From the 4.2.1 release, AgentX support is being compiled in by default.
# However, this is still experimental code, so should not be used on
# critical production systems.
# Please see the file README.agentx for more details.
#
# If having read, marked, learnt and inwardly digested this information,
# you decide that you do wish to make use of this mechanism, simply
# uncomment the following directive.
#
# master agentx
#
# I repeat - this is *NOT* regarded as suitable for front-line production
# systems, though it is probably stable enough for day-to-day use.
# Probably.
#
# No refunds will be given.

############################################################
# Further Information
#
# See the snmpd.conf manual page, and the output of “snmpd -H”.
# MUCH more can be done with the snmpd.conf than is shown as an
# example here.



mac: net-snmp - through macports

Details installation and configuration on Mac OS X are on separate post.


* RRDTool
linux: rrdtool

win: 
We all have an impressions that it is very difficult to install RRDTool on a Windows Server (including Windows XP, Windows Vista, Windows NT and Windows 2003/ 2008 Server) but that is not the case. There are few very Simple Steps to install RRDTool:
1. Create a Folder on any of your drives with name RRDTool.
2. Download the latest version of RRDTool from here
3. Extract the ZIP in RRDTool folder.
4. Open START >> Run >> type cmd to open Windows command prompt.
5. Type following command on prompt to use the RRDTool.
cd C:\RRDTool\

mac: rrdtool - through macports

Monday, May 24, 2010

cPanel Configuration for MySQL Access

Case: cPanel user would like to hire web developer, want to give ftp access (for upload and download web files) and MySQL database access (the web is using Joomla) only.

These are the example:
- db name: cybi1_testing
- db username: cybi1_test
- pass: t3st1ng
- host: cybi.co.id (server Cohosting 1)

a. via terminal:



b. or via phpMyAdmin (available for Linux/ Unix, Windows and Mac/ other mySQL FrontEnd GUI:




Below are the steps to follow:
1. Create ftp account for the web developer, menu Files → FTP Accounts



Fill-in username, password, default directory dan capacity




2. Create new database, user and priviliges to access the database







3. Allowing host to access database, Databases → Remote MySQL




Enjoy.. :)

Monday, April 12, 2010

Using VMWare Workstation Port Forwarding

The scenario was setting up a Windows guest OS (with VMWare) on Ubuntu Server host, and allowing access to any services running on that Windows guest OS. At first, it is complicated to figure out how to do it. But, then, I realize that it is so simple, and only needs simple configuration.

One example is by allowing access to Windows remote desktop service. These are how to do it:

1. configure your Windows guest OS to use NAT for Network Adaptor settings (Used to share the host's IP address)

2. open the configuration file:
# vi /etc/vmware/vmnet8/nat/nat.conf
3. add this line:
[incomingtcp]
# Forward Remote Desktop connections to Windows VM
3389 = 192.168.0.101:3389
 
[incomingudp]
# Forward Remote Desktop connections to Windows VM
3389 = 192.168.0.101:3389
4. restart VMware services
# sudo /etc/init.d/vmware restart
Then you can try to access remote desktop service on your Windows guest OS.

Saturday, April 3, 2010

Interlude Of The Life

There's been an empty post for several month, it is due to many circumstances. One of them is that I decide to do so.. not write or post anything in my blog. But now it's time to start again. There's a lot to write. So, if you haven't read anything in my blog, start to do it.. or there would be a lot to catch :)

Thursday, October 29, 2009

Dual Boot-ing Windows 7 and Ubuntu Jaunty 9.04 Server Edition

I just succesfully implementing dual boot Windows 7 and Ubuntu Jaunty, using Windows 7 Bootloader, with the help of awesome application called EasyBCD. My first trial was using GRUB Bootloader (install to MBR), with the result "BOOTMGR is missing". Apparently my GRUB installation on MBR, not just failed, but also destroyed Windows 7 Bootloader.

Here is my disk partition mapping, my harddisk size is 80GB:
# Primary partition
/dev/sda1 100mb - automatically created with Windows 7 installation
/dev/sda2 32gb - Windows 7 installation

# Logical partition - Ubuntu
/dev/sda5 100mb - boot
/dev/sda6 2gb - swap
/dev/sda7 10gb - root
/dev/sda8 32gb - home

Before installing Windows, I move the GRUB installation from MBR to my root partition. This way, I can switch between Windows 7 bootloader and GRUB bootloader.

After installing Windows 7, download and install EasyBCD, run it, then go to add/remove Entries:


image courtesy to Neosmart

In Drive, choose your root partition, click 'Add Entry' button, then Save. That's it! Restart your computer, and you'll get Bootloader to choose your Operating System :)

Thursday, October 22, 2009

Exporting and Importing MySQL Database

1. Export
# mysqldump -u [username] -p [database-name] > [database-name].sql
2. Import
# mysqladmin -u [username] -p create [database-name]
# mysql [database-name] < [database-name].sql

Wednesday, October 21, 2009

TTYtter - My Favourite Twitter client

@ttytter, developed by Floodgap is my favourite twitter client. Despite of its minimalist look (CLI apps, text-based running on terminal), I can use it to run on many platform, including on my Palm Treo Pro. On Linux/Unix and Mac, you just need to do this:

1. download it from here
2. on the directory where you keep the download:
# mv ttytter.txt ttytter
# chmod +x ttytter
3. then you can run it by executing:
# ./ttytter
or
# ./ttytter -user=[username]:[password] -vcheck
If you are Windows user, you can do telnet/ SSH to your Linux/ UNIX machine, or if you don't have any, you can register to public access UNIX server like SDF and running ttytter from there. Same thing if you want to use your mobile phone. From my Palm Treo Pro which running Windows Mobile, I just need to install SSH client like PocketPutty, and do the rest like you do at Windows PC. That also applies to another mobile/ pda phone using any OS, as long as they have telnet/ SSH client installed.

Some simple command is:
1. type directly to post status update
2. D [username] to send direct message
3. /re [post number] to reply
4. /rt [post number] to retweet

5. /re to list @[yourusername]
6. /again to refresh your timeline
7. /dmagain to show your DM

For complete operational command, you can look here.

And for additional group support, you can take a look at my friend's blog (@vkoser) here.