Re: was database too old or corrupt error on debian ever solved
"Markus Hoenicka" <[email protected]>
| Newsgroups | gmane.text.refdb.general |
|---|---|
| Message-ID | <[email protected]> |
Hi Dan, Markus Hoenicka writes: > > Finally, I wonder if supplying values for dbase and username in the > > config files is really wise, especially in the case of the dbase > > username (nobody is likely to use Joe User, so this can ONLY cause > > trouble), and probably in the case of SqlLite, since many people will > > want to use either MySql or PostGres. > > > > This is basically a good point. The clients are written to > use the login name as a fallback if no database user name is > supplied. I'll change the config files accordingly. > I checked the config file examples, and none of them defines a database username, so all should be well. Where did you take "Joe User" from? Is that something you typed off the manual? BTW the reason to pick SQLite as a default was to allow the easiest possible package installation using precompiled binaries. RefDB needs at least one database engine to start with, and SQLite is small and requires no administration. That is, with some script magic a *BSD or Linux package builder can package RefDB in a way that it is ready to run right after installation. Setting up the refdb database in MySQL or PostgreSQL.requires knowledge of the database admin password, and in the case of PostgreSQL it may require running commands from the postgres user account. This is far harder to do from a run-of-the-mill installation script. Therefore David (the now-gone Debian package builder) convinced me to use SQLite as a default in the tarball too. You just have to provide the proper switch to the ./configure script to use a different engine. That script even prints your choice at the end of the output to make sure you notice what it did. It's just hard to find a way to make users aware of the configure switch in time. regards, Markus -- Markus Hoenicka [email protected] (Spam-protected email: replace the quadrupeds with "mhoenicka") http://www.mhoenicka.de ------------------------------------------------------- All the advantages of Linux Managed Hosting--Without the Cost and Risk! Fully trained technicians. The highest number of Red Hat certifications in the hosting industry. Fanatical Support. Click to learn more http://sel.as-us.falkag.net/sel?cmd=lnk&kid=107521&bid=248729&dat=121642