Installation Issue's

Hello,

I am new to Blojsom and would like to set up a development
environment
on my local machine so I can begin creating a theme for my
blog.
However I seem to be having difficulty installing Blojsom. I
have
included the steps I did to attempt the installation(*note
this is on
Ubuntu Gutsy):-

1. First I set up the Java Environment using the java 1.5.
See
following steps for setting up Java Environment:-

sudo apt-get install sun-java5-jdk sun-java5-plugin
sudo update-java-alternatives -s java-1.5.0-sun
I then added "/usr/lib/jvm/java-6-sun" line to the
top of /etc/jvm file

To test all was fine with the Java Environment I then issued
"java
-version" and the usual was printed to the teminal:

"java version "1.5.0_13"
Java(TM) 2 Runtime Environment, Standard Edition (build
1.5.0_13-b05)
Java HotSpot(TM) Client VM (build 1.5.0_13-b05, mixed mode,
sharing)"

2. Now for MySQL:-

sudo apt-get install mysql-server

I then created a user, and a new database called blojsom and
gave the
user all rights to the database blojsom, basically the same
as
http://wiki.blojsom.com/wiki/display/blojsom
3/Tomcat+Setup+for+MySQL,
and tested user could log in and see database.

3. Downloaded Tomcat 5.0.28

Unzipped the Tomcat to my /home/user directory.

Changed the Tomcat server.xml file to include the
URIEncoding="UTF-8".

Added JAVA_HOME to .bashrc:-

    export JAVA_HOME=/usr/lib/jvm/java-1.5.0-sun
    export PATH=$PATH:$JAVA_HOME/bin

Downloaded the MYSQL JDBC Driver
"mysql-connector-java-3.1.14" package
and placed the .jar into Tomcats common/lib directory.

4. Deploying Blojsom

Did the same as "Setup blojsom" 
http://wiki.blojsom.com/wiki/display/blojsom
3/Tomcat+Setup+for+MySQL

Added MYSQL user name and password that has access to
blojsom in the
"blojsom-helper-beans-include.xml"

5. Attempting to Run

Started tomcat with ./startup.sh

Browsed to http://localhost:8080, and
all is fine. Web apps included
with tomcat appear to be functioning.

Through the tomcat manager I see the Blojsom application
link. When I
click the link I am then direct to go to
http://lo
calhost:8080/blojsom/blog/default. When I do I then see
a
HTTP Status 500 screen with the following errors which you
can see at
pastebin:-

http://pastebin.com/m4e1
ff4a

Whats is wrong here any pointers would be appreciated, I've
ran out of ideas..

Regards

L. Tambiah (flossgeek)

------------------------------------------------------------
-------------
SF.Net email is sponsored by:
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services
for just about anything Open Source.
http://ad.doubleclick.net/clk;164216
239;13503038;w?http://sf.net/marketplace
_______________________________________________
Blojsom-users mailing list
Blojsom-userslists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/blojsom-u
sers

It looks as though there is a problem with the DataSource
properties.

Can you post the datasource definition from 
blojsom-helper-beans-include.xml"?
> Added MYSQL user name and password that has access to
blojsom in the
> "blojsom-helper-beans-include.xml"

----- Original Message ----- 
From: "Lee Tambiah" <leetambiahgmail.com>
To: <blojsom-userslists.sourceforge.net>
Sent: Sunday, December 16, 2007 11:33 AM
Subject: [Blojsom-users] Installation Issue's


