Missing file in The SMART Connect 6.3 delivery package

[xitrum hd]

Hi All,

Hope you are doing great!

I'm trying to install Smart connect on local server.

I download SMART Connect from link on smartconservationtools.org website, folder on google driver is  "SMART 6.3 Delivery"

I follow the guide "Instructions for Connect Installation On Local Server" and I see that:
- Cannot find the server.settings.xml in the SMART 6.3 Delivery package. So, I cannot do this step in the guide: "Copy the information from the server.settings.xml file into the server.xml file located in Tomcat’s  “conf/” directory. This information should be placed inside the   <GlobalNamingResources> tag."

- When I run the script name "connect6_2_sql_merged_script.sql" on PostgreSQL to restore the database for smart connect, I got the error "ERROR:  constraint "type_chk" of relation "data_queue" does not exist"

- Cannot find: jBCrypt-0.4.jar”,”postgresql-9.4-1201-jdbc41.jar”, “connect_bcrypt.jar” and “javax.mail.jar” in the SMART 6.3 Delivery package, but I manual download it and copy to Tomcat’s lib directory

- I installed server.war but when try to access the smart connect link, I got 404 error message, maybe by I don't have server.settings.xml file to config server.xml

I'm using:

------

Java 1.8.0_171
Tomcat 9
Postgresql 10
------

Could you help to share with me the server.settings.xml file,  PostgreSQL script for Smart Connect 6.3? or the fully Smart Connect 6.3 delivery package that I can use to install Smart Connect successfully? Or the new guide/new delivery package to install Smart connect on 6.3 local server?

[Guido Saborio]

Hi,

I am certainly not the person to answer your questions, but if you are willing to give it a try, in here I am sharing a postgres script that @Oliver Adolph share with me last year, when I was having similar problems to the ones you described. I also share a server.settings file, that may be a good starting point.

Hope this helps, 

G

--
You received this message because you are subscribed to the Google Groups "SMART Community Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to community+...@smartconservationsoftware.org.
To view this discussion on the web visit https://groups.google.com/a/smartconservationsoftware.org/d/msgid/community/7b58962c-a741-4465-8852-24a65b600c2an%40smartconservationsoftware.org.

--

M.Sc. Guido Saborío R. 

Biólogo

gsab...@gmail.com

guido....@sinac.go.cr

   

[Alexander Wyatt]

Dear all, 

Please note that Roger is supporting Dzung directly to solve this problem. Thank you, Roger.

Kind regards, 

Alex

On Sat, 26 Mar 2022 at 10:05, xitrum hd <xitr...@gmail.com> wrote:

Hi All,

Hope you are doing great!

I'm trying to install Smart connect on local server.

I download SMART Connect from link on smartconservationtools.org website, folder on google driver is  "SMART 6.3 Delivery"

I follow the guide "Instructions for Connect Installation On Local Server" and I see that:
- Cannot find the server.settings.xml in the SMART 6.3 Delivery package. So, I cannot do this step in the guide: "Copy the information from the server.settings.xml file into the server.xml file located in Tomcat’s  “conf/” directory. This information should be placed inside the   <GlobalNamingResources> tag."

- When I run the script name "connect6_2_sql_merged_script.sql" on PostgreSQL to restore the database for smart connect, I got the error "ERROR:  constraint "type_chk" of relation "data_queue" does not exist"

- Cannot find: jBCrypt-0.4.jar”,”postgresql-9.4-1201-jdbc41.jar”, “connect_bcrypt.jar” and “javax.mail.jar” in the SMART 6.3 Delivery package, but I manual download it and copy to Tomcat’s lib directory

- I installed server.war but when try to access the smart connect link, I got 404 error message, maybe by I don't have server.settings.xml file to config server.xml

I'm using:

------

Java 1.8.0_171
Tomcat 9
Postgresql 10
------

Could you help to share with me the server.settings.xml file,  PostgreSQL script for Smart Connect 6.3? or the fully Smart Connect 6.3 delivery package that I can use to install Smart Connect successfully? Or the new guide/new delivery package to install Smart connect on 6.3 local server?

Thanks and best regards
Dzung Dang