Wednesday, 2014-01-08

*** nowen (~nowen@99-174-92-191.lightspeed.tukrga.sbcglobal.net) has joined #wikid14:10
*** nowen has quit (Read error: Connection reset by peer)16:26
*** nowen (~nowen@99-174-92-191.lightspeed.tukrga.sbcglobal.net) has joined #wikid16:26
*** rick_ (48c40b51@gateway/web/freenode/ip.72.196.11.81) has joined #wikid16:31
rick_is there any documentation on replacing the self signed ssl cert with a wildcard cert for using the wikidadmin16:32
nowenrick_: for the ssl cert for WiKIDAdmin? let me check16:33
rick_yeah, the wikiadmin and thanks16:33
nowenI don't see any.  It is just a standard java cert.  It is called /opt/WiKID/conf/tomcatKeystore16:34
nowenit is set in /opt/WiKID/tomcat/conf/server.xml16:35
rick_ok, thanks will take a look16:35
nowenI will put it on my list of docs to write ;-)16:35
rick_thanks again16:37
nowennp16:37
*** rick_ has quit (Ping timeout: 272 seconds)16:42
*** Troy__ (329b98a8@gateway/web/freenode/ip.50.155.152.168) has joined #wikid20:20
Troy__Good afternoon Nick20:22
nowenhey Troy__20:23
Troy__I'm working with Vince to bring our lab system back online.. Vince is restoring a copy of the db from the production server to the lab server20:23
nowenok20:24
Troy__but we are getting that same issue we had when starting the wikid service..20:24
Troy__on our primary.. The database is not yet configured for WiKID. Please run /opt/WiKID/sbin/load_db.sh.20:24
nowenhmm.20:25
Troy__oops.. actually it fails when initializing wAuth20:25
nowenIs this a new server?20:25
Troy__then when I stop I get that db not configured20:25
nowenI mean, did you just set it up and restore the db? or is the db not restored yet?20:25
Troy__well that's what I can't figure out.. I think the VM got corrupted or something.  because I didn't see the wikid tomcat folder20:26
nowenhmm20:26
nowenyou can try re-running setup20:26
Troy__so I copied that back over from my backup and ran setup again20:26
nowenthere's no /opt/WiKID/tomcat at all?20:27
Troy__Vincent:  I get these errors: [postgres@hsvwikidt2 tomcat]$ /opt/WiKID/sbin/load_db.sh Initializing WiKID database ... Sorry, user postgres is not allowed to execute '/usr/bin/psql -h localhost -d template1 -f /opt/WiKID/conf/database/db-users.sql' as postgres on hsvwikidt2.sanmina-sci.com.20:28
nowencheck the permissions on /var/lib/pgsql/data20:29
Troy__yes.. the tomcat folder is there.. but nothing is extracted in webapps20:29
Troy__just ROOT.. no wikid or WiKIDAdmin20:29
nowenoh - as long as the war files are there, they will extract on a proper start20:30
Troy__ok. I think that's the problem.. the startup doesn't complete.. just hangs on: Waiting for wAuth initialization to complete............20:32
nowentry starting just postgres as a service and see if it fails.  if so, check pgstartup.log20:33
Troy__maybe we should just start over with these lab boxes20:33
Troy__ok20:33
Troy__i asked Vince to join the IRC.. we'll see if he is able20:33
nowenok20:37
Troy__i think it's the pg_hba.conf not setup20:37
nowenIt's also possible that the postgresql.conf didn't get copied correctly.  you can compare it to the one in /opt/WiKID/conf/templates20:38
nowensame for pg_hba.conf20:38
nowenyou can run diff on them and see20:39
Troy__yea.. it looks like it's the default to me20:39
nowenback it up and copy the wikid one in20:39
Troy__ok20:39
nowenany luck?20:47
nowentrying to get to a basketball game.  I may go mobile here20:50
Troy__one min.. Vince is not responding20:51
nowennp20:51
Troy__that's fine.. we are just playing with the test lab20:51
*** nowen_phone (~AndChat72@99-174-92-191.lightspeed.tukrga.sbcglobal.net) has joined #wikid20:52
nowen_phoneOk20:52
nowennowen_phone: ping20:52
nowenhmm. no sound notifications. :(20:53
*** nowen has quit (Quit: Leaving.)20:53
*** nowen (~AndChat72@172.56.5.110) has joined #wikid20:55
*** nowen_phone has quit (Ping timeout: 260 seconds)20:59
nowenCheck21:07
Troy__check21:08
nowenI won't post any basketball pics.  :)21:14
Troy__lol21:16
*** nowen has quit (Quit: Bye)22:28
*** nowen (~nowen@99-174-92-191.lightspeed.tukrga.sbcglobal.net) has joined #wikid22:28
nowenTroy__: any progress?22:28
Troy__Vince is still working on getting the pg sql configuration setup for both test servers22:35
Troy__i'll let you know when we are ready to start it up again22:36
nowenok.23:45

Generated by irclog2html.py 2.11.0 by Marius Gedminas - find it at mg.pov.lt!