> Hello,
>
> I am new to Blojsom and would like to set up a
development environment
> on my local machine so I can begin creating a theme for
my blog.
> However I seem to be having difficulty installing
Blojsom. I have
> included the steps I did to attempt the
installation(*note this is on
> Ubuntu Gutsy):-
>
> 1. First I set up the Java Environment using the java
1.5. See
> following steps for setting up Java Environment:-
>
> sudo apt-get install sun-java5-jdk sun-java5-plugin
> sudo update-java-alternatives -s java-1.5.0-sun
> I then added "/usr/lib/jvm/java-6-sun" line
to the top of /etc/jvm file
>
> To test all was fine with the Java Environment I then
issued "java
> -version" and the usual was printed to the
teminal:
>
> "java version "1.5.0_13"
> Java(TM) 2 Runtime Environment, Standard Edition (build
1.5.0_13-b05)
> Java HotSpot(TM) Client VM (build 1.5.0_13-b05, mixed
mode, sharing)"
>
> 2. Now for MySQL:-
>
> sudo apt-get install mysql-server
>
> I then created a user, and a new database called
blojsom and gave the
> user all rights to the database blojsom, basically the
same as
> http://wiki.blojsom.com/wiki/display/blojsom
3/Tomcat+Setup+for+MySQL,
> and tested user could log in and see database.
>
> 3. Downloaded Tomcat 5.0.28
>
> Unzipped the Tomcat to my /home/user directory.
>
> Changed the Tomcat server.xml file to include the
URIEncoding="UTF-8".
>
> Added JAVA_HOME to .bashrc:-
>
>    export JAVA_HOME=/usr/lib/jvm/java-1.5.0-sun
>    export PATH=$PATH:$JAVA_HOME/bin
>
> Downloaded the MYSQL JDBC Driver
"mysql-connector-java-3.1.14" package
> and placed the .jar into Tomcats common/lib directory.
>
> 4. Deploying Blojsom
>
> Did the same as "Setup blojsom" 
> http://wiki.blojsom.com/wiki/display/blojsom
3/Tomcat+Setup+for+MySQL
>
> Added MYSQL user name and password that has access to
blojsom in the
> "blojsom-helper-beans-include.xml"
>
> 5. Attempting to Run
>
> Started tomcat with ./startup.sh
>
> Browsed to http://localhost:8080, and
all is fine. Web apps included
> with tomcat appear to be functioning.
>
> Through the tomcat manager I see the Blojsom
application link. When I
> click the link I am then direct to go to
> http://lo
calhost:8080/blojsom/blog/default. When I do I then see
a
> HTTP Status 500 screen with the following errors which
you can see at
> pastebin:-
>
> http://pastebin.com/m4e1
ff4a
>
> Whats is wrong here any pointers would be appreciated,
I've ran out of 
> ideas..
>
> Regards
>
> L. Tambiah (flossgeek)
>
>
------------------------------------------------------------
-------------
> SF.Net email is sponsored by:
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services
> for just about anything Open Source.
> http://ad.doubleclick.net/clk;164216
239;13503038;w?http://sf.net/marketplace
> _______________________________________________
> Blojsom-users mailing list
> Blojsom-userslists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/blojsom-u
sers 


------------------------------------------------------------
-------------
SF.Net email is sponsored by:
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services
for just about anything Open Source.
http://ad.doubleclick.net/clk;164216
239;13503038;w?http://sf.net/marketplace
_______________________________________________
Blojsom-users mailing list
Blojsom-userslists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/blojsom-u
sers

On Dec 17, 2007 2:15 AM, Ingo Jobling <ingo.joblingvideotron.ca> wrote:
> It looks as though there is a problem with the
DataSource properties.
>
> Can you post the datasource definition from

Thanks for the reply, here is the "dataSource" in
my
blojsom-helper-beans-include.xml, with the name and password
changed
for obvious reasons:-

    <bean id="dataSource"
class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
        <property name="driverClassName"
value="com.mysql.jdbc.Driver"/>
        <property name="url"
value="jdbc:mysql://localhost:3306/blojsom?autoReconnec
t=true&amp;useUnicode=true&amp;characterEncoding=utf
-8"/>
        <property name="myUsername"
value="blojsom"/>
        <property name="myPassword"
value="blojsom"/>
    </bean>

Thank you

Flossgeek

_________________________________________
> Blojsom-users mailing list
> Blojsom-userslists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/blojsom-u
sers

------------------------------------------------------------
-------------
SF.Net email is sponsored by:
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services
for just about anything Open Source.
http://ad.doubleclick.net/clk;164216
239;13503038;w?http://sf.net/marketplace
_______________________________________________
Blojsom-users mailing list
Blojsom-userslists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/blojsom-u
sers

Looking at the datasource you posted, the properties are
named "myUsername" 
and "myPassword".  Try renaming these properties
to "username" and 
"password" as follows :

<bean id="dataSource"
class="org.apache.commons.dbcp.BasicDataSource" 
destroy-method="close">
        <property name="driverClassName"
value="com.mysql.jdbc.Driver"/>
        <property name="url" 
value="jdbc:mysql://localhost:3306/blojsom?autoReconnec
t=true&amp;useUnicode=true&amp;characterEncoding=utf
-8"/>
        <property name="username"
value="blojsom"/>
        <property name="password"
value="blojsom"/>
    </bean>

----- Original Message ----- 
From: "Lee Tambiah" <leetambiahgmail.com>
To: <blojsom-userslists.sourceforge.net>
Sent: Monday, December 17, 2007 2:05 PM
Subject: Re: [Blojsom-users] Installation Issue's


