| 01:28.22 | *** join/#asterisk-doc jsmith_ (n=jsmith@67.151.170.235) |
| 01:32.33 | *** mode/#asterisk-doc [+o jsmith] by ChanServ |
| 01:32.42 | *** part/#asterisk-doc jsmith (n=jsmith@67.151.170.235) |
| 01:32.50 | *** join/#asterisk-doc jsmith (n=jsmith@67.151.170.235) |
| 01:32.50 | *** mode/#asterisk-doc [+o jsmith] by ChanServ |
| 01:32.56 | jsmith | ljam: Ping! |
| 01:33.09 | ljam | jsmith: Pong! |
| 01:33.15 | ljam | jsmith: you ever setup unixODBC? |
| 01:33.22 | jsmith | Yeah... still have the scars. |
| 01:33.23 | jsmith | why? |
| 01:33.36 | jsmith | It's really not that hard. |
| 01:33.37 | ljam | I'm trying ot get it working -- I have it "configured" I think -- but the system gives me this error: |
| 01:33.41 | ljam | <PROTECTED> |
| 01:33.43 | ljam | [IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified |
| 01:33.46 | ljam | [ISQL]ERROR: Could not SQLConnect |
| 01:33.53 | ljam | I know -- it shouldn't be hard -- but I've missed somethign stupid |
| 01:33.56 | jsmith | Have you setup a DSN? |
| 01:34.03 | jsmith | There are two steps... |
| 01:34.09 | ljam | someone else said that -- I don't know what that means :) |
| 01:34.17 | jsmith | First, configure a DSN pointing to the PostgreSQL driver. |
| 01:34.21 | ljam | where? |
| 01:34.24 | jsmith | Second, setup the Postgresql driver. |
| 01:34.29 | jsmith | Here, let's do it together! |
| 01:34.31 | ljam | odbc.ini or odbcinst.ini ? |
| 01:34.38 | ljam | I configured both |
| 01:34.41 | jsmith | One is for the driver, the other is for the DSN. |
| 01:34.43 | jsmith | Hold please. |
| 01:34.52 | ljam | but I think I need to tell it about the configuration somehow |
| 01:35.02 | jsmith | In the DSN :-) |
| 01:35.07 | ljam | what DSN? |
| 01:35.20 | jsmith | Here, let me refresh my memory. |
| 01:35.25 | ljam | k cool |
| 01:35.35 | ljam | want to do it on tampa3? |
| 01:35.50 | ljam | or just do it locally if you think it'd be faster |
| 01:35.53 | jsmith | Let me do it on my box here, and then we'll do it on tampa3 |
| 01:35.58 | ljam | works for me |
| 01:36.04 | jsmith | (I'd rather screw up on my box first) |
| 01:36.06 | ljam | I'm sure I've just missed some small little peice |
| 01:36.10 | ljam | perfect :) |
| 01:40.08 | jsmith | [root@localhost ~]# yum install unixodbc postgresql-odbc php-odbc |
| 01:40.28 | jsmith | ============================================================================= |
| 01:40.28 | jsmith | <PROTECTED> |
| 01:40.28 | jsmith | ============================================================================= |
| 01:40.28 | jsmith | Installing: |
| 01:40.29 | jsmith | <PROTECTED> |
| 01:40.29 | jsmith | <PROTECTED> |
| 01:40.29 | jsmith | Transaction Summary |
| 01:40.30 | jsmith | ============================================================================= |
| 01:40.32 | jsmith | Install 2 Package(s) |
| 01:40.36 | jsmith | Update 0 Package(s) |
| 01:40.38 | jsmith | Remove 0 Package(s) |
| 01:40.40 | jsmith | Total download size: 221 k |
| 01:40.42 | jsmith | Is this ok [y/N]: y |
| 01:41.23 | jsmith | Installed: php-odbc.ppc 0:5.1.2-5 postgresql-odbc.ppc 0:08.01.0200-1.2 |
| 01:41.23 | jsmith | Complete! |
| 01:41.43 | ljam | also done! |
| 01:42.06 | jsmith | cat /etc/odbcinst.ini |
| 01:42.09 | jsmith | # Included in the unixODBC package |
| 01:42.10 | jsmith | [PostgreSQL] |
| 01:42.10 | jsmith | Description = ODBC for PostgreSQL |
| 01:42.10 | jsmith | Driver = /usr/lib/libodbcpsql.so |
| 01:42.10 | jsmith | Setup = /usr/lib/libodbcpsqlS.so |
| 01:42.10 | jsmith | FileUsage = 1 |
| 01:42.21 | jsmith | I love it when RPMs do the right thing... |
| 01:42.32 | ljam | agreed |
| 01:42.34 | jsmith | OK, so odbcinst.ini is pointed at the driver... |
| 01:42.42 | ljam | agreed |
| 01:43.24 | jsmith | [root@localhost ~]# file /usr/lib/libodbcpsql.so |
| 01:43.24 | jsmith | /usr/lib/libodbcpsql.so: symbolic link to `libodbcpsql.so.2.0.0' |
| 01:43.24 | jsmith | [root@localhost ~]# file /usr/lib/libodbcpsqlS.so |
| 01:43.24 | jsmith | /usr/lib/libodbcpsqlS.so: symbolic link to `libodbcpsqlS.so.1.0.0' |
| 01:43.24 | jsmith | [root@localhost ~]# file /usr/lib/libodbcpsql.so.2.0.0 |
| 01:43.25 | jsmith | /usr/lib/libodbcpsql.so.2.0.0: ELF 32-bit MSB shared object, PowerPC or cisco 4500, version 1 (SYSV), stripped |
| 01:43.28 | jsmith | [root@localhost ~]# file /usr/lib/libodbcpsqlS.so.1.0.0 |
| 01:43.30 | jsmith | /usr/lib/libodbcpsqlS.so.1.0.0: ELF 32-bit MSB shared object, PowerPC or cisco 4500, version 1 (SYSV), stripped |
| 01:43.41 | jsmith | And the driver files actually exist, in the right location |
| 01:43.48 | ljam | and configured to the tampa4 server -- and the tampa4 server lists 8.7.177.3 in pg_hba.conf :) |
| 01:43.57 | ljam | jsmith: yes -- I was surprised as well! |
| 01:44.37 | jsmith | OK, now for odbc.ini |
| 01:45.25 | ljam | [PostgreSQL-asterisk] |
| 01:45.25 | ljam | <PROTECTED> |
| 01:45.25 | ljam | <PROTECTED> |
| 01:45.25 | ljam | <PROTECTED> |
| 01:45.27 | ljam | <PROTECTED> |
| 01:45.30 | ljam | <PROTECTED> |
| 01:45.32 | ljam | <PROTECTED> |
| 01:45.35 | ljam | <PROTECTED> |
| 01:45.37 | ljam | <PROTECTED> |
| 01:45.40 | ljam | <PROTECTED> |
| 01:45.43 | ljam | <PROTECTED> |
| 01:45.45 | ljam | <PROTECTED> |
| 01:45.47 | ljam | <PROTECTED> |
| 01:45.50 | ljam | <PROTECTED> |
| 01:45.53 | ljam | <PROTECTED> |
| 01:45.55 | ljam | <PROTECTED> |
| 01:45.57 | ljam | <PROTECTED> |
| 01:56.24 | jsmith | Hold please... |
| 01:56.34 | ljam | ok -- I'm going to go get some food ok? |
| 01:56.49 | ljam | I'll be back in about 30 mins -- gotta leave the house since there isn't anything in the cupboards :) |
| 01:57.34 | jsmith | OK. |
| 01:58.01 | ljam | jsmith: I'm jealous :) |
| 02:36.20 | ljam | jsmith: !!!! |
| 02:36.21 | ljam | I'm back |
| 02:36.32 | jsmith | My burger just showed up... :-) |
| 02:36.41 | ljam | nice! My subway just got home |
| 02:37.08 | jsmith | They even brought me my own bottle of ketchup, mustard, and mayo |
| 02:37.37 | ljam | wow! good family :) |
| 02:37.56 | ljam | so -- what simple thing did I forget to do to make ODBC work? :) |
| 02:38.02 | jsmith | Not sure yet... |
| 02:38.07 | jsmith | My phone has been ringing off the hook |
| 02:38.17 | jsmith | I'll get back into it right after I take a bite or two |
| 02:42.00 | jsmith | Man, this burger is the best I've ever had. |
| 02:42.08 | ljam | no problem -- I'm eating too |
| 02:56.31 | ljam | mmmm... good sub |
| 03:02.29 | jsmith | OK, I've tickled my brain, and finally got it to remember how to setup ODBC! |
| 03:02.46 | jsmith | OK, here's the secrets... |
| 03:02.56 | jsmith | First, you setup the driver in odbcinst.ini |
| 03:03.11 | jsmith | (This should automagically get done when you install the postgresql-odbc RPM) |
| 03:03.16 | jsmith | With me so far? |
| 03:03.45 | ljam | yep |
| 03:04.33 | jsmith | The name in square brackets (it's a context!) is the name of the driver. |
| 03:04.52 | ljam | yep, figured that :) |
| 03:04.59 | jsmith | So in your odbc.ini, where you say "Driver = blah", that's what points the DSN to the proper driver entry in odbcinst.ini |
| 03:05.11 | jsmith | The name in square brackets in odbc.ini is the name of the DSN |
| 03:05.15 | ljam | yep, got that :) |
| 03:06.12 | jsmith | Third, you must setup pg_hba.conf and postgresql.conf in PostgreSQL |
| 03:06.17 | jsmith | But I'm getting ahead of myself. |
| 03:06.21 | ljam | I've done that |
| 03:06.24 | ljam | I think.... |
| 03:06.30 | jsmith | Once you have odbcinst.ini pointing at the driver |
| 03:06.40 | jsmith | And odbc.ini with a DSN created... |
| 03:06.49 | jsmith | Then, we use isql to test.... |
| 03:07.03 | ljam | yep -- that's what failed |
| 03:07.35 | jsmith | echo "select count(*) from foo" | isql -v MyLovelyDSNName my_postgresql_user my_postgresql_password |
| 03:09.18 | ljam | [IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified |
| 03:09.22 | ljam | [ISQL]ERROR: Could not SQLConnect |
| 03:09.24 | ljam | same error :( |
| 03:09.32 | jsmith | Woo hoo! |
| 03:09.53 | jsmith | That means that what you typed as the DSN name to isql doesn't match what's in square brackets in odbc.ini |
| 03:10.16 | ljam | yes, I type it exactly |
| 03:10.42 | ljam | <PROTECTED> |
| 03:11.58 | ljam | I'm not sure what could be wrong... |
| 03:12.46 | ljam | can I test from psql somehow to make sure I can connect to the DB? |
| 03:13.13 | jsmith | Well, you'd get a different error message then. |
| 03:13.31 | jsmith | But yes, you can do "psql -Upostgres -h127.0.0.1" |
| 03:14.01 | ljam | ok, so I can connect at least |
| 03:15.11 | jsmith | OK, gimme gimme the login info and I'll take a gander at it... |
| 03:15.46 | ljam | seems like I have everything right.... |
| 03:16.53 | ljam | just reinstalling postgresql-odbc |
| 03:16.57 | ljam | ok done |
| 04:09.34 | ljam | jsmith: thanks again! night! |
| 07:51.46 | *** join/#asterisk-doc ToTo (n=ToTo@81.174.33.2) |
| 13:15.48 | *** join/#asterisk-doc jsmith (n=jsmith@67.151.170.236) |
| 13:15.48 | *** mode/#asterisk-doc [+o jsmith] by ChanServ |
| 14:13.31 | *** join/#asterisk-doc jsmith_ (n=jsmith@209.125.86.115) |
| 14:14.24 | *** mode/#asterisk-doc [+o jsmith] by ChanServ |
| 14:30.45 | *** join/#asterisk-doc ToTo (n=ToTo@81.174.33.2) |
| 14:51.43 | *** join/#asterisk-doc bweschke (n=bweschke@66.152.225.74) |
| 19:42.30 | *** join/#asterisk-doc ToTo (n=ToTo@host26-200.pool875.interbusiness.it) |
| 22:57.25 | *** join/#asterisk-doc penghb (n=npenghb@202.108.130.138) [NETSPLIT VICTIM] |
| 22:57.25 | *** join/#asterisk-doc locksy (n=locksy@mrtg.sisgroup.com.au) [NETSPLIT VICTIM] |
| 23:03.56 | *** join/#asterisk-doc penghb (n=npenghb@202.108.130.138) |
| 23:03.57 | *** join/#asterisk-doc locksy (n=locksy@mrtg.sisgroup.com.au) [NETSPLIT VICTIM] |
| 23:09.20 | *** join/#asterisk-doc penghb (n=npenghb@202.108.130.138) [NETSPLIT VICTIM] |
| 23:09.21 | *** join/#asterisk-doc locksy (n=locksy@mrtg.sisgroup.com.au) [NETSPLIT VICTIM] |