[Logo] SpagoWorld Forums
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing  
[Groups] Back to home page  [Moderation Log] Moderation Log   [Register] Register /  [Login] Login 
SpagoBI 3.3 All-In-One Installation problem  XML
Forum Index » Technical Help - SpagoBI Server - CORE
Author Message
peronist.spw



Joined: 22/02/2012 21:34:04
Messages: 5
Location: Ancona - Italy
Offline

Dear all,
I have download the file "All-In-One-SpagoBI-3.3-01242012.zip" from the SpagoBI website and extract it on a windows xp folder (spagobi).
Everything went fine and when I started the SpagoBI Server from <spagobi_dir>/bin/SapgoBIstartup
and I have seen a lot of tomcat messages. Then I tried http://localhost:8080/spagobi, but I got the error below:

HTTP Status 404 - /SpagoBI

type Status report

message /SpagoBI

description The requested resource (/SpagoBI) is not available.
Apache Tomcat/6.0.35

The Java home is into the path and is 1.6.0_22

What I'm doing wrong ?
Another question: may I use this version (all-in-one) or it's just a demo ?

Thanks in advance for your support

sp
edro.spw



Joined: 05/03/2012 15:14:51
Messages: 7
Offline

I am also experiencing the same problem.

I am able to successfully run Tomcat and don't see and errors from running the SpagoBIStartup.bat script.

Any suggestions? Am I overlooking anything?
e0419.spw


[Avatar]

Joined: 06/03/2012 13:48:49
Messages: 4
Location: rome
Offline

I am also experiencing the same problem. Do you succed in solving this issue?
thanks in advance.
Lisa e Ale
e0419.spw


[Avatar]

Joined: 06/03/2012 13:48:49
Messages: 4
Location: rome
Offline

peronist.spw
maybe you can try using http://localhost:8080/spagoBI

that is with caps on
angioia

SpagoBI hero
[Avatar]

Joined: 12/04/2010 15:41:11
Messages: 562
Location: Milan, Italy
Offline

The name of the webapp in the url is case sensitive. try with ...

http://localhost:8080/SpagoBI

where S, B and I are in uppercase.

This message was edited 1 time. Last update was at 06/03/2012 14:16:14


Andrea Gioia
-------------------------
@andrea_gioia
@geobinitiative
-------------------------
[WWW]
edro.spw



Joined: 05/03/2012 15:14:51
Messages: 7
Offline

Tried that and still does not work. Tried all sorts of variations with no luck.
edro.spw



Joined: 05/03/2012 15:14:51
Messages: 7
Offline

Can you have a look at my server.xml configuration file. I have a feeling it may have something to do with my configuration.

<?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">

<!--APR library loader. Documentation at /docs/apr.html -->
<Listener SSLEngine="on" className="org.apache.catalina.core.AprLifecycleListener"/>
<!--Initialize Jasper prior to webapps are loaded. Documentation at /docs/jasper-howto.html -->
<Listener className="org.apache.catalina.core.JasperListener"/>
<!-- JMX Support for the Tomcat server. Documentation at /docs/non-existent.html -->
<Listener className="org.apache.catalina.mbeans.ServerLifecycleListener"/>
<Listener className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListener"/>

<!-- 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 auth="Container" description="User database that can be updated and saved" factory="org.apache.catalina.users.MemoryUserDatabaseFactory" name="UserDatabase" pathname="conf/tomcat-users.xml" type="org.apache.catalina.UserDatabase"/>

<!--<Environment name="<VARIABLE-NAME>" type="java.lang.String" value="<VARIABLE-VALUE>"/>-->

<Environment name="spagobi_resource_path" type="java.lang.String" value="../resources"/>
<Environment name="spagobi-sso-class" type="java.lang.String" value="it.eng.spagobi.services.common.FakeSsoService"/>
<Environment name="spagobi-service-url" type="java.lang.String" value="http://localhost:8080/SpagoBI"/>
<Environment name="spagobi-host-url" type="java.lang.String" value="http://localhost:8080"/>


