Hi Samuel, Regarding the error, sounds you are not configuring DCS Master host correctly, the Host Name displayed is "trafodion", but should be "ubuntu-1", you can edit $MY_SQROOT/trafci/bin/trafci and correct it to retry. >trafodion@ubuntu-1:~$ trafci >Welcome to Apache Trafodion Command Interface Copyright (c) 2015-2016 >Apache Software Foundation Host Name/IP Address: trafodion:23400 User >Name: trafodion >*** ERROR[1] The message id: as_connect_message_error With parameters: >server handle not available >*** ERROR[1] The message id: as_connect_message_error With parameters: >server handle not available >*** ERROR[1] The message id: as_connect_message_error With parameters: >server handle not available Can you please help ?
Best regards, Jason -----Original Message----- From: Elitelco [mailto:samuel.lepe...@elitelco.net] Sent: Saturday, October 15, 2016 5:41 PM To: dev@trafodion.incubator.apache.org Subject: Running trafodion on Ubuntu 16 >Hi >we have installed trafodion on Ubuntu 16 distribution. >After few modifications in scripts and librairies, trafodion DB seems to be up >and running: >----------------------------------------------------------------------- >----------------------------------------------------------------------- >------------- >trafodion@ubuntu-1:~/apache-trafodion_server-2.0.1-incubating/sql/scrip >ts$ ./sqstart Checking orphan processes. >Removing old mpijob* files from >/home/trafodion/apache-trafodion_server-2.0.1-incubating/tmp >Removing old monitor.port* files from >/home/trafodion/apache-trafodion_server-2.0.1-incubating/tmp >Executing sqipcrm (output to sqipcrm.out) Starting the SQ Environment >(Executing >/home/trafodion/apache-trafodion_server-2.0.1-incubating/sql/scripts/go >mon.cold) >Background SQ Startup job (pid: 24645) ># of SQ processes: 26 ......... >SQ Startup script >(/home/trafodion/apache-trafodion_server-2.0.1-incubating/sql/scripts/gomon.cold) > ran successfully. Performing further checks... >Checking if processes are up. >Checking attempt: 1; user specified max: 2. Execution time in seconds: 0. >The SQ environment is up! >Process Configured Actual Down >------- ---------- ------ ---- DTM 2 > >2 RMS 4 4 DcsMaster 1 1 >DcsServer 1 1 mxosrvr 8 0 >8 vendredi 14 octobre 2016, 16:36:28 (UTC+0200) Checking if processes >are up. >Checking attempt: 1; user specified max: 1. Execution time in seconds: 0. >The SQ environment is up! >Process Configured Actual Down >------- ---------- ------ ---- DTM 2 > >2 RMS 4 4 DcsMaster 1 1 >DcsServer 1 1 mxosrvr 8 0 >8 Starting the DCS environment now master 20503. Stop it first. >ubuntu-1: server 20915. Stop it first. >Checking if processes are up. >Checking attempt: 1; user specified max: 2. Execution time in seconds: 0. >The SQ environment is up! >Process Configured Actual Down >------- ---------- ------ ---- DTM 2 > >2 RMS 4 4 DcsMaster 1 1 >DcsServer 1 1 mxosrvr 8 0 >8 Checking if processes are up. >Checking attempt: 1; user specified max: 1. Execution time in seconds: 0. >The SQ environment is up! >Process Configured Actual Down >------- ---------- ------ ---- DTM 2 > >2 RMS 4 4 DcsMaster 1 1 >DcsServer 1 1 mxosrvr 8 0 >8 Starting the REST environment now starting rest, logging to >/home/trafodion/apache-trafodion_server-2.0.1-incubating/rest-2.0.1/bin >/../logs/rest-trafodion-1-rest-ubuntu-1.out >Zookeeper listen port: 2181 >DcsMaster listen port: 23400 >Configured Primary DcsMaster: "trafodion" >Active DcsMaster : "localhost", pid 20503 Process >Configured Actual Down >--------- ---------- ------ ---- DcsMaster 1 > >1 DcsServer 1 1 mxosrvr 8 0 > >8 You can monitor the SQ shell log file : >/home/trafodion/apache-trafodion_server-2.0.1-incubating/logs/sqmon.log >Startup time 0 hour(s) 3 minute(s) 38 second(s) >----------------------------------------------------------------------- >----------------------------------------------------------------------- >------------- However, when we launch trafci for testing DB, we have an >error: >trafodion@ubuntu-1:~$ trafci >Welcome to Apache Trafodion Command Interface Copyright (c) 2015-2016 >Apache Software Foundation Host Name/IP Address: trafodion:23400 User >Name: trafodion >*** ERROR[1] The message id: as_connect_message_error With parameters: >server handle not available >*** ERROR[1] The message id: as_connect_message_error With parameters: >server handle not available >*** ERROR[1] The message id: as_connect_message_error With parameters: >server handle not available Can you please help ? >By the way, 23400 port is listenning: >trafodion@ubuntu-1:~/apache-trafodion_server-2.0.1-incubating/sql/scrip >ts$ netstat -a|grep 23400 >tcp6 0 0 [::]:23400 [::]:* >LISTEN And if we try sqlci: >trafodion@ubuntu-1:~$ sqlci >Apache Trafodion Conversational Interface 2.0.1 Copyright (c) 2015-2016 >Apache Software Foundation >*** ERROR[2055] The specified value '0.001' for DEFAULTS attribute >WORK_UNIT_ESP_DATA_COPY_COST is not valid. >regards >Samuel