Bug 117186

Summary: Open office has lost read access to odbc DB
Product: [Fedora] Fedora Reporter: Need Real Name <mike>
Component: openoffice.orgAssignee: Caolan McNamara <caolanm>
Status: CLOSED WORKSFORME QA Contact:
Severity: medium Docs Contact:
Priority: medium    
Version: rawhide   
Target Milestone: ---   
Target Release: ---   
Hardware: All   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2004-12-09 12:45:34 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Bug Depends On:    
Bug Blocks: 114963, 123268, 136451    

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@bristolreccc.co.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.