Hi Vishwas.
I can successfully log into MySQL from MySQL Workbench and the MySQL
Command Line Client, using the root user and the same password I have
placed into the server.xml file.
In case it is helpful, I have attached my server.xml file. I made as few
changes as possible from the default server.xml, only those that were
needed to fulfill the requirements of the technical install doc.
Thanks,
Todd
On Fri, Jan 31, 2014 at 5:35 AM, Vishwas Babu <[email protected]>wrote:
> Hi Todd,
>
> >> I assume mifos-platform.log; any others?
> Yes, mifos-platform.log is sufficient
>
> The error seems to be with connecting to the mifosplatform-tenants
> database. Can you please cross check that the same can be accessed using
> root, mysql credentials?
>
> Regards,
> Vishwas
>
>
> On 31 January 2014 11:00, Todd Robinson <[email protected]> wrote:
>
>> Hello, Vishwas. Thanks for helping me.
>>
>> I will look forward to the discussion on SSL, as it is relevant to the
>> Windows install guide project.
>>
>> I am not very familiar with Tomcat logging -- which specific log files do
>> you normally want to see from a user to troubleshoot this type of problem?
>> I assume mifos-platform.log; any others? This will be helpful for me to
>> know as I work on end-user-facing Mifos projects.
>>
>> In any case, I went ahead and zipped all log files created since
>> yesterday when I produced this problem, and I have attached the zip to this
>> email (hopefully this mailing list accepts attachments).
>>
>> Thanks again!
>> Todd
>>
>>
>>
>> On Thu, Jan 30, 2014 at 8:26 PM, Vishwas Babu <[email protected]>wrote:
>>
>>> *over a https channel
>>>
>>>
>>> On 31 January 2014 09:56, Vishwas Babu <[email protected]> wrote:
>>>
>>>> Hello Tod,
>>>>
>>>> >>Is SSL required?
>>>> Yes, by design the platform can only be accessed over a http channel.
>>>> However, I would think that we are open to having a discussion about having
>>>> a build without this restriction.
>>>>
>>>> @ Keith, John
>>>> What are your views on this?
>>>>
>>>> >>Here is the error I am getting, in Firefox, when I attempt to launch
>>>> Mifos X.
>>>> Could you please share your tomcat logs?
>>>>
>>>> Regards,
>>>> Vishwas
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> On 30 January 2014 13:56, Todd Robinson <[email protected]>wrote:
>>>>
>>>>> Hello, Mifos community.
>>>>>
>>>>>
>>>>> I have recently begun volunteering with Mifos, and I am currently
>>>>> working on the Windows Installation Guide for Mifos X (see project page
>>>>> here<https://mifosforge.jira.com/wiki/display/MIFOSX/Windows+Installation+Guide+for+Mifos+X>in
>>>>> the documentation wiki). Many thanks to Ed Cable for helping me get
>>>>> started.
>>>>>
>>>>> As part of learning Mifos X and writing this installation guide, I
>>>>> have installed Mifos X on my own personal machine, a Windows 7 laptop. I
>>>>> am following the technical installation guide
>>>>> here<https://github.com/openMF/mifosx/blob/develop/INSTALL.md>
>>>>> .
>>>>>
>>>>> I am experiencing an error in my installation. Please assist me in
>>>>> getting Mifos X running on my machine.
>>>>>
>>>>>
>>>>> Below are a few relevant notes:
>>>>>
>>>>>
>>>>> (1) I have a fairly technical background, but am not specifically an
>>>>> engineer or IT person.
>>>>>
>>>>>
>>>>> (2) I would like to use this process to learn about the support
>>>>> provided via this mailing list. If possible, please help me get Mifos X
>>>>> running using techniques that a non-technical but computer-savvy user
>>>>> would
>>>>> be capable of. (If this is not currently possible, that is fine for now
>>>>> --
>>>>> it is just a preference that would assist in my documentation work for
>>>>> non-technical users.)
>>>>>
>>>>>
>>>>> (3) Once I get my personal installation running, I will have several
>>>>> technical questions that Ed has asked me to post to this mailing list.
>>>>> These questions relate to writing the non-technical Windows Installation
>>>>> Guide for Mifos X. I will ask these questions on a separate post, once I
>>>>> get my own installation running.
>>>>>
>>>>>
>>>>> (4) There is one technical question I need to bring up now. I am
>>>>> attempting to run Mifos X without SSL, in order to simulate a
>>>>> non-technical
>>>>> user's environment (and also, it's been years since I configured SSL on a
>>>>> web server, so I would prefer to skip that step on my own machine).
>>>>>
>>>>> Here is my question to Ed about this, and his response:
>>>>>
>>>>> Todd: Is SSL required? --- This appears to add quite a bit of
>>>>> complexity to the installation process. I assume the target audience for
>>>>> the Windows install doc will run Mifos on a single computer, or across
>>>>> their local private network, which presumably has already been secured.
>>>>>
>>>>> Ed: I think this is a fantastic question to pose to the mailing
>>>>> list. I was surprised that for any installation we required SSL by default
>>>>> and we should have an open discussion on the mailing list about that. The
>>>>> target audience for this would be those who are installing on a single
>>>>> computer or local network. Where we're looking to scale deployments the
>>>>> most is through our partners, who should be capable enough to configure
>>>>> SSL
>>>>> for their production installs.
>>>>>
>>>>> I bring up this topic in case my lack of SSL usage is negatively
>>>>> affecting my personal Mifos X installation (other than the obvious lack of
>>>>> encryption without SSL).
>>>>>
>>>>>
>>>>> (5) I previous had an all-in-one WAMP stack on my machine, called Uniform
>>>>> Server <http://www.uniformserver.com/>. This was useful for some PHP
>>>>> web apps I was writing, but caused problems with the Mifos X install
>>>>> (especially MySQL) and was very difficult to remove. I believe I have
>>>>> completely removed all traces of Uniform Server, including registry
>>>>> entries, and MySQL is now running fine. I do not think this is related to
>>>>> the error I am getting when launching Mifos, but I wanted to mention for
>>>>> full disclosure.
>>>>>
>>>>>
>>>>> (6) Here is the error I am getting, in Firefox, when I attempt to
>>>>> launch Mifos X.
>>>>>
>>>>> ( URL =
>>>>> http://127.0.0.1:8080/mifosng-provider/api/v1/offices?tenantIdentifier=default&pretty=true)
>>>>>
>>>>> ----------------------------------------
>>>>> HTTP Status 404 - /mifosng-provider/api/v1/offices
>>>>>
>>>>> type Status report
>>>>>
>>>>> message /mifosng-provider/api/v1/offices
>>>>>
>>>>> description The requested resource is not available.
>>>>>
>>>>> Apache Tomcat/7.0.47
>>>>> ----------------------------------------
>>>>>
>>>>>
>>>>> Thanks for your help!
>>>>>
>>>>> Sincerely,
>>>>> Todd Robinson
>>>>> Oregon, USA
>>>>>
>>>>>
>>>>>
>>>>> ------------------------------------------------------------------------------
>>>>> WatchGuard Dimension instantly turns raw network data into actionable
>>>>> security intelligence. It gives you real-time visual feedback on key
>>>>> security issues and trends. Skip the complicated setup - simply import
>>>>> a virtual appliance and go from zero to informed in seconds.
>>>>>
>>>>> http://pubads.g.doubleclick.net/gampad/clk?id=123612991&iu=/4140/ostg.clktrk
>>>>> _______________________________________________
>>>>> Mifos-users mailing list
>>>>> [email protected]
>>>>> https://lists.sourceforge.net/lists/listinfo/mifos-users
>>>>>
>>>>>
>>>>
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> WatchGuard Dimension instantly turns raw network data into actionable
>>> security intelligence. It gives you real-time visual feedback on key
>>> security issues and trends. Skip the complicated setup - simply import
>>> a virtual appliance and go from zero to informed in seconds.
>>>
>>> http://pubads.g.doubleclick.net/gampad/clk?id=123612991&iu=/4140/ostg.clktrk
>>> _______________________________________________
>>> Mifos-users mailing list
>>> [email protected]
>>> https://lists.sourceforge.net/lists/listinfo/mifos-users
>>>
>>>
>>
>>
>> ------------------------------------------------------------------------------
>> WatchGuard Dimension instantly turns raw network data into actionable
>> security intelligence. It gives you real-time visual feedback on key
>> security issues and trends. Skip the complicated setup - simply import
>> a virtual appliance and go from zero to informed in seconds.
>>
>> http://pubads.g.doubleclick.net/gampad/clk?id=123612991&iu=/4140/ostg.clktrk
>> _______________________________________________
>> Mifos-users mailing list
>> [email protected]
>> https://lists.sourceforge.net/lists/listinfo/mifos-users
>>
>>
>
>
> ------------------------------------------------------------------------------
> WatchGuard Dimension instantly turns raw network data into actionable
> security intelligence. It gives you real-time visual feedback on key
> security issues and trends. Skip the complicated setup - simply import
> a virtual appliance and go from zero to informed in seconds.
>
> http://pubads.g.doubleclick.net/gampad/clk?id=123612991&iu=/4140/ostg.clktrk
> _______________________________________________
> Mifos-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/mifos-users
>
>
<?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.
-->
<!-- Note: A "Server" is not itself a "Container", so you may not
define subcomponents such as "Valves" at this level.
Documentation at /docs/config/server.html
-->
<Server port="8005" shutdown="SHUTDOWN">
<!-- Security listener. Documentation at /docs/config/listeners.html
<Listener className="org.apache.catalina.security.SecurityListener" />
-->
<!--APR library loader. Documentation at /docs/apr.html -->
<Listener className="org.apache.catalina.core.AprLifecycleListener" SSLEngine="on" />
<!--Initialize Jasper prior to webapps are loaded. Documentation at /docs/jasper-howto.html -->
<Listener className="org.apache.catalina.core.JasperListener" />
<!-- Prevent memory leaks due to use of particular java/javax APIs-->
<Listener className="org.apache.catalina.core.JreMemoryLeakPreventionListener" />
<Listener className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListener" />
<Listener className="org.apache.catalina.core.ThreadLocalLeakPreventionListener" />
<!-- Global JNDI resources
Documentation at /docs/jndi-resources-howto.html
-->
<GlobalNamingResources>
<!-- Editable user database that can also be used by
UserDatabaseRealm to authenticate users
-->
<Resource name="UserDatabase" auth="Container"
type="org.apache.catalina.UserDatabase"
description="User database that can be updated and saved"
factory="org.apache.catalina.users.MemoryUserDatabaseFactory"
pathname="conf/tomcat-users.xml" />
<Resource type="javax.sql.DataSource"
name="jdbc/mifosplatform-tenants"
factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/mifosplatform-tenants"
username="root"
password="password"
initialSize="3"
maxActive="10"
maxIdle="6"
minIdle="3"
validationQuery="SELECT 1"
testOnBorrow="true"
testOnReturn="true"
testWhileIdle="true"
timeBetweenEvictionRunsMillis="30000"
minEvictableIdleTimeMillis="60000"
logAbandoned="true"
suspectTimeout="60"
/>
</GlobalNamingResources>
<!-- A "Service" is a collection of one or more "Connectors" that share
a single "Container" Note: A "Service" is not itself a "Container",
so you may not define subcomponents such as "Valves" at this level.
Documentation at /docs/config/service.html
-->
<Service name="Catalina">
<!--The connectors can use a shared executor, you can define one or more named thread pools-->
<!--
<Executor name="tomcatThreadPool" namePrefix="catalina-exec-"
maxThreads="150" minSpareThreads="4"/>
-->
<!-- A "Connector" represents an endpoint by which requests are received
and responses are returned. Documentation at :
Java HTTP Connector: /docs/config/http.html (blocking & non-blocking)
Java AJP Connector: /docs/config/ajp.html
APR (HTTP/AJP) Connector: /docs/apr.html
Define a non-SSL HTTP/1.1 Connector on port 8080
-->
<Connector port="8080" protocol="HTTP/1.1"
connectionTimeout="20000"
redirectPort="8443" />
<!-- A "Connector" using the shared thread pool-->
<!--
<Connector executor="tomcatThreadPool"
port="8080" protocol="HTTP/1.1"
connectionTimeout="20000"
redirectPort="8443" />
-->
<!-- Define a SSL HTTP/1.1 Connector on port 8443
This connector uses the JSSE configuration, when using APR, the
connector should be using the OpenSSL style configuration
described in the APR documentation -->
<!--
<Connector port="8443" protocol="HTTP/1.1" SSLEnabled="true"
maxThreads="150" scheme="https" secure="true"
clientAuth="false" sslProtocol="TLS" />
-->
<!-- Define an AJP 1.3 Connector on port 8009 -->
<Connector port="8009" protocol="AJP/1.3" redirectPort="8443" />
<!-- An Engine represents the entry point (within Catalina) that processes
every request. The Engine implementation for Tomcat stand alone
analyzes the HTTP headers included with the request, and passes them
on to the appropriate Host (virtual host).
Documentation at /docs/config/engine.html -->
<!-- You should set jvmRoute to support load-balancing via AJP ie :
<Engine name="Catalina" defaultHost="localhost" jvmRoute="jvm1">
-->
<Engine name="Catalina" defaultHost="localhost">
<!--For clustering, please take a look at documentation at:
/docs/cluster-howto.html (simple how to)
/docs/config/cluster.html (reference documentation) -->
<!--
<Cluster className="org.apache.catalina.ha.tcp.SimpleTcpCluster"/>
-->
<!-- Use the LockOutRealm to prevent attempts to guess user passwords
via a brute-force attack -->
<Realm className="org.apache.catalina.realm.LockOutRealm">
<!-- This Realm uses the UserDatabase configured in the global JNDI
resources under the key "UserDatabase". Any edits
that are performed against this UserDatabase are immediately
available for use by the Realm. -->
<Realm className="org.apache.catalina.realm.UserDatabaseRealm"
resourceName="UserDatabase"/>
</Realm>
<Host name="localhost" appBase="webapps"
unpackWARs="true" autoDeploy="true">
<!-- SingleSignOn valve, share authentication between web applications
Documentation at: /docs/config/valve.html -->
<!--
<Valve className="org.apache.catalina.authenticator.SingleSignOn" />
-->
<!-- Access log processes all example.
Documentation at: /docs/config/valve.html
Note: The pattern used is equivalent to using pattern="common" -->
<Valve className="org.apache.catalina.valves.AccessLogValve" directory="logs"
prefix="localhost_access_log." suffix=".txt"
pattern="%h %l %u %t "%r" %s %b" />
</Host>
</Engine>
</Service>
</Server>
------------------------------------------------------------------------------
WatchGuard Dimension instantly turns raw network data into actionable
security intelligence. It gives you real-time visual feedback on key
security issues and trends. Skip the complicated setup - simply import
a virtual appliance and go from zero to informed in seconds.
http://pubads.g.doubleclick.net/gampad/clk?id=123612991&iu=/4140/ostg.clktrk
_______________________________________________
Mifos-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-users