<Context docBase="SpagoBI" path="/SpagoBI" privileged="true" reloadable="true">
<!-- <ResourceLink global="<VARIABLE-NAME>" name="<VARIABLE-NAME>" type="java.lang.String"/> -->
<ResourceLink global="jdbc/spagobi" name="jdbc/spagobi" type="javax.sql.DataSource"/>
<ResourceLink global="jdbc/foodmart" name="jdbc/foodmart" type="javax.sql.DataSource"/>
<ResourceLink global="spagobi-resource-path" name="spagobi-resource-path" type="java.lang.String"/>
<ResourceLink global="spagobi-sso-class" name="spagobi-sso-class" type="java.lang.String"/>
<ResourceLink global="spagobi-host-url" name="spagobi-host-url" type="java.lang.String"/>

<ResourceLink global= "wm/SpagoWorkManager" name= "wm/SpagoWorkManager" type="jcommonj.work.WorkManager" />
</Context>


<Context docBase="SpagoBIJasperReportEngine" path="/SpagoBIJasperReportEngine" privileged="true" reloadable="false">
<ResourceLink global="jdbc/foodmart" name="jdbc/foodmart" type="javax.sql.DataSource"/>
<ResourceLink global="jdbc/spagobi" name="jdbc/spagobi" type="javax.sql.DataSource"/>
<ResourceLink global="spagobi-resource-path" name="spagobi_resource-path" type="java.lang.String"/>
<ResourceLink global="spagobi-sso-class" name="spagobi-sso-class" type="java.lang.String"/>
<ResourceLink global="spagobi-service-url" name="spagobi-service-url" type="java.lang.String"/>
</Context>

<Resource name="jdbc/spagobi" auth="Container"
type="javax.sql.DataSource" driverClassName="com.mysql.jdbc.Driver"
url="jdbc:hsqldb:file:${catalina.base}/database/spagobi"
username="sa" password="" maxActive="20" maxIdle="10"
maxWait="-1"/>

<Resource name="jdbc/foodmart" auth="Container"
type="javax.sql.DataSource" driverClassName="com.mysql.jdbc.Driver"
url="jdbc:hsqldb:hsql://localhost:9001/foodmart"
username="sa" password="" maxActive="20" maxIdle="10"
maxWait="-1" validationQuery="select 1 from INFORMATION_SCHEMA.SYSTEM_USERS"
removeAbandoned="true" removeAbandonedTimeout="3600"/>

<Resource name="jdbc/bam" auth="Container"
type="javax.sql.DataSource" driverClassName="com.mysql.jdbc.Driver"
url="jdbc:hsqldb:file:${catalina.base}/database/bam"
username="sa" password="" maxActive="20" maxIdle="10"
maxWait="-1"/>

<Resource auth="Container" factory="de.myfoo.commonj.work.FooWorkManagerFactory"
maxThreads="5" name="wm/SpagoWorkManager"
type="commonj.work.WorkManager"/>


<Resource auth="Container" driverClassName="com.mysql.jdbc.Driver" maxActive="20" maxIdle="10" maxWait="-1"
name="jdbc/spagobi" password="root" type="javax.sql.DataSource" url="jdbc:mysql://localhost/spagobi" username="root"/>

<Resource auth="Container" driverClassName="com.mysql.jdbc.Driver" maxActive="20" maxIdle="10" maxWait="-1"
name="jdbc/foodmart" password="root" type="javax.sql.DataSource" url="jdbc:mysql://localhost/foodmart" username="root"/>

</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 connectionTimeout="20000" port="8080" protocol="HTTP/1.1" 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 defaultHost="localhost" name="Catalina">

<!--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"/>
-->

<!-- The request dumper valve dumps useful debugging information about
the request and response data received and sent by Tomcat.
Documentation at: /docs/config/valve.html -->
<!--
<Valve className="org.apache.catalina.valves.RequestDumperValve"/>
-->

<!-- 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"/>

<!-- Define the default virtual host
Note: XML Schema validation will not work with Xerces 2.2.
-->
<Host appBase="webapps" autoDeploy="true" name="localhost" unpackWARs="true" xmlNamespaceAware="false" xmlValidation="false">

