The search for the new text editor 
Changing from one editor to another... wow! An editor is a tool that i'm using so much, that changing from one to another feels like moving to another appartment.

On windows, I'm using homesite 3 for quite some years. Homesite 4 and 5 never attracted me: adding feature after feature to a product seldom makes it better. The new homesites were slower and less stable. So why change?

On unix, i'm using vi. But the reason for that is that its always available, and there are no alternatives, except for emacs, but that doesn't feel good. It has a steep learning curve, and i can't waste time learning an editor. On unix I stick with vi for a while.

But now, homesite 3 feels a bit outdated, and some issues are irritating.

So what are editor knock out criteria for me:
- stability. Losing a text file is not acceptable.
- lean and mean. Speed is essential
- correct tabs/indents. Most editors fail on this, create spaces instead of tabs etc.
- No silly mistakes with arrows and del keys. There are some simple rules that an editor needs to follow: backspace on the beginning of a line adds the line to the previous one, cursoring down may not change column position
- line numbers
- unlimited line length
- I like the homesite explorer-window on the left. It has become natural for me
- Multiple file editing, with one-click (tabbed) file changing

And a few nice to haves:
- ftp integration. Using an ftp-server as if you're working local (this is the reason I want to dismiss homesite3)
- overview/compression mode.

So I downloaded a few editors to see which one had it all. It turned out to be a dificult search:

Notepad++ - feel is good. However, no explorer toolwindow on the left.
Syn - No correct tab/indents. For the rest it seems ok
Jedit - ugly as hell (thanks to java), slow, no explorer window
MED - no correct tab/indents. Not lean and mean. Lot of useless stuff.
TexEdit - silly key mistakes. Does not feel natural. Bad indent/tab
Crimson - Feel is ok. No siilly mistakes. Tab/indent is a bit hidden, but the implementation is ok. It has a nice ftp feature, although not transparantly integrated it works ok. This is an editor that I will try for a while to see if it sticks.







[ add comment ]   |  permalink  |  related link  |   ( 3 / 923 )
Oracle on Gentoo 
Oracle installations are always a pain, and on a non-supported distro like gentoo it will probably be much worse. Lets see what we get.

The oracle CD (9.2) contains a script called runInstaller.

* Create a user oracle and group oracle to run this script in.
* run runInstaller from the cd as user oracle


The default gentoo fstab for cdroms does not allow running scripts from cd.
You will get a bash: permission denied error, even if the file is x-r.

