Skip to first unread message
Akash Agrawall
Jan 15, 2014, 1:52:14 PM1/15/14
to d...@openmrs.org
I am in this page ... https://wiki.openmrs.org/display/docs/Installing+OpenMRS
and I am stuck on the step ... "Deploy OpenMRS"
on the step "Install Tomcat" I followed the instructions and in this line:
when I type in the same thing as user name and password it doesn't work plz help me out... !!
and I am stuck on the step ... "Deploy OpenMRS"
on the step "Install Tomcat" I followed the instructions and in this line:
<user name="admin" password="XXXXXX" roles="tomcat,admin,manager,manager-gui"/>
I wrote:
<user name="admin" password="admin" roles="tomcat,admin,manager,manager-gui"/>when I type in the same thing as user name and password it doesn't work plz help me out... !!
mhawila ahmedi
Jan 15, 2014, 1:55:37 PM1/15/14
to d...@openmrs.org
what errors do you get?
--
OpenMRS Developers: http://go.openmrs.org/dev
Post: d...@openmrs.org | Unsubscribe: dev+uns...@openmrs.org
Manage your OpenMRS subscriptions at https://id.openmrs.org/
To unsubscribe from this group and stop receiving emails from it, send an email to dev+uns...@openmrs.org.
Michael Downey
Jan 15, 2014, 1:56:58 PM1/15/14
to OpenMRS Developer List
Hi Akash,
If you need help installing Tomcat on Ubuntu you might use Google or
your favorite search engine for some starting points.
http://tomcat.apache.org/tomcat-7.0-doc/index.html is the primary
reference for Tomcat documentation.
Michael Downey
OpenMRS Community Manager
your favorite search engine for some starting points.
http://tomcat.apache.org/tomcat-7.0-doc/index.html is the primary
reference for Tomcat documentation.
Michael Downey
OpenMRS Community Manager
Akash Agrawall
Jan 15, 2014, 1:58:39 PM1/15/14
to d...@openmrs.org
invalid username or password !!
mhawila ahmedi
Jan 15, 2014, 2:19:04 PM1/15/14
to d...@openmrs.org
So, tomcat is installed successfully but you are not capable of log on the manager page? If that is the case, take a look at the tomcat log and see what it says.
Friedman, Roger (CDC/CGH/DGHA) (CTR)
Jan 15, 2014, 2:22:01 PM1/15/14
to d...@openmrs.org
Akash --
What version of tomcat are you using? I believe that the "manager" role has been removed by 6.0.35; you can change it to manager-status if you want.
Also, there are some issues between OpenMRS and Ubuntu about how the various Tomcat directories (/usr/share/tomcat6, /var/lib/tomcat6, /usr/lib/apache-tomcat-6.0.35) work together. It's almost certain that this is not the best way, but what I have done is to configure Tomcat (including the user list and the command-line parameters) in /usr/lib/apache-tomcat-6.0.35; when I start up the machine, using sudo I kill the process running Tomcat and then start /usr/lib/apache-tomcat-6.0.35/bin/startup.sh. Before shutting down, I run shutdown.sh.
--
OpenMRS Developers: http://go.openmrs.org/dev
Post: d...@openmrs.org | Unsubscribe:
dev+uns...@openmrs.org
Manage your OpenMRS subscriptions at https://id.openmrs.org/
Akash Agrawall
Jan 16, 2014, 3:49:34 AM1/16/14
to d...@openmrs.org
I am not able to log on to openMRS manager page.... !!
I have installed tomcat6 on /etc folder and it consists of these files: server.xml
akash.wanteds
Akash Agrawall
Jan 16, 2014, 3:49:40 AM1/16/14
to d...@openmrs.org
I have installed tomcat6 on /etc folder and it consists of these files:
Catalina,
context.xml
policy.d
tomcat-users.xml
catalina.properties
logging.properties
server.xml
web.xml
Catalina,
context.xml
policy.d
tomcat-users.xml
catalina.properties
logging.properties
server.xml
web.xml
--
akash.wanteds
akash.wanteds
Miencha Agustine 0.
Jan 16, 2014, 5:04:53 AM1/16/14
to d...@openmrs.org
Hi,
If you're installing this in Ubuntu, open in a text editor and add the
roles admin and manager for the user "tomcat"
i.e <user name="tomcat" password="tomcat"
roles="tomcat,admin,manager"/>
or
Replace what is in var/lib/tomcat6/conf/tomcat-users.xml with:
<tomcat-users>
<!--
<role rolename="tomcat"/>
<role rolename="role1"/>
<user username="tomcat" password="tomcat" roles="tomcat"/>
<user username="both" password="tomcat" roles="tomcat,role1"/>
<user username="role1" password="tomcat" roles="role1"/>
-->
<role rolename="tomcat"/>
<user username ="tomcat" password ="tomcat"
roles="tomcat,manager,manager-gui,admin" />
</tomcat-users>
Then navigate; http://localhost:8080/manager/html to deploy the war file.
Thanks.
Miencha Agustine
Ampath, kenya.
On 1/16/14, Akash Agrawall <akash....@gmail.com> wrote:
> I am not able to log on to openMRS manager page.... !!
> I have installed tomcat6 on /etc folder and it consists of these files:
> Catalina,
> context.xml
> policy.d
> tomcat-users.xml
> catalina.properties
> logging.properties
> server.xml
> web.xml
>
>
> On Thu, Jan 16, 2014 at 12:49 AM, mhawila ahmedi
> <a.mh...@gmail.com>wrote:
>
>> So, tomcat is installed successfully but you are not capable of log on
>> the
>> manager page? If that is the case, take a look at the tomcat log and see
>> what it says.
>>
>> *Best regards,*
>>
>> *Mhawila A. Mhawila*
>> *Phone :* 641-814-6937
>> *Email :* a.mh...@gmail.com
>> *Skype :* mhawila
>>>>
>>>> *Mhawila A. Mhawila*
>>>> *Phone :* 641-814-6937
>>>> *Email :* a.mh...@gmail.com
>>>> *Skype :* mhawila
If you're installing this in Ubuntu, open in a text editor and add the
roles admin and manager for the user "tomcat"
i.e <user name="tomcat" password="tomcat"
roles="tomcat,admin,manager"/>
or
Replace what is in var/lib/tomcat6/conf/tomcat-users.xml with:
<tomcat-users>
<!--
<role rolename="tomcat"/>
<role rolename="role1"/>
<user username="tomcat" password="tomcat" roles="tomcat"/>
<user username="both" password="tomcat" roles="tomcat,role1"/>
<user username="role1" password="tomcat" roles="role1"/>
-->
<role rolename="tomcat"/>
<user username ="tomcat" password ="tomcat"
roles="tomcat,manager,manager-gui,admin" />
</tomcat-users>
Then navigate; http://localhost:8080/manager/html to deploy the war file.
Thanks.
Miencha Agustine
Ampath, kenya.
On 1/16/14, Akash Agrawall <akash....@gmail.com> wrote:
> I am not able to log on to openMRS manager page.... !!
> I have installed tomcat6 on /etc folder and it consists of these files:
> Catalina,
> context.xml
> policy.d
> tomcat-users.xml
> catalina.properties
> logging.properties
> server.xml
> web.xml
>
>
> On Thu, Jan 16, 2014 at 12:49 AM, mhawila ahmedi
> <a.mh...@gmail.com>wrote:
>
>> So, tomcat is installed successfully but you are not capable of log on
>> the
>> manager page? If that is the case, take a look at the tomcat log and see
>> what it says.
>>
>>
>> *Mhawila A. Mhawila*
>> *Phone :* 641-814-6937
>> *Email :* a.mh...@gmail.com
>> *Skype :* mhawila
>>
>>
>> On Wed, Jan 15, 2014 at 1:58 PM, Akash Agrawall
>> <akash....@gmail.com>wrote:
>>
>>> invalid username or password !!
>>>
>>>
>>> On Thursday, January 16, 2014 12:25:37 AM UTC+5:30, mhawila ahmedi
>>> wrote:
>>>
>>>> what errors do you get?
>>>>
>>>> *Best regards,*
>>
>> On Wed, Jan 15, 2014 at 1:58 PM, Akash Agrawall
>> <akash....@gmail.com>wrote:
>>
>>> invalid username or password !!
>>>
>>>
>>> On Thursday, January 16, 2014 12:25:37 AM UTC+5:30, mhawila ahmedi
>>> wrote:
>>>
>>>> what errors do you get?
>>>>
>>>>
>>>> *Mhawila A. Mhawila*
>>>> *Phone :* 641-814-6937
>>>> *Email :* a.mh...@gmail.com
>>>> *Skype :* mhawila
Akash Agrawall
Jan 16, 2014, 5:40:23 AM1/16/14
to d...@openmrs.org
@miencha ....
I copied and pasted the code that you told in var/lib/tomcat6/conf/tomcat-users.xml file"http://localhost:8081/openmrs-standalone/index.htm"
Content of tomcat-users.xml
"
<?xml version='1.0' encoding='utf-8'?>
<!--
Licensed to the Apache Software Foundation (ASF) under one or more
contributor license agreements. See the NOTICE file distributed with
this work for additional information regarding copyright ownership.
The ASF licenses this file to You under the Apache License, Version 2.0
(the "License"); you may not use this file except in compliance with
the License. You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.
-->
"
<?xml version='1.0' encoding='utf-8'?>
<!--
Licensed to the Apache Software Foundation (ASF) under one or more
contributor license agreements. See the NOTICE file distributed with
this work for additional information regarding copyright ownership.
The ASF licenses this file to You under the Apache License, Version 2.0
(the "License"); you may not use this file except in compliance with
the License. You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.
-->
<tomcat-users>
<!--
<role rolename="tomcat"/>
<role rolename="role1"/>
<user username="tomcat" password="tomcat" roles="tomcat"/>
<user username="both" password="tomcat" roles="tomcat,role1"/>
<user username="role1" password="tomcat" roles="role1"/>
-->
<role rolename="tomcat"/>
<user username ="tomcat" password ="tomcat"
roles="tomcat,manager,manager-gui,admin" />
</tomcat-users>
"
have been stuck on it since two days.... :( ..
Harsha Kumara
Jan 16, 2014, 6:04:33 AM1/16/14
to d...@openmrs.org
Hi Akash,
I recommend you to download the tomcat distribution and extract openmrs war into webapp folder and then run the initial setup. Normally you no need to do anything, default user admin and passworeds will be either Admin123 or test and you should be able to log into the system. I'll be at gtalk if you need any help.
Thanks,
Harsha
Harsha Kumara
Undergraduate
Department of Computer Science and Engineering
University of Moratuwa
Sri Lanka.
Miencha Agustine 0.
Jan 16, 2014, 7:04:23 AM1/16/14
to d...@openmrs.org
Hi Akash
If you have installed all applications properly(tomcat6,Java,mysql)
and you have openmrs war ready. You can copy that directly to
var/lib/tomcat6/webapps and run the initial set up as Harsha has
indicated. That will help relief you from having the earlier settings
I sent you.
Miencha Agustine
Ampath.
> *Harsha Kumara*
> *Undergraduate*
> *Department of Computer Science and Engineering*
> *University of Moratuwa*
> *Sri Lanka.*
If you have installed all applications properly(tomcat6,Java,mysql)
and you have openmrs war ready. You can copy that directly to
var/lib/tomcat6/webapps and run the initial set up as Harsha has
indicated. That will help relief you from having the earlier settings
I sent you.
Miencha Agustine
Ampath.
> *Undergraduate*
> *Department of Computer Science and Engineering*
> *University of Moratuwa*
> *Sri Lanka.*
Akash Agrawall
Jan 16, 2014, 9:42:15 AM1/16/14
to d...@openmrs.org
copied the war file to var/lib/tomcat6/webapps now when I run the jar file using :
"java -jar openmrs-standalone.jar"Harsha Kumara
Jan 16, 2014, 9:46:31 AM1/16/14
to d...@openmrs.org
Oopz, seems like you have jumble things. If you using OpenMRS standalone version, you no need any of other requirements such as mysql,tomcat and etc. Standalone version comes with all the required packages. If you using openMRS standalone version, you only need to run the jar file only. Extract the tar or zip and run the jar file should be do do the things for you. If your tomcat port is 8081 in standalone popup window, use "localhost:8081/openmrs-standalone/
Akash Agrawall
Jan 16, 2014, 9:51:53 AM1/16/14
to d...@openmrs.org
that page doesn't open when I go to that....
the error encountered on the GUI small window of OpenMRS Standalone which pops up when run the jar file... is this:
[MysqldResource] launching mysqld (driver_launched_mysqld_3)
Jan 16, 2014 8:19:57 PM org.apache.catalina.connector.Connector stop
SEVERE: Coyote connector has not been started
[MysqldResource]
[MysqldResource] mysqld pid-file not found: /home/aka/Downloads/openmrs-standalone-1.9.7/database/data/MysqldResource.pid
P.S. I am in ubuntu 12.10 ...the error encountered on the GUI small window of OpenMRS Standalone which pops up when run the jar file... is this:
[MysqldResource] launching mysqld (driver_launched_mysqld_3)
Jan 16, 2014 8:19:57 PM org.apache.catalina.connector.Connector stop
SEVERE: Coyote connector has not been started
[MysqldResource]
[MysqldResource] mysqld pid-file not found: /home/aka/Downloads/openmrs-standalone-1.9.7/database/data/MysqldResource.pid
Harsha Kumara
Jan 16, 2014, 9:55:35 AM1/16/14
to d...@openmrs.org
Make sure the specified ports are not occupied by other programs. I would say have a fresh unzip of standalone and try run it again.
Akash Agrawall
Jan 16, 2014, 10:09:57 AM1/16/14
to d...@openmrs.org
I am in a university and I am using a proxy server... would that be a problem... ??
Harsha Kumara
Jan 16, 2014, 10:14:06 AM1/16/14
to d...@openmrs.org
It won't be a problem as you haven't build anything. Can you check whether those ports(8081 and 3317) are occupied by some other process? If so kill those programs or change the port in property file inside openmrs standalone folder and run it again. I'm not sure the status of 1.9.7 standalone version.
Akash Agrawall
Jan 16, 2014, 10:26:43 AM1/16/14
to d...@openmrs.org
did a fresh download of the zip and started the file using "java -jar openmrs-standalone.jar"
the link "localhost:8081/openmrs-standalone/" shows unable to connect... ??com.mysql.management.driverlaunched.ServerLauncherSocketFactory.alreadyStarted(ServerLauncherSocketFactory.java:155)
... 19 more
??
Harsha Kumara
Jan 16, 2014, 10:33:13 AM1/16/14
to d...@openmrs.org
Give us the full stack trace?
Akash Agrawall
Jan 16, 2014, 10:52:53 AM1/16/14
to d...@openmrs.org
Initial configuration needed
Deleting active database
Unzipping database from demodatabase.zip
Resetting connection.password to 'test'
Attempting to load properties file in current directory: openmrs-standalone-runtime.properties
Using runtime properties file: openmrs-standalone-runtime.properties
Attempting to load properties file in current directory: openmrs-standalone-runtime.properties
Using runtime properties file: openmrs-standalone-runtime.properties
Working directory is /home/aka/Downloads/openmrs-standalone-1.9.7/.
Opening MySQL connection to create openmrs/test users
Exception in thread "main" com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2364)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:773)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:352)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)
at java.sql.DriverManager.getConnection(DriverManager.java:571)
at java.sql.DriverManager.getConnection(DriverManager.java:215)
at org.openmrs.standalone.StandaloneUtil.startupDatabaseToCreateDefaultUser(StandaloneUtil.java:422)
at org.openmrs.standalone.ApplicationController.init(ApplicationController.java:234)
at org.openmrs.standalone.ApplicationController.<init>(ApplicationController.java:56)
at org.openmrs.standalone.ApplicationController.main(ApplicationController.java:111)
Caused by: com.mysql.management.util.SQLRuntimeException: java.sql.SQLException: Access denied for user 'openmrs'@'localhost' (using password: YES)
at com.mysql.management.driverlaunched.ServerLauncherSocketFactory.alreadyStarted(ServerLauncherSocketFactory.java:160)
at com.mysql.management.driverlaunched.ServerLauncherSocketFactory.ensureMysqlStarted(ServerLauncherSocketFactory.java:82)
at com.mysql.management.driverlaunched.ServerLauncherSocketFactory.connect(ServerLauncherSocketFactory.java:72)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:290)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2288)
... 15 more
Caused by: java.sql.SQLException: Access denied for user 'openmrs'@'localhost' (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3536)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3468)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:917)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3974)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1282)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2142)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:773)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:352)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)
at java.sql.DriverManager.getConnection(DriverManager.java:571)
at java.sql.DriverManager.getConnection(DriverManager.java:215)
at com.mysql.management.driverlaunched.ServerLauncherSocketFactory.alreadyStarted(ServerLauncherSocketFactory.java:155)
... 19 more
Deleting active database
Unzipping database from demodatabase.zip
Resetting connection.password to 'test'
Attempting to load properties file in current directory: openmrs-standalone-runtime.properties
Using runtime properties file: openmrs-standalone-runtime.properties
Attempting to load properties file in current directory: openmrs-standalone-runtime.properties
Using runtime properties file: openmrs-standalone-runtime.properties
Working directory is /home/aka/Downloads/openmrs-standalone-1.9.7/.
Opening MySQL connection to create openmrs/test users
Exception in thread "main" com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2364)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:773)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:352)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)
at java.sql.DriverManager.getConnection(DriverManager.java:571)
at java.sql.DriverManager.getConnection(DriverManager.java:215)
at org.openmrs.standalone.StandaloneUtil.startupDatabaseToCreateDefaultUser(StandaloneUtil.java:422)
at org.openmrs.standalone.ApplicationController.init(ApplicationController.java:234)
at org.openmrs.standalone.ApplicationController.<init>(ApplicationController.java:56)
at org.openmrs.standalone.ApplicationController.main(ApplicationController.java:111)
Caused by: com.mysql.management.util.SQLRuntimeException: java.sql.SQLException: Access denied for user 'openmrs'@'localhost' (using password: YES)
at com.mysql.management.driverlaunched.ServerLauncherSocketFactory.alreadyStarted(ServerLauncherSocketFactory.java:160)
at com.mysql.management.driverlaunched.ServerLauncherSocketFactory.ensureMysqlStarted(ServerLauncherSocketFactory.java:82)
at com.mysql.management.driverlaunched.ServerLauncherSocketFactory.connect(ServerLauncherSocketFactory.java:72)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:290)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2288)
... 15 more
Caused by: java.sql.SQLException: Access denied for user 'openmrs'@'localhost' (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3536)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3468)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:917)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3974)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1282)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2142)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:773)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:352)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)
at java.sql.DriverManager.getConnection(DriverManager.java:571)
at java.sql.DriverManager.getConnection(DriverManager.java:215)
at com.mysql.management.driverlaunched.ServerLauncherSocketFactory.alreadyStarted(ServerLauncherSocketFactory.java:155)
... 19 more
Harsha Kumara
Jan 16, 2014, 10:56:47 AM1/16/14
to d...@openmrs.org
Seems like some problem with your mysql in standalone version. Are you sure that nothing is run in your mysql port?
Akash Agrawall
Jan 16, 2014, 11:19:13 AM1/16/14
to d...@openmrs.org
how do I check that... ??
cos as far as I know nothing is running on myslq port... !! 
Ope Bakare
Jan 16, 2014, 11:45:05 AM1/16/14
to d...@openmrs.org
You may have a firewall running on your Ubuntu install that's blocking even local TCP connections.
Friedman, Roger (CDC/CGH/DGHA) (CTR)
Jan 16, 2014, 12:02:55 PM1/16/14
to d...@openmrs.org
try starting the mysql command line interface:
mysql -uUSERNAME -pPASSWORD --port=PORT DBNAME
Akash Agrawall
Jan 16, 2014, 12:10:00 PM1/16/14
to d...@openmrs.org
when I do this command it comes:
"Unknown suffix 'P' used for variable 'port' (value 'PORT')
mysql: Error while setting value 'PORT' to 'port'"
but I am able to do this:"Unknown suffix 'P' used for variable 'port' (value 'PORT')
mysql: Error while setting value 'PORT' to 'port'"
mysql>show databases;
Akash Agrawall
Jan 16, 2014, 12:10:38 PM1/16/14
to d...@openmrs.org
I am able to run the web2py local host and even rails 3.2.16 ...
why not this. ??Friedman, Roger (CDC/CGH/DGHA) (CTR)
Jan 16, 2014, 12:21:13 PM1/16/14
to d...@openmrs.org
You need to replace the capitalized words with the corresponding values on your machine. The default port for MySQL is 3306, but I believe the standalone uses 3307.
Harsha Kumara
Jan 16, 2014, 1:47:00 PM1/16/14
to d...@openmrs.org
Now are you able to run the standalone? netstat -tulpn| grep 3307 will give the running process of specified process.
Akash Agrawall
Jan 16, 2014, 2:26:33 PM1/16/14
to d...@openmrs.org
@friedman, roger sry for late reply..... yaa this is working f9 .... and my mysql port is 3306 ...
Akash Agrawall
Jan 16, 2014, 2:29:31 PM1/16/14
to d...@openmrs.org
@harsha same lines in the OpenMRS Standalone :(
here my mysql port is 3317Harsha Kumara
Jan 16, 2014, 2:58:11 PM1/16/14
to d...@openmrs.org
Okey let me give you a another thought, do a fresh unzip and go to the property file in the folder and change the tomcat and mysql ports and try run the jar file again. I don't know whether this is a incompatibility of standalone version but will try that way too.
Akash Agrawall
Jan 16, 2014, 3:04:54 PM1/16/14
to d...@openmrs.org
I changed the tomcat port to 8080 .... I don't see changin the mysql port anywhere.... ??
when I exit the OpenMRS standalone window.... I get this line in terminal...
[MysqldResource] Mysqld not running. No file: /home/aka/Downloads/openmrs-standalone-1.9.7/database/data/MysqldResource.pid
Lara Kellett
Jan 16, 2014, 3:13:28 PM1/16/14
to d...@openmrs.org
Have you restarted your computer between
any of these steps, because some of the earlier stack traces look like
mysql etc have still been running from earlier failed attempts?
So I would suggest.
1) Restart your machine to make sure everything has been stopped.
2) Unzip a fresh copy of the standalone, don't make any changes, don't move any of the files from the unzipped structure you get
3) Try running the standalone jar file
Hope that helps,
Lara Kellett
M�decins Sans Fronti�res/Doctors Without Borders
lara.k...@newyork.msf.org
+1.631.480.4969
Skype: lara.kellett
So I would suggest.
1) Restart your machine to make sure everything has been stopped.
2) Unzip a fresh copy of the standalone, don't make any changes, don't move any of the files from the unzipped structure you get
3) Try running the standalone jar file
Hope that helps,
Lara Kellett
M�decins Sans Fronti�res/Doctors Without Borders
lara.k...@newyork.msf.org
+1.631.480.4969
Skype: lara.kellett
Harsha Kumara
Jan 16, 2014, 3:18:05 PM1/16/14
to d...@openmrs.org
May be Daniel will know the exact reason for this as he is the in charge of openmrs standalone version.By changing the database url port will change the mysql port. And try setting it and run. If that wouldn't work, let me know.
Akash Agrawall
Jan 16, 2014, 3:38:37 PM1/16/14
to d...@openmrs.org
doing the same.... downloading is taking time...
Akash Agrawall
Jan 16, 2014, 4:20:32 PM1/16/14
to d...@openmrs.org
now what is the username and password that I need to put... ??
the openmrs username doesn't work .. !!--
akash.wanteds
akash.wanteds
Lluis Martinez
Jan 16, 2014, 4:53:40 PM1/16/14
to d...@openmrs.org
Akash Agrawall
Jan 16, 2014, 5:47:25 PM1/16/14
to d...@openmrs.org
@lluis martinex.... I get this screen.... (find attached)
when I type in the username and password as "root" and "openmrs" (without quotes) it shows invalid username/password.....
please hava look
Elliott Williams
Jan 16, 2014, 6:21:07 PM1/16/14
to d...@openmrs.org
Akash,
According to the wiki[1], try logging in with
Username: admin
and
Password: Admin123 or test
For reference, my 1.9.7 standalone is admin/Admin123
Cheers,
Elliott
Harsha Kumara
Jan 16, 2014, 8:37:55 PM1/16/14
to d...@openmrs.org
Hope things now working. :)
Akash Agrawall
Jan 16, 2014, 9:20:03 PM1/16/14
to d...@openmrs.org
yaa they are working...... I am able to login to the account with the password test....on completing other steps... :)
Thanx guys for the awesome support... 
Daniel Kayiwa
Jan 17, 2014, 1:56:08 AM1/17/14
to dev
@Akash,
Do you mind creating a wiki page that documents the problems you encountered and how you solved them?If we keep uppermost in our minds the unkind and unjust acts of others, we shall find it impossible to love them as Christ has loved us; but if our thoughts dwell upon the wondrous love and pity of Christ for us, the same spirit will flow out to others.
Akash Agrawall
Jan 17, 2014, 4:53:13 AM1/17/14
to d...@openmrs.org
Daniel Kayiwa
Jan 17, 2014, 7:10:25 AM1/17/14
to dev
The link seems invalid. :)
Akash Agrawall
Jan 17, 2014, 8:27:45 AM1/17/14
to d...@openmrs.org
it's opening on my PC....
go to my profile link... https://wiki.openmrs.org/pages/viewpage.action?pageId=60065922
Daniel Kayiwa
Jan 17, 2014, 8:40:57 AM1/17/14
to dev
I still get a page not found error. Are you directly clicking the link you gave me?
Akash Agrawall
Jan 17, 2014, 8:45:19 AM1/17/14
to d...@openmrs.org
mah badd man.... I was logged in ...
https://wiki.openmrs.org/display/~aka007
check out this link.... !!
https://wiki.openmrs.org/display/~aka007
check out this link.... !!
Daniel Kayiwa
Jan 17, 2014, 8:47:03 AM1/17/14
to dev
The last link loads fine. But i do not see the documentation. :)
Akash Agrawall
Jan 17, 2014, 9:08:17 AM1/17/14
to d...@openmrs.org
I can see when I am logged in ... there doesn't seem to be any option to make it public....
Burke Mamlin
Jan 17, 2014, 9:48:27 AM1/17/14
to d...@openmrs.org
Akash,
Pages in your personal space are private to you by default. You can change the permissions in your personal space through the menu Browse > Space Admin > Permissions to, for example, grant View privilege to anonymous users. We would not recommend granting anything other than View to anonymous users, since even allowing anonymous comments will invite spambots to fill the wiki with ads. Granting View privilege will allow people to see your pages without logging into the wiki (you can still change permissions on individual pages if you, for example, want to restrict access to a specific page and its children).
Cheers,
-Burke
On Fri, Jan 17, 2014 at 9:08 AM, Akash Agrawall <akash....@gmail.com> wrote:
I can see when I am logged in ... there doesn't seem to be any option to make it public....
Akash Agrawall
Jan 17, 2014, 10:21:56 AM1/17/14
to d...@openmrs.org
Done :) :)
To unsubscribe from this group and stop receiving emails from it, send an email to dev+uns...@openmrs.org.
--
akash.wanteds
Mhawila A. Mhawila
Jan 17, 2014, 10:41:47 AM1/17/14
to d...@openmrs.org
Akash,
Could you open that post for comments from authenticated users? I think there are some few things that need clarification because the way it stands right now it might be confusing, especially to beginners.Lara Kellett
Jan 17, 2014, 10:48:28 AM1/17/14
to d...@openmrs.org
Hi Akash,
I think the confusion lies in the difference between the OpenMRS standalone package (which has an embedded database and server) and the OpenMRS Enterprise WAR which needs to be deployed onto a server (requiring both MySQL and Tomcat to be installed).
If you were following the instruction on the https://wiki.openmrs.org/display/docs/Installing+OpenMRS page you should have downloaded and tried to deploy the OpenMRS Enterprise WAR at step 5. If you were trying to use the OpenMRS standalone package the instructions are on this page https://wiki.openmrs.org/display/docs/OpenMRS+Standalone.
If you think there is any clarification needed on the https://wiki.openmrs.org/display/docs/Step+5+-+Deploy+OpenMRS to explain which download link should be used then you should edit that page.
Hope that makes things a little clearer,
Lara Kellett
Médecins Sans Frontières/Doctors Without Borders
lara.k...@newyork.msf.org
+1.631.480.4969
Skype: lara.kellett
From: Akash Agrawall <akash....@gmail.com>
To: d...@openmrs.org,
I think the confusion lies in the difference between the OpenMRS standalone package (which has an embedded database and server) and the OpenMRS Enterprise WAR which needs to be deployed onto a server (requiring both MySQL and Tomcat to be installed).
If you were following the instruction on the https://wiki.openmrs.org/display/docs/Installing+OpenMRS page you should have downloaded and tried to deploy the OpenMRS Enterprise WAR at step 5. If you were trying to use the OpenMRS standalone package the instructions are on this page https://wiki.openmrs.org/display/docs/OpenMRS+Standalone.
If you think there is any clarification needed on the https://wiki.openmrs.org/display/docs/Step+5+-+Deploy+OpenMRS to explain which download link should be used then you should edit that page.
Hope that makes things a little clearer,
Lara Kellett
Médecins Sans Frontières/Doctors Without Borders
lara.k...@newyork.msf.org
+1.631.480.4969
Skype: lara.kellett
From: Akash Agrawall <akash....@gmail.com>
To: d...@openmrs.org,
Date:
01/17/2014 10:22 AM
Subject: Re: Regarding deployment of OpenMRS in ubuntu
Subject: Re: Regarding deployment of OpenMRS in ubuntu
Reply all
Reply to author
Forward
0 new messages