Please Help: Workbench Installation Problem

[DMurray3]

Hi all,

I downloaded (today) the Schema Workbench (Release Candidate based on Mondrian HEAD, revision 9247). I unzipped and extracted contents.

I have copied my MySQL .jar file in the \workbench\lib folder and have also placed the same in the "Path" of my Environment Variables.

I start the SW and try to set the JDBC SW Preferences, providing:

DRIVER CLASS NAME: com.mysql.jdbc.Driver
CONNECTION URL: jdbc:mysql://localhost:3306/mydatabasename
USER NAME: myusername
PASSWORD: mypassword

I "accept" the above, but when trying to open a new Schema (File-New-Schema..) the SW displays.....
"Database connection could not be done.
com.mysql.jdbc.Driver
All validations related to database will be ignored"

I have also tried changing the CONNECTION URL to: "jdbc:mysql://localhost:3306/mydatabasename?myusername&mypassword" leaving the USER NAME and PASSWORD fields blank, with the same resutl.

I can confirm that the above specified class name and connection url are correct, because these are the same I use in other connections related to the PCI, PDI, RDW and RD. Further I am using the same MySQL jar file as well. Furthermore, I am using W/XP and have JRE 1.5.0_13 and JDK 1.5.0_13 duely installed in the Path and JAVA_HOME respectively of my Environment Variables. Finally, I have ensured that no spaces exist in the files / folder names.

Any assitance will be highly appreciated.

Regards, Daniel

And cannot

[DMurray3]

Sorry for my previuos post. I didn't read other posts beforehand....

I would suggest that the Workbench be updated in that the jdbc drivers be placed in the ..\lib.. forlder or to provide for said folder from the inset. Alternatively I would suggest updating the WB Wiki Page and Manual advising users to create a "drivers" folder in the Workbench home and have them place thier jdbc connectors in said folder.

Regards, DMurray3

[Phantal]

I don't know what OS you're running, but hopefully if you're not in *nix you can translate what I say to that enviornment. Initially I had trouble with some of the tools for working with pentaho as well and had to make alterations to shell scripts to make sure they worked right. I'm going to quote to you the last few lines of my workbench.sh script, try to make sure yours emulates its behavior

:- Open workbench.sh in the workbench folder
:- Near the bottom is some code that reads (in my script):

for i in `ls drivers/*.jar`; do
CP=$CP:$i
done

#echo $CP
localdir=`echo ~/`
echo "\n"
echo $CP | sed -e 's/:/\n/g'
java -Xms100m -Xmx500m -cp "$CP" -Dlog4j.configuration=file:$localdir/.schemaWorkbench/log4j.xml mondrian.gui.Workbench

I don't remember what all I changed. I seem to remember that the original "java ...." line had:

...guration=file:~/.schemaWorkbench/log4j.xml

... but when things weren't working right, I checked the console output from workbench and it was complaining about ~/, when I realized it was trying to find something with that name and not expanding it to my home directory, so I added that 'localdir' bit in there.

I've written up a bug on this, I don't know if it has received any attention.

-Brian

[Phantal]

Oh, and make sure you also place the mysql driver jar file in the workbench/drivers directory. Can't hurt to spam it anywhere the script might look

-Brian

[DMurray3]

Thank a lot... My OS is W/XP.... fortunately all I had to do was create the drivers folder and copy my .jar conncetor.... I'll keep in mind your suggestions when I use *nix.

Regards, DMurray3