<!-- 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 -->
<!--
<Valve className="org.apache.catalina.valves.AccessLogValve" directory="logs"
prefix="localhost_access_log." suffix=".txt" pattern="common" resolveHosts="false"/>
-->
</Host>
</Engine>
</Service>
</Server>

angioia

SpagoBI hero
[Avatar]

Joined: 12/04/2010 15:41:11
Messages: 562
Location: Milan, Italy
Offline

If you get always a 404 error that means that for some reasons the server is unable to sturtup the SpagoBI webapp. If so, an error should be visible in catalina.log file. Can you check?

Andrea Gioia
-------------------------
@andrea_gioia
@geobinitiative
-------------------------
[WWW]
edro.spw



Joined: 05/03/2012 15:14:51
Messages: 7
Offline

Searched the entire PC and could not find the catalina.log file
edro.spw



Joined: 05/03/2012 15:14:51
Messages: 7
Offline

Disregard my last message. I found the log file but no error message.

Catalina.2012-03-05.log:
Mrz 05, 2012 11:10:48 AM org.apache.catalina.core.StandardContext reload
Information: Reloading Context with name [/SpagoBISDK] has started
edro.spw



Joined: 05/03/2012 15:14:51
Messages: 7
Offline

I realized that no log files are generated for SpagobI server. Is it an option I have to turn on? If so, how?
angioia

SpagoBI hero
[Avatar]

Joined: 12/04/2010 15:41:11
Messages: 562
Location: Milan, Italy
Offline

log behaviour is configurated using file \webapps\SpagoBI\WEB-INF\classes\log4j.properties

Anyway it should be already on, even if configured to lowes verbosity (tracing level ERROR). So if you cannot see a file named SpagoBI.log in logs folder, no matter if the file itself is empty, this means that the webapp has not been started properly during server's boot. Could you post the whole catalona.log file here?

Andrea

Andrea Gioia
-------------------------
@andrea_gioia
@geobinitiative
-------------------------
[WWW]
kyhutch.spw



Joined: 20/03/2012 18:00:56
Messages: 2
Offline

I had the same problem trying to run the demo program. I downloaded the SpagoBI 3.3 All in One zip file, unzipped it and ran the SpagoBIStartup.bat file (I am working a Windows XP box) and tried to connect to the localhost:8080/SpagoBI url. Nothing would happen. Even when I tried to go to the default TomCat webpage of localhost:8080 nothing would come up.

I discovered that in order to make the demo application run correctly on Windows that you need to take rename the directory that you upzip to SpagoBI and put it in the root of the C:\ directory (C:\SpagoBI). Be sure to type the case exactly or else it will not work. So your directory location should be C:\SpagoBI\bin when you go to run the SpagoBIStartup.bat and everything should run correctly.

I found the hint to this solution buried inside a web.xml file that is looking for the resource directory in "C:/SpagoBI/resources" (TomCat uses the forward slash, so don't worry that it is a different slash than what Windows displays). I hope this helps get the demo running for other people too.
angioia

SpagoBI hero
[Avatar]

Joined: 12/04/2010 15:41:11
Messages: 562
Location: Milan, Italy
Offline

That's really strange. I installed SpagoBI 3.3 under folder D:\Documenti\Prototipi\SpagoBIServer\spagobi-3.3.0 and it works properly when I run SpagoBIStratup.bat . I'm on Window 7.

I found the hint to this solution buried inside a web.xml file that is looking for the resource directory in "C:/SpagoBI/resources"


web.xml file of which web application? Can you provide its relative path from your root installation folder?

Regards,

Andrea Gioia
-------------------------
@andrea_gioia
@geobinitiative
-------------------------
[WWW]
kyhutch.spw



Joined: 20/03/2012 18:00:56
Messages: 2
Offline

web.xml file of which web application? Can you provide its relative path from your root installation folder?



So starting at my root directory here is the rest of the file path %ROOTDIR%\webapps\SpagoBI\WEB-INF\web.xml
 
Forum Index » Technical Help - SpagoBI Server - CORE
Go to:   
Powered by JForum 2.1.9 © JForum Team