SSL-Explorer 1.0.0_RC17 reset admin on Ubuntu Server 10.04.1 Linux

How are users being authenticated? Active Directory or Built - in?

I'm using built-in accounts..

Well.. I just did a search for this on the net and I couldn't find any hints on resetting the password. You might have to wait for a while to see if it unlocks itself (I read somewhere that there is a time limit before a user account is unlocked - not sure if that holds for admin account too)

See if this uses a DB as a back end. If yes, then you are in luck.

These are all the running processes on the server?  Do any of these look like a database service?  If I know what type of database i shouldn't have any trouble accessing it.

--------------------------------------

ps -A
  PID TTY          TIME CMD
    1 ?        00:00:03 init
    2 ?        00:00:00 kthreadd
    3 ?        00:00:00 migration/0
    4 ?        00:00:01 ksoftirqd/0
    5 ?        00:00:00 watchdog/0
    6 ?        00:01:12 events/0
    7 ?        00:00:00 cpuset
    8 ?        00:00:00 khelper
    9 ?        00:00:00 async/mgr
   10 ?        00:00:00 pm
   11 ?        00:00:10 sync_supers
   12 ?        00:00:24 bdi-default
   13 ?        00:00:00 kintegrityd/0
   14 ?        00:00:34 kblockd/0
   15 ?        00:00:00 kacpid
   16 ?        00:00:00 kacpi_notify
   17 ?        00:00:00 kacpi_hotplug
   18 ?        00:00:00 ata/0
   19 ?        00:00:00 ata_aux
   20 ?        00:00:00 ksuspend_usbd
   21 ?        00:00:00 khubd
   22 ?        00:00:00 kseriod
   23 ?        00:00:00 kmmcd
   26 ?        00:00:03 khungtaskd
   27 ?        00:00:04 kswapd0
   28 ?        00:00:00 ksmd
   29 ?        00:00:00 aio/0
   30 ?        00:00:00 ecryptfs-kthrea
   31 ?        00:00:00 crypto/0
   35 ?        00:00:00 scsi_eh_0
   36 ?        00:00:00 scsi_eh_1
   39 ?        00:00:00 kstriped
   40 ?        00:00:00 kmpathd/0
   41 ?        00:00:00 kmpath_handlerd
   42 ?        00:00:00 ksnapd
   43 ?        00:00:00 kondemand/0
   44 ?        00:00:00 kconservative/0
  227 ?        00:01:59 flush-8:0
  230 ?        00:03:38 jbd2/sda1-8
  231 ?        00:00:00 ext4-dio-unwrit
  250 ?        00:00:00 mountall
  273 ?        00:00:00 upstart-udev-br
  277 ?        00:00:00 udevd
  378 ?        00:00:00 kpsmoused
  574 ?        00:00:38 rsyslogd
  586 ?        00:00:00 dbus-daemon
  603 ?        00:00:23 avahi-daemon
  610 ?        00:00:00 avahi-daemon
  636 tty4     00:00:00 getty
  640 tty5     00:00:00 getty
  645 tty2     00:00:00 getty
  646 tty3     00:00:00 getty
  651 tty6     00:00:00 getty
  661 ?        00:00:10 cron
  662 ?        00:00:00 atd
  701 ?        00:48:47 wrapper
  702 ?        00:00:14 java <defunct>
  728 ?        00:00:00 libvirtd
  800 ?        00:00:06 dhclient3
  883 ?        00:00:00 kdmflush
  913 ?        00:00:00 sshd
  947 ?        00:00:00 kcryptd_io
  948 ?        00:00:00 kcryptd
  976 ?        00:00:21 dnsmasq
 1024 tty1     00:00:00 getty
 1041 ?        02:03:34 java
 3765 ?        00:50:38 java
17262 ?        00:01:25 sshd
17345 ?        00:01:42 sftp-server
17358 ?        00:00:00 sshd
17444 ?        00:00:00 sshd
17445 pts/0    00:00:00 bash
17714 pts/0    00:00:00 less
17829 ?        00:00:00 sshd
17913 ?        00:00:00 sshd
17914 pts/1    00:00:00 bash
17930 pts/1    00:00:00 ps
18196 ?        00:00:00 udevd
18197 ?        00:00:00 udevd
18201 ?        00:00:00 xfs_mru_cache
18202 ?        00:00:00 xfslogd/0
18203 ?        00:00:00 xfsdatad/0
18204 ?        00:00:00 xfsconvertd/0
18207 ?        00:00:00 jfsIO
18208 ?        00:00:00 jfsCommit
18209 ?        00:00:00 jfsSync
30339 ?        00:00:00 console-kit-dae

---------------------------

