Linux can't start ML automatically after it start

I want to run MobileLink server automatically after Linux OS
start, so add the following script into /etc/rc.local file:

cd ~sybase
su sybase -c '. ~sybase/start_mlserver.sh'
cd
su -root -c
'/usr/local/jakarta-tomcat-4.1.24/bin/startup.sh'

Linux run the MobileLink server,but ML can't start properly,
it raise an error in the log file:

E. 03/12 08:11:53. <Main>: Error: ODBC: [MERANT][ODBC Oracle
driver][Oracle]ORA-12535:

TNS:operation timed out  (ODBC State = HY000, Native error
code = 12535)

I tried 2 times,but failed, then I start ML manually
successfully,you can see it from the log.

Additionally, I add the following script into /etc/rc.local
file, but Linux can't run ML.
cd ~sybase
su -sybase -c '/home/sybase/start_mlserver.sh' # the
start_mlserver.sh in the /home/sybase dir.

Can you give some advice?   email:
yan.shui@shanghaiebest.com
0
yan
3/12/2004 2:51:15 AM
sybase.sqlanywhere.mobilink 5254 articles. 0 followers. Follow

5 Replies
796 Views

Similar Articles

[PageSpeed] 42

> I want to run MobileLink server automatically after Linux
> OS start, so add the following script into /etc/rc.local
> file:
>
> cd ~sybase
> su sybase -c '. ~sybase/start_mlserver.sh'
> cd
> su -root -c
> '/usr/local/jakarta-tomcat-4.1.24/bin/startup.sh'
>
> Linux run the MobileLink server,but ML can't start
> properly, it raise an error in the log file:
>
> E. 03/12 08:11:53. <Main>: Error: ODBC: [MERANT][ODBC
> Oracle driver][Oracle]ORA-12535:
>
> TNS:operation timed out  (ODBC State = HY000, Native error
> code = 12535)
>
> I tried 2 times,but failed, then I start ML manually
> successfully,you can see it from the log.
>
> Additionally, I add the following script into
> /etc/rc.local file, but Linux can't run ML.
> cd ~sybase
> su -sybase -c '/home/sybase/start_mlserver.sh' # the
> start_mlserver.sh in the /home/sybase dir.
>
> Can you give some advice?   email:
> yan.shui@shanghaiebest.com

There is the detail log below:

I. 03/12 07:53:32. <thread 1.2>: Shutting down
I. 03/12 07:53:32. <thread 1.1>: Shutting down
I. 03/12 07:53:33. <Main>: end_connection <connection> (no
script)
I. 03/12 07:53:33. <Main>: COMMIT Transaction:
end_connection
I. 03/12 07:53:33. <Main>: Disconnected from consolidated
database
I. 03/12 07:56:47. Adaptive Server Anywhere MobiLink Version
8.0.2.3608
I. 03/12 07:56:47.
I. 03/12 07:56:47. Copyright (c) 1989-2002 Sybase, Inc.
                   Portions Copyright (c) 2002, iAnywhere
Solutions, Inc.
I. 03/12 07:56:47. All rights reserved. All unpublished
rights reserved.
I. 03/12 07:56:47.
I. 03/12 07:56:47. This software contains confidential and
trade secret information of
I. 03/12 07:56:47. iAnywhere Solutions, Inc.
                   Use, duplication or disclosure of the
software and documentation
I. 03/12 07:56:47. by the U.S. Government is subject to
restrictions set forth in a license
I. 03/12 07:56:47. agreement between the Government and
iAnywhere Solutions, Inc. or
I. 03/12 07:56:47. other written agreement specifying the
Government's rights to use the
I. 03/12 07:56:47. software and any applicable FAR
provisions, for example, FAR 52.227-19.
I. 03/12 07:56:47.
I. 03/12 07:56:47. Sybase, Inc., One Sybase Drive, Dublin,
CA 94568, USA
I. 03/12 07:56:47.
I. 03/12 07:56:47. Networked Seat (per-seat) model. Access
to the server is limited to 1 seat(s).
                   This server is licensed to:
