Re: [Planner Dev] planner database

[Geoffrey <esoteric 3times25 net>]

Richard Hult wrote:
> Geoffrey wrote:
>
> > Well it's interesting.  I've tried first to connect locally.  If I try 
> > it as root, I get a 'connection to database plannerdb' failed.'  If I 
> > try the same as non-root user, it crashes when I attempt to connect to 
> > the database.  I'm using the same database user name, just running 
> > planner as root and a non-root user.
>
>
> Could you post a stack trace of the crash please?
>
> /Richard

The wierd thing now is that it crashes even as root.  I can't reproduce 
the connection error on that machine now.

I ran it with strace and compared it to the output from running planner 
on another machine.  The one difference I see is the planner that 
crashes has a reference to /etc/passwd, whereas the machine that does 
not crash has a reference to $HOME/.pgpass so I'm thinking the 
difference might have something to do with the way it's attempting to 
authenticate the id.  In both cases, I left the password field blank.  I 
did try entering a password on the machine that planner crashes on, but 
that made no difference.  The strace output is 76 meg compressed.  Here 
is the stack trace from gdb:

#0  0x00000000 in ?? ()
#1  0x2c0ec498 in gda_postgres_recordset_get_n_rows (model=0x8263c78)
    at gda-postgres-recordset.c:651
#2  0x2c0837e5 in gda_data_model_get_n_rows (model=0x8263c78)
    at gda-data-model.c:431
#3  0x2c06c887 in sql_plugin_retrieve_project_id (plugin=0x81662f8,
    server=0x82663c0 "localhost", port=0x0, database=0x825de58 "plannerdb",
    login=0x825de30 "esoteric", password=0x0) at planner-sql-plugin.c:427
#4  0x2c06ce70 in sql_plugin_open (component=0x816b038, user_data=0x81662f8,
    cname=0x81a7c70 "Open") at planner-sql-plugin.c:613
#5  0x2abfbb65 in marshal_VOID__USER_DATA_STRING (closure=0x8166230,
    return_value=0xbfffe660, n_param_values=2, param_values=0x8249960,
    invocation_hint=0x0, marshal_data=0x0) at bonobo-ui-component.c:221
#6  0x2b6feef7 in g_closure_invoke () from /usr/lib/libgobject-2.0.so.0
#7  0x2ac71258 in bonobo_closure_invoke_va_list ()
   from /usr/lib/libbonobo-2.so.0
#8  0x2ac714f7 in bonobo_closure_invoke () from /usr/lib/libbonobo-2.so.0
#9  0x2abfba52 in impl_Bonobo_UIComponent_execVerb (servant=0x816b04c,
    cname=0x824f328 "Open", ev=0xbfffe750) at bonobo-ui-component.c:158
#10 0x2ac75ce0 in Bonobo_UIComponent_execVerb () from 
/usr/lib/libbonobo-2.so.0
#11 0x2ac0304a in real_exec_verb (engine=0x816ae88,
    component_name=0xbfffe750 "", verb=0x8167148 "Open")
    at bonobo-ui-engine.c:1533
#12 0x2ac03263 in impl_emit_verb_on (engine=0x80b98b0, node=0x8167149)
    at bonobo-ui-engine.c:1584
#13 0x2b7127e4 in g_cclosure_marshal_VOID__POINTER ()
   from /usr/lib/libgobject-2.0.so.0
#14 0x2b6ff267 in g_cclosure_new_swap () from /usr/lib/libgobject-2.0.so.0
#15 0x2b6feef7 in g_closure_invoke () from /usr/lib/libgobject-2.0.so.0
#16 0x2b711369 in g_signal_emit_by_name () from /usr/lib/libgobject-2.0.so.0
#17 0x2b7108e8 in g_signal_emit_valist () from /usr/lib/libgobject-2.0.so.0
#18 0x2b710b24 in g_signal_emit () from /usr/lib/libgobject-2.0.so.0
#19 0x2ac05be5 in bonobo_ui_engine_emit_verb_on_w (engine=0x8263bb8,
    widget=0x8263bb8) at bonobo-ui-engine.c:3026
#20 0x2ac0b487 in exec_verb_cb (item=0x8263bb8, engine=0x8263bb8)
    at bonobo-ui-sync-menu.c:445
#21 0x2b711c87 in g_cclosure_marshal_VOID__VOID ()
   from /usr/lib/libgobject-2.0.so.0
#22 0x2b6feef7 in g_closure_invoke () from /usr/lib/libgobject-2.0.so.0
#23 0x2b71189e in g_signal_emit_by_name () from /usr/lib/libgobject-2.0.so.0
#24 0x2b7108e8 in g_signal_emit_valist () from /usr/lib/libgobject-2.0.so.0
#25 0x2b710b24 in g_signal_emit () from /usr/lib/libgobject-2.0.so.0
#26 0x2b474d5d in gtk_widget_activate () from /usr/lib/libgtk-x11-2.0.so.0
#27 0x2b39dbc2 in gtk_menu_shell_activate_item ()
   from /usr/lib/libgtk-x11-2.0.so.0
#28 0x2b39ce53 in _gtk_menu_shell_activate () from 
/usr/lib/libgtk-x11-2.0.so.0
#29 0x2b39629b in gtk_menu_reorder_child () from 
/usr/lib/libgtk-x11-2.0.so.0
#30 0x2b38e10f in _gtk_marshal_BOOLEAN__BOXED ()
   from /usr/lib/libgtk-x11-2.0.so.0
#31 0x2b6ff267 in g_cclosure_new_swap () from /usr/lib/libgobject-2.0.so.0
#32 0x2b6feef7 in g_closure_invoke () from /usr/lib/libgobject-2.0.so.0
#33 0x2b711369 in g_signal_emit_by_name () from /usr/lib/libgobject-2.0.so.0
#34 0x2b7106e5 in g_signal_emit_valist () from /usr/lib/libgobject-2.0.so.0
#35 0x2b710b24 in g_signal_emit () from /usr/lib/libgobject-2.0.so.0
#36 0x2b474b7b in gtk_widget_send_expose () from 
/usr/lib/libgtk-x11-2.0.so.0
#37 0x2b38df07 in gtk_propagate_event () from /usr/lib/libgtk-x11-2.0.so.0
#38 0x2b38cc05 in gtk_main_do_event () from /usr/lib/libgtk-x11-2.0.so.0
#39 0x2b545315 in _gdk_events_queue () from /usr/lib/libgdk-x11-2.0.so.0
#40 0x2b752c30 in unblock_source () from /usr/lib/libglib-2.0.so.0
#41 0x2b753c98 in g_main_context_dispatch () from /usr/lib/libglib-2.0.so.0
#42 0x2b753fad in g_main_context_dispatch () from /usr/lib/libglib-2.0.so.0
#43 0x2b7546cf in g_main_loop_run () from /usr/lib/libglib-2.0.so.0
#44 0x2b38c43f in gtk_main () from /usr/lib/libgtk-x11-2.0.so.0
#45 0x2abee05e in bonobo_ui_main () at bonobo-ui-main.c:164
#46 0x0806611f in main (argc=1, argv=0xbffff714) at planner-main.c:103

--
Until later, Geoffrey       Registered Linux User #108567
                            AT&T Certified UNIX System Programmer - 1995