Now that I think about it I remember reading somewhere that it does have its own database. Assuming it does have its own database how would I access the database and reset or unlock the admin user?

If it does have a DB then mysql is not being used as I don't see mysql running on the server based on the output you have sent.
Probably it uses hsql?

Here is a link which should help you

http://3sp.com/en/kb/idx.php/31/249/Known-issues--Bugs/article/Reenabling-the-Default-Authentication-Scheme-when-you-lock-your-Super-User-out-of-SSLExplorer.html

Hi That link describes a windows based ssl-explorer. I need to to find a way to access the unix/linux based database.

It should be the same on Linux..

Check for a directory named sslexplorer ( can be under /usr/local; /etc/ ; /opt etc..)

You might need X windows to fire up firefox browser and put in the URL
 jdbc:hsqldb:file:<Install Directory>/db/explorer_configuration
or
 jdbc:hsqldb:file:/usr/local/db/explorer_configuration (if it is under /usr/local)

Since you have access to the system, you'll have to spend time searching for it. I guess there is no easy way out..

I will work on this and let you know...

This is a search results for the word sslexplorer and db within those results...

I will search through these for the database...

I do see paths like so:

./opt/sslexplorer-1.0.0_RC17/sslexplorer-community-web-forwards/src/prepared/hsqldb

not sure which is database path though? I will try multiple locations until i get a connection.
fin-keyword-sslexplorer.txt
find-keyword-db.txt

these are some of the paths im going to try...


./opt/sslexplorer-1.0.0_RC17/sslexplorer-community-web-forwards/src/prepared/hsqldb

./opt/sslexplorer-1.0.0_RC17/sslexplorer-community-tunnels/build/classes/prepared/hsqldb

./opt/sslexplorer-1.0.0_RC17/sslexplorer/src/com/sslexplorer/jdbc/hsqldb/

./opt/sslexplorer-1.0.0_RC17/sslexplorer/webapp/WEB-INF/lib/hsqldb.jar

./opt/sslexplorer-1.0.0_RC17/sslexplorer/webapp/WEB-INF/classes/com/sslexplorer/jdbc/hsqldb/


im leaning towards...

./opt/sslexplorer-1.0.0_RC17/sslexplorer/webapp/WEB-INF/lib/hsqldb.jar

as the database though...

actually this looks closer

/opt/sslexplorer-1.0.0_RC17/sslexplorer/db

Hi quick question...I haven't used hummingbird exceed in a few years...

I started exceed then went to the commandline typed:


root@server:/# export DISPLAY=ipaddress
root@server:/# xclock
Error: Can't open display: ipaddress
root@server:/#

Is there a step on the windows desktop im missing.  Its windows 7 with Hummingbird Connectivity 2008 x64 installed...

firewall issue or a step in exceed that im missing maybe?

im all set i was missing X11 x11 forwarding to  localhost:0.0   in putty

i opened firefox from xwindows and enetered this as url

jdbc:hsqldb:file:/opt/sslexplorer-1.0.0_RC17/sslexplorer/db/explorer_configuration


i get this error

"Firefox doesn't know how to open this address, because the protocol (jdbc) inst associated with any program"

I'm going to try this

http://razorsql.com/

I was able to copy the db directory local and using razor sql update AUTH_SCHEMES


UPDATE AUTH_SCHEMES SET ENABLED = '1' WHERE RESOURCE_NAME = 'Default';

i then made a backup of the db directory on the box and overwrote withe the updated db directory...

I will reboot the server tonight and let you know if this worked...

You will not need to reboot the system most probably. Restart the services (ssl-explorer program) and see if you can login using your password.

okay i will restart services tonight and let you know.

How do I restart services?

Check if there are binaries under /etc/init.d to /opt/ssl-explorer....

it might be /etc/init.d/ssl-explorer

Then restart as,
/etc/init.d/ssl-explorer stop (wait 1 - 2 minutes for all java processes to gracefully stop)
/etc/init.d/ssl-explorer start

hi i ended up rebooting now it isn't working at all. I tried coping the old db back as a test as well..
/opt/sslexplorer-1.0.0_RC17/sslexplorer/db/

ive tried stopping and start and it says its starting...but still no good

/etc/init.d/sslexplorer stop
and
/etc/init.d/sslexplorer start


root@severhost:~# /etc/init.d/sslexplorer start
Starting SSL-Explorer...
root@severhost:~#

i also tried from this method..

service sslexplorer start

from
/opt/sslexplorer-1.0.0_RC17/sslexplorer

:/opt/sslexplorer-1.0.0_RC17/sslexplorer# service sslexplorer start
Starting SSL-Explorer...
root@serverhost:/opt/sslexplorer-1.0.0_RC17/sslexplorer#