I. 03/12 07:56:47.     "BrightDairy"
I. 03/12 07:56:47.     "BrightDairy"
I. 03/12 07:56:48. <Main>: MobiLink server started
I. 03/12 07:56:48. <Main>: Option 1: -c
I. 03/12 07:56:48. <Main>: Option 2: ****************
I. 03/12 07:56:48. <Main>: Option 3: -w
I. 03/12 07:56:48. <Main>: Option 4: 20
I. 03/12 07:56:48. <Main>: Option 5: -wu
I. 03/12 07:56:48. <Main>: Option 6: 10
I. 03/12 07:56:48. <Main>: Option 7: -cn
I. 03/12 07:56:48. <Main>: Option 8: 21
I. 03/12 07:56:48. <Main>: Option 9: -v
I. 03/12 07:56:48. <Main>: Option 10: cnrst
I. 03/12 07:56:48. <Main>: Option 11: -zu+
I. 03/12 07:56:48. <Main>: Option 12: -zwd
I. 03/12 07:56:48. <Main>: Verbose logging: show row values
I. 03/12 07:56:48. <Main>: Verbose logging: show script
names when invoked
I. 03/12 07:56:48. <Main>: Verbose logging: show script
contents when invoked
I. 03/12 07:56:48. <Main>: Verbose logging: show translated
SQL for prepared statements
I. 03/12 07:56:48. <Main>: Verbose logging: show rowcount
values
I. 03/12 07:56:48. <Main>: Individual database connections
will be closed after synchronization errors.
I. 03/12 07:56:48. <Main>: BLOB cache size: 524288
I. 03/12 07:56:48. <Main>: Maximum number of BLOB bytes to
compare: 4294967295
I. 03/12 07:56:48. <Main>: Maximum number of database
connections: 21
I. 03/12 07:56:48. <Main>: Maximum number of deadlock
retries: 10
I. 03/12 07:56:48. <Main>: Timeout for inactive database
connections: 60 minutes
I. 03/12 07:56:48. <Main>: Maximum delay between retries
after deadlock: 30 seconds
I. 03/12 07:56:48. <Main>: Rowset size: 10
I. 03/12 07:56:48. <Main>: Upload cache size: 524288 bytes
I. 03/12 07:56:48. <Main>: Download cache size: 524288 bytes
I. 03/12 07:56:48. <Main>: Number of worker threads: 20
I. 03/12 07:56:48. <Main>: Maximum number of threads
uploading concurrently: 10
I. 03/12 07:56:48. <Main>: Warning: Unknown users will be
added automatically (when there is no authenticate_user
script).
I. 03/12 07:56:48. <Main>: Pass last download timestamp
first.
I. 03/12 07:56:48. <Main>: Example scripts will not be
automatically generated for unknown versions.
I. 03/12 07:56:48. <Main>: Local file for remote
synchronization logs: 'dbmlsrv.mle'
I. 03/12 07:56:48. <Main>: Stream specifier 1: tcpip
E. 03/12 08:00:03. <Main>: Error: ODBC: [MERANT][ODBC Oracle
driver][Oracle]ORA-12535: TNS:operation timed out
                    (ODBC State = HY000, Native error code =
12535)
I. 03/12 08:00:03. <Main>: MobiLink server finished
I. 03/12 08:08:37. Adaptive Server Anywhere MobiLink Version
8.0.2.3608
I. 03/12 08:08:37.
I. 03/12 08:08:37. Copyright (c) 1989-2002 Sybase, Inc.
                   Portions Copyright (c) 2002, iAnywhere
Solutions, Inc.
I. 03/12 08:08:37. All rights reserved. All unpublished
rights reserved.
I. 03/12 08:08:37.
I. 03/12 08:08:37. This software contains confidential and
trade secret information of
I. 03/12 08:08:37. iAnywhere Solutions, Inc.
                   Use, duplication or disclosure of the
software and documentation
I. 03/12 08:08:37. by the U.S. Government is subject to
restrictions set forth in a license
I. 03/12 08:08:37. agreement between the Government and
iAnywhere Solutions, Inc. or
I. 03/12 08:08:37. other written agreement specifying the
Government's rights to use the
I. 03/12 08:08:37. software and any applicable FAR
provisions, for example, FAR 52.227-19.
I. 03/12 08:08:37.
I. 03/12 08:08:37. Sybase, Inc., One Sybase Drive, Dublin,
CA 94568, USA
I. 03/12 08:08:37.
I. 03/12 08:08:37. Networked Seat (per-seat) model. Access
to the server is limited to 1 seat(s).
                   This server is licensed to:
I. 03/12 08:08:37.     "BrightDairy"
I. 03/12 08:08:37.     "BrightDairy"
I. 03/12 08:08:37. <Main>: MobiLink server started
I. 03/12 08:08:37. <Main>: Option 1: -c
I. 03/12 08:08:37. <Main>: Option 2: ****************
I. 03/12 08:08:37. <Main>: Option 3: -w
I. 03/12 08:08:37. <Main>: Option 4: 20
I. 03/12 08:08:37. <Main>: Option 5: -wu
I. 03/12 08:08:37. <Main>: Option 6: 10
I. 03/12 08:08:37. <Main>: Option 7: -cn
I. 03/12 08:08:37. <Main>: Option 8: 21
I. 03/12 08:08:37. <Main>: Option 9: -v
I. 03/12 08:08:37. <Main>: Option 10: cnrst
I. 03/12 08:08:37. <Main>: Option 11: -zu+
I. 03/12 08:08:37. <Main>: Option 12: -zwd
I. 03/12 08:08:37. <Main>: Verbose logging: show row values
I. 03/12 08:08:37. <Main>: Verbose logging: show script
names when invoked
I. 03/12 08:08:37. <Main>: Verbose logging: show script
contents when invoked
I. 03/12 08:08:37. <Main>: Verbose logging: show translated
SQL for prepared statements
I. 03/12 08:08:37. <Main>: Verbose logging: show rowcount
values
I. 03/12 08:08:37. <Main>: Individual database connections
will be closed after synchronization errors.
I. 03/12 08:08:37. <Main>: BLOB cache size: 524288
I. 03/12 08:08:37. <Main>: Maximum number of BLOB bytes to
compare: 4294967295
I. 03/12 08:08:37. <Main>: Maximum number of database
connections: 21
I. 03/12 08:08:37. <Main>: Maximum number of deadlock
retries: 10
I. 03/12 08:08:37. <Main>: Timeout for inactive database
connections: 60 minutes
I. 03/12 08:08:37. <Main>: Maximum delay between retries
after deadlock: 30 seconds
I. 03/12 08:08:38. <Main>: Rowset size: 10
I. 03/12 08:08:38. <Main>: Upload cache size: 524288 bytes
I. 03/12 08:08:38. <Main>: Download cache size: 524288 bytes
I. 03/12 08:08:38. <Main>: Number of worker threads: 20
I. 03/12 08:08:38. <Main>: Maximum number of threads
uploading concurrently: 10
I. 03/12 08:08:38. <Main>: Warning: Unknown users will be
added automatically (when there is no authenticate_user
script).
I. 03/12 08:08:38. <Main>: Pass last download timestamp
first.
I. 03/12 08:08:38. <Main>: Example scripts will not be
automatically generated for unknown versions.
I. 03/12 08:08:38. <Main>: Local file for remote
synchronization logs: 'dbmlsrv.mle'
I. 03/12 08:08:38. <Main>: Stream specifier 1: tcpip
E. 03/12 08:11:53. <Main>: Error: ODBC: [MERANT][ODBC Oracle
driver][Oracle]ORA-12535: TNS:operation timed out
                    (ODBC State = HY000, Native error code =
12535)
I. 03/12 08:11:53. <Main>: MobiLink server finished
I. 03/12 08:20:47. Adaptive Server Anywhere MobiLink Version
8.0.2.3608
I. 03/12 08:20:47.
I. 03/12 08:20:47. Copyright (c) 1989-2002 Sybase, Inc.
                   Portions Copyright (c) 2002, iAnywhere
Solutions, Inc.
I. 03/12 08:20:47. All rights reserved. All unpublished
rights reserved.
I. 03/12 08:20:47.
I. 03/12 08:20:47. This software contains confidential and
trade secret information of
I. 03/12 08:20:47. iAnywhere Solutions, Inc.
                   Use, duplication or disclosure of the
software and documentation
I. 03/12 08:20:47. by the U.S. Government is subject to
restrictions set forth in a license
I. 03/12 08:20:47. agreement between the Government and
iAnywhere Solutions, Inc. or
I. 03/12 08:20:47. other written agreement specifying the
Government's rights to use the
I. 03/12 08:20:47. software and any applicable FAR
provisions, for example, FAR 52.227-19.
I. 03/12 08:20:47.
I. 03/12 08:20:47. Sybase, Inc., One Sybase Drive, Dublin,
CA 94568, USA
I. 03/12 08:20:47.
I. 03/12 08:20:47. Networked Seat (per-seat) model. Access
to the server is limited to 1 seat(s).
                   This server is licensed to:
I. 03/12 08:20:47.     "BrightDairy"
I. 03/12 08:20:47.     "BrightDairy"
I. 03/12 08:20:47. <Main>: MobiLink server started
I. 03/12 08:20:47. <Main>: Option 1: -c
I. 03/12 08:20:47. <Main>: Option 2: ****************
I. 03/12 08:20:47. <Main>: Option 3: -w
I. 03/12 08:20:47. <Main>: Option 4: 20
I. 03/12 08:20:47. <Main>: Option 5: -wu
I. 03/12 08:20:47. <Main>: Option 6: 10
I. 03/12 08:20:47. <Main>: Option 7: -cn
I. 03/12 08:20:47. <Main>: Option 8: 21
I. 03/12 08:20:47. <Main>: Option 9: -v
I. 03/12 08:20:47. <Main>: Option 10: cnrst
I. 03/12 08:20:47. <Main>: Option 11: -zu+
I. 03/12 08:20:47. <Main>: Option 12: -zwd
I. 03/12 08:20:47. <Main>: Verbose logging: show row values
I. 03/12 08:20:47. <Main>: Verbose logging: show script
names when invoked
I. 03/12 08:20:47. <Main>: Verbose logging: show script
contents when invoked
I. 03/12 08:20:47. <Main>: Verbose logging: show translated
SQL for prepared statements
I. 03/12 08:20:47. <Main>: Verbose logging: show rowcount
values
I. 03/12 08:20:47. <Main>: Individual database connections
will be closed after synchronization errors.
I. 03/12 08:20:47. <Main>: BLOB cache size: 524288
I. 03/12 08:20:47. <Main>: Maximum number of BLOB bytes to
compare: 4294967295
I. 03/12 08:20:47. <Main>: Maximum number of database
connections: 21
I. 03/12 08:20:47. <Main>: Maximum number of deadlock
retries: 10
I. 03/12 08:20:47. <Main>: Timeout for inactive database
connections: 60 minutes
I. 03/12 08:20:47. <Main>: Maximum delay between retries
after deadlock: 30 seconds
I. 03/12 08:20:47. <Main>: Rowset size: 10
I. 03/12 08:20:47. <Main>: Upload cache size: 524288 bytes
I. 03/12 08:20:47. <Main>: Download cache size: 524288 bytes
I. 03/12 08:20:47. <Main>: Number of worker threads: 20
I. 03/12 08:20:47. <Main>: Maximum number of threads
uploading concurrently: 10
I. 03/12 08:20:47. <Main>: Warning: Unknown users will be
added automatically (when there is no authenticate_user
script).
I. 03/12 08:20:47. <Main>: Pass last download timestamp
first.
I. 03/12 08:20:47. <Main>: Example scripts will not be
automatically generated for unknown versions.
I. 03/12 08:20:47. <Main>: Local file for remote
synchronization logs: 'dbmlsrv.mle'
I. 03/12 08:20:47. <Main>: Stream specifier 1: tcpip
I. 03/12 08:20:48. <Main>: ODBC DBMS Name: Oracle
I. 03/12 08:20:48. <Main>: ODBC DBMS Version: 08.00.0006
Oracle 8.0.6.1.0
I. 03/12 08:20:48. <Main>: ODBC DBMS Driver Version:
04.00.0045
I. 03/12 08:20:48. <Main>: ODBC Version supported by the
driver: 3.51
I. 03/12 08:20:48. <Main>: ODBC isolation set to: Read
Committed
I. 03/12 08:20:48. <Main>: Connected
I. 03/12 08:20:49. <Main>: Translated SQL:
                   SELECT COUNT(*) FROM ml_scripts_modified
