RE: [Phpgroupware-developers] phpgroupware and coldsync

[Adam Hull]

Progress!

Not sure all that did but my ultimate problem was table permissions.
Despite having

local        all                                           trust
host         all         127.0.0.1     255.255.255.255     trust

in /var/lib/pgsql/data/pg_hba.conf, I had to set individual permissions for
each table. I am knew to pgsql so I didn't realize this was necessary.

Anyway, I have successfully transfered calendar, addressbook, and notes data
from phpgw into palm. However, todo did not work and nothing has moved from
palm to phpgw. I am now getting this error in the log:

cond_readstatus: <<< "301 Use of uninitialized value in addition (+) at
/usr/share/coldsync-2.2.5/conduits/addressbook-phpgroupware line 156."
Use of uninitialized value in addition (+) at
/usr/share/coldsync-2.2.5/conduits/addressbook-phpgroupware line 156.
run_conduit: got status 301
Child has printed to stdout.
cond_readline: About to select()
cond_readline: select() returned 1
cond_readstatus: <<< "301 Use of uninitialized value in string ne at
/usr/lib/perl5/site_perl/5.6.1/Palm/Address.pm line 598."
Use of uninitialized value in string ne at
/usr/lib/perl5/site_perl/5.6.1/Palm/Address.pm line 598.

Brian, I saw you discussed this on the coldsync mailing list and ultimately
changes were made to Address.pm? Well I am running p5-palm version 1.2.4. I
think that is that latest. Do you know what might be causing this?

Thanks!

