| *** remix_tj has quit (Ping timeout: 272 seconds) | 10:52 | |
| *** remix_tj (~remix_tj@ip6.server.remixtj.net) has joined #wikid | 11:05 | |
| *** nowen (~nowen@adsl-176-210-205.asm.bellsouth.net) has joined #wikid | 13:14 | |
| *** davidspollack (4a022302@gateway/web/freenode/ip.74.2.35.2) has joined #wikid | 18:53 | |
| davidspollack | anyone here | 18:53 |
|---|---|---|
| nowen | yep | 18:54 |
| davidspollack | hi there. | 18:54 |
| davidspollack | so i got around to installing this today, rpm version | 18:54 |
| davidspollack | postgress was installed via RPM, and then the wikid rpms | 18:55 |
| nowen | community or enterprise? | 18:55 |
| davidspollack | enterprise | 18:55 |
| nowen | ok | 18:55 |
| davidspollack | the logger & "timecop" services arent starting | 18:55 |
| davidspollack | and i dont see why. | 18:55 |
| davidspollack | Starting Logger service...Database listener not available! Logger NOT started! Starting TimeCop service...Database listener not available! Timecop NOT started! | 18:55 |
| davidspollack | i found your post on this, and made sure I followed those instructions | 18:56 |
| nowen | maybe the db wasn't initialized? | 18:56 |
| davidspollack | how can I check that | 18:56 |
| nowen | if you run 'service postgresql start' does the db start? | 18:56 |
| davidspollack | yes | 18:56 |
| nowen | which doc are you following? the enterprise rpm one? | 18:57 |
| davidspollack | maybe not. | 18:57 |
| davidspollack | i found a post you wrote in response to this error. | 18:57 |
| davidspollack | do you have a link for the document? | 18:57 |
| nowen | http://www.wikidsystems.com/support/wikid-support-center/installation-how-tos/how-to-install-the-wikid-enterprise-rpms | 18:58 |
| davidspollack | thanks | 18:58 |
| davidspollack | ok now im geting somewhere | 18:59 |
| davidspollack | looks like postgres starts but isnt listening | 18:59 |
| nowen | hmm | 18:59 |
| davidspollack | i have no postgres experience; is this a common issue | 19:00 |
| nowen | what port are you checking for it on? | 19:00 |
| davidspollack | all i did was the yum install postgresql (for all the packages) | 19:00 |
| davidspollack | selinux is off ... | 19:00 |
| nowen | do the yum install listed on that page to get all the right packages | 19:01 |
| davidspollack | yes ive done that | 19:01 |
| nowen | what is in /var/lib/pgsql/pgstart.log | 19:01 |
| davidspollack | one sec | 19:01 |
| nowen | that name may be wrong | 19:01 |
| nowen | pgstartup.log | 19:02 |
| davidspollack | no such file ... | 19:02 |
| nowen | what OS is this? | 19:02 |
| davidspollack | but i see sucessful startups in /var/log/messages | 19:02 |
| davidspollack | centos 4.x | 19:02 |
| davidspollack | [root@parrot WiKID]$ uname -a Linux parrot.slm.int 2.6.9-55.ELsmp #1 SMP Wed May 2 14:04:42 EDT 2007 x86_64 x86_64 x86_64 GNU/Linux | 19:02 |
| davidspollack | java 1.6u21 | 19:03 |
| nowen | try ' | 19:03 |
| nowen | service postgresql initdb' | 19:03 |
| davidspollack | [root@parrot WiKID]$ uname -a Linux parrot.slm.int 2.6.9-55.ELsmp #1 SMP Wed May 2 14:04:42 EDT 2007 x86_64 x86_64 x86_64 GNU/Linux | 19:03 |
| davidspollack | oops | 19:03 |
| davidspollack | no such option | 19:04 |
| davidspollack | [root@parrot WiKID]$ service postgresql initdb Usage: /etc/init.d/postgresql {start|stop|status|restart|condrestart|condstop|reload|force-reload} | 19:04 |
| nowen | 'ls -all /var/lib/pgsql/' | 19:04 |
| nowen | there should be a log there | 19:04 |
| nowen | also: 'netstat -anp | grep postgres' | 19:05 |
| davidspollack | initdb.i18n | 19:05 |
| nowen | do you have to stick with centos4? 4 has been out for a while and 6 should be here any minute | 19:05 |
| davidspollack | its not stayign up | 19:05 |
| davidspollack | no i dont have to | 19:06 |
| davidspollack | its just the box im using for testing. | 19:06 |
| davidspollack | how big is the iso/vm download? | 19:06 |
| nowen | how do you know it's not staying up? | 19:06 |
| nowen | ~700 m | 19:06 |
| davidspollack | cause after I run service postgresql start, theres no postgres process | 19:06 |
| davidspollack | ill ry & start it manuallu | 19:06 |
| nowen | the iso is super easy to setup | 19:06 |
| davidspollack | manually | 19:06 |
| davidspollack | im sure | 19:06 |
| davidspollack | id just rather not have another box if it isnt necessary | 19:07 |
| davidspollack | can you explain one thing ? | 19:07 |
| nowen | sure | 19:07 |
| davidspollack | why does the server needs to be exposed to the internet | 19:07 |
| nowen | the token clients talk to the server | 19:07 |
| nowen | are you running other software on this server? perhaps it is already using that port? | 19:08 |
| davidspollack | wiat ipostgres is up | 19:08 |
| davidspollack | postgres 31558 1 0 13:59 pts/0 00:00:00 /usr/bin/postmaster -p 5432 -D /var/lib/pgsql/data postgres 31560 31558 0 13:59 pts/0 00:00:00 postgres: stats buffer process postgres 31561 31560 0 13:59 pts/0 00:00:00 postgres: stats collector process | 19:08 |
| davidspollack | on the default port too. | 19:08 |
| nowen | ok | 19:09 |
| nowen | did you run the install scripts? | 19:09 |
| davidspollack | yes | 19:09 |
| davidspollack | i wiill re-run them. | 19:09 |
| nowen | no | 19:09 |
| nowen | don't do that | 19:09 |
| davidspollack | ok | 19:10 |
| nowen | do this | 19:10 |
| nowen | su - postgres | 19:10 |
| davidspollack | ok | 19:10 |
| nowen | pgsql -d wikid | 19:10 |
| nowen | \dt; | 19:10 |
| nowen | and see if the database is there | 19:11 |
| davidspollack | whoa | 19:11 |
| davidspollack | something is wrong | 19:11 |
| davidspollack | [postgres@parrot ~]$ pgsql -bash: pgsql: command not found | 19:11 |
| nowen | sorry | 19:11 |
| nowen | psql -d wikid | 19:11 |
| davidspollack | aha. | 19:11 |
| davidspollack | [postgres@parrot ~]$ psql -d wikid psql: FATAL: database "wikid" does not exist [postgres@parrot ~]$ | 19:11 |
| nowen | ok - rerun the scripts | 19:12 |
| nowen | ctrl -d to get out of postgres | 19:12 |
| davidspollack | ok im going to run | 19:12 |
| davidspollack | wikidserver_config.sh | 19:12 |
| davidspollack | and then | 19:12 |
| davidspollack | wikid-firstboot.sh | 19:13 |
| davidspollack | right? | 19:13 |
| nowen | yes | 19:13 |
| davidspollack | [root@parrot WiKID]$ /opt/WiKID/conf/templates/wikid-firstboot.sh dropdb: database removal failed: ERROR: database "wikid" does not exist dropuser: removal of user "wikid-sens" failed: ERROR: user "wikid-sens" does not exist dropuser: removal of user "timecop" failed: ERROR: user "timecop" does not exist dropuser: removal of user "tomcat" failed: ERROR: user "tomcat" does not exist dropuser: removal of user "wikidadmin" failed: | 19:14 |
| davidspollack | Initializing WiKID database ... psql: could not connect to server: Connection refused Is the server running on host "localhost" and accepting TCP/IP connections on port 5432? psql: could not connect to server: Connection refused Is the server running on host "localhost" and accepting TCP/IP connections on port 5432? psql: could not connect to server: Connection refused Is the server running on host "localhost" and accepting TC | 19:14 |
| davidspollack | wierd. | 19:14 |
| davidspollack | let me check the hosts file ... | 19:14 |
| davidspollack | that looks ok | 19:14 |
| nowen | what does 'netstat -anp | grep postgres' show? | 19:15 |
| davidspollack | nothing. | 19:16 |
| davidspollack | wierd. | 19:16 |
| davidspollack | [root@parrot WiKID]$ netstat -anp | grep postgres [root@parrot WiKID]$ netstat -tulnp | grep post [root@parrot WiKID]$ ps -ef | grep post postgres 9593 1 0 14:13 pts/0 00:00:00 /usr/bin/postmaster -p 5432 -D /var/lib/pgsql/data postgres 9595 9593 0 14:13 pts/0 00:00:00 postgres: stats buffer process postgres 9596 9595 0 14:13 pts/0 00:00:00 postgres: stats collector process | 19:16 |
| davidspollack | i think i found it. | 19:19 |
| davidspollack | one sec | 19:19 |
| davidspollack | fixed! | 19:19 |
| davidspollack | netstat -tulnp | grep post tcp 0 0 0.0.0.0:5432 0.0.0.0:* LISTEN 13259/postmaster tcp 0 0 :::5432 :::* LISTEN 13259/postmaster | 19:19 |
| nowen | what was it? | 19:20 |
| davidspollack | postgresql.conf had | 19:20 |
| davidspollack | tcpip_socket = false | 19:20 |
| davidspollack | switched that to true, bounced postgresql | 19:20 |
| davidspollack | now ill try the scripts | 19:20 |
| nowen | huh | 19:20 |
| davidspollack | postgres wasnt actually listening on tc 5432 | 19:20 |
| davidspollack | now it is | 19:21 |
| davidspollack | so now the install scripts should work | 19:21 |
| davidspollack | boo-ya. | 19:21 |
| davidspollack | looks better; | 19:22 |
| davidspollack | i got this | 19:22 |
| davidspollack | The database is not yet configured for WiKID. Please run /opt/WiKID/sbin/load_db.sh. | 19:22 |
| davidspollack | so im going to run that script ... | 19:22 |
| nowen | did you run the scripts? | 19:23 |
| davidspollack | i also had to modify the startup script because I have another tomcat instance on the same machine .. | 19:23 |
| nowen | ok - just so you know, we recommend running WiKID on it's own box | 19:23 |
| nowen | for security | 19:23 |
| davidspollack | yes that does make sense. | 19:23 |
| davidspollack | this would ideally be in a DMZ | 19:23 |
| nowen | also, the tokens must use port 80. You can re-direct them. | 19:24 |
| davidspollack | ok | 19:24 |
| nowen | the WiKIDAdmin port is whatever you want | 19:24 |
| davidspollack | and it would be tricky to put this in a dmz & then replicate. | 19:25 |
| davidspollack | you dont offer this as a SaaS do you ? | 19:25 |
| nowen | not currently, but we could set one up on amazon | 19:25 |
| davidspollack | then i guess the only tricky thing is getting the users set up | 19:26 |
| nowen | you would need to tunnel the radius connections | 19:26 |
| davidspollack | ah yes. | 19:26 |
| davidspollack | ok; i think im going to give up on doing this on an existing box. | 19:26 |
| davidspollack | i cant login now to my install; not sure whats going on | 19:26 |
| nowen | you can't login via ssh? | 19:28 |
| davidspollack | no i cant login to the wikidadmin interface | 19:29 |
| davidspollack | using the default userid/pwd | 19:29 |
| nowen | that's the db | 19:29 |
| davidspollack | but im still not sure the db is there | 19:29 |
| nowen | run those psql commands again and peek in the db | 19:30 |
| davidspollack | ok | 19:30 |
| davidspollack | [postgres@parrot ~]$ psql -h localhost wikid psql: FATAL: database "wikid" does not exist | 19:31 |
| davidspollack | [postgres@parrot ~]$ psql -h localhost -l List of databases Name | Owner | Encoding -----------+----------+----------- template0 | postgres | SQL_ASCII template1 | postgres | SQL_ASCII (2 rows) | 19:31 |
| davidspollack | hmmmm | 19:31 |
| nowen | did you re-run the two config scripts? | 19:33 |
| davidspollack | ill try that now | 19:33 |
| davidspollack | the db isnt getting created | 19:35 |
| davidspollack | i ran both "wikidserver_config.sh" and then "wikid-firstboot.sh" | 19:35 |
| nowen | as root? | 19:35 |
| davidspollack | yes | 19:35 |
| davidspollack | [root@parrot WiKID]$ sh -x /opt/WiKID/conf/templates/wikid-firstboot.sh + '[' '!' -d /var/lib/pgsql/data/base ']' + /opt/WiKID/sbin/init_db.sh dropdb: database removal failed: ERROR: database "wikid" does not exist dropuser: removal of user "wikid-sens" failed: ERROR: user "wikid-sens" does not exist dropuser: removal of user "timecop" failed: ERROR: user "timecop" does not exist dropuser: removal of user "tomcat" failed: ERROR: | 19:36 |
| davidspollack | Updating PostgreSQL configuration files for use with WiKID ... + /bin/rm -f /etc/rc3.d/S99wikid-firstboot.sh | 19:36 |
| davidspollack | ls -l /v | 19:36 |
| davidspollack | ok i created the DB manually | 19:39 |
| davidspollack | using the commands here /opt/WiKID/sbin/load_db.sh | 19:39 |
| nowen | ok | 19:39 |
| davidspollack | arg | 19:41 |
| davidspollack | closer | 19:41 |
| davidspollack | but i got a tomcat crash | 19:41 |
| davidspollack | oy. | 19:41 |
| nowen | what is it? | 19:41 |
| nowen | feel free to use pastebin.com | 19:41 |
| davidspollack | never seen that | 19:41 |
| davidspollack | send it to what email | 19:42 |
| nowen | please use http://pastebin.com | 19:42 |
| nowen | it's much easier | 19:42 |
| davidspollack | im trying - where do I send it to you | 19:42 |
| nowen | just post it here | 19:42 |
| davidspollack | http://pastebin.com/gBaGvhuB | 19:42 |
| nowen | hmm | 19:43 |
| nowen | what pages are trying to access? | 19:43 |
| davidspollack | i restarted tomcat | 19:43 |
| davidspollack | one sec | 19:43 |
| davidspollack | yay! | 19:44 |
| davidspollack | its up. | 19:44 |
| davidspollack | so i can expose port 80 thru the fw to this server | 19:44 |
| davidspollack | and then I can register tokens etc | 19:45 |
| nowen | yes | 19:45 |
| nowen | all the token requests will go to /wikid/ | 19:45 |
| davidspollack | just need to worry about tomcat port 80 security | 19:45 |
| nowen | you can nat the WiKID server, just use the external IP for the domain identifier/server code | 19:46 |
| davidspollack | yup | 19:46 |
| davidspollack | if i set up a master/slave | 19:47 |
| davidspollack | can i have the tokens register with the master | 19:47 |
| davidspollack | and then use the slave as the radius client , not exposing it to the internet? | 19:47 |
| nowen | no, the slave is only a stand-by | 19:47 |
| davidspollack | oh ok. | 19:47 |
| davidspollack | cool. | 19:48 |
| davidspollack | thanks Nick. | 19:49 |
| nowen | ok - I've to run some errands off site | 19:49 |
| davidspollack | ok thanks agaIN | 19:49 |
| nowen | I should be back in about 1-2 hours | 19:49 |
| nowen | np | 19:49 |
| *** nowen has quit (Quit: Leaving.) | 19:51 | |
| *** davidspollack has quit (Quit: Page closed) | 19:52 | |
| *** nowen (~nowen@adsl-176-210-205.asm.bellsouth.net) has joined #wikid | 21:55 | |
| *** nowen has quit (Quit: Leaving.) | 23:01 | |
Generated by irclog2html.py 2.11.0 by Marius Gedminas - find it at mg.pov.lt!