> On Dec 17, 2007 2:15 AM, Ingo Jobling
<ingo.joblingvideotron.ca> wrote:
>> It looks as though there is a problem with the
DataSource properties.
>>
>> Can you post the datasource definition from
>
> Thanks for the reply, here is the
"dataSource" in my
> blojsom-helper-beans-include.xml, with the name and
password changed
> for obvious reasons:-
>
>    <bean id="dataSource"
>
class="org.apache.commons.dbcp.BasicDataSource"
> destroy-method="close">
>        <property name="driverClassName"
value="com.mysql.jdbc.Driver"/>
>        <property name="url"
>
value="jdbc:mysql://localhost:3306/blojsom?autoReconnec
t=true&amp;useUnicode=true&amp;characterEncoding=utf
-8"/>
>        <property name="myUsername"
value="blojsom"/>
>        <property name="myPassword"
value="blojsom"/>
>    </bean>
>
> Thank you
>
> Flossgeek
>
> _________________________________________
>> Blojsom-users mailing list
>> Blojsom-userslists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/blojsom-u
sers
>
>
------------------------------------------------------------
-------------
> SF.Net email is sponsored by:
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services
> for just about anything Open Source.
> http://ad.doubleclick.net/clk;164216
239;13503038;w?http://sf.net/marketplace
> _______________________________________________
> Blojsom-users mailing list
> Blojsom-userslists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/blojsom-u
sers 


------------------------------------------------------------
-------------
SF.Net email is sponsored by:
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services
for just about anything Open Source.
http://ad.doubleclick.net/clk;164216
239;13503038;w?http://sf.net/marketplace
_______________________________________________
Blojsom-users mailing list
Blojsom-userslists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/blojsom-u
sers

On Dec 17, 2007 10:48 PM, Ingo Jobling <ingo.joblingvideotron.ca> wrote:
> Looking at the datasource you posted, the properties
are named "myUsername"
> and "myPassword".  Try renaming these
properties to "username" and
> "password" as follows :
>
> <bean id="dataSource"
class="org.apache.commons.dbcp.BasicDataSource"
> destroy-method="close">
>         <property name="driverClassName"
value="com.mysql.jdbc.Driver"/>
>         <property name="url"
>
value="jdbc:mysql://localhost:3306/blojsom?autoReconnec
t=true&amp;useUnicode=true&amp;characterEncoding=utf
-8"/>
>         <property name="username"
value="blojsom"/>
>         <property name="password"
value="blojsom"/>
>     </bean>
>
> ----- Original Message -----
> From: "Lee Tambiah" <leetambiahgmail.com>
> To: <blojsom-userslists.sourceforge.net>
>
> Sent: Monday, December 17, 2007 2:05 PM
> Subject: Re: [Blojsom-users] Installation Issue's
>
>
> > On Dec 17, 2007 2:15 AM, Ingo Jobling
<ingo.joblingvideotron.ca> wrote:
> >> It looks as though there is a problem with the
DataSource properties.
> >>
> >> Can you post the datasource definition from
> >
> > Thanks for the reply, here is the
"dataSource" in my
> > blojsom-helper-beans-include.xml, with the name
and password changed
> > for obvious reasons:-
> >
> >    <bean id="dataSource"
> >
class="org.apache.commons.dbcp.BasicDataSource"
> > destroy-method="close">
> >        <property
name="driverClassName"
value="com.mysql.jdbc.Driver"/>
> >        <property name="url"
> >
value="jdbc:mysql://localhost:3306/blojsom?autoReconnec
t=true&amp;useUnicode=true&amp;characterEncoding=utf
-8"/>
> >        <property name="myUsername"
value="blojsom"/>
> >        <property name="myPassword"
value="blojsom"/>
> >    </bean>
> >
> > Thank you
> >
> > Flossgeek

I changed the values to username and password, but I though
you were
suppose to add your mysql username and password here that
has access
to the blojsom database. Which is what I did previously.
Changing the
values you specified now gives me:

HTTP Status 404 - Unable to load blog ID: default

type: Status report
message: Unable to load blog ID: default
description: The requested resource (Unable to load blog ID:
default)
is not available

Thanks

Flossgeek




 _________________________________________
> >> Blojsom-users mailing list
> >> Blojsom-userslists.sourceforge.net
> >> https://lists.sourceforge.net/lists/listinfo/blojsom-u
sers

