Pages

Thursday, October 5, 2006

Mount Windows folder in VMware server

Ubuntu packages needed:


  • smbfs, samba


On the windows machine the folder must be shared. Let's assume the windows share name is sharedfolder

On the ubuntu side the mount command should be:



Obviously WinDomain, with the double slash that follows, would be used in case you are authenticating against a domain server

Friday, August 25, 2006

Timestamp too far in the future

In that case, do:


(Username: the name of the Ubuntu user, that should behave like root)

Saturday, June 17, 2006

Migrating greek table from mysql < 4.1

I do not remember how the tables were transferred from the old DB to the new (more likely through a mysqldump).

The end effect was that the tables in the 4.1 MySql Db had a collation of latin1_swedish_ci.

After backing up the affected tables, do:



Just make sure you return the column type at exactly what was before you made it a blob.

Now the columns should have a collation of greek_general_ci

Furthermore, in case the php scripts gives you trouble loading the new rows, try something like:



The above example was run in some AdoDB Phakt scripts, but the gist of it is before any selects run the above sql commands.

Good luck...

Friday, June 16, 2006

Passwordless ssh connection with another server

First, create the key on the local machine (without a passphrase)



Then create a directory on the remote machine:



Finally append new key to remote .ssh/authorized_keys file:



Note

In place of the last command you could have also used:



but in the case your public key file does not contain a newline character at the end of the file (which probably it does not) the final concatenation on the `authorized_keys` will end up with long text line without newlines between the keys, thus making the file invalid. Tee on the other hand prepends the concatenation with a newline, keeping `authorized keys` happy.