Brand new OpenVPMS installation on FreeBSD - any beginner tips to save time?

Submitted by Guest on Fri, 02/11/2012 - 20:13

Implementation discussion

Hello all,

I am about to install openVPMS on FreeBSD.  I have installed all of the 
constituent parts and read the implementation documentation.

Before I launch in, does anyone have any suggestions about obvious settings 
I need to enable on the different components (mysql, phpmyadmin, libreoffice, 
Tomcat)to save me some frustrating hours?

Cheers,

Cahir

Re: Brand new OpenVPMS installation on FreeBSD - any ...

Submitted by ck234 (not verified) on Tue, 13/11/2012 - 17:21.

OK - Got most of the way through this but encountering one error relating to Tomcat 7.

On starting the Tomcat server I get a messages saying Tomcat failed to start. However, Tomcat actually does start in the background and I can log into the OpenVPMS web interface fine.

I checked the Catalina(date).log file and pasted a snapshot of the problem in italics below. Is there a solution to this that I have missed? Or should I revert back to Tomcat 6?

Cheers,

Cahir

Nov 12, 2012 7:32:57 PM org.apache.catalina.core.StandardService stopInternal

INFO: Stopping service Catalina

Nov 12, 2012 7:32:58 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads

SEVERE: The web application [/openvpms] appears to have started a thread named [Abandoned connection cleanup thread] but has failed to stop it. This is very likely to create a memory leak.

Nov 12, 2012 7:32:58 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads

SEVERE: The web application [/openvpms] appears to have started a thread named [net.sf.ehcache.CacheManager@13c635b] but has failed to stop it. This is very likely to create a memory leak.

Nov 12, 2012 7:32:58 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads

SEVERE: The web application [/openvpms] appears to have started a thread named [scheduler_Worker-1] but has failed to stop it. This is very likely to create a memory leak.

Re: Brand new OpenVPMS installation on FreeBSD - any ...

Submitted by tanderson on Mon, 19/11/2012 - 12:04.

You can ignore this. It will only be an issue if you redeploy OpenVPMS many times without stopping Tomcat.

-Tim

Re: Brand new OpenVPMS installation on FreeBSD - any ...

Submitted by ck234 (not verified) on Tue, 20/11/2012 - 17:03.

Thank you for your reply Tim. I ended up avoiding the issue by installing Tomcat 6.0, no more error messages!

FreeBSD & OpenVPMS - importing a new price/product list

Submitted by ck234 (not verified) on Wed, 21/11/2012 - 07:25.

On a separate note.

Our main supplier emails out their complete prouct file with associated price list in .txt format. Can anyone suggest the most appropriate way of importing this product list to OpenVPMS?

Thanks in advance.

Re: FreeBSD & OpenVPMS - importing a new price/product list

Submitted by tanderson on Wed, 21/11/2012 - 11:54.

The OpenVPMSLoader plugin for Pentaho Kettle is the most appropriate tool for this purpose.

See the notes put together by Tim Gething and http://www.openvpms.org/documentation/openvpms-loader-plugin-pentaho-kettle search the forums for usage tips.

-Tim A

Re: FreeBSD & OpenVPMS - importing a new price/product list

Submitted by tgething (not verified) on Thu, 22/11/2012 - 16:22.

Tim A is correct - Kettle needs to be used. However, the learning curve is quite steep - not so much with Kettle itself (which is a wonderful tool for data conversion) but in understanding how to load stuff into the OPV database.

The dataload tool is far simpler to use - but you need to get the data file formatted properly. If you have had a look at the products.xml file in the <OPV-HOME>\import\data\demo folder you will see what I mean.

For some of my data (I am converting an RxWorks system), I found it easiest at the time to use Kettle to process the data to be loaded (eg a CSV file containing species and breeds) to generate the XML file to be loaded by dataload. [Now I am more familiar with the OPV database structure and the Kettle OpenVPMSLoader, I would probably use Kettle to load the species/breed data directly.]