------------------------------------------------------------
-------------
SF.Net email is sponsored by:
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services
for just about anything Open Source.
http://ad.doubleclick.net/clk;164216
239;13503038;w?http://sf.net/marketplace
_______________________________________________
Blojsom-users mailing list
Blojsom-userslists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/blojsom-u
sers

On Dec 18, 2007 10:17 AM, Lee Tambiah <leetambiahgmail.com> wrote:
>
> On Dec 17, 2007 10:48 PM, Ingo Jobling
<ingo.joblingvideotron.ca> wrote:
> > Looking at the datasource you posted, the
properties are named "myUsername"
> > and "myPassword".  Try renaming these
properties to "username" and
> > "password" as follows :
> >
> > <bean id="dataSource"
class="org.apache.commons.dbcp.BasicDataSource"
> > destroy-method="close">
> >         <property
name="driverClassName"
value="com.mysql.jdbc.Driver"/>
> >         <property name="url"
> >
value="jdbc:mysql://localhost:3306/blojsom?autoReconnec
t=true&amp;useUnicode=true&amp;characterEncoding=utf
-8"/>
> >         <property name="username"
value="blojsom"/>
> >         <property name="password"
value="blojsom"/>
> >     </bean>
> >
> > ----- Original Message -----
> > From: "Lee Tambiah" <leetambiahgmail.com>
> > To: <blojsom-userslists.sourceforge.net>
> >
> > Sent: Monday, December 17, 2007 2:05 PM
> > Subject: Re: [Blojsom-users] Installation Issue's
> >
> >
> > > On Dec 17, 2007 2:15 AM, Ingo Jobling
<ingo.joblingvideotron.ca> wrote:
> > >> It looks as though there is a problem
with the DataSource properties.
> > >>
> > >> Can you post the datasource definition
from
> > >
> > > Thanks for the reply, here is the
"dataSource" in my
> > > blojsom-helper-beans-include.xml, with the
name and password changed
> > > for obvious reasons:-
> > >
> > >    <bean id="dataSource"
> > >
class="org.apache.commons.dbcp.BasicDataSource"
> > > destroy-method="close">
> > >        <property
name="driverClassName"
value="com.mysql.jdbc.Driver"/>
> > >        <property name="url"
> > >
value="jdbc:mysql://localhost:3306/blojsom?autoReconnec
t=true&amp;useUnicode=true&amp;characterEncoding=utf
-8"/>
> > >        <property
name="myUsername" value="blojsom"/>
> > >        <property
name="myPassword" value="blojsom"/>
> > >    </bean>
> > >
> > > Thank you
> > >
> > > Flossgeek
>
> I changed the values to username and password, but I
though you were
> suppose to add your mysql username and password here
that has access
> to the blojsom database. Which is what I did
previously. Changing the
> values you specified now gives me:
>
> HTTP Status 404 - Unable to load blog ID: default
>
> type: Status report
> message: Unable to load blog ID: default
> description: The requested resource (Unable to load
blog ID: default)
> is not available
>
> Thanks
>
>
> Flossgeek
>

Relying to my own message, I get the drift now, it is the
value that
needs to be changed to suit the database user name and
password, I
tried this and still got the 404 - Unable to load blog
ID:default.
Just to make sure I have:-

    <bean id="dataSource"
class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
        <property name="driverClassName"
value="com.mysql.jdbc.Driver"/>
        <property name="url"
value="jdbc:mysql://localhost:3306/blojsom?autoReconnec
t=true&amp;useUnicode=true&amp;characterEncoding=utf
-8"/>
        <property name="username"
value="myUsername"/>
        <property name="password"
value="myPassword"/>
    </bean>

Where myUsername and myPasword contain the user and password
to the
mysql database which has access to the blojsom database.

Flossgeek

------------------------------------------------------------
-------------
SF.Net email is sponsored by:
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services
for just about anything Open Source.
http://ad.doubleclick.net/clk;164216
239;13503038;w?http://sf.net/marketplace
_______________________________________________
Blojsom-users mailing list
Blojsom-userslists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/blojsom-u
sers

Hello dude, I think your problems lies in this line:

value="jdbc:mysql://localhost:3306/blojsom?autoReconnec
t=true&useUnicode=true&characterEncoding=utf-8"
/>

So, first of all, make sure the database (mysql) is on the
same server as
the tomcat. The name of the machine should be localhost in
that case, but I
guess it's just like that.

Then, most important make sure your mysql is using the port
connector like
3306.

Go to the linux console and type something like: ps -ef |
grep mysql