I. 03/12 08:20:49. <thread 1.1>: Ready to handle requests
I. 03/12 08:20:49. <thread 1.2>: Ready to handle requests
I. 03/12 08:20:49. <thread 1.3>: Ready to handle requests
I. 03/12 08:20:49. <thread 1.4>: Ready to handle requests
I. 03/12 08:20:49. <thread 1.5>: Ready to handle requests
I. 03/12 08:20:49. <thread 1.6>: Ready to handle requests
I. 03/12 08:20:49. <thread 1.7>: Ready to handle requests
I. 03/12 08:20:49. <thread 1.8>: Ready to handle requests
I. 03/12 08:20:49. <thread 1.9>: Ready to handle requests
I. 03/12 08:20:49. <thread 1.10>: Ready to handle requests
I. 03/12 08:20:49. <thread 1.11>: Ready to handle requests
I. 03/12 08:20:49. <thread 1.12>: Ready to handle requests
I. 03/12 08:20:49. <thread 1.13>: Ready to handle requests
I. 03/12 08:20:49. <thread 1.14>: Ready to handle requests
I. 03/12 08:20:49. <thread 1.15>: Ready to handle requests
I. 03/12 08:20:49. <thread 1.16>: Ready to handle requests
I. 03/12 08:20:49. <thread 1.17>: Ready to handle requests
I. 03/12 08:20:49. <thread 1.18>: Ready to handle requests
I. 03/12 08:20:49. <thread 1.19>: Ready to handle requests
I. 03/12 08:20:49. <thread 1.20>: Ready to handle requests
I. 03/12 08:20:51. <Main>: Press 'q' to quit MobiLink server
0
yan
3/12/2004 3:05:24 AM
yan.shui@shanghaiebest.com wrote in news:4051259e.46d6.846930886
@sybase.com:

....
ys> E. 03/12 08:11:53. <Main>: Error: ODBC: [MERANT][ODBC Oracle
ys> driver][Oracle]ORA-12535:
ys> 
ys> TNS:operation timed out  (ODBC State = HY000, Native error
ys> code = 12535)

Is Oracle running on the same Linux box?
What RC level is it starting at?
Can you confirm it has *finished* starting before MobiLink attempts to
connect?

