Discussion :

[davinium]

Bonjour !


J'essaye de créer un serveur Sybase ASE-15 express edition sur un distribution Cent OS
à base d'un noyau linux 2.6.18-8.1.15.el5

Passer la phase d'installation réussi de sybase sur mon système j'essaye alors de créer un server mais une erreur m'empêche de le faire :

pour le faire J' utilise la commande :

./srvbuildres -r sqlsrv.res

Le contenu de mon fichier : sqlsrv.res
-------------------------------------
sybinit.release_directory: /opt/sybase
sybinit.product: sqlsrv
sqlsrv.server_name: SYB_CENT_OS
sqlsrv.new_config: yes
sqlsrv.do_add_server: yes
sqlsrv.network_protocol_list: tcp
sqlsrv.network_hostname_list: localhost
sqlsrv.network_port_list: 5000
sqlsrv.server_page_size: 16k
sqlsrv.force_buildmaster: yes
sqlsrv.master_device_physical_name: /opt/sybase/data/master.dat
sqlsrv.master_device_size: 240
sqlsrv.master_database_size: 104
sqlsrv.errorlog: /var/log/sybase/ASE-15_0/install/SYB_CENT_OS.log
sqlsrv.do_upgrade: no
sqlsrv.sybsystemprocs_device_physical_name: /opt/sybase/data/sysprocs.dat
sqlsrv.sybsystemprocs_device_size: 132
sqlsrv.sybsystemprocs_database_size: 132
sqlsrv.sybsystemdb_device_physical_name: /opt/sybase/data/sybsysdb.dat
sqlsrv.sybsystemdb_device_size: 4
---------------------------------------------

Voivi la log générée pendant la tentative de création du serveur :
---------------------------------------------
[sybase@Cent_OS bin]$ ./srvbuildres -r sqlsrv.res

