web-erp-developers

[Web-erp-developers] Porting to postgres

[Jake S. <ns...@us...>]

HI,

I am one of the lead developers working for a groupware/CRM system called
Enterprise Groupware System (EGS) - http://egs.sourceforge.net. We have come
across web-erp and are very interesting in porting/including it in our GPL'd
system.

I have emailed Phil already and he has pointed me in the direction of Danie
who is working on a port to postgresql. I was interested in the progress of
the port and would interested in helping out if there is still work to be
done.

Many Thanks

Jake

Re: [Web-erp-developers] Porting to postgres

[Phil D. <ph...@du...>]

Jake,

These are the files that Danie has submitted (sent to your sourceforge email 
address) - the issue is there may be some areas that don't quite work yet!! 
Danie was working through them.

The script MYSQL2PGSQL.py is a python script to convert the current Mysql db 
dump to a pg sql dump. web-erp.psql is the output of a previous version 2.8 I 
think db. The script ConnectDB.pg.inc should replace the 
includes/ConnectDB.inc script for the pg db calls.

Phil

Re: [Web-erp-developers] Porting to postgres

[Jake S. <ns...@us...>]

Thanks for the files, I am have hit a couple of issues so far.

Firstly, how have people gotten around the issue of quoting strings? I
cannot even connect at present since the query:

SELECT FullAccess, CustomerID, LastVisitDate, PageSize, DefaultLocation,
BranchCode, ModulesAllowed, Blocked FROM WWW_Users WHERE UserID="demo" AND
Password="weberp"

Should be:

 SELECT FullAccess, CustomerID, LastVisitDate, PageSize, DefaultLocation,
BranchCode, ModulesAllowed, Blocked FROM WWW_Users WHERE UserID='demo' AND
Password='weberp'

For postgresql and so fails.

I also believe there is a bug in the connect file which means that if you
use a username/password to connect to postgres then it will not work:

The code starting at line 12-18 should read (notice the 'db' added so that
$user becomes $dbuser as in the config.php file):

if ( isset( $dbuser ) && ($dbuser != "") ) {
// if we have a user we need to use password if supplied
        $PgConnStr .= " user=".$dbuser;
        if ( isset( $dbpassword ) && ($dbpassword != "") ) {
                $PgConnStr .= " password=".$dbpassword;
        }
}

Thanks

Jake

On 24/5/04 11:58, "Phil Daintree" <ph...@du...> wrote:

> Jake,
> 
> These are the files that Danie has submitted (sent to your sourceforge email
> address) - the issue is there may be some areas that don't quite work yet!!
> Danie was working through them.
> 
> The script MYSQL2PGSQL.py is a python script to convert the current Mysql db
> dump to a pg sql dump. web-erp.psql is the output of a previous version 2.8 I
> think db. The script ConnectDB.pg.inc should replace the
> includes/ConnectDB.inc script for the pg db calls.
> 
> Phil
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by: Oracle 10g
> Get certified on the hottest thing ever to hit the market... Oracle 10g.
> Take an Oracle 10g class now, and we'll give you the exam FREE.
> http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>