The dataload tool also has problems processing large datasets. In my case it had problems loading 671 breed/species and I ended up separating things into dogs, cats and others. [see http://www.openvpms.org/forum/dataload-bug-drops-species-when-there-are-large-number ]

However, I assume it does handle the demo products.xml file correctly and this is some 500Kb of data so there may not be a problem with it loading large numbers of products.

I can certainly upload my DataGen-Breeds Kettle transform so that you have an example to work off if you want to go down the Kettle/Dataload route.

Regards, Tim G

PS if you can handle dalaload, but Kettle scares you, email me the product data file and I will see what I can knock up. email me at tim dot gething at bigpond dot com

Re: FreeBSD & OpenVPMS - setting up email / SMS reminders

Submitted by ck234 (not verified) on Fri, 14/12/2012 - 03:11.

OK,

Thanks to the help of many people I have the OPV server up and running. My next task is to get the email / SMS reminders going.

I set up email in the practice location tab. The smtp server is "mail.hostname.com and the port number is 25. The mail server requires authentication, for which I input an email address and password.

I then setup an account with clickatell.

Then I input the clickatell SMS settings under Administration>Type:SMS as instructed on the website. I used my clicatell username and password (which I use to login to the clickatell website), the API ID and our practice email addresses.

However when I run SMS in the test box below the SMS box I keep getting the error:

SMS-0203: Failed to send email: Failed messages: com.sun.mail.smtp.SMTPSendFailedException: 550 Access denied - Invalid HELO name (See RFC2821 4.1.1.1)

Any ideas?

Re: FreeBSD & OpenVPMS - setting up email / SMS reminders

Submitted by tony on Fri, 14/12/2012 - 06:48.

Hi,

My understanding is this error typically means the domain part of your sending email address does not match the domain part of the email address you are using for authentication. Some SMTP servers wont let you send emails as someone other than the email address of the account you authenticated as.

Cheers Tony

Re: FreeBSD & OpenVPMS - setting up email / SMS reminders

Submitted by ck234 (not verified) on Fri, 14/12/2012 - 07:51.

Tony,

Thank you for your reply.

You are correct - the domain name of my mail server and email login did not exactly match, so I corrected this. Interestingly I was able to send the test-SMS using these details from a plain webmail interface, addressing the message to sms[at]messaging.clickatell[dot]com.

However, I still get the "invalid HELO" error when trying to use the tested SMS box on OpenVPMS.

I have reset the practice location email settings, and even the practice email. Am I missing something basic on the OpenVPMS email setup? Is there an easy way to test if OpenVPMS can send a quick message via its email settings?

Cahir.

Re: FreeBSD & OpenVPMS - setting up email / SMS reminders

Submitted by tony on Fri, 14/12/2012 - 12:21.

Hi Cahir,

Firstly did you log out and back in after changing the practice and practice location details ?

If you have version 1.6 beta-3 installed then you cna test email from any print dialogue by clicking the Mail button. Otherwsie mailing is limitied to Reminders and Statemenst so cna only test during a run of either of these.

Keep me posted. :-)

Cheers Tony

Re: FreeBSD & OpenVPMS - setting up email / SMS reminders

Submitted by ck234 (not verified) on Sat, 15/12/2012 - 02:34.

Tony - thanks for your reply.

I did log out and in again after updating the mail server details. I even restarted openvpms from the Tomcat manager web-interface.

This didn't change things. It seems to be a problem with the mail server settings I am entering in OpenVPMS.

I created an account with yahoo mail. (server: smtp.mail.yahoo.com, port 465). I then put these settings in the practice location. Then I entered the yahoo address in the SMS clickatell box and tried the test SMS button again - and got a different error:

SMS-0203: Failed to send email: Mail server connection failed; nested exception is javax.mail.MessagingException: Exception reading response;
nested exception is:
java.net.SocketException: Connection reset. Failed messages: javax.mail.MessagingException: Exception reading response;
nested exception is:
java.net.SocketException: Connection reset

Re: FreeBSD & OpenVPMS - setting up email / SMS reminders

Submitted by tony on Sat, 15/12/2012 - 08:40.

Hi Cahir,

From my understanding the Yahoo smtp server on this port requires TLS/SSL setup as well. You can only do this in the OpenVPMS user interface in 1.6 beta 3 not in 1.5.1. In 1.5.1 you need to set this up in the webapp configuration files so not so straight forward.

Cheers Tony

Re: FreeBSD & OpenVPMS - setting up email / SMS reminders

Submitted by bencharlton (not verified) on Sat, 15/12/2012 - 08:51.

https://openvpms.atlassian.net/browse/OVPMS-1111

is the place to start if you stick with 1.5.1 look in the comments for TLS configuration in the application context

http://www.openvpms.org/forum/email-setup-reminder

and

http://www.openvpms.org/forum/does-openvpmss-mailservice-spring-javamail...

you might find what you need for 1.5.1

I use gmail for mail, and it requires TLS/SSL as well, mind you I upgraded to 1.6.3beta and its all configured via the webapp so a lot easier, however you can enable the debug in the application context to get the SMTP communication in the logs, which helps with debugging mail sending issues.

Re: FreeBSD & OpenVPMS - setting up email / SMS reminders

Submitted by ck234 (not verified) on Sat, 15/12/2012 - 23:09.

Guys,

Thanks for your input. I think I will try to enable the secure login using the patch for version 1.5.1 (in part because I couldn't find a download for 1.6!).

So, from following the text:

(https://openvpms.atlassian.net/browse/OVPMS-1111?page=com.atlassian.jira...)

- I need to modify an xml file. Now, is this file called "applicationContext.xml" or "applicationConfig.xml"? The forums seem to use both names.

I have a file called applicationContext.xml located under "openvpms-home/conf". I assume I just open this in a text editor and paste the patch above at the bottom of the file?

Cahir

Re: FreeBSD & OpenVPMS - setting up email / SMS reminders

Submitted by ck234 (not verified) on Mon, 17/12/2012 - 01:10.

OK - problem solved. Just upgraded to OPV 1.6, selected "SSL" encyption on the practice location dialogue and used gmail and the SMS function worked.

Thanks for your help guys.

Brand new OpenVPMS installation on FreeBSD - any beginner tips to save time?

Comment viewing options