Building Adaptive Server 'SYB_CENT_OS':
Writing entry into directory services...
Directory services entry complete.
Building master device...
sh: line 1: 23374 Segmentation fault /opt/sybase/ASE-15_0/bin/dataserver -d/opt/sybase/data/master.dat -b240M -z16k -sSYB_CENT_OS -e/var/log/sybase/ASE-15_0/install/SYB_CENT_OS.log -T1623 -f >/tmp/sbmoD7xe 2>&1
Task failed
dataserver: master device size for this server: 240.0 Mb
dataserver: master database size for this server: 104.0 Mb
dataserver: model database size for this server: 24.0 Mb
00:00000:00000:2007/11/04 13:55:17.93 kernel SySAM: Using licenses from: /opt/sybase/SYSAM-2_0/licenses
00:00000:00000:2007/11/04 13:55:18.43 kernel SySAM: Checked out license for 1 ASE_CORE (2009.1231/permanent/1D35 365A 76EE F11F).
00:00000:00000:2007/11/04 13:55:19.87 kernel This product is licensed to: ASE Express Edition Free Deployment License
00:00000:00000:2007/11/04 13:55:19.87 kernel Checked out license ASE_CORE
00:00000:00000:2007/11/04 13:55:19.87 kernel Adaptive Server Enterprise Express Edition. (Limits: 1 Engine, 2GB Memory, 5GB Disk space).
00:00000:00000:2007/11/04 13:55:19.89 kernel Initializing device /opt/sybase/data/master.dat from offset 0 with zeros.
00:00000:00000:2007/11/04 13:55:24.69 kernel Finished initialization.
00:00000:00000:2007/11/04 13:55:24.73 kernel Using config area from primary master device.
00:00000:00000:2007/11/04 13:55:24.79 kernel Warning: Using default file '/opt/sybase/SYB_CENT_OS.cfg' since a configuration file was not specified. Specify a configuration file name in the RUNSERVER file to avoid this message.
00:00000:00000:2007/11/04 13:55:25.63 kernel SySAM: Checked out graced license for 1 ASE_ASM (2007.0524) will expire Tue Dec 4 13:55:18 2007.
00:00000:00000:2007/11/04 13:55:25.63 kernel SySAM: Failed to obtain 1 license(s) for ASE_ASM feature with properties 'PE=XE;AS=A'.
00:00000:00000:2007/11/04 13:55:25.63 kernel Error: 131275, Severity: 17, State: 1
00:00000:00000:2007/11/04 13:55:25.65 kernel SySAM: WARNING: ASE functionality that requires the ASE_ASM license will be disabled on Tue Dec 4 13:55:18 2007, unless a suitable ASE_ASM license is obtained before that date.
00:00000:00000:2007/11/04 13:55:26.85 kernel Checked out license ASE_ASM
Checked out License : ASE_ASM as graced
00:00000:00000:2007/11/04 13:55:26.89 kernel os_create_keyfile: Removed old segment /opt/sybase/SYB_CENT_OS.krg
00:00000:00000:2007/11/04 13:55:26.90 kernel Internal run-time model set for Linux - Native
00:00000:00000:2007/11/04 13:55:26.90 kernel Using 1024 file descriptors.
00:00000:00000:2007/11/04 13:55:26.90 kernel Adaptive Server Enterprise/15.0.2/EBF 14331/P/Linux Intel/Linux 2.4.21-47.ELsmp i686/ase1502/2486/32-bit/FBO/Thu May 24 08:15:50 2007
00:00000:00000:2007/11/04 13:55:26.90 kernel Confidential property of Sybase, Inc.
00:00000:00000:2007/11/04 13:55:26.90 kernel Copyright 1987, 2007
00:00000:00000:2007/11/04 13:55:26.90 kernel Sybase, Inc. All rights reserved.
00:00000:00000:2007/11/04 13:55:26.90 kernel Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2007/11/04 13:55:26.90 kernel
00:00000:00000:2007/11/04 13:55:26.90 kernel This software contains confidential and trade secret information of Sybase,
00:00000:00000:2007/11/04 13:55:26.90 kernel Inc. Use, duplication or disclosure of the software and documentation by
00:00000:00000:2007/11/04 13:55:26.90 kernel the U.S. Government is subject to restrictions set forth in a license
00:00000:00000:2007/11/04 13:55:26.90 kernel agreement between the Government and Sybase, Inc. or other written
00:00000:00000:2007/11/04 13:55:26.90 kernel agreement specifying the Government's rights to use the software and any
00:00000:00000:2007/11/04 13:55:26.90 kernel applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2007/11/04 13:55:26.90 kernel Sybase, Inc. One Sybase Drive, Dublin, CA 94568, USA
00:00000:00000:2007/11/04 13:55:26.90 kernel Using /opt/sybase as the 'SYBASE' environment variable, found during startup.
00:00000:00000:2007/11/04 13:55:26.90 kernel Using OCS-15_0 as the 'SYBASE_OCS' environment variable, found during startup.
00:00000:00000:2007/11/04 13:55:26.90 kernel ASE booted on Linux release 2.6.18-8.1.15.el5 version #1 SMP Mon Oct 22 08:32:04 EDT 2007.
00:00000:00000:2007/11/04 13:55:26.90 kernel Using '/opt/sybase/SYB_CENT_OS.cfg' for configuration information.
00:00000:00000:2007/11/04 13:55:26.90 kernel Logging ASE messages in file '/var/log/sybase/ASE-15_0/install/SYB_CENT_OS.log'.
00:00000:00000:2007/11/04 13:55:26.90 kernel Platform TCP network is forced to IPv4-only.
00:00000:00000:2007/11/04 13:55:26.90 kernel ASE booted with TCP_NODELAY enabled.
00:00000:00000:2007/11/04 13:55:26.92 kernel SSL Plus v5.0.4 security modules loaded successfully.
00:00000:00000:2007/11/04 13:55:26.92 kernel Network and device connection limit is 1009.
00:00000:00000:2007/11/04 13:55:27.37 server Number of blocks left for proc headers: 6960.
00:00000:00000:2007/11/04 13:55:27.38 server Proc header memory allocated 1392 pages for each per engine cache
00:00000:00000:2007/11/04 13:55:27.44 server Size of the 16K memory pool: 8192 Kb
00:00000:00000:2007/11/04 13:55:27.44 server Memory allocated for the default data cache cachelet 1: 8192 Kb
00:00000:00000:2007/11/04 13:55:27.45 kernel Enabling Linux Native Kernel asynchronous disk I/O strategy.
00:00000:00000:2007/11/04 13:55:27.45 kernel Initializing virtual device 0, '/opt/sybase/data/master.dat' with dsync 'off'.
00:00000:00000:2007/11/04 13:55:27.45 kernel Virtual device 0 started using asynchronous i/o.
00:00000:00000:2007/11/04 13:55:27.45 server Loaded default Unilib conversion handle.
00:00000:00000:2007/11/04 13:55:27.50 kernel Worker Thread Manager is not enabled for use in ASE.
00:00000:00000:2007/11/04 13:55:27.53 kernel kdcl_sess_open: connectivity library supports master/query syntax.
00:00000:00000:2007/11/04 13:55:27.54 server No security mechanisms were listed against the server 'SYB_CENT_OS'.
00:00000:00000:2007/11/04 13:55:27.54 kernel Unix interval timer enabled for sysclk interrupts.
00:00000:00000:2007/11/04 13:55:27.59 kernel Begin processing to generate RSA keypair.
00:00000:00000:2007/11/04 13:55:27.72 kernel Completed processing to generate RSA keypair.
00:00000:00000:2007/11/04 13:55:27.72 kernel Encryption provider initialization succeeded on engine 0.
00:00000:00000:2007/11/04 13:55:27.72 kernel engine 0, os pid 23374 online
Server 'SYB_CENT_OS' was not created.
-------------------------------------------------