(Oracle uses a shebang to sh instead of bash (#!/bin/sh) in their script, so i was first on the wrong track checking the sh link (/bin/sh -> /bin/bash) but that was fine)

the reason is the gentoo folks advise you to put the 'user' option on the cdrom mounts. But this also implies 'noexec'.
You need to add 'exec' to the /etc/fstab cdrom mount line options:

/dev/cdroms/cdrom0 /mnt/cdrom auto noauto,user,exec 0 0

* You need to emerge lib-compat. If not emerged, you'll get an error because oracle can't find libstdc++-libc6.1.1.so.2

The next the error is:
Unable to load native library: /tmp/OraInstall2005-01-02_07-02-08PM/jre/lib/i386 /libjava.so: symbol __libc_wait, version GLIBC_2.0 not defined in file libc.so.6 with link time reference.

See if I can fix this one in the next post.


[ 1 comment ] ( 338 views )   |  permalink  |  related link  |   ( 3 / 210 )
oracle vs mysql 
after fiddling with mysql a bit, you normally want to use a real database. The limitations of mysql are numerous: no views, no triggers, no stored procedures and so on. For very simple applications its ok, but sql is more than just a select statement. Therefore someday you move over to oracle. Oracle software normally sucks, but their sql server rocks. Its very stable, scalable, unix oriented stuff.

Some do's and don'ts:
- never run oracle on windows. Its not stable (even less stable than windows itself). It is just not a good combination. You need to reboot it all the time (at least daily) due to memory leaks. Prepare for the worst if you're following this path.

- Never use other oracle software than their database server. Oracle forms? a joke. Oracle designer? sucks. Oracle installations: Always a pain. I have *NEVER* seen an oracle installation procedure without severe errors. (and that means over 7 years of oracle installtion history)

- Oracle databases are memory hungry. Start with 1Gb, then go up.

- After install, immediately tune up the server parameters. The defaults are not usable. Make your shared pool at least 500M for a 1Gb server, use large dbblocks (16k at least) If you don't do this, only 2 users can log in

[ 1 comment ] ( 26 views )   |  permalink  |  related link  |   ( 3 / 714 )
mysql from a remote machine. 
Assuming you can connect locally to mysql, you'd expect to be able to connect remote...not! This is not as easy as it seems.

First make sure you CAN access the mysql server from a remote machine. By default, the my.cnf file contains a statement:
bind-address=127.0.0.1
that is in your way. This only allows connections from the localhost. Put a # in front of it.

After this, still no luck, because the mysql privilege system is not your default user/password pair, but mysql for some reason also needs to know where you're calling from. This is due to the unusual non-standard structure of their user table: it contains host/user/password.

So add your remote host to the table by issuing:

grant all on *.* to user@remotehost identified by 'password'

or, if you want to allow access from all hosts, use a % like:
grant all on *.* to 'user'@'%' identified by 'password'

note: put quotes around username and host if neccesary. Beware not to quote the complete thing (like 'user@host') because mysql thinks you mean user "user@host" on the local machine.

Because mysql caches privileges, you need to flush them so enter:
flush privileges

after this you should be able to login

to see if its ok, do

use mysql
select * from user;

That's it. Sounds easy, but as the mysql documentation index/search sucks bigtime it can take you hours to find this out. (for instance, searching on the 1130 error number puts you on the wrong trail by giving information about blocked-hosts that has nothing to do with the real problem)



[ 2 comments ] ( 227 views )   |  permalink  |  related link  |   ( 3 / 656 )
Gentoo and the pvr350 with ivtv support 
Getting mythtv to work is the final step in a long range of sub-applications that need to work first. Amongst these are:

Mysql
One is mysql. Emerge mysql does the trick, but then
/etc/init.d/mysql start
told me that I still needed to run a script. The ebuild doesn't do this for you. After this the mysql server started, and running the client (also called mysql) with the simple test command 'show databases' showed everything was fine.

Ivtv
For the pvr350 (or pvr250 card) you'll need ivtv (http://ivtv.sourceforge.net). So first
emerge ivtv
Getting the pvr350 card to work needed some tweaking as well. The "default" kernel doesn't add tuner.o in the modules directory. Reason is that the BT848 is not included as a module. Reason for this is that the i2c bit-banging interfaces are OFF. These deep-dependancies can be a pain in the ass.

to fix this:
genkernel --menuconfig all
Then when the menuconfig screen appears, i went to character devices->i2c support
turned the bit-banging interface.
Then to the multimedia video section and turned the BT848

To load the whole ivtv section during boot, i did
echo ivtv >>/etc/modules.autoload.d/kernel-2.4

Also some settings in the modules.conf are needed, but in gentoo you normally generate this file and put stuff in /etc/modules.d
After emerging ivtv, the file ivtv is already in /etc/modules.d, but it needs some tweaking.

Using modprobe tveeprom, found out that my tuner is type 5, so:
#alias char-major-61 lirc_i2c
#add above ivtv lirc_dev lirc_i2c
alias char-major-81 videodev
alias char-major-81-0 ivtv
### modprobe tveeprom geeft: tuner=philips FM1216 idx=21 type=5
options ivtv debug=1 ivtv_pal=1 tuner=5
options tuner pal=1 type=5
options saa7127 enable_output=1 output_select=0 pal=1
options msp3400 once=1 simple=1
add below ivtv msp3400 saa7115 saa7127 tuner
# add above ivtv lirc_dev lirc_i2c
# add above ivtv ivtv-fb
post-install ivtv /usr/local/bin/test_ioctl -d /dev/video0 -u 0xff

lirc is not functioning now, so that has to be done later on.

[ 1 comment ] ( 244 views )   |  permalink  |  related link  |   ( 3 / 858 )

Back Next