Jimmy's weblog

8/12/2004

Onboard RAID Controller

Filed under: — jimmy @ 7:20 pm

I have a Gigabyte GA-7N400 Pro motherboard(nforce2) which has a raid controller onboard. I do not need the raid functionality but I wanted to know if I can use the IDE ports.
Here’s the output of lspci:

RAID bus controller: Integrated Technology Express, Inc. IT/ITE8212
Dual channel ATA RAID controller (PCI version seems to be IT8212, embedded seems (rev 10)
Subsystem: Integrated Technology Express, Inc.: Unknown device 0001
Flags: bus master, 66MHz, medium devsel, latency 0, IRQ 11
I/O ports at 8010 [size=8]
I/O ports at 8400 [size=4]
I/O ports at 8810 [size=8]
I/O ports at 8c00 [size=4]
I/O ports at 9000 [size=16]
Capabilities: [80] Power Management version 2

The driver for the ITE8212 controller is not part of the linux kernel so I had to google. This article was very helpful.
Basically you have to:

  • Enable the controller in the BIOS :-)
  • Get the driver source from the manufacturer.
  • Copy the source into your kernel source directory and compile the module.

The last step is a little bit tricky. My solution was to make a new Makefile for the iteraid driver and to include this Makefile in the Makefile of the kernel. So I copied the driver source to /usr/src/linux/drivers/scsi and made a Makefile called iteraid:

EXTRA_FLAGS += -I.
EXTRA_FLAGS += -Wno-cast-qual -Wno-strict-prototypes
obj-m += iteraid.o
iteraid-obj := iteraid.o

Then I appended the following line to the Makefile(at the beginning) of the scsi directory:

# Added for iteRAID
# Without absolute path it did NOT work
include /usr/src/linux/drivers/scsi/iteraid

Now I was able to compile the module. The only test I’ve done was with one harddisc connected:

kernel: scsi0 : ITE RAIDExpress133
kernel:   Vendor: ITE       Model: IT8212F           Rev: 1.3
kernel:   Type:   Direct-Access                      ANSI SCSI revision: 00
kernel: SCSI device sda: 488397168 512-byte hdwr sectors (250059 MB)
kernel: sda: asking for cache data failed
kernel: sda: assuming drive cache: write through
kernel:  sda: sda1
kernel: Attached scsi disk sda at scsi0, channel 0, id 2, lun 0

Openoffice and MySQL

Filed under: — jimmy @ 1:25 pm

When using Openoffice and mysql together there a few things to notice:

  • Mysql needs to be configured to use networking. Most distributions setup mysql to skip networking for security reasons. When enabling it again you should secure your server with other methods, like iptables.
  • You need the unixODBC driver and have to populate /etc/odbc.ini. Otherwise openoffice will claim that it has problems with the odbc libs. Details can be found here.

Now it should be possible to use openoffice and mysql together, as described here.

Openoffice: forms and database access

Filed under: — jimmy @ 12:19 pm

Yesterday I was looking for a replacement for MS Access. I found knoda and kexi. I didn’t test knoda, since there was no debian package available. Kexi looks nice but there is no documentation, AFAIK.
Finally I found out that openoffice has support for databases. Take a look at the homepage of the Database Access Project. There’s also a list of external resources, describing how to get started.
After some reading I started to use a flatfile database for contacts. It worked fine except one bug in the current openoffice debian package(only when using german translation) that makes using forms impossible. See bugreport #216647 for a workaround.