Hi, Pierre, One can also use ‘dcscheck’ to show the ODBC/JDBC port number if one not using the standard port number in http://trafodion.apache.org/port-assignment.html For example, 23400 was used by another application and one have to change it.
Thanks, Ming 发件人: Pierre Smits [mailto:[email protected]] 发送时间: 2016年3月28日 1:29 收件人: [email protected] 主题: Re: Trafodion 1.3 Sandbox Hi Amanda, Resolved that step too. This helped: http://trafodion.apache.org/port-assignment.html Best regards, Pierre Smits ORRTIZ.COM<http://www.orrtiz.com> OFBiz based solutions & services OFBiz Extensions Marketplace http://oem.ofbizci.net/oci-2/ On Sun, Mar 27, 2016 at 6:25 PM, Pierre Smits <[email protected]<mailto:[email protected]>> wrote: HI Amanda, Everything worked out fine. Now I am trying to connect from my mac where the VirtualBox runs and into which I imported the download. For this I installed locally the t4driver and SQuirrel SQL client. But I can't connect to the running VirtualBox instance. Where can I check the port to connect to? Best regards, Pierre Smits ORRTIZ.COM<http://www.orrtiz.com> OFBiz based solutions & services OFBiz Extensions Marketplace http://oem.ofbizci.net/oci-2/ On Sun, Mar 27, 2016 at 4:27 PM, Amanda Moran <[email protected]<mailto:[email protected]>> wrote: Sorry all! Forgot that in the steps! admin:admin This is the default for HDP. Thanks! Sent from my iPhone On Mar 27, 2016, at 7:21 AM, Pierre Smits <[email protected]<mailto:[email protected]>> wrote: Hi Amanda, The steps up to #5 worked like a breeze. I used root/traf123 to login. #6: Open the browser and open Ambari to start all services didn't work. Starting this requires a userId and password too. So I couldn't continue. Best regards, Pierre Smits ORRTIZ.COM<http://www.orrtiz.com> OFBiz based solutions & services OFBiz Extensions Marketplace http://oem.ofbizci.net/oci-2/ On Fri, Mar 25, 2016 at 9:48 PM, Amanda Moran <[email protected]<mailto:[email protected]>> wrote: Hi there All- I have created a Trafodion 1.3 VirtualBox VM with HDP 2.2. https://www.dropbox.com/s/5i2fk4nbpltw11m/trafodion_1.3.ova?dl=0 Instructions 1. Download sandbox (this will take a bit of time :)) 2. Import Sandbox into VirtualBox 3. Under "Settings-> Network" you will need to toggle these settings to match your set up, so that you have an internet connect on the VM and a way to access the VM via putty/winscp etc. This will take some experimenting on your part. HDP has issues starting up if this isn't set correcting. 4. Start VM 5. Select "other" at log in: root/traf123 or log in as trafodion/traf123 6. Open Firefox -> Open Ambari (localhost:8080) -> Start All services 7. Once everything is started open a terminal -> hbase shell -> status (If no errors come up then everything started correctly... do not try to start Trafodion if HDFS/HBase has not come up). 8. sudo su trafodion 9. sqstart 10. sqlci -> create table -> get table Thanks! Let me know if you have any issues or feedback :) -- Thanks, Amanda Moran