i do get this when i try to stop...so i guess it really isnt running?

root@severhost:/opt/sslexplorer-1.0.0_RC17/sslexplorer# /etc/init.d/sslexplorer stop
Stopping SSL-Explorer...
SSL-Explorer was not running.
root@severhost:/opt/sslexplorer-1.0.0_RC17/sslexplorer#

This is what is currently running, what was running and what is in the init.d directory
conents-of-init.d.txt
was-running.txt
currently-running.txt

Can you do a "ps -ef | grep -i ssl" after you /etc/init.d/sslexplorer start and see if it really runs.. If it doesn't then something is preventing it from running. We'll have to find the logs.. hopefully it is under /var/log/messages or it might hve its own log..

output from ps looking for ssl after sslexplorer start
---------------------------------------

root@severhost:/etc/init.d# clear
root@severhost:/etc/init.d# /etc/init.d/sslexplorer start
Starting SSL-Explorer...
root@severhost:/etc/init.d# ps -ef | grep -i ssl
tomcat6   1966     1  1 10:25 ?        00:00:05 /usr/lib/jvm/java-6-openjdk/bin/java -Djava.util.logging.config.file=/var/lib/tomcat6/conf/logging.properties -Djava.awt.headless=true -Xmx128M -XX:+UseConcMarkSweepGC -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Djava.endorsed.dirs=/usr/share/tomcat6/endorsed -classpath /usr/share/tomcat6/bin/bootstrap.jar -Dcatalina.base=/var/lib/tomcat6 -Dcatalina.home=/usr/share/tomcat6 -Djava.io.tmpdir=/tmp/tomcat6-tmp org.apache.catalina.startup.Bootstrap start
root      2055     1  0 10:30 ?        00:00:00 /opt/sslexplorer-1.0.0_RC17/sslexplorer/install/platforms/linux/x86/wrapper /opt/sslexplorer-1.0.0_RC17/sslexplorer/conf/wrapper.conf wrapper.pidfile=tmp/sslexplorer.pid wrapper.daemonize=TRUE
root      2056  2055 90 10:30 ?        00:00:04 /usr/lib/jvm/java-1.5.0-sun-1.5.0.15/jre/bin/java -Dsun.jnu.encoding=UTF-8 -Dfile.encoding=UTF-8 -Xms64m -Xmx512m -Djava.library.path=/opt/sslexplorer-1.0.0_RC17/sslexplorer/install/platforms/linux/x86 -classpath build/boot:lib/sslexplorer-boot.jar -Dwrapper.key=OkISTTMHxQefBMeh -Dwrapper.port=32000 -Dwrapper.use_system_time=TRUE -Dwrapper.version=3.1.2 -Dwrapper.native_library=wrapper -Dwrapper.service=TRUE -Dwrapper.cpu.timeout=10 -Dwrapper.jvmid=1 com.sslexplorer.boot.Bootstrap
root      2080  1592  0 10:30 pts/0    00:00:00 grep --color=auto -i ssl
root@severhost:/etc/init.d#

attached is

var/log/messages
var-log-messages.txt

It seems to be running. What happens when you try to invoke the program? How do you start the interface or use the program. The output shows this is running

i did find this file...i also attached the full file...


/opt/sslexplorer-1.0.0_RC17/sslexplorer/logs/sslexplorer.log

