set up problem

Submitted by Guest on Fri, 14/08/2009 - 17:21

General User's Discussion

I am trying to set upthe new version of OpenVPMS. Never used it before. It says "include the following lines in my.ini
max_allowed_packet=16M, innodb_file_per_table". I dont see a "my.ini" named configuration setting file under MySQL Server 5.0. There is however "my-innodb-heavy-4G" and "my" files.Can you guide me on this. And where do you add these lines actually?

Re: set up problem

Submitted by Tony De Keizer (not verified) on Fri, 14/08/2009 - 21:00.

Hi,

The my file is the one you are after. I think your explorer window is hiding file name suffixes so you cannot see the ini.

The lines can be added at the bottom of the file using Notepad as an editor. Each setting on its own line.

Hope this helps.

Cheers Tony

On 14/08/09 4:21 PM, "bilgic_ozgur@hotmail.com" :

> I am trying to set upthe new version of OpenVPMS. Never used it before. It > says "include the following lines in my.ini > max_allowed_packet=16M, innodb_file_per_table". I dont see a "my.ini" named > configuration setting file under MySQL Server 5.0. There is however > "my-innodb-heavy-4G" and "my" files.Can you guide me on this. And where do you > add these lines actually? > _______________________________________________ > OpenVPMS User Mailing List > users@lists.openvpms.org > To unsubscribe or change your subscription visit: > http://lists.openvpms.org/listinfo/users > Posts from this mailing list can be viewed online and replied to in the > OpenVPMS User's forum- http://tinyurl.com/openvfu

_______________________________________________ OpenVPMS User Mailing List users@lists.openvpms.org To unsubscribe or change your subscription visit: http://lists.openvpms.org/listinfo/users Posts from this mailing list can be viewed online and replied to in the OpenVPMS User's forum- http://tinyurl.com/openvfu

Creating database

Submitted by toothvet (not verified) on Sat, 15/08/2009 - 02:42.

Could you explain this a bit more?

To create the OpenVPMS MySQL database, run the following in a shell prompt

> cd <OPENVPMS_HOME>/db

> mysql -u admin -p < createdb.sql

> mysql -u admin -p openvpms < db.sql

When you say "shell prompt" are you talking about the "command prompt" under accesories or "MySQL Command Line Client" under MySQL? Or is there someother thing that I dont know? Am I gonna type the exact thing, I mean include ">" at the beginning? Am I gonna type each line and press enter after each line? I know a little bit of DOS. cd is used to enter in a folder. the first line is used to enter the db folder I assume. And the second two lines are command lines. Other question that come to my mind, where sould these directories (mysql-connector-java-5.1.8, apache-tomcat-5.5.28, openvpms-release-1.3) be? in any folder, any location or they need to be gathered under certain location, file folder, etc?

continued from the previous

Submitted by toothvet (not verified) on Sat, 15/08/2009 - 03:00.

I figured out one of my questions; I used MySQL Command Line client. Command Prompt gives invalid command, etc.

"NOTE: replace 'admin' with a user that has administrator priviledges in MySQL" Are you talking about a user who has administrative priviledges in Microsoft windows, because I dont know how to tell who has administrative priviledges in MySQL.

Thanks for all your help. If I can get this program working I am planning to use it in my new clinic.

setting up

Submitted by Matt C on Sun, 16/08/2009 - 13:49.

Hey toothvet,

As a fellow user, can I humbly recommend you make a modest investment in a integrator/implementor tweaking your install. As a fledgling user community we need to make sure all our installs are using OpenVPMS to its full potential.

A couple of days invested now could save you literally hundreds of IT-Frustration hours in the future.

Cheers,

Matt C

Re: continued from the previous

Submitted by Tony De Keizer (not verified) on Sun, 16/08/2009 - 14:00.

Hi Bilgic,

The administrative user is typically root in a Windows environment and the password is the one you set when installing Mysql Essentials package.

When you get in enter the commands as suggested but do not include the > at the front which represents the Mysql command prompter.

Hope this gets you further.

Cheers Tony

On 15/08/09 2:00 AM, "bilgic_ozgur@hotmail.com" :

> I figured out one of my questions; I used MySQL Command Line client. Command

> Prompt gives invalid command, etc. "NOTE: replace 'admin' with a user that

> has administrator priviledges in MySQL" Are you talking about a user who has > administrative priviledges in Microsoft windows, because I dont know how to > tell who has administrative priviledges in MySQL. Thanks for all your help. If

> I can get this program working I am planning to use it in my new > clinic.

_______________________________________________

OpenVPMS User

> Mailing List

users@lists.openvpms.org

To unsubscribe or change your

> subscription visit:

http://lists.openvpms.org/listinfo/users

Posts from this

> mailing list can be viewed online and replied to in the OpenVPMS User's forum- > http://tinyurl.com/openvfu

Re: New or updated comment for General User's Discussion Forum t

Submitted by Matt C on Sat, 05/09/2009 - 10:28.

Hey toothvet,
As a fellow user, can I suggest you make a modest investment in a
integrator/implementor tweaking your install. As a fledgling user community
we need to make sure all our installs are using OpenVPMS to its full
potential. A couple of days invested now could save you literally hundreds
of IT-Frustration hours in the future.
Cheers,
Matt C

On Fri, 14 Aug 2009 16:01:37 +0000 (UTC), toothvet
wrote:
>

set up problem

Submitted by toothvet (not verified) on Mon, 17/08/2009 - 09:46.

Hey,

I will be honest with you. I have no idea what you are talking about <integrator/implementor tweaking your install> Can you eleborate this a little more. I have no idea how I am gonna work this program. Is this a web based program. What am I supposed to do after finishing all the set-up steps to run this program. I am ok with making investments or donations etc. But I need more technical info to guide me through how to get started with this software.

toothvet

Re: set up problem

Submitted by Tony De Keizer (not verified) on Mon, 17/08/2009 - 17:00.

Hi Bilgic,

I think what Matt is saying is if you want to persist and utilise the slightly technical install notes and this forum to get your install working that's cool but if you want your learning mileage to be less and get the application up and running earlier you may wish to invest a relatively small amount to get someone with more technical skills in OpenVPMS to help you install and setup OpenVPMS.

The decision is yours.

BTW an integrator is someone who can "integrate" hardware and software components to provide a working I.T. system. An Implementer in this context is someone who is skilled in getting you up on and running with the OpenVPMS software specifically. Some companies specialise in both others in one or the other.

Either way when done you will be able to access OpenVPMS from a browser (Internet Explorer, Firefox etc) on your laptop/Pc by entering the address

http://localhost:8080/openvpms

Cheers Tony

On 17/08/09 8:46 AM, "bilgic_ozgur@hotmail.com" :

> Hey,

I will be honest with you. I have no idea what you are talking about

> Can you eleborate this a little > more. I have no idea how I am gonna work this program. Is this a web based > program. What am I supposed to do after finishing all the set-up steps to run > this program. I am ok with making investments or donations etc. But I need > more technical info to guide me through how to get started with this > software.

toothvet _______________________________________________

OpenVPMS

> User Mailing List

users@lists.openvpms.org

To unsubscribe or change your

> subscription visit:

http://lists.openvpms.org/listinfo/users

Posts from this

> mailing list can be viewed online and replied to in the OpenVPMS User's forum- > http://tinyurl.com/openvfu