help connecting to progress and dumping tables

jumbosafari

New Member
hi. i'm in need of some assistance.
as well, i'm a newb to progress.

specs:
progress 9.1c
mysql 5 (not installed on linux system)
linux redhat (no gui)

i would like to dump a progress db to mysql, any ideas?
there is a problem, i don't have a login or password to the progress db.

i currently have the progress db 9.1c installed on a redhat machine.
i'm looking for a way to end up with a csv or sql dump.

is it possible to get into the progress db admin tool without login creds?

as well i have access to all files of the entire linux filesystem.
i do have root access to the redhat linux installation

possibly this can achieved from the command line using a progress db command?

showcfg returned:

product name: workgroup db
user limit: 15
serial num: 003335765
control numbers: sffff-sdfds-sdfsf
version number: 9.1c
machine class: kb
port number: 38

result for :
$DLC/bin/pro databasename
--this version of progress requires a start up procedure.(495)

result for :
$DLC/bin/mpro databasename
--error. there is no server for database.(1423)

sometimes i also get another error.
--standard input and output are on different terminals. (360)

any ideas?

any help would be much appreciated.
thanks.
 

comatt1

Member
are you using the fully qualified name of the database to start the db?

try just <prompt> (if $DLC is pathed), pro -db /dir/dbname or _progres /dir/dbname

you can use mpro if you are running it command line (with a procedure).

if you want to dump data (while the db is up). you can use

mpro -db /dir/dbname -p dump_d ("ALL","<dest dir>","")

make sure you $DLC path is setup..

i would like to dump a progress db to mysql, any ideas?
there is a problem, i don't have a login or password to the progress db.

--- depending on your setup, it is possible to get into the db without issue or a valid user.

i currently have the progress db 9.1c installed on a redhat machine.
i'm looking for a way to end up with a csv or sql dump.

--- you can dump data into a csv, I have never worked with sequel (I do remember that 9.1C was buggy, but don't recall if the bugs were pertinent to your situation) - you can just import into excel (unless you are an apt programmer)
 

jumbosafari

New Member
thanks for the help.
using mpro /db_path -p _dict -rx
i'm able to get into the admin tool however "export data" and inside "dump data and defs" "tbale contents" are disabled.

i tried using the dump_d command however i got an syntax error:
unexpected token near "("

any ideas?
i would much prefer to just use the admin tool if possible.
 

comatt1

Member
you need to run it in a progress editor

RUN prodict/dump_df.p ("ALL","/backup/db.df","") is how I use it - added this with a .p that is called from a script

forgot to mention
 

jumbosafari

New Member
so i got into the edit using _edit.p
and typed

RUN prodict dump ("ALL","<dest dir>","")

and again

RUN prodict/dump_df.p ("ALL","/mydir","")

however i got a message:
this version of progress compiles only encrypted programs. (1086)
 

comatt1

Member
Tom can probably answer better than I can,

you could always extract the prodict lib in $DLC/src/

prolib -extract <lib> or extractpl <lib>

you will get another directory called prodict in $DLC/src/

I forgot that I extracted the pl, and the thing I mentioned before gives the relative path to the procedure.
 

comatt1

Member
whoops

prolib prodict.pl -extract

remember to setup your $DLC

if you have $DLC/src/extractpl

just use

extractpl prodict.pl
 

jumbosafari

New Member
so i did
prolib prodict.pl -extract
and
extractpl prodict.pl
and it worked fine.

however when i tried to run

RUN prodict/dump_df.p ("ALL","/mydir","")

i still got the message:
this version of progress compiles only encrypted programs. (1086)
 

comatt1

Member
Most likely you dont own the source to the application that runs on your database. The vendor may give you a document with the database info, however, I have never worked with apps where the souce wasnt purchased.

Sorry

Did you attempt naming both the directory (mydir) along with the output name of the df file

/mydir/db.df

?
 

comatt1

Member
I would ask Tom Bascom, but I recall on the peg, there was someone who did write a program to decrypt Progress code. However, I don't know if this if just for compiled programs or the database itself...

I thought it was George Potemkin.
 

jumbosafari

New Member
i appreciate the effort.
can you think of some other way to get the data out as a csv or sql dump?

i was able to export the table structure as "create table" queries from within the admin tool, only thing missing now is the data.....
 

comatt1

Member
I would pass this to someone else, I do more DBA work, programming isnt my thing.

There are others that could be much more helpful, maybe pass this to the peg or something.

Several people on here could definately help you too.

Sorry I cant help more
 

TomBascom

Curmudgeon
You're going to be banging your head against walls endlessly until:

1) You get some training.

and

2) You get a development license to work with.

You might overcome the lack of one or the other by posting lots of questions but trying to go from a cold start to mastery of both conditions is going to be a challenge.

Do you have a set of manuals or the electronic documentation available? Have you found the online manuals on PSDN yet?

Yes, there are (usually) ways to dump the data without a development license. You could, for instance, do a binary dump using proutil. Or you could get someone else to compile a program for you that extracts the data with dynamic queries (there might even be such a thing posted somewhere here -- I vaguely recall it...).

BTW -- 9.1c is ancient and unsupported. It's frequently associated with old, orphaned Symix sites. If that's what you're trying to understand you would probably be better off asking specific questions in the Symix Syteline forum. If it is some other vendor's product they may also have a forum.

If your real problem is needing to get the data out of Progress and into MySQL because you're converting systems you'd be better off being up-front about it and hiring a consultant to help you out.
 
Top