Brian Johnson (address@hidden) wrote*:
>
>In the perl program, the HEADERS (phpid in braces) is a pointer to an
>array
>
>The array's name is HEADERS and phpid is one of the values in that array -
>it is defined in the conf file and it also defined at the top of the conduit
>in case it is ommitted from the conf file - that shouldn't be the sync
>problem you're experiencing - it's something else
>
>I need to play with it to double check what's happening - in the meantime,
>try the memo conduit - it's the first one I did and spent the most time on
>since it is the easiest (has the fewest fields) - therefore it is the
>easiest to debug as well
>
>
>> -----Original Message-----
>> From: address@hidden
>> [mailto:address@hidden Behalf Of Adam Hull
>> Sent: Tuesday, July 09, 2002 2:12 PM
>> To: address@hidden
>> Subject: RE: [Phpgroupware-developers] phpgroupware and coldsync
>>
>>
>> Hey!
>> It worked! using the phpgw userid successfully returned data like so:
>> SELECT e.*, p.palm_rec_id, u.cat_name FROM (palm_addressbook
>> p RIGHT JOIN
>> phpgw_addressbook e ON p.cal_id = e.id) LEFT JOIN
>> phpgw_categories u ON e.id =
>> u.cat_id WHERE e.owner = 4
>>
>> so can we replace the question mark with a proper variable?
>> could we replace it with  ? (those are braces around phpid)
>>
>> Brian Johnson (address@hidden) wrote*:
>> >
>> >Try replacing the question mark with your phpid - the
>> results should still
>> >be the same - I just wanted to make sure you didn't get any
>> errors to prove
>> >that the database tables were setup correctly
>> >
>> >I'll be a couple of days - I'm setting up my laptop with coldsync and
>> >phpgroupware so that I can trouble shoot when not at the office
>> >
>> >I hope I can get my Palm to sync via IR - I got it to work
>> under Windows
>> >
>> >
>> >
>> >> -----Original Message-----
>> >> From: address@hidden
>> >> [mailto:address@hidden Behalf Of
>> Adam Hull
>> >> Sent: Monday, July 08, 2002 7:33 PM
>> >> To: address@hidden
>> >> Subject: RE: [Phpgroupware-developers] phpgroupware and coldsync
>> >>
>> >>
>> >> I just ran this query:
>> >>
>> >> SELECT e.*, p.palm_rec_id, u.cat_name FROM (palm_addressbook
>> >> p RIGHT JOIN
>> >> phpgw_addressbook e ON p.cal_id = e.id) LEFT JOIN
>> >> phpgw_categories u ON e.id =
>> >> u.cat_id WHERE e.owner = ?
>> >>
>> >> and it returned nothing. is it because the palm_addressbook
>> >> table is empty?
>> >> But I would think that palm_addressbook requires no initial
>> >> data, right?
>> >>
>> >>
>> >> Brian Johnson (address@hidden) wrote*:
>> >> >
>> >> >Try connecting to the database with a database tool and
>> >> perform the query
>> >> >there
>> >> >
>> >> >> -----Original Message-----
>> >> >> From: address@hidden
>> >> >> [mailto:address@hidden Behalf Of
>> >> Adam Hull
>> >> >> Sent: Wednesday, July 03, 2002 4:51 PM
>> >> >> To: address@hidden; address@hidden
>> >> >> Cc: address@hidden
>> >> >> Subject: [Phpgroupware-developers] phpgroupware and coldsync
>> >> >>
>> >> >>
>> >> >> Greetings all, I am cross posting this message to the
>> >> >> coldsync-hackers and
>> >> >> phpgroupware-developers mailing lists because I am unsure
>> >> >> where my issue stems
>> >> >> from so I apologize in advance to anyone who receives
>> this twice.
>> >> >>
>> >> >> I am continuing Brian Johnson's excellent work on
>> phpgroupware palm
>> >> >> synchronization. He has successfully tested the conduits with
>> >> >> phpgw 0.9.13.018
>> >> >> (R14 release candidate 3).
>> >> >>
>> >> >> Here is my setup:
>> >> >> Mandrake 8.1
>> >> >> perl 5.6.1
>> >> >> postgres 7.1.2
>> >> >> coldsync 2.2.5
>> >> >> phpgroupware 0.9.15.002
>> >> >>
>> >> >> I am pretty sure I have installed all the necessary perl
>> >> >> modules and other
>> >> >> dependencies. I am now getting the following coldsync error
>> >> >> when I attempt
>> >> >> synching via netsync.
>> >> >>
>> >> >> 401 Error executing sql DBI::db=HASH(0x8200d88)->errstr at
>> >> >> /usr/share/coldsync-2.2.5/conduits/addressbook-phpgroupware l07
>> >> >>
>> >> >> The above error is followed by:
>> >> >> cond_readstatus: <<< "301 DBD::Pg::st execute failed:
>> >> ERROR: Relation
>> >> >> 'palm_addressbook' does not exist at
>> >> >>
>> >>
>> /usr/share/coldsync-2.2.5/conduits/addressbook-phpgroupware line 107
>> >> >> DBD::Pg::st execute failed: ERROR: Relation
>> >> >> 'palm_addressbook' does not exist
>> >> >> at
>> >> >>
>> >>
>> /usr/share/coldsync-2.2.5/conduits/addressbook-phpgroupware line 107.
>> >> >>
>> >> >> The above I believe may just be a chain reaction from the
>> >> >> failed SQL execution
>> >> >> but I am not sure.
>> >> >>
>> >> >> The line it is failing on in addressbook-phpgroupware is:
>> >> >> $sth_select_all->execute($HEADERS)
>> >> >> or die "$err_exec_sql $dbh->errstr";
>> >> >>
>> >> >> which might be failing due to this SQL statement:
>> >> >> my $sth_select_all = $dbh->prepare(
>> >> >>  "SELECT e.*, p.palm_rec_id, u.cat_name".
>> >> >>  " FROM (palm_addressbook p RIGHT JOIN phpgw_addressbook e ON
>> >> >> p.cal_id=e.id)".
>> >> >>  " LEFT JOIN phpgw_categories u ON e.id = u.cat_id".
>> >> >>  " WHERE e.owner = ?"
>> >> >> ) or die $err_prep_sql;
>> >> >>
>> >> >> But I compared the above against the phpgw tables and it
>> >> >> checks out. There
>> >> >> does not appear to be any table changes between 0.9.13 and
>> >> >> 0.9.15. And it
>> >> >> appears as though coldsync is making a connection to pgsql
>> >> >> because after
>> >> >> running coldsync and the palm finishes the sync process I do
>> >> >> a "ps aux" and I
>> >> >> can see an open postgres connection process still running.
>> >> >> So, I have no idea
>> >> >> where this is failing. Any help from anyone would be most
>> >> appreciated.
>> >> >>
>> >> >> Thanks a lot,
>> >> >> Adam Hull
>> >> >> http://axisgroupware.org
>> >> >>
>> >> >>
>> >> >> _______________________________________________
>> >> >> Phpgroupware-developers mailing list
>> >> >> address@hidden
>> >> >> http://mail.gnu.org/mailman/listinfo/phpgroupware-developers
>> >> >
>> >> >
>> >> >_______________________________________________
>> >> >Phpgroupware-developers mailing list
>> >> >address@hidden
>> >> >http://mail.gnu.org/mailman/listinfo/phpgroupware-developers
>> >> >
>> >>
>> >>
>> >> _______________________________________________
>> >> Phpgroupware-developers mailing list
>> >> address@hidden
>> >> http://mail.gnu.org/mailman/listinfo/phpgroupware-developers
>> >
>> >
>> >_______________________________________________
>> >Phpgroupware-developers mailing list
>> >address@hidden
>> >http://mail.gnu.org/mailman/listinfo/phpgroupware-developers
>> >
>>
>>
>> _______________________________________________
>> Phpgroupware-developers mailing list
>> address@hidden
>> http://mail.gnu.org/mailman/listinfo/phpgroupware-developers
>
>
>_______________________________________________
>Phpgroupware-developers mailing list
>address@hidden
>http://mail.gnu.org/mailman/listinfo/phpgroupware-developers
>