d' apres ce que j'ai compris la base master ne peut-être crée et il semble y avoir un probléme de licence.

je suis novice sur sybase, pourriez vous m'eclairé ?

Merci beaucoup

[mpeppler]

Essaye de faire

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
 
export LD_POINTER_GUARD=1

avant de lancer le srvbuildres.

Voir aussi: http://www.peppler.org/FAQ/linux.html#q1.25

[davinium]

bien vu !


export LD_POINTER_GUARD=1

Cela n'a pas fonctionné car la version Cent_os que j'utilse est l'équivalente d'une RHEL5 elle même basé sur une fedora 6,
par contre export LD_POINTER_GUARD=0 ca fonctionne



j'ai un autre souci, j'ai éffectué un shutdown du server apres my être connecté avec isql,
et je n'arrive pas a trouvé le fichier de démarrage sybase RUN_Syb_cent_os
donc impossible de faire un ~/install/startserver -f RUN_Syb_cent_os
ou devrait 'il être normalement lors de sa creation ./srvbuildres -r sqlsrv.res ?

Par contre ./srvbuildres -r sqlsrv.res ma crée plein de fichiers de configuration
Syb_Cent_os.01,02,03 ... voir ci dessous mon répertoire ASE-15, pourquoi autant de fichier qui semblent identique ?