these were the errors in it....
--------------------------------------------------------

      Line 271: 26-03-2012 18:29:08 [WebServer] ERROR CoreServlet - Failed to initialise property database.
      Line 296: 26-03-2012 18:29:08 [WebServer] ERROR CoreServlet - Failed to initialise core.
      Line 370: 26-03-2012 18:29:37 [WebServer] ERROR Main - Failed to start Jetty. Multiple exceptions
      Line 530: 26-03-2012 18:29:57 [WebServer] ERROR CoreServlet - Failed to initialise property database.
      Line 555: 26-03-2012 18:29:57 [WebServer] ERROR CoreServlet - Failed to initialise core.
      Line 629: 26-03-2012 18:30:14 [WebServer] ERROR Main - Failed to start Jetty. Multiple exceptions
      Line 789: 26-03-2012 18:32:29 [WebServer] ERROR CoreServlet - Failed to initialise property database.
      Line 814: 26-03-2012 18:32:29 [WebServer] ERROR CoreServlet - Failed to initialise core.
      Line 888: 26-03-2012 18:32:32 [WebServer] ERROR Main - Failed to start Jetty. Multiple exceptions
      Line 1048: 26-03-2012 18:36:00 [WebServer] ERROR CoreServlet - Failed to initialise property database.
      Line 1073: 26-03-2012 18:36:00 [WebServer] ERROR CoreServlet - Failed to initialise core.
      Line 1147: 26-03-2012 18:36:02 [WebServer] ERROR Main - Failed to start Jetty. Multiple exceptions
      Line 1307: 26-03-2012 20:06:15 [WebServer] ERROR CoreServlet - Failed to initialise property database.
      Line 1332: 26-03-2012 20:06:15 [WebServer] ERROR CoreServlet - Failed to initialise core.
      Line 1406: 26-03-2012 20:06:55 [WebServer] ERROR Main - Failed to start Jetty. Multiple exceptions
      Line 1566: 27-03-2012 07:44:47 [WebServer] ERROR CoreServlet - Failed to initialise property database.
      Line 1591: 27-03-2012 07:44:47 [WebServer] ERROR CoreServlet - Failed to initialise core.
      Line 1665: 27-03-2012 07:44:50 [WebServer] ERROR Main - Failed to start Jetty. Multiple exceptions
      Line 1825: 27-03-2012 09:59:16 [WebServer] ERROR CoreServlet - Failed to initialise property database.
      Line 1850: 27-03-2012 09:59:16 [WebServer] ERROR CoreServlet - Failed to initialise core.
      Line 1924: 27-03-2012 09:59:18 [WebServer] ERROR Main - Failed to start Jetty. Multiple exceptions
      Line 2084: 27-03-2012 10:07:22 [WebServer] ERROR CoreServlet - Failed to initialise property database.
      Line 2109: 27-03-2012 10:07:22 [WebServer] ERROR CoreServlet - Failed to initialise core.
      Line 2183: 27-03-2012 10:07:57 [WebServer] ERROR Main - Failed to start Jetty. Multiple exceptions
      Line 2343: 27-03-2012 10:20:01 [WebServer] ERROR CoreServlet - Failed to initialise property database.
      Line 2368: 27-03-2012 10:20:01 [WebServer] ERROR CoreServlet - Failed to initialise core.
      Line 2442: 27-03-2012 10:20:29 [WebServer] ERROR Main - Failed to start Jetty. Multiple exceptions
      Line 2602: 27-03-2012 10:24:24 [WebServer] ERROR CoreServlet - Failed to initialise property database.
      Line 2627: 27-03-2012 10:24:24 [WebServer] ERROR CoreServlet - Failed to initialise core.
      Line 2701: 27-03-2012 10:24:25 [WebServer] ERROR Main - Failed to start Jetty. Multiple exceptions
      Line 2861: 27-03-2012 10:25:50 [WebServer] ERROR CoreServlet - Failed to initialise property database.
      Line 2886: 27-03-2012 10:25:50 [WebServer] ERROR CoreServlet - Failed to initialise core.
      Line 2960: 27-03-2012 10:25:52 [WebServer] ERROR Main - Failed to start Jetty. Multiple exceptions
      Line 3121: 27-03-2012 10:30:14 [WebServer] ERROR CoreServlet - Failed to initialise property database.
      Line 3146: 27-03-2012 10:30:14 [WebServer] ERROR CoreServlet - Failed to initialise core.
      Line 3220: 27-03-2012 10:30:16 [WebServer] ERROR Main - Failed to start Jetty. Multiple exceptions
sslexplorer.log.txt

I use it all as a web application remotely...

https://hostname

maybe web service or tomcat isn't running right?

The errors start when the program tries to initialize the database.

27-03-2012 10:30:14 [WebServer] ERROR CoreServlet - Failed to initialise property database.
java.sql.SQLException: Wrong database file version

You will have to check if the name of the DB is correctly mentioned in the configuration file.. (which I'm not familiar with)

You can also try to restart the setup and not do any changes as mentioned in the link

http://3sp.com/en/kb/idx.php/31/249/Known-issues--Bugs/article/Reenabling-the-Default-Authentication-Scheme-when-you-lock-your-Super-User-out-of-SSLExplorer.html

See the comments section (last)

okay well i did run part of the installer again bit that didnt seem to do anything...but i did find a way to copy old db back and restart and its running again...but i need to still edit database i guess

were you able to find a tool that i can use on the server to edit the hsql db?

Doesn't RazorSQL do the job?

I wonder if the razorsql tool modifies the db version

I tried the windows version of razorsql...i wonder if it changes the db version...

Try this
http://www.dbvis.com/products/dbvis/features/index.jsp?page=screens

I haven't used this though.. You can try it on the backed up DB and see if you really can modify contents

I suggest you try this first though since it is from the creator of the hsqld DB

http://hsqldb.org/doc/guide/running-chapt.html#rgc_access_tools

Full solution described in last comment......

Too bad the links to the solution on the 3sp web site are no longer valid.  Any chance of you posting the original text of those links?  I am fighting the same problem right now, but on Windows...