libmyodbc doesn't set up driver

[Joel Parker]

Binary package hint: libmyodbc

It seems natural that if I install libmyodbc (the MySQL ODBC driver), then the driver would be set up in /etc/odbcinst.ini so that it can be used automatically. Why doesn't this happen?

[Enrico Zini (enrico)]

Hello,

I have libmyodbc installed but it's not registered in /etc/odbcinst.ini

I noticed that /var/lib/dpkg/info/libmyodbc.postinst only registers the
driver if the user chose so in debconf. I however didn't manage to
reconfigure libmyodbc to choose to have the driver registered:

# dpkg-reconfigure libmyodbc
# dpkg-reconfigure -plow libmyodbc
#

I resorted to running manually the odbcinst line from
/var/lib/dpkg/info/libmyodbc.postinst :

  odbcinst -i -d -f /usr/share/libmyodbc/odbcinst.ini

Ciao,

Enrico

--
GPG key: 1024D/797EBFAB 2000-12-05 Enrico Zini <email address hidden>

[Joel Parker (jjkp)]

Binary package hint: libmyodbc

It seems natural that if I install libmyodbc (the MySQL ODBC driver), then the driver would be set up in /etc/odbcinst.ini so that it can be used automatically. Why doesn't this happen?

[Steve Langasek (vorlon)]

On Tue, May 25, 2004 at 02:49:30PM +0200, Martin Renold wrote:
> Package: libmyodbc
> Version: 3.51.06-1
> Severity: normal

> To get MySQL support in OpenOffice this package seems to be necessary.
> I don't know what ODBC is, I just install and it asks: "Do you want MyODBC
> to be registered as an ODBC driver?" With default to No.

> I think the default should be yes, so it will just work for most users.
> Unless you have a reason, of course.

The reason for this is that handing over control of the driver entries to
the package will result in any local changes to the entry in
/etc/odbcinst.ini being overwritten. I believe this is a policy violation,
so am not willing to enable this by default.

I've started a thread on debian-devel looking for input on this.

> Another thing, in an attempt to get asked the question again I tried:
> # dpkg-reconfigure libmyodbc
> odbcinst: Driver installed. Usage count increased to 2. Target directory is /etc
> # dpkg-reconfigure libmyodbc
> odbcinst: Driver installed. Usage count increased to 3. Target directory is /etc

This part is definitely a bug (in my reasoning when I put the packaging
together). It will be fixed in an upcoming upload.

--
Steve Langasek Give me a lever long enough and a Free OS
Debian Developer to set it on, and I can move the world.
Ubuntu Developer http://www.debian.org/
<email address hidden> <email address hidden>

[Nathan MWF (tan+mc+logic)]

ODBC appears to have a multi-file configuration that is not obvious. I believe that it could be set up to connect to the test database, just so you know that it is working.

[Rolf Leggewie (r0lf)]

In the upstream debian bug report Steve says he does not enable the driver by default on purpose. I hope we can find something better than the current situation that does not run afoul of policy.

[rusivi2 (rusivi2-deactivatedaccount)]

Thank you for taking the time to report this bug and helping to make Ubuntu better. The version of Ubuntu your using is in End of Life status. More information may be found at: https://wiki.ubuntu.com/Releases As well, the package your using is updated and issue you reported should be reproducible with the live environment of the Desktop CD development release - Maverick Meerkat. It would help us greatly if you could test with it so we can work on getting it fixed in the next release of Ubuntu. You can find more about the development release at http://www.ubuntu.com/testing/. Please repost a detailed error report and update the bug status. Thanks again and we appreciate your help.

[Rolf Leggewie (r0lf)]

nothing new in the Debian ticket and reconfirming to be still present in lucid.