Note: This is a public test instance of Red Hat Bugzilla. The data contained within is a snapshot of the live data so any changes you make will not be reflected in the production Bugzilla. Email is disabled so feel free to test any aspect of the site that you want. File any problems you find or give feedback at bugzilla.redhat.com.
Bug 117186 - Open office has lost read access to odbc DB
Summary: Open office has lost read access to odbc DB
Keywords:
Status: CLOSED WORKSFORME
Alias: None
Product: Fedora
Classification: Fedora
Component: openoffice.org
Version: rawhide
Hardware: All
OS: Linux
medium
medium
Target Milestone: ---
Assignee: Caolan McNamara
QA Contact:
URL:
Whiteboard:
: 117190 (view as bug list)
Depends On:
Blocks: FC2Target FC3Target FC4Target
TreeView+ depends on / blocked
 
Reported: 2004-03-01 13:14 UTC by Need Real Name
Modified: 2007-11-30 22:10 UTC (History)
0 users

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2004-12-09 12:45:34 UTC
Type: ---
Embargoed:

Attachments (Terms of Use)

Description Need Real Name 2004-03-01 13:14:16 UTC 
Description of problem:
When I installed FC2 test1 odbc access to Postgresql worked properly
ie: write access. Now for some reason only read access is allowed.

This seemed to happen after I did a query via odbc
Comment 1 Need Real Name 2004-03-01 13:53:48 UTC 
Further info

I have tested the Database/odbc driver with excel/access and
everything works fine.
Comment 2 Dan Williams 2004-03-01 16:09:00 UTC 
*** Bug 117190 has been marked as a duplicate of this bug. ***
Comment 3 Caolan McNamara 2004-10-28 12:18:27 UTC 
caolanm->mike.uk: 
What's your unixODBC rpm version ? Can you try with a unixODBC >= 2.2.8 ?
Comment 4 Caolan McNamara 2004-12-09 12:44:51 UTC 
openoffice.org-1.1.2-11.5.fc3
unixODBC-2.2.10-1
postgresql-7.4.6-1.FC3.1

> su - postgres
> createuser
Enter name of user to add: cmc
Shall the new user be allowed to create databases? (y/n) y
Shall the new user be allowed to create more new users? (y/n) y
CREATE USER
> exit
> su - cmc
> createdb
CREATE DATABASE
> su 
cat > /etc/odbc.ini
[PostgreSQL-test]
Description = Postgres database test
ReadOnly = 0
Servername = localhost
Database = cmc
Port = 5432
Driver = PostgreSQL
Protocol = 7.4.6
UserName = cmc
Password =
^D
> exit
> oowriter &
tools->data sources
new data source, database type ODBC, select PostgreSQL-test
successfully add a table with some random column types
can view and edit database
create a simple query, can run it and can still edit afterwards
exit oowriter, restart, still ok

I suspect that it might have been a problem with unixODBC, I can't
reproduce a similiar problem on FC-3. Though if theres another way to
reproduce this, feel free to reopen.
Note You need to log in before you can comment on or make changes to this bug.