[OFBiz] Users - Problems upgrading to latest svn...

[Ian Gilbert]

Hi all,

I'm trying to upgrade our installation to the latest svn to develop a plan
to do this when a stable release is made and to facilitate testing by some
of our guys in the meantime to make that release as stable as possible.

Although there have been a huge number of changes in the last year (when I
did the last upgrade) I think that the majority of these shouldn't affect
the upgrade.  I wrote a script last year which detailed which files I had
changed to get that instance running ok and have copied these files
across.

When I run the startup script I am getting what looks like a database
error but I'm at a loss to know what this might be.  I used to use a file
called 'fieldtypepostgres72.xml' which is no longer used and so I've
changed my references in 'entityengine.xml' to point to the
'fieldtypepostgres' file instead.  I've changed the pg_hba.conf file and
postgresql.conf files in postgres to allow incoming connections in line
with the previous build and have modified my previous
'ofbiz-containers.xml' and 'component-load.xml' files to represent the
current environment.  In fact in both cases I have retained the new files
instead of copying over my previous ones.

I've attached the ofbiz.log file that has been generated (it's a zip file
called log.zip attached to this mail - please let me know if this is
unsuitable or innappropriate) and this definitely points repeatedly to a
problem with the database.  I've been looking at this for some time and
would greatly appreciate someone else's opinion if anyone has time as I'm
clearly missing something and I suspect that this will not be the last
issue that I have with this upgrade :)

Thanks and very best wishes

Ian Gilbert
 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users

[Si Chen-2]

Ian,

fiedtypepostgres72.xml has been replaced to fieldtypepostgresql.xml, so
you did the right thing.

I'm looking at your log file right now.  It's not authenticating your
user.  I'm not sure why that is.  Maybe, but this is just a guess,
postgresql doesn't like you trying to connect in using this username?  
(Generally, I don't think you should not be using the "postgres" user to
access the database under the "ident sameuser" scheme.  You should use
"createuser -W <username>" to create a user, then add that user to your
pg_hba.conf under a "password" identifcation.)

We'll be upgrading the next two weeks to a newer version of OFBiz, so
I'll keep everybody posted on what we're doing, and we can try to help
each other out.

Si

Ian Gilbert wrote:

>Hi all,
>
>I'm trying to upgrade our installation to the latest svn to develop a plan
>to do this when a stable release is made and to facilitate testing by some
>of our guys in the meantime to make that release as stable as possible.
>
>Although there have been a huge number of changes in the last year (when I
>did the last upgrade) I think that the majority of these shouldn't affect
>the upgrade.  I wrote a script last year which detailed which files I had
>changed to get that instance running ok and have copied these files
>across.
>
>When I run the startup script I am getting what looks like a database
>error but I'm at a loss to know what this might be.  I used to use a file
>called 'fieldtypepostgres72.xml' which is no longer used and so I've
>changed my references in 'entityengine.xml' to point to the
>'fieldtypepostgres' file instead.  I've changed the pg_hba.conf file and
>postgresql.conf files in postgres to allow incoming connections in line
>with the previous build and have modified my previous
>'ofbiz-containers.xml' and 'component-load.xml' files to represent the
>current environment.  In fact in both cases I have retained the new files
>instead of copying over my previous ones.
>
>I've attached the ofbiz.log file that has been generated (it's a zip file
>called log.zip attached to this mail - please let me know if this is
>unsuitable or innappropriate) and this definitely points repeatedly to a
>problem with the database.  I've been looking at this for some time and
>would greatly appreciate someone else's opinion if anyone has time as I'm
>clearly missing something and I suspect that this will not be the last
>issue that I have with this upgrade :)
>
>Thanks and very best wishes
>
>Ian Gilbert
>
>------------------------------------------------------------------------
>
>
>_______________________________________________
>Users mailing list
>[hidden email]
>http://lists.ofbiz.org/mailman/listinfo/users
>

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users

[Ian Gilbert]

:)

Thanks very much indeed for that Si.  It resolved that problem nicely.
I've got some more now but I'll get onto those one at a time.

I will also log my experiences with this and publish to the list once
complete.  My previous build was based on a cvs from just over a year ago
(will try and work out exact date) so it should be useful to those with
installs of about that age.  That build in turn was an upgrade to one
about a year previously.  Each one is getting easier and easier (he says
hopefully).

Thanks again.  It has *really* helped me out.

Very best wishes

Ian

On Fri, August 12, 2005 9:18 pm, Si Chen wrote:

> Ian,
>
>
> fiedtypepostgres72.xml has been replaced to fieldtypepostgresql.xml, so
> you did the right thing.
>
> I'm looking at your log file right now.  It's not authenticating your
> user.  I'm not sure why that is.  Maybe, but this is just a guess,
> postgresql doesn't like you trying to connect in using this username?
> (Generally, I don't think you should not be using the "postgres" user to
> access the database under the "ident sameuser" scheme.  You should use
> "createuser -W <username>" to create a user, then add that user to your
> pg_hba.conf under a "password" identifcation.)
>
> We'll be upgrading the next two weeks to a newer version of OFBiz, so
> I'll keep everybody posted on what we're doing, and we can try to help
> each other out.
>
> Si
>
>
> Ian Gilbert wrote:
>
>
>> Hi all,
>>
>>
>> I'm trying to upgrade our installation to the latest svn to develop a
>> plan to do this when a stable release is made and to facilitate testing
>> by some of our guys in the meantime to make that release as stable as
>> possible.
>>
>> Although there have been a huge number of changes in the last year
>> (when I
>> did the last upgrade) I think that the majority of these shouldn't
>> affect the upgrade.  I wrote a script last year which detailed which
>> files I had changed to get that instance running ok and have copied
>> these files across.
>>
>> When I run the startup script I am getting what looks like a database
>> error but I'm at a loss to know what this might be.  I used to use a
>> file called 'fieldtypepostgres72.xml' which is no longer used and so
>> I've
>> changed my references in 'entityengine.xml' to point to the
>> 'fieldtypepostgres' file instead.  I've changed the pg_hba.conf file
>> and postgresql.conf files in postgres to allow incoming connections in
>> line with the previous build and have modified my previous
>> 'ofbiz-containers.xml' and 'component-load.xml' files to represent the
>> current environment.  In fact in both cases I have retained the new
>> files instead of copying over my previous ones.
>>
>> I've attached the ofbiz.log file that has been generated (it's a zip
>> file called log.zip attached to this mail - please let me know if this
>> is unsuitable or innappropriate) and this definitely points repeatedly
>> to a problem with the database.  I've been looking at this for some time
>> and would greatly appreciate someone else's opinion if anyone has time
>> as I'm clearly missing something and I suspect that this will not be the
>> last issue that I have with this upgrade :)
>>
>> Thanks and very best wishes
>>
>>
>> Ian Gilbert
>>
>>
>> -----------------------------------------------------------------------
>> -
>>
>>
>>
>> _______________________________________________
>> Users mailing list
>> [hidden email]
>> http://lists.ofbiz.org/mailman/listinfo/users
>>
>>
>
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/users
>
>

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users

[Si Chen-2]

Wow.  That was the answer?  Happy to hear it...

Have a great weekend.  Let us know how the upgrade goes.  We'll be doing
the same in the next couple of weeks.

Si

Ian Gilbert wrote:

>:)
>
>Thanks very much indeed for that Si.  It resolved that problem nicely.
>I've got some more now but I'll get onto those one at a time.
>
>I will also log my experiences with this and publish to the list once
>complete.  My previous build was based on a cvs from just over a year ago
>(will try and work out exact date) so it should be useful to those with
>installs of about that age.  That build in turn was an upgrade to one
>about a year previously.  Each one is getting easier and easier (he says
>hopefully).
>
>Thanks again.  It has *really* helped me out.
>
>Very best wishes
>
>Ian
>
>On Fri, August 12, 2005 9:18 pm, Si Chen wrote:
>  
>
>>Ian,
>>
>>
>>fiedtypepostgres72.xml has been replaced to fieldtypepostgresql.xml, so
>>you did the right thing.
>>
>>I'm looking at your log file right now.  It's not authenticating your
>>user.  I'm not sure why that is.  Maybe, but this is just a guess,
>>postgresql doesn't like you trying to connect in using this username?
>>(Generally, I don't think you should not be using the "postgres" user to
>>access the database under the "ident sameuser" scheme.  You should use
>>"createuser -W <username>" to create a user, then add that user to your
>>pg_hba.conf under a "password" identifcation.)
>>
>>We'll be upgrading the next two weeks to a newer version of OFBiz, so
>>I'll keep everybody posted on what we're doing, and we can try to help
>>each other out.
>>
>>Si
>>
>>
>>Ian Gilbert wrote:
>>
>>
>>    
>>
>>>Hi all,
>>>
>>>
>>>I'm trying to upgrade our installation to the latest svn to develop a
>>>plan to do this when a stable release is made and to facilitate testing
>>>by some of our guys in the meantime to make that release as stable as
>>>possible.
>>>
>>>Although there have been a huge number of changes in the last year
>>>(when I
>>>did the last upgrade) I think that the majority of these shouldn't
>>>affect the upgrade.  I wrote a script last year which detailed which
>>>files I had changed to get that instance running ok and have copied
>>>these files across.
>>>
>>>When I run the startup script I am getting what looks like a database
>>>error but I'm at a loss to know what this might be.  I used to use a
>>>file called 'fieldtypepostgres72.xml' which is no longer used and so
>>>I've
>>>changed my references in 'entityengine.xml' to point to the
>>>'fieldtypepostgres' file instead.  I've changed the pg_hba.conf file
>>>and postgresql.conf files in postgres to allow incoming connections in
>>>line with the previous build and have modified my previous
>>>'ofbiz-containers.xml' and 'component-load.xml' files to represent the
>>>current environment.  In fact in both cases I have retained the new
>>>files instead of copying over my previous ones.
>>>
>>>I've attached the ofbiz.log file that has been generated (it's a zip
>>>file called log.zip attached to this mail - please let me know if this
>>>is unsuitable or innappropriate) and this definitely points repeatedly
>>>to a problem with the database.  I've been looking at this for some time
>>>and would greatly appreciate someone else's opinion if anyone has time
>>>as I'm clearly missing something and I suspect that this will not be the
>>>last issue that I have with this upgrade :)
>>>
>>>Thanks and very best wishes
>>>
>>>
>>>Ian Gilbert
>>>
>>>
>>>-----------------------------------------------------------------------
>>>-
>>>
>>>
>>>
>>>_______________________________________________
>>>Users mailing list
>>>[hidden email]
>>>http://lists.ofbiz.org/mailman/listinfo/users
>>>
>>>
>>>      
>>>
>>_______________________________________________
>>Users mailing list
>>[hidden email]
>>http://lists.ofbiz.org/mailman/listinfo/users
>>
>>
>>    
>>
>
>
>
>_______________________________________________
>Users mailing list
>[hidden email]
>http://lists.ofbiz.org/mailman/listinfo/users
>
>  
>

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users

