Page 3 of 5 FirstFirst 12345 LastLast
Results 21 to 30 of 48

Thread: cron job not running

  1. #21
    ken yap NNTP User

    Default Re: cron job not running


    Remove the -vx, it's not telling us anything new. Focus on why
    navicat.exe is exiting. You may have to strace it. Edit the shell script
    and make it strace navicat.exe where it used to be just navicat.exe.

    BTW, is navicat.exe a Windows .exe? Don't you have to do "wine
    navicat.exe" to run it instead of just navicat.exe?


    --
    ken_yap
    ------------------------------------------------------------------------
    ken_yap's Profile: http://forums.opensuse.org/member.php?userid=221
    View this thread: http://forums.opensuse.org/showthread.php?t=404918


  2. #22
    Ski K2 NNTP User

    Default Re: cron job not running


    I'm not familiar with strace.

    Yes navicat.exe is probably a windows exec file.

    I can tell you just launching start_navicat script using nautilus from
    gnome launches the app ok probably related to their method of packaging
    wine with their app. The app ran ok even before I installed wine. Note
    the reference to Picasa wrapper.

    I'll read up on strace usage.


    --
    Ski_K2
    ------------------------------------------------------------------------
    Ski_K2's Profile: http://forums.opensuse.org/member.php?userid=6818
    View this thread: http://forums.opensuse.org/showthread.php?t=404918


  3. #23
    Ski K2 NNTP User

    Default Re: cron job not running


    ken_yap;1927623 Wrote:
    > Remove the -vx, it's not telling us anything new. Focus on why
    > navicat.exe is exiting. You may have to strace it. Edit the shell script
    > and make it strace navicat.exe where it used to be just navicat.exe.
    >
    > BTW, is navicat.exe a Windows .exe? Don't you have to do "wine
    > navicat.exe" to run it instead of just navicat.exe?


    schedule.log was created empty.

    Here's what I did

    cp start_navicat start_navicat_strace
    vi start_navicat_strace
    added strace before Navicat.exe
    saved

    crontab -e
    50 20 * * * HOME=/home/pathp sh
    /home/pathp/Navicat/start_navicat_strace /schedule "Rack 5 to Local All"
    > /tmp/schedule.log 2>&1


    Where is strace output?

    Thanks for spending so much time on this!


    --
    Ski_K2
    ------------------------------------------------------------------------
    Ski_K2's Profile: http://forums.opensuse.org/member.php?userid=6818
    View this thread: http://forums.opensuse.org/showthread.php?t=404918


  4. #24
    ken yap NNTP User

    Default Re: cron job not running


    It goes to standard output so it should have ended up in the log file.

    Can you post what those last few lines of start_navicat are? I wonder
    if there is something odd about the exec of navicat.exe.


    --
    ken_yap
    ------------------------------------------------------------------------
    ken_yap's Profile: http://forums.opensuse.org/member.php?userid=221
    View this thread: http://forums.opensuse.org/showthread.php?t=404918


  5. #25
    Ski K2 NNTP User

    Default Re: cron job not running


    Here is the modified version with strace added

    > # install inf
    > for infcmd in wine.inf/DefaultInstall ; do
    > inffile=`echo $infcmd | cut -d '/' -f 1`
    > inftype=`echo $infcmd | cut -d '/' -f 2`
    >
    > runreg=0
    > if [ -f "$WINEPREFIX/drive_c/windows/inf.done/$inffile" ] ; then
    > diff -q "$WINEPREFIX/drive_c/windows/inf/$inffile"
    > "$WINEPREFIX/drive_c/windows/inf.done/$inffile" >/dev/null 2>&1
    > if [ $? -ne 0 ] ; then
    > runreg=1
    > fi
    > else
    > runreg=1
    > fi
    >
    > if [ $runreg -gt 0 ] ; then
    > "${WINELOADER:-wine}" rundll32.exe
    > setupapi.dll,InstallHinfSection $inftype 128 $inffile
    > cp "$WINEPREFIX/drive_c/windows/inf/$inffile"
    > "$WINEPREFIX/drive_c/windows/inf.done/$inffile"
    > fi
    > done
    >
    > # run Navicat.exe
    > exec "${WINELOADER:-wine}" "$navicat_root/Navicat/strace Navicat.exe"
    > "$1" "$2" "$3" "$4" "$5" "$6" "$7"



    --
    Ski_K2
    ------------------------------------------------------------------------
    Ski_K2's Profile: http://forums.opensuse.org/member.php?userid=6818
    View this thread: http://forums.opensuse.org/showthread.php?t=404918


  6. #26
    Ski K2 NNTP User

    Default Re: cron job not running


    It's been a long day for me so I'll have to take a look at this again
    tomorrow, time permitting.

    Thanks again for all the help!


    --
    Ski_K2
    ------------------------------------------------------------------------
    Ski_K2's Profile: http://forums.opensuse.org/member.php?userid=6818
    View this thread: http://forums.opensuse.org/showthread.php?t=404918


  7. #27
    ken yap NNTP User

    Default Re: cron job not running


    Ski_K2;1927646 Wrote:
    > Here is the modified version with strace added


    No, should be like this:


    Code:
    --------------------
    exec strace "${WINELOADER:-wine}" "$navicat_root/Navicat/Navicat.exe" "$1" "$2" "$3" "$4" "$5" "$6" "$7"
    --------------------


    --
    ken_yap
    ------------------------------------------------------------------------
    ken_yap's Profile: http://forums.opensuse.org/member.php?userid=221
    View this thread: http://forums.opensuse.org/showthread.php?t=404918


  8. #28
    Ski K2 NNTP User

    Default Re: cron job not running


    ken_yap;1927746 Wrote:
    > No, should be like this:
    >
    > >

    Code:
    --------------------
    > > exec strace "${WINELOADER:-wine}" "$navicat_root/Navicat/Navicat.exe" "$1" "$2" "$3" "$4" "$5" "$6" "$7"

    --------------------
    > >


    Running crontab without -vx schedule.log creates empty

    Running with -vx gives this

    schedule.log
    >
    > #!/bin/bash
    > # This is a script modified from Picasa wrapper script to launch
    > Navicat.exe
    >
    > cd `dirname "$0"`
    > dirname "$0"
    > ++ dirname /home/pathp/Navicat/start_navicat_strace
    > + cd /home/pathp/Navicat
    > navicat_root=`pwd`
    > pwd
    > ++ pwd
    > + navicat_root=/home/pathp/Navicat
    >
    > # Wine environment required
    > export PATH="$navicat_root/wine/bin":"$navicat_root":$PATH
    > + export
    > PATH=/home/pathp/Navicat/wine/bin:/home/pathp/Navicat:/usr/bin:/bin
    > + PATH=/home/pathp/Navicat/wine/bin:/home/pathp/Navicat:/usr/bin:/bin
    > export
    > LD_LIBRARY_PATH="$navicat_root/wine/lib":"$navicat_root/lib":$LD_LIBRARY_PATH
    > + export
    > LD_LIBRARY_PATH=/home/pathp/Navicat/wine/lib:/home/pathp/Navicat/lib:
    > +
    > LD_LIBRARY_PATH=/home/pathp/Navicat/wine/lib:/home/pathp/Navicat/lib:
    > export WINEDLLPATH="$navicat_root/wine/lib/wine"
    > + export WINEDLLPATH=/home/pathp/Navicat/wine/lib/wine
    > + WINEDLLPATH=/home/pathp/Navicat/wine/lib/wine
    > export WINELOADER="$navicat_root/wine/bin/wine"
    > + export WINELOADER=/home/pathp/Navicat/wine/bin/wine
    > + WINELOADER=/home/pathp/Navicat/wine/bin/wine
    > export WINESERVER="$navicat_root/wine/bin/wineserver"
    > + export WINESERVER=/home/pathp/Navicat/wine/bin/wineserver
    > + WINESERVER=/home/pathp/Navicat/wine/bin/wineserver
    > export WINEPREFIX=$HOME/.navicat
    > + export WINEPREFIX=/home/pathp/.navicat
    > + WINEPREFIX=/home/pathp/.navicat
    > export WINEDLLOVERRIDES="msxml3=n" # use native msxml3
    > + export WINEDLLOVERRIDES=msxml3=n
    > + WINEDLLOVERRIDES=msxml3=n
    > # find the x window server location at [current
    > machine]:[displaynumber=0]:[screennumber=0] to run x window application
    > # used in crontab schedule part of navicat
    > export DISPLAY=":0.0"
    > + export DISPLAY=:0.0
    > + DISPLAY=:0.0
    >
    > # create directories
    > [ -d "$WINEPREFIX" ] || mkdir -p "$WINEPREFIX"
    > + '[' -d /home/pathp/.navicat ']'
    > [ -d "$WINEPREFIX/drive_c" ] || mkdir -p "$WINEPREFIX/drive_c"
    > + '[' -d /home/pathp/.navicat/drive_c ']'
    > [ -d "$WINEPREFIX/drive_c/Program Files" ] || mkdir -p
    > "$WINEPREFIX/drive_c/Program Files"
    > + '[' -d '/home/pathp/.navicat/drive_c/Program Files' ']'
    > [ -d "$WINEPREFIX/drive_c/windows" ] || mkdir -p
    > "$WINEPREFIX/drive_c/windows"
    > + '[' -d /home/pathp/.navicat/drive_c/windows ']'
    > [ -d "$WINEPREFIX/drive_c/windows/temp" ] || mkdir -p
    > "$WINEPREFIX/drive_c/windows/temp"
    > + '[' -d /home/pathp/.navicat/drive_c/windows/temp ']'
    > [ -d "$WINEPREFIX/drive_c/windows/inf.done" ] || mkdir -p
    > "$WINEPREFIX/drive_c/windows/inf.done"
    > + '[' -d /home/pathp/.navicat/drive_c/windows/inf.done ']'
    > [ -d "$WINEPREFIX/dosdevices" ] || mkdir -p "$WINEPREFIX/dosdevices"
    > + '[' -d /home/pathp/.navicat/dosdevices ']'
    >
    > # check integrity of system directories
    > for system_dir in \
    > drive_c/windows/fonts \
    > drive_c/windows/inf \
    > drive_c/windows/system \
    > drive_c/windows/system32 \
    > ; do
    > if [ -h "$WINEPREFIX/$system_dir" ] ; then
    > if [ `stat --dereference --format %i "$WINEPREFIX/$system_dir"` =
    > `stat --dereference --format %i "$navicat_root/wine/$system_dir"` ] ;
    > then
    > continue;
    > fi
    > [ -d "$WINEPREFIX/$system_dir" ] || rm -f
    > "$WINEPREFIX/$system_dir"
    > fi
    >
    > [ -d "$WINEPREFIX/$system_dir" ] || ln -s
    > "$navicat_root/wine/$system_dir" "$WINEPREFIX/$system_dir"
    >
    > done
    > + for system_dir in drive_c/windows/fonts drive_c/windows/inf
    > drive_c/windows/system drive_c/windows/system32
    > + '[' -h /home/pathp/.navicat/drive_c/windows/fonts ']'
    > stat --dereference --format %i "$WINEPREFIX/$system_dir"
    > ++ stat --dereference --format %i
    > /home/pathp/.navicat/drive_c/windows/fonts
    > stat --dereference --format %i "$navicat_root/wine/$system_dir"
    > ++ stat --dereference --format %i
    > /home/pathp/Navicat/wine/drive_c/windows/fonts
    > + '[' 1425989 = 1425989 ']'
    > + continue
    > + for system_dir in drive_c/windows/fonts drive_c/windows/inf
    > drive_c/windows/system drive_c/windows/system32
    > + '[' -h /home/pathp/.navicat/drive_c/windows/inf ']'
    > stat --dereference --format %i "$WINEPREFIX/$system_dir"
    > ++ stat --dereference --format %i
    > /home/pathp/.navicat/drive_c/windows/inf
    > stat --dereference --format %i "$navicat_root/wine/$system_dir"
    > ++ stat --dereference --format %i
    > /home/pathp/Navicat/wine/drive_c/windows/inf
    > + '[' 1425994 = 1425994 ']'
    > + continue
    > + for system_dir in drive_c/windows/fonts drive_c/windows/inf
    > drive_c/windows/system drive_c/windows/system32
    > + '[' -h /home/pathp/.navicat/drive_c/windows/system ']'
    > stat --dereference --format %i "$WINEPREFIX/$system_dir"
    > ++ stat --dereference --format %i
    > /home/pathp/.navicat/drive_c/windows/system
    > stat --dereference --format %i "$navicat_root/wine/$system_dir"
    > ++ stat --dereference --format %i
    > /home/pathp/Navicat/wine/drive_c/windows/system
    > + '[' 1425996 = 1425996 ']'
    > + continue
    > + for system_dir in drive_c/windows/fonts drive_c/windows/inf
    > drive_c/windows/system drive_c/windows/system32
    > + '[' -h /home/pathp/.navicat/drive_c/windows/system32 ']'
    > stat --dereference --format %i "$WINEPREFIX/$system_dir"
    > ++ stat --dereference --format %i
    > /home/pathp/.navicat/drive_c/windows/system32
    > stat --dereference --format %i "$navicat_root/wine/$system_dir"
    > ++ stat --dereference --format %i
    > /home/pathp/Navicat/wine/drive_c/windows/system32
    > + '[' 1425999 = 1425999 ']'
    > + continue



    --
    Ski_K2
    ------------------------------------------------------------------------
    Ski_K2's Profile: http://forums.opensuse.org/member.php?userid=6818
    View this thread: http://forums.opensuse.org/showthread.php?t=404918


  9. #29
    Ski K2 NNTP User

    Default Re: cron job not running


    schedule.log cont'd

    > # create Navicat directories
    > [ -h "$WINEPREFIX/Navicat" ] && rm -f "$WINEPREFIX/Navicat"
    > + '[' -h /home/pathp/.navicat/Navicat ']'
    > [ -d "$WINEPREFIX/Navicat" ] || mkdir -p "$WINEPREFIX/Navicat"
    > + '[' -d /home/pathp/.navicat/Navicat ']'
    > (cd "$navicat_root/Navicat";
    > for x in * ; do
    > oldlink="`pwd`/$x"
    > newlink="$WINEPREFIX/Navicat/$x"
    > if [ -h "$newlink" ] ; then
    > if [ `stat --dereference --format %i "$oldlink"` = `stat
    > --dereference --format %i "$newlink"` ] ; then
    > continue;
    > fi
    > [ -d "$newlink" ] || rm -f "$newlink"
    > fi
    >
    > [ -d "$newlink" ] || ln -s "$oldlink" "$newlink"
    >
    > done
    > )
    > + cd /home/pathp/Navicat/Navicat
    > + for x in '*'
    > pwd
    > ++ pwd
    > + oldlink=/home/pathp/Navicat/Navicat/Navicat.exe
    > + newlink=/home/pathp/.navicat/Navicat/Navicat.exe
    > + '[' -h /home/pathp/.navicat/Navicat/Navicat.exe ']'
    > stat --dereference --format %i "$oldlink"
    > ++ stat --dereference --format %i
    > /home/pathp/Navicat/Navicat/Navicat.exe
    > stat --dereference --format %i "$newlink"
    > ++ stat --dereference --format %i
    > /home/pathp/.navicat/Navicat/Navicat.exe
    > + '[' 1425955 = 1425955 ']'
    > + continue
    > + for x in '*'
    > pwd
    > ++ pwd
    > + oldlink=/home/pathp/Navicat/Navicat/help
    > + newlink=/home/pathp/.navicat/Navicat/help
    > + '[' -h /home/pathp/.navicat/Navicat/help ']'
    > stat --dereference --format %i "$oldlink"
    > ++ stat --dereference --format %i /home/pathp/Navicat/Navicat/help
    > stat --dereference --format %i "$newlink"
    > ++ stat --dereference --format %i /home/pathp/.navicat/Navicat/help
    > + '[' 1425411 = 1425411 ']'
    > + continue
    > + for x in '*'
    > pwd
    > ++ pwd
    > + oldlink=/home/pathp/Navicat/Navicat/libeay32.dll
    > + newlink=/home/pathp/.navicat/Navicat/libeay32.dll
    > + '[' -h /home/pathp/.navicat/Navicat/libeay32.dll ']'
    > stat --dereference --format %i "$oldlink"
    > ++ stat --dereference --format %i
    > /home/pathp/Navicat/Navicat/libeay32.dll
    > stat --dereference --format %i "$newlink"
    > ++ stat --dereference --format %i
    > /home/pathp/.navicat/Navicat/libeay32.dll
    > + '[' 1425952 = 1425952 ']'
    > + continue
    > + for x in '*'
    > pwd
    > ++ pwd
    > + oldlink=/home/pathp/Navicat/Navicat/libmysql_c.dll
    > + newlink=/home/pathp/.navicat/Navicat/libmysql_c.dll
    > + '[' -h /home/pathp/.navicat/Navicat/libmysql_c.dll ']'
    > stat --dereference --format %i "$oldlink"
    > ++ stat --dereference --format %i
    > /home/pathp/Navicat/Navicat/libmysql_c.dll
    > stat --dereference --format %i "$newlink"
    > ++ stat --dereference --format %i
    > /home/pathp/.navicat/Navicat/libmysql_c.dll
    > + '[' 1425953 = 1425953 ']'
    > + continue
    > + for x in '*'
    > pwd
    > ++ pwd
    > + oldlink=/home/pathp/Navicat/Navicat/license.txt
    > + newlink=/home/pathp/.navicat/Navicat/license.txt
    > + '[' -h /home/pathp/.navicat/Navicat/license.txt ']'
    > stat --dereference --format %i "$oldlink"
    > ++ stat --dereference --format %i
    > /home/pathp/Navicat/Navicat/license.txt
    > stat --dereference --format %i "$newlink"
    > ++ stat --dereference --format %i
    > /home/pathp/.navicat/Navicat/license.txt
    > + '[' 1425954 = 1425954 ']'
    > + continue
    > + for x in '*'
    > pwd
    > ++ pwd
    > + oldlink=/home/pathp/Navicat/Navicat/logs
    > + newlink=/home/pathp/.navicat/Navicat/logs
    > + '[' -h /home/pathp/.navicat/Navicat/logs ']'
    > stat --dereference --format %i "$oldlink"
    > ++ stat --dereference --format %i /home/pathp/Navicat/Navicat/logs
    > stat --dereference --format %i "$newlink"
    > ++ stat --dereference --format %i /home/pathp/.navicat/Navicat/logs
    > + '[' 1434109 = 1434109 ']'
    > + continue
    > + for x in '*'
    > pwd
    > ++ pwd
    > + oldlink=/home/pathp/Navicat/Navicat/ntunnel_mysql.php
    > + newlink=/home/pathp/.navicat/Navicat/ntunnel_mysql.php
    > + '[' -h /home/pathp/.navicat/Navicat/ntunnel_mysql.php ']'
    > stat --dereference --format %i "$oldlink"
    > ++ stat --dereference --format %i
    > /home/pathp/Navicat/Navicat/ntunnel_mysql.php
    > stat --dereference --format %i "$newlink"
    > ++ stat --dereference --format %i
    > /home/pathp/.navicat/Navicat/ntunnel_mysql.php
    > + '[' 1425956 = 1425956 ']'
    > + continue
    > + for x in '*'
    > pwd
    > ++ pwd
    > + oldlink=/home/pathp/Navicat/Navicat/profiles
    > + newlink=/home/pathp/.navicat/Navicat/profiles
    > + '[' -h /home/pathp/.navicat/Navicat/profiles ']'
    > stat --dereference --format %i "$oldlink"
    > ++ stat --dereference --format %i /home/pathp/Navicat/Navicat/profiles
    > stat --dereference --format %i "$newlink"
    > ++ stat --dereference --format %i
    > /home/pathp/.navicat/Navicat/profiles
    > + '[' 1434106 = 1434106 ']'
    > + continue
    > + for x in '*'
    > pwd
    > ++ pwd
    > + oldlink=/home/pathp/Navicat/Navicat/ssleay32.dll
    > + newlink=/home/pathp/.navicat/Navicat/ssleay32.dll
    > + '[' -h /home/pathp/.navicat/Navicat/ssleay32.dll ']'
    > stat --dereference --format %i "$oldlink"
    > ++ stat --dereference --format %i
    > /home/pathp/Navicat/Navicat/ssleay32.dll
    > stat --dereference --format %i "$newlink"
    > ++ stat --dereference --format %i
    > /home/pathp/.navicat/Navicat/ssleay32.dll
    > + '[' 1425957 = 1425957 ']'
    > + continue
    >
    > # create wine emulated devices
    > if [ -h "$WINEPREFIX/dosdevices/c:" ] ; then
    > [ -d "$WINEPREFIX/dosdevices/c:" ] || rm -f
    > "$WINEPREFIX/dosdevices/c:"
    > fi
    > + '[' -h /home/pathp/.navicat/dosdevices/c: ']'
    > + '[' -d /home/pathp/.navicat/dosdevices/c: ']'
    > [ -d "$WINEPREFIX/dosdevices/c:" ] || ln -s "$WINEPREFIX/drive_c/"
    > "$WINEPREFIX/dosdevices/c:"
    > + '[' -d /home/pathp/.navicat/dosdevices/c: ']'
    >
    > if [ -h "$WINEPREFIX/dosdevices/z:" ] ; then
    > [ -d "$WINEPREFIX/dosdevices/z:" ] || rm -f
    > "$WINEPREFIX/dosdevices/z:"
    > fi
    > + '[' -h /home/pathp/.navicat/dosdevices/z: ']'
    > + '[' -d /home/pathp/.navicat/dosdevices/z: ']'
    > [ -d "$WINEPREFIX/dosdevices/z:" ] || ln -s /
    > "$WINEPREFIX/dosdevices/z:"
    > + '[' -d /home/pathp/.navicat/dosdevices/z: ']'
    >
    > if [ -h "$WINEPREFIX/dosdevices/y:" ] ; then
    > [ -d "$WINEPREFIX/dosdevices/y:" ] || rm -f
    > "$WINEPREFIX/dosdevices/y:"
    > fi
    > + '[' -h /home/pathp/.navicat/dosdevices/y: ']'
    > + '[' -d /home/pathp/.navicat/dosdevices/y: ']'
    > if [ -d "$HOME" ] ; then
    > [ -d "$WINEPREFIX/dosdevices/y:" ] || ln -s "$HOME"
    > "$WINEPREFIX/dosdevices/y:"
    > fi
    > + '[' -d /home/pathp ']'
    > + '[' -d /home/pathp/.navicat/dosdevices/y: ']'
    >
    > # hide error/stdout message
    > if test "z$WINEDEBUG" = z ; then
    > exec >/tmp/navicat.output 2>&1
    > fi
    > + test z = z
    > + exec



    --
    Ski_K2
    ------------------------------------------------------------------------
    Ski_K2's Profile: http://forums.opensuse.org/member.php?userid=6818
    View this thread: http://forums.opensuse.org/showthread.php?t=404918


  10. #30
    Ski K2 NNTP User

    Default Re: cron job not running


    In reviewing this thread with a fresh mind I'm wondering if the problem
    might be that the parameter is not getting passed to navicat.exe when
    called from crontab.

    The / in the parameter as originally specified by the applications
    author may be preventing the param from being passed.

    HOME=/home/pathp sh /home/pathp/Navicat/start_navicat_strace /schedule
    "Rack 5 to Local All" > /tmp/schedule.log 2>&1

    ????


    --
    Ski_K2
    ------------------------------------------------------------------------
    Ski_K2's Profile: http://forums.opensuse.org/member.php?userid=6818
    View this thread: http://forums.opensuse.org/showthread.php?t=404918


Page 3 of 5 FirstFirst 12345 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •