On Saturday 03 December 2005 21:50, Randall R Schulz wrote:
Hi,
Is it worse to re-post with proper trimming than it is to leave just the under-trimmed message?
On Saturday 03 December 2005 13:17, Phil Burness wrote:
...
Randall - I haven't a chance!
Interested to read through your notes but I'm not good with Java and don't know how to proceed....
Sorry. It's actually simple enough, if you cut to the chase instead of getting the blow-by-blow that I gave you.
Try this: Create an "sspy" script (be sure to "chmod +x sspy"):
-==--==--==--==--==--==--==--==--==--==--==--==--==--==--==--==- #!/bin/bash --norc
classPath="/usr/share/java/mysql-connector-java.jar"
export CLASSPATH="$classPath"
exec \ java \ -jar /acquisitions/schemaSpy_2.1.0.jar \ -t mysql \ -cp "$classPath" \ "$@" -==--==--==--==--==--==--==--==--==--==--==--==--==--==--==--==-
(For whatever funky reason, you need the Connector/J JAR both in the Java class path _and_ in the -cp argument to schemaSpy itself.)
Be sure to correct the path names for your system.
Based on my experience, I recommend you use 3.1.12 of Connector/J. The one you have should be OK or you can install the latest mysql-connector-java package from the Packman repository (mysql-connector-java-3.1.12-0.pm.0).
If you want to see the pretty graphical database diagrams, install this RPM: <http://www.graphviz.org/pub/graphviz/ARCHIVE/graphviz-2.6-1.fc4.i386.rpm>
Now invoke it like this:
% sspy -db tract -o library -u phil -p X -host localhost -s mysql -all
That should do it.
Again, good luck. If you still have problems, feel free to report back.
Phil
Randall Schulz I feel this is never going to work for me..... I tried using apt to install the mysql-connector-java on packman and it gave me E: package not found...
I set sources.list to look at packman and issued the apt install --no-checksig mysql-connector-java-3.1.12.pm.0 I also tried apt install --no-checksig mysql-connector-java-3.1.12 Same error! I then thought what the heck and downloaded graphviz listed above and did a rpm -Uhv graphviz*.rpm it failed on libstdc++ dependencies :-( Sometimes life is harder than it needs to be....... Phil PS - Glad you like it though!