[Si Chen-2]

Ian,

If you can wait about a week we can do the upgrade together.  My old
version is from about the same date.  Also we're working on a few new
features in the next few days which will affect the way the order and
invoice data is laid out
(http://jira.undersunconsulting.com/browse/OFBIZ-439).  So it might pay
just to wait a little bit...

Si

Ian Gilbert wrote:

>:)
>
>Thanks very much indeed for that Si.  It resolved that problem nicely.
>I've got some more now but I'll get onto those one at a time.
>
>I will also log my experiences with this and publish to the list once
>complete.  My previous build was based on a cvs from just over a year ago
>(will try and work out exact date) so it should be useful to those with
>installs of about that age.  That build in turn was an upgrade to one
>about a year previously.  Each one is getting easier and easier (he says
>hopefully).
>
>Thanks again.  It has *really* helped me out.
>
>Very best wishes
>
>Ian
>
>On Fri, August 12, 2005 9:18 pm, Si Chen wrote:
>  
>
>>Ian,
>>
>>
>>fiedtypepostgres72.xml has been replaced to fieldtypepostgresql.xml, so
>>you did the right thing.
>>
>>I'm looking at your log file right now.  It's not authenticating your
>>user.  I'm not sure why that is.  Maybe, but this is just a guess,
>>postgresql doesn't like you trying to connect in using this username?
>>(Generally, I don't think you should not be using the "postgres" user to
>>access the database under the "ident sameuser" scheme.  You should use
>>"createuser -W <username>" to create a user, then add that user to your
>>pg_hba.conf under a "password" identifcation.)
>>
>>We'll be upgrading the next two weeks to a newer version of OFBiz, so
>>I'll keep everybody posted on what we're doing, and we can try to help
>>each other out.
>>
>>Si
>>
>>
>>Ian Gilbert wrote:
>>
>>
>>    
>>
>>>Hi all,
>>>
>>>
>>>I'm trying to upgrade our installation to the latest svn to develop a
>>>plan to do this when a stable release is made and to facilitate testing
>>>by some of our guys in the meantime to make that release as stable as
>>>possible.
>>>
>>>Although there have been a huge number of changes in the last year
>>>(when I
>>>did the last upgrade) I think that the majority of these shouldn't
>>>affect the upgrade.  I wrote a script last year which detailed which
>>>files I had changed to get that instance running ok and have copied
>>>these files across.
>>>
>>>When I run the startup script I am getting what looks like a database
>>>error but I'm at a loss to know what this might be.  I used to use a
>>>file called 'fieldtypepostgres72.xml' which is no longer used and so
>>>I've
>>>changed my references in 'entityengine.xml' to point to the
>>>'fieldtypepostgres' file instead.  I've changed the pg_hba.conf file
>>>and postgresql.conf files in postgres to allow incoming connections in
>>>line with the previous build and have modified my previous
>>>'ofbiz-containers.xml' and 'component-load.xml' files to represent the
>>>current environment.  In fact in both cases I have retained the new
>>>files instead of copying over my previous ones.
>>>
>>>I've attached the ofbiz.log file that has been generated (it's a zip
>>>file called log.zip attached to this mail - please let me know if this
>>>is unsuitable or innappropriate) and this definitely points repeatedly
>>>to a problem with the database.  I've been looking at this for some time
>>>and would greatly appreciate someone else's opinion if anyone has time
>>>as I'm clearly missing something and I suspect that this will not be the
>>>last issue that I have with this upgrade :)
>>>
>>>Thanks and very best wishes
>>>
>>>
>>>Ian Gilbert
>>>
>>>
>>>-----------------------------------------------------------------------
>>>-
>>>
>>>
>>>
>>>_______________________________________________
>>>Users mailing list
>>>[hidden email]
>>>http://lists.ofbiz.org/mailman/listinfo/users
>>>
>>>
>>>      
>>>
>>_______________________________________________
>>Users mailing list
>>[hidden email]
>>http://lists.ofbiz.org/mailman/listinfo/users
>>
>>
>>    
>>
>
>
>
>_______________________________________________
>Users mailing list
>[hidden email]
>http://lists.ofbiz.org/mailman/listinfo/users
>
>  
>

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users