then look for the line like:
/usr/libexec/mysql/mysqld --basedir=/usr
--datadir=/var/lib/mysql
--user=mysql --pid-file=/var/run/mysql/mysql.pid
--skip-external-locking
--port=3306 --socket=/var/run/mysql/mysql.sock


What is important here is to have those parameters included:
--port=3306.

Also make sure NOT to have this parameter:
--skip-networking

You can test for/debug connection to the database using de
mysql client.
-- 
View this message in context: http://www.nabble.com/Installation-Issue%27
s-tp14363287p14394383.html
Sent from the Blojsom - User mailing list archive at
Nabble.com.


------------------------------------------------------------
-------------
SF.Net email is sponsored by:
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services
for just about anything Open Source.
http://ad.doubleclick.net/clk;164216
239;13503038;w?http://sf.net/marketplace
_______________________________________________
Blojsom-users mailing list
Blojsom-userslists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/blojsom-u
sers

having those lines:

        <property name="username"
value="blojsom"/> 
        <property name="password"
value="blojsom"/>

means you must have the username "blojsom" with
the password "blojsom" added
to the mysql database table.

Can you connect with the mysql client using blojsom:blojsom
to the database?
-- 
View this message in context: http://www.nabble.com/Installation-Issue%27
s-tp14363287p14395323.html
Sent from the Blojsom - User mailing list archive at
Nabble.com.


------------------------------------------------------------
-------------
SF.Net email is sponsored by:
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services
for just about anything Open Source.
http://ad.doubleclick.net/clk;164216
239;13503038;w?http://sf.net/marketplace
_______________________________________________
Blojsom-users mailing list
Blojsom-userslists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/blojsom-u
sers

On Dec 18, 2007 11:35 AM, Arise <against_spamzyahoo.com> wrote:
>
> having those lines:
>
>         <property name="username"
value="blojsom"/>
>         <property name="password"
value="blojsom"/>
>
> means you must have the username "blojsom"
with the password "blojsom" added
> to the mysql database table.
>
> Can you connect with the mysql client using
blojsom:blojsom to the database?
> --
> View this message in context: http://www.nabble.com/Installation-Issue%27
s-tp14363287p14395323.html
> Sent from the Blojsom - User mailing list archive at
Nabble.com.

The command:

ps -ef | grep mysql

outputs:

root      4866     1  0 12:57 ?        00:00:00 /bin/sh
/usr/bin/mysqld_safe
mysql     4906  4866  0 12:57 ?        00:00:00
/usr/sbin/mysqld
--basedir=/usr --datadir=/var/lib/mysql --user=mysql
--pid-file=/var/run/mysqld/mysqld.pid
--skip-external-locking
--port=3306 --socket=/var/run/mysqld/mysqld.sock
root      4907  4866  0 12:57 ?        00:00:00 logger -p
daemon.err
-t mysqld_safe -i -t mysqld
1000      5866  5846  0 13:12 pts/0    00:00:00 grep mysql

This indicates port 3306.

With regards to the:-

<property name="username"
value="blojsom"/>
       <property name="password"
value="blojsom"/>

I have a user name called simon and a password called peter
that has
full access to the mysql blojsom database, therefore I
changed it to
the following for my needs:-

<property name="username"
value="simon"/>
       <property name="password"
value="peter"/>

But still no joy, I think the issue is in the jdbc connector
and
mysql, perhaps I need to do a simple database test with a
.jsp page to
see if it is working correctly.

Thanks

flossgeek

_______________________________________________
Blojsom-users mailing list
Blojsom-userslists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/blojsom-u
sers

------------------------------------------------------------
-------------
SF.Net email is sponsored by:
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services
for just about anything Open Source.
http://ad.doubleclick.net/clk;164216
239;13503038;w?http://sf.net/marketplace
_______________________________________________
Blojsom-users mailing list
Blojsom-userslists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/blojsom-u
sers

Check the database with the mysql client or with some 3rd
party client like
dbvis:

Those are the tables I have...

http://programaresociala.ro/resources/default/upl
oads/mysql.png

Do you have the following structure?

If you have them, then maybe you should check some
properties in the tables.
-- 
View this message in context: http://www.nabble.com/Installation-Issue%27
s-tp14363287p14397210.html
Sent from the Blojsom - User mailing list archive at
Nabble.com.


------------------------------------------------------------
-------------
SF.Net email is sponsored by:
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services
for just about anything Open Source.
http://ad.doubleclick.net/clk;164216
239;13503038;w?http://sf.net/marketplace
_______________________________________________
Blojsom-users mailing list
Blojsom-userslists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/blojsom-u
sers