drwxr-xr-x 2 sybase sybase 4096 Nov 5 16:16 bin
drwxr-xr-x 2 sybase sybase 4096 Nov 4 14:59 certificates
drwxr-xr-x 7 sybase sybase 4096 Nov 4 14:59 init
drwxr-xr-x 3 sybase sybase 4096 Nov 5 16:47 install
drwxr-xr-x 2 sybase sybase 4096 Nov 4 15:00 lib
drwxr-xr-x 4 sybase sybase 4096 Nov 4 15:01 locales
drwxr-xr-x 8 sybase sybase 4096 Nov 4 14:59 sample
drwxr-xr-x 6 sybase sybase 4096 Nov 5 16:13 scripts
-rwxr-xr-x 1 root root 925 Nov 5 13:31 sqlsrv.bak
-rwxr-xr-x 1 sybase sybase 931 Nov 5 13:40 sqlsrv.res
-rwxr-xr-x 1 sybase sybase 9620 Nov 5 14:43 Syb_Cent_os.001
-rwxr-xr-x 1 sybase sybase 9690 Nov 5 14:43 Syb_Cent_os.002
-rwxr-xr-x 1 sybase sybase 9696 Nov 5 14:43 Syb_Cent_os.003
-rwxr-xr-x 1 sybase sybase 9690 Nov 5 14:43 Syb_Cent_os.004
-rwxr-xr-x 1 sybase sybase 9696 Nov 5 14:44 Syb_Cent_os.005
-rwxr-xr-x 1 sybase sybase 9690 Nov 5 14:44 Syb_Cent_os.006
-rwxr-xr-x 1 sybase sybase 9696 Nov 5 14:44 Syb_Cent_os.007
-rwxr-xr-x 1 sybase sybase 9690 Nov 5 14:44 Syb_Cent_os.008
-rwxr-xr-x 1 sybase sybase 9696 Nov 5 14:44 Syb_Cent_os.009
-rwxr-xr-x 1 sybase sybase 9690 Nov 5 14:44 Syb_Cent_os.010
-rwxr-xr-x 1 sybase sybase 9696 Nov 5 14:44 Syb_Cent_os.011
-rwxr-xr-x 1 sybase sybase 9690 Nov 5 14:44 Syb_Cent_os.012
-rwxr-xr-x 1 sybase sybase 9696 Nov 5 14:44 Syb_Cent_os.013
-rwxr-xr-x 1 sybase sybase 9690 Nov 5 14:44 Syb_Cent_os.014
-rwxr-xr-x 1 sybase sybase 9696 Nov 5 14:44 Syb_Cent_os.015
-rwxr-xr-x 1 sybase sybase 9690 Nov 5 14:44 Syb_Cent_os.016
-rwxr-xr-x 1 sybase sybase 9696 Nov 5 14:44 Syb_Cent_os.017
-rwxr-xr-x 1 sybase sybase 9690 Nov 5 14:44 Syb_Cent_os.018
-rwxr-xr-x 1 sybase sybase 9696 Nov 5 14:45 Syb_Cent_os.bak
-rwxr-xr-x 1 sybase sybase 9696 Nov 5 14:44 Syb_Cent_os.cfg
drwxr-xr-x 5 sybase sybase 4096 Nov 4 15:00 sybhelp
drwxr-xr-x 2 sybase sybase 4096 Nov 5 17:13 sysam
drwxr-xr-x 2 sybase sybase 4096 Nov 4 15:01 ThirdPartyLegal
drwxr-xr-x 2 sybase sybase 4096 Nov 4 15:00 upgrade
drwxr-xr-x 2 sybase sybase 4096 Nov 4 15:00 xappdefaults


Pourtant le nom de mon server crée est bien référencer dans le fichier interface :

Syb_Cent_os
master tcp ether 127.0.0.1 5000
query tcp ether 127.0.0.1 5000





Merci Mpeppler pour ton aide et pour le lien de la FAQ linux sybase qui est trés pratique.

[mpeppler]

Le "RUN_xxx" est normallement dans $SYBASE/$SYBASE_ASE/install.

Pour ce qui est des fichiers de config - un nouveau fichier est automatiquement généré chaque fois qu'on exécute sp_configure. Lors de la création du serveur sp_configure est exécuté un bon nombre de fois, d'où tous ces fichiers. Tu peux tranquillement les effacer (cad tous ceux qui finissent par .0xx) - ils servent simplement pour pouvoir faire retour arrière si on se trompe dans un sp_configure et que le dataserver ne démarre plus...

Michael