-- 
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase 
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with 
EACH post (dbeng9 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm 

Developer Community / Whitepapers
http://www.ianywhere.com/developer

CaseXpress - to report bugs
http://casexpress.sybase.com

CodeXchange - Free samples
http://ianywhere.codexchange.sybase.com/servlets/ProjectDocumentList

0
David
3/12/2004 12:41:14 PM
David Fishburn wrote:
> 
> Is Oracle running on the same Linux box?
> What RC level is it starting at?
> Can you confirm it has *finished* starting before MobiLink attempts to
> connect?

Along with what David asked, can you post the start_mlserver.sh script?
Which distro and version of Linux are you using?

When you run the script by hand and it succeeds, which user are you 
doing it as?

This is likely a difference in the environment between the successful 
running by hand and the failed rc.local startup.  You could compare the 
output of "env | sort" when running by hand versus the same during 
rc.local to see what differences exist.

Hope this helps,
greg.fenton
-- 
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
0
Greg
3/17/2004 6:36:09 PM
> yan.shui@shanghaiebest.com wrote in
> news:4051259e.46d6.846930886 @sybase.com:
>
> ...
> ys> E. 03/12 08:11:53. <Main>: Error: ODBC: [MERANT][ODBC
> Oracle ys> driver][Oracle]ORA-12535:
> ys>
> ys> TNS:operation timed out  (ODBC State = HY000, Native
> error ys> code = 12535)
>
> Is Oracle running on the same Linux box?
> What RC level is it starting at?
> Can you confirm it has *finished* starting before MobiLink
> attempts to connect?
>
> --
> David Fishburn
> Certified ASA Developer Version 8
> iAnywhere Solutions - Sybase
> Professional Services
> Please only post to the newsgroup
> Please ALWAYS include version and MORE importantly BUILD
> number with  EACH post (dbeng9 -v).

First Thank you very much for your response!!


> Is Oracle running on the same Linux box?
ans: No Oracle run on another server, and it has run
normally, and other applications connect to it well

> What RC level is it starting at?
ans: the script in the file rc.local, as following:

#!/bin/sh
#
# This script will be executed *after* all the other init
scripts.
# You can put your own initialization stuff in here if you
don't
# want to do the full Sys V style init stuff.

touch /var/lock/subsys/local

sleep 30
cd ~sybase
su sybase -c '. ~sybase/start_mlserver.sh'
#su - sybase -c '/home/sybase/start_mlserver.sh'
cd
su - root -c
'/usr/local/jakarta-tomcat-4.1.24/bin/startup.sh'

The ML start command in the file: start_mlserver.sh

.. /opt/sybase/SYBSsa8/bin/asa_config.sh
export ORACLE_HOME=/opt/oracle/product/8.1.7
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib
export PATH=$PATH:$ORACLE_HOME/bin
export ODBCINI=~/.odbc.ini
export NLS_LANG="SIMPLIFIED CHINESE"
/opt/sybase/SYBSsa8/bin/dbmlsrv8 -c "dsn=Oracle" -w 20 -wu
10 -cn 21 -o "pdalog/sync.log" -os 10000000 -v cnrst -zu+
-zwd -ud

> Can you confirm it has *finished* starting before MobiLink
> attempts to connect?
ans: Yes. we can see it from the log:


I. 03/12 07:53:32. <thread 1.2>: Shutting down
I. 03/12 07:53:32. <thread 1.1>: Shutting down
I. 03/12 07:53:33. <Main>: end_connection <connection> (no
script)
I. 03/12 07:53:33. <Main>: COMMIT Transaction:
end_connection
I. 03/12 07:53:33. <Main>: Disconnected from consolidated
database
I. 03/12 07:56:47. Adaptive Server Anywhere MobiLink Version
8.0.2.3608
I. 03/12 07:56:47.
I. 03/12 07:56:47. Copyright (c) 1989-2002 Sybase, Inc.
                   Portions Copyright (c) 2002, iAnywhere
Solutions, Inc.
I. 03/12 07:56:47. All rights reserved. All unpublished
rights reserved.
I. 03/12 07:56:47.
I. 03/12 07:56:47. This software contains confidential and
trade secret information of
I. 03/12 07:56:47. iAnywhere Solutions, Inc.
                   Use, duplication or disclosure of the
software and documentation
I. 03/12 07:56:47. by the U.S. Government is subject to
restrictions set forth in a license
I. 03/12 07:56:47. agreement between the Government and
iAnywhere Solutions, Inc. or
I. 03/12 07:56:47. other written agreement specifying the
Government's rights to use the
I. 03/12 07:56:47. software and any applicable FAR
provisions, for example, FAR 52.227-19.
I. 03/12 07:56:47.
I. 03/12 07:56:47. Sybase, Inc., One Sybase Drive, Dublin,
CA 94568, USA
I. 03/12 07:56:47.
I. 03/12 07:56:47. Networked Seat (per-seat) model. Access
to the server is limited to 1 seat(s).
                   This server is licensed to:
I. 03/12 07:56:47.     "BrightDairy"
I. 03/12 07:56:47.     "BrightDairy"
I. 03/12 07:56:48. <Main>: MobiLink server started
I. 03/12 07:56:48. <Main>: Option 1: -c
I. 03/12 07:56:48. <Main>: Option 2: ****************
I. 03/12 07:56:48. <Main>: Option 3: -w
I. 03/12 07:56:48. <Main>: Option 4: 20
I. 03/12 07:56:48. <Main>: Option 5: -wu
I. 03/12 07:56:48. <Main>: Option 6: 10
I. 03/12 07:56:48. <Main>: Option 7: -cn
I. 03/12 07:56:48. <Main>: Option 8: 21
I. 03/12 07:56:48. <Main>: Option 9: -v
I. 03/12 07:56:48. <Main>: Option 10: cnrst
I. 03/12 07:56:48. <Main>: Option 11: -zu+
I. 03/12 07:56:48. <Main>: Option 12: -zwd
I. 03/12 07:56:48. <Main>: Verbose logging: show row values
I. 03/12 07:56:48. <Main>: Verbose logging: show script
names when invoked
I. 03/12 07:56:48. <Main>: Verbose logging: show script
contents when invoked
I. 03/12 07:56:48. <Main>: Verbose logging: show translated
SQL for prepared statements
I. 03/12 07:56:48. <Main>: Verbose logging: show rowcount
values
I. 03/12 07:56:48. <Main>: Individual database connections
will be closed after synchronization errors.
I. 03/12 07:56:48. <Main>: BLOB cache size: 524288
I. 03/12 07:56:48. <Main>: Maximum number of BLOB bytes to
compare: 4294967295
I. 03/12 07:56:48. <Main>: Maximum number of database
connections: 21
I. 03/12 07:56:48. <Main>: Maximum number of deadlock
retries: 10
I. 03/12 07:56:48. <Main>: Timeout for inactive database
connections: 60 minutes
I. 03/12 07:56:48. <Main>: Maximum delay between retries
after deadlock: 30 seconds
I. 03/12 07:56:48. <Main>: Rowset size: 10
I. 03/12 07:56:48. <Main>: Upload cache size: 524288 bytes
I. 03/12 07:56:48. <Main>: Download cache size: 524288 bytes
I. 03/12 07:56:48. <Main>: Number of worker threads: 20
I. 03/12 07:56:48. <Main>: Maximum number of threads
uploading concurrently: 10
I. 03/12 07:56:48. <Main>: Warning: Unknown users will be
added automatically (when there is no authenticate_user
script).
I. 03/12 07:56:48. <Main>: Pass last download timestamp
first.
I. 03/12 07:56:48. <Main>: Example scripts will not be
automatically generated for unknown versions.
I. 03/12 07:56:48. <Main>: Local file for remote
synchronization logs: 'dbmlsrv.mle'
I. 03/12 07:56:48. <Main>: Stream specifier 1: tcpip
E. 03/12 08:00:03. <Main>: Error: ODBC: [MERANT][ODBC Oracle
driver][Oracle]ORA-12535: TNS:operation timed out
                    (ODBC State = HY000, Native error code =
12535)
I. 03/12 08:00:03. <Main>: MobiLink server finished
I. 03/12 08:08:37. Adaptive Server Anywhere MobiLink Version
8.0.2.3608
I. 03/12 08:08:37.
I. 03/12 08:08:37. Copyright (c) 1989-2002 Sybase, Inc.
                   Portions Copyright (c) 2002, iAnywhere
Solutions, Inc.
I. 03/12 08:08:37. All rights reserved. All unpublished
rights reserved.
I. 03/12 08:08:37.
I. 03/12 08:08:37. This software contains confidential and
trade secret information of
I. 03/12 08:08:37. iAnywhere Solutions, Inc.
                   Use, duplication or disclosure of the
software and documentation
I. 03/12 08:08:37. by the U.S. Government is subject to
restrictions set forth in a license
I. 03/12 08:08:37. agreement between the Government and
iAnywhere Solutions, Inc. or
I. 03/12 08:08:37. other written agreement specifying the
Government's rights to use the
I. 03/12 08:08:37. software and any applicable FAR
provisions, for example, FAR 52.227-19.
I. 03/12 08:08:37.
I. 03/12 08:08:37. Sybase, Inc., One Sybase Drive, Dublin,
CA 94568, USA
I. 03/12 08:08:37.
I. 03/12 08:08:37. Networked Seat (per-seat) model. Access
to the server is limited to 1 seat(s).
                   This server is licensed to:
I. 03/12 08:08:37.     "BrightDairy"
I. 03/12 08:08:37.     "BrightDairy"
I. 03/12 08:08:37. <Main>: MobiLink server started
I. 03/12 08:08:37. <Main>: Option 1: -c
I. 03/12 08:08:37. <Main>: Option 2: ****************
I. 03/12 08:08:37. <Main>: Option 3: -w
I. 03/12 08:08:37. <Main>: Option 4: 20
I. 03/12 08:08:37. <Main>: Option 5: -wu
I. 03/12 08:08:37. <Main>: Option 6: 10
I. 03/12 08:08:37. <Main>: Option 7: -cn
I. 03/12 08:08:37. <Main>: Option 8: 21
I. 03/12 08:08:37. <Main>: Option 9: -v
I. 03/12 08:08:37. <Main>: Option 10: cnrst
I. 03/12 08:08:37. <Main>: Option 11: -zu+
I. 03/12 08:08:37. <Main>: Option 12: -zwd
I. 03/12 08:08:37. <Main>: Verbose logging: show row values
I. 03/12 08:08:37. <Main>: Verbose logging: show script
names when invoked
I. 03/12 08:08:37. <Main>: Verbose logging: show script
contents when invoked
I. 03/12 08:08:37. <Main>: Verbose logging: show translated
SQL for prepared statements
I. 03/12 08:08:37. <Main>: Verbose logging: show rowcount
values
I. 03/12 08:08:37. <Main>: Individual database connections
will be closed after synchronization errors.
I. 03/12 08:08:37. <Main>: BLOB cache size: 524288
I. 03/12 08:08:37. <Main>: Maximum number of BLOB bytes to
compare: 4294967295
I. 03/12 08:08:37. <Main>: Maximum number of database
connections: 21
I. 03/12 08:08:37. <Main>: Maximum number of deadlock
retries: 10
I. 03/12 08:08:37. <Main>: Timeout for inactive database
connections: 60 minutes
I. 03/12 08:08:37. <Main>: Maximum delay between retries
after deadlock: 30 seconds
I. 03/12 08:08:38. <Main>: Rowset size: 10
I. 03/12 08:08:38. <Main>: Upload cache size: 524288 bytes
I. 03/12 08:08:38. <Main>: Download cache size: 524288 bytes
I. 03/12 08:08:38. <Main>: Number of worker threads: 20
I. 03/12 08:08:38. <Main>: Maximum number of threads
uploading concurrently: 10
I. 03/12 08:08:38. <Main>: Warning: Unknown users will be
added automatically (when there is no authenticate_user
script).
I. 03/12 08:08:38. <Main>: Pass last download timestamp
first.
I. 03/12 08:08:38. <Main>: Example scripts will not be
automatically generated for unknown versions.
I. 03/12 08:08:38. <Main>: Local file for remote
synchronization logs: 'dbmlsrv.mle'
I. 03/12 08:08:38. <Main>: Stream specifier 1: tcpip
E. 03/12 08:11:53. <Main>: Error: ODBC: [MERANT][ODBC Oracle
driver][Oracle]ORA-12535: TNS:operation timed out
                    (ODBC State = HY000, Native error code =
12535)
I. 03/12 08:11:53. <Main>: MobiLink server finished
I. 03/12 08:20:47. Adaptive Server Anywhere MobiLink Version
8.0.2.3608
I. 03/12 08:20:47.
I. 03/12 08:20:47. Copyright (c) 1989-2002 Sybase, Inc.
                   Portions Copyright (c) 2002, iAnywhere
Solutions, Inc.
I. 03/12 08:20:47. All rights reserved. All unpublished
rights reserved.
I. 03/12 08:20:47.
I. 03/12 08:20:47. This software contains confidential and
trade secret information of
I. 03/12 08:20:47. iAnywhere Solutions, Inc.
                   Use, duplication or disclosure of the
software and documentation
I. 03/12 08:20:47. by the U.S. Government is subject to
restrictions set forth in a license
I. 03/12 08:20:47. agreement between the Government and
iAnywhere Solutions, Inc. or
I. 03/12 08:20:47. other written agreement specifying the
Government's rights to use the
I. 03/12 08:20:47. software and any applicable FAR
provisions, for example, FAR 52.227-19.
I. 03/12 08:20:47.
I. 03/12 08:20:47. Sybase, Inc., One Sybase Drive, Dublin,
CA 94568, USA
I. 03/12 08:20:47.
I. 03/12 08:20:47. Networked Seat (per-seat) model. Access
to the server is limited to 1 seat(s).
                   This server is licensed to:
I. 03/12 08:20:47.     "BrightDairy"
I. 03/12 08:20:47.     "BrightDairy"
I. 03/12 08:20:47. <Main>: MobiLink server started
I. 03/12 08:20:47. <Main>: Option 1: -c
I. 03/12 08:20:47. <Main>: Option 2: ****************
I. 03/12 08:20:47. <Main>: Option 3: -w
I. 03/12 08:20:47. <Main>: Option 4: 20
I. 03/12 08:20:47. <Main>: Option 5: -wu
I. 03/12 08:20:47. <Main>: Option 6: 10
I. 03/12 08:20:47. <Main>: Option 7: -cn
I. 03/12 08:20:47. <Main>: Option 8: 21
I. 03/12 08:20:47. <Main>: Option 9: -v
I. 03/12 08:20:47. <Main>: Option 10: cnrst
I. 03/12 08:20:47. <Main>: Option 11: -zu+
I. 03/12 08:20:47. <Main>: Option 12: -zwd
I. 03/12 08:20:47. <Main>: Verbose logging: show row values
I. 03/12 08:20:47. <Main>: Verbose logging: show script
names when invoked
I. 03/12 08:20:47. <Main>: Verbose logging: show script
contents when invoked
I. 03/12 08:20:47. <Main>: Verbose logging: show translated
SQL for prepared statements
I. 03/12 08:20:47. <Main>: Verbose logging: show rowcount
values
I. 03/12 08:20:47. <Main>: Individual database connections
will be closed after synchronization errors.
I. 03/12 08:20:47. <Main>: BLOB cache size: 524288
I. 03/12 08:20:47. <Main>: Maximum number of BLOB bytes to
compare: 4294967295
I. 03/12 08:20:47. <Main>: Maximum number of database
connections: 21
I. 03/12 08:20:47. <Main>: Maximum number of deadlock
retries: 10
I. 03/12 08:20:47. <Main>: Timeout for inactive database
connections: 60 minutes
I. 03/12 08:20:47. <Main>: Maximum delay between retries
after deadlock: 30 seconds
I. 03/12 08:20:47. <Main>: Rowset size: 10
I. 03/12 08:20:47. <Main>: Upload cache size: 524288 bytes
I. 03/12 08:20:47. <Main>: Download cache size: 524288 bytes
I. 03/12 08:20:47. <Main>: Number of worker threads: 20
I. 03/12 08:20:47. <Main>: Maximum number of threads
uploading concurrently: 10
I. 03/12 08:20:47. <Main>: Warning: Unknown users will be
added automatically (when there is no authenticate_user
script).
I. 03/12 08:20:47. <Main>: Pass last download timestamp
first.
I. 03/12 08:20:47. <Main>: Example scripts will not be
automatically generated for unknown versions.
I. 03/12 08:20:47. <Main>: Local file for remote
synchronization logs: 'dbmlsrv.mle'
I. 03/12 08:20:47. <Main>: Stream specifier 1: tcpip
I. 03/12 08:20:48. <Main>: ODBC DBMS Name: Oracle
I. 03/12 08:20:48. <Main>: ODBC DBMS Version: 08.00.0006
Oracle 8.0.6.1.0
I. 03/12 08:20:48. <Main>: ODBC DBMS Driver Version:
04.00.0045
I. 03/12 08:20:48. <Main>: ODBC Version supported by the
driver: 3.51
I. 03/12 08:20:48. <Main>: ODBC isolation set to: Read
Committed
I. 03/12 08:20:48. <Main>: Connected
I. 03/12 08:20:49. <Main>: Translated SQL:
                   SELECT COUNT(*) FROM ml_scripts_modified
I. 03/12 08:20:49. <thread 1.1>: Ready to handle requests
I. 03/12 08:20:49. <thread 1.2>: Ready to handle requests
I. 03/12 08:20:49. <thread 1.3>: Ready to handle requests
I. 03/12 08:20:49. <thread 1.4>: Ready to handle requests
I. 03/12 08:20:49. <thread 1.5>: Ready to handle requests
I. 03/12 08:20:49. <thread 1.6>: Ready to handle requests
I. 03/12 08:20:49. <thread 1.7>: Ready to handle requests
I. 03/12 08:20:49. <thread 1.8>: Ready to handle requests
I. 03/12 08:20:49. <thread 1.9>: Ready to handle requests
I. 03/12 08:20:49. <thread 1.10>: Ready to handle requests
I. 03/12 08:20:49. <thread 1.11>: Ready to handle requests
I. 03/12 08:20:49. <thread 1.12>: Ready to handle requests
I. 03/12 08:20:49. <thread 1.13>: Ready to handle requests
I. 03/12 08:20:49. <thread 1.14>: Ready to handle requests
I. 03/12 08:20:49. <thread 1.15>: Ready to handle requests
I. 03/12 08:20:49. <thread 1.16>: Ready to handle requests
I. 03/12 08:20:49. <thread 1.17>: Ready to handle requests
I. 03/12 08:20:49. <thread 1.18>: Ready to handle requests
I. 03/12 08:20:49. <thread 1.19>: Ready to handle requests
I. 03/12 08:20:49. <thread 1.20>: Ready to handle requests
I. 03/12 08:20:51. <Main>: Press 'q' to quit MobiLink server
0
yan
3/22/2004 1:57:28 AM
There are a couple of potential problems with your startup script.  I've 
put comments inline below.

greg.fenton


yan.shui wrote:
> 
> . /opt/sybase/SYBSsa8/bin/asa_config.sh
> export ORACLE_HOME=/opt/oracle/product/8.1.7
> export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib

The value here should be in double-quotes just in case the existing 
value of LD_LIBRARY_PATH contains spaces:

    export LD_LIBRARY_PATH="$LD_LIBRARY_PATH:$ORACLE_HOME/lib"

[Okay, so I'm being paranoid].  Personally, I double-quote all variable 
values in my shell scripts (it's a good habit to be in if you ever have 
to write scripts for environments where the GUI allows users to create 
files with spaces in the filename).


> export PATH=$PATH:$ORACLE_HOME/bin
> export ODBCINI=~/.odbc.ini

The value of "~" may not be defined, might be ambiguous during boot-up 
or may not be interpreted the same by all shells.  Consider replacing 
this with the full to your .odbc.ini file.

> export NLS_LANG="SIMPLIFIED CHINESE"
> /opt/sybase/SYBSsa8/bin/dbmlsrv8 -c "dsn=Oracle" -w 20 -wu
> 10 -cn 21 -o "pdalog/sync.log" -os 10000000 -v cnrst -zu+
> -zwd -ud
> 

Your script does not "cd" anywhere, so the location of the output file 
"pdalog/sync.log" is ambiguous.  Also, since you are using the "-ud" 
flag, the server actually does a "cd" before it separates its child 
process...again the location of the output file is ambiguous.  Consider 
adding the full path for the location of that file.

Hope this helps,
greg.fenton
-- 
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
0
Greg
3/22/2004 3:03:47 PM
Reply: