First use: OpenEdge need to export CVS or SQL

R

rootinshell

New Member
Hello
it's my first experience with OpenEdge ODBC. the company where i work has finished using an application ( application client software expired licence ) using an OpenEdge server. we need to export all our data saved to this databse, ( names, Number, phones ..etc )

i'm not the one who have configured this server, or the application. i dont have any infomations about the database name or even the password, the server is running an RHEL on a poweredge box.

would you please guide me to export our data to an exploitable file.

i've tried to found some information about the odbc server. i got an file here's the code :

odbc.ini
Code: 
[ODBC Data Sources]
XA_Oracle8=DataDirect 410 Oracle 8 Driver
XA_SybaseTDS=DataDirect 410 Sybase TDS Driver

[OpenEdge]
[Progress_V100A]
QEWSD=38657
;Driver=/common/custom/progress/QA/linux/lib/ivoe1021.so
Driver=/common/custom/progress/drops/linux/lib/pgoe1021.so
LogonID=odbc01
Password=odbc01
;LogonID=odbc
;Password=odbc
;HostName=nc-jruss
HostName=10.30.12.85
;HostName=172.16.7.181
;PortNumber=2807
;PortNumber=2808
PortNumber=3000
;PortNumber=9144
;DatabaseName=jdbc
;DatabaseName=odbc
DatabaseName=odbc01
;Database=jdbc

[XA_Oracle80]
Driver=/var/mqm/odbc/lib/ivora00.so
Description=Oracle
ServerName=ncapachecp178
LogonID=test28
Password=test28
CatalogOptions=0
ProcedureRetResults=0
EnableDescribeParam=1
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
DefaultLongDataBuffLen=2048

[XA_Oracle8]
;Driver=/var/mqm/odbc/lib/ddora20.so
;Driver=/home/users/mattd/odbc/lib/ddora20.so
;Driver=/common/mattd/500mq.sol64/lib/ddora20.so
Driver=/var/mqm/exits64/ddora20.so
;Driver=/var/mqm/exits64/ddora00.so
;Driver=/common/mattd/500mq.sol64/lib/ddora20.so
Description=Oracle8
;HostName=nc-mdomencic
;PortNumber=8888
;Sid=CP31
;Sid=CP871
HostName=nc-linuxdb3
PortNumber=1521
Sid=CP31
CatalogOptions=0
ProcedureRetResults=0
;EnableDescribeParam=0
EnableDescribeParam=1
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
;ServerName=linuxdb3cp31
LogonID=test21
Password=test21

[olXA_Oracle8]
QEWSD=38389
;Driver=/var/mqm/odbc/lib/ddora20.so
;Driver=/home/users/mattd/odbc/lib/ddora20.so
Driver=/common/mattd/500mq.sol64/lib/ddora20.so
Description=Oracle8
;HostName=ncapache
HostName=nc-linuxdb3
PortNumber=1521
;SID=CP178
SID=CP31
CatalogOptions=0
ProcedureRetResults=0
EnableDescribeParam=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
;ServerName=ncapachetest
ServerName=linuxdb3cp31
LogonID=test21
Password=test21

[XA_SybaseTDS]
QEWSD=38437
;Driver=/home/users/mattd/odbc/lib/UKase20.so
;Driver=/home/users/mattd/odbc/lib/ddase20.so
Driver=/common/mattd/500mq.sol64/lib/ddase20.so
NetworkAddress=nc-devaix,4100
Database=test
LogonID=test01
Password=test01
ApplicationUsingThreads=1
EnableDescribeParam=1
EnableQuotedIdentifiers=0
OptimizePrepare=1
RaiseErrorPositionBehavior=0
SelectMethod=0
DefaultLongDataBuffLen=2048
TruncateTimeTypeFractions=0
PasswordEncryption=0
ReportCodePageConversionErrors=0
LoadBalancing=0
ConnectionRetryCount=0
ConnectionRetryDelay=3
AlternateServers=

[SybaseTDS]
Driver=/var/mqm/odbc410/lib/ivase18.so
Description=Sybase11
Database=
NetworkAddress=pilot,4100
LogonID=test01
Password=test01
EnableDescribeParam=1
OptimizePrepare=2
SelectMethod=1

[ODBC]
Trace=0
TraceFile=odbctrace.out
TraceDll=/var/mqm/odbc/lib/odbctrac.so
;InstallDir=/home/users/mattd/odbc
;InstallDir=/common/custom/QA.510
;InstallDir=/common/custom/progress/QA/linux
InstallDir=/common/custom/progress/QA/drop/progress
;InstallDir=/home/users/is/server/SolarisQA64/QA.500
;InstallDir=/var/mqm/odbcs

[Default]
Database=test
LogonId=odbc01
ServerName=narwhalTEST
Driver=/common/custom/progress/QA/linux/lib/ivoe1021.so

and

Code: 
OpenEdge Release 10.1A0230  as of Fri Aug 24 12:32:11 EDT 2007

on my local hard drive i've copied some .d1 file it's about 130 MB :) and some .db and .lg files ..

i dont have ny knowledge on openedge. but i'm very familiar with unix and mysql..

thank you
 
Copying the files to another server won't help you unless that other server has Progress installed on it with an appropriate license.

It is unusual for the db license to "expire". That generally only applies to evaluation licenses and certain development kits. Not production databases. Try the "showcfg" command on the original server. It will work even if the license has expired. The output will tell us what sort of licenses are on that server and might help determine how you can extract the data. Generally speaking ODBC is going to be a fairly painful way to go about it.
 
hello,
thank you for the replay.

isnt the server who has expired, it's only a client programme devlopped by another company for a specifique use, that programme who permit to access data and commit entries.. in other way. my client softawre are locked but all the data still on the openedge server.

anyway. i'm still fighting :D

i'm on pro -p dict.p still trying to export data to an exploitable file. that can be possible ?

thanks again ( sorry for my english)
 
If the db server is still functional then yes, running the dictionary routines on the server is probably the simplest way to extract the data.

Admin -> Export Data -> Text
 
You must log in or register to reply here.
Back
Top