*** cytrinox_ has joined #ingres | 00:39 | |
*** cytrinox has quit IRC | 00:43 | |
*** cytrinox_ is now known as cytrinox | 00:43 | |
*** Alex| has joined #ingres | 01:37 | |
*** ChanServ sets mode: +o Alex| | 01:37 | |
*** Alex| has quit IRC | 02:08 | |
*** Alex| has joined #ingres | 02:25 | |
*** ChanServ sets mode: +o Alex| | 02:25 | |
*** Dejan has joined #ingres | 05:10 | |
*** Dejan has quit IRC | 05:30 | |
sehh | hey people | 05:57 |
---|---|---|
sehh | I'd appreciate some help please | 05:57 |
sehh | I'm using two servers (one DB with Ingres and one Web server with Apache+PHP) | 05:57 |
sehh | I've installed Ingres on the Web server as well (since PHP connects to local Ingres, which in turn connects to the remote DB ingres) | 05:58 |
sehh | but I don't understand how to setup the login/authentication between the two of them | 05:59 |
sehh | I tell the truth, I'm completely confused with the authentication model of ingres | 06:00 |
sehh | there are passwords in accessdb, more passwords under netutil and none make any sense where they are used.. | 06:01 |
*** Mud has joined #ingres | 07:54 | |
sehh | anyone around? I'd appreciate some help please | 08:31 |
Vroomfondle | have you tried the forums? They're a lot more active than this channel | 08:34 |
sehh | not yet to tell you the truth | 08:34 |
sehh | the whole authentication thing in ingres is very confusing | 08:35 |
sehh | I'm also reading about a "DBMS password".. not sure what that is, but it seems many people have authentication problems with that is set | 08:35 |
Vroomfondle | there's an installation password | 08:38 |
Vroomfondle | which is used to prevent people from connecting their Ingres installation to yours | 08:38 |
sehh | ok, so how do I debug my authentication problem? I've created a database, created a user "apache" in accessdb with password "apache". But when I try to connect via php (localy on the ingres DB server), I get authentication failure | 08:41 |
sehh | based on the documentation, it seems like ingres is trying to athenticate the user as a unix user, so I've used "passwd" under linux to set a password for the apache user | 08:42 |
sehh | but still it won't authenticate | 08:42 |
sehh | I also have the "apache" user created via accessdb, and I've set a password there as well | 08:43 |
sehh | still no go.. | 08:43 |
Vroomfondle | on the remote database? | 08:43 |
sehh | no, this is all local on the ingres server | 08:44 |
sehh | first I want to make everything running on the ingres server, before I deal with vnodes and remove acccess | 08:44 |
sehh | (I've installed apache+php on the ingres DB server) | 08:44 |
Vroomfondle | I see | 08:44 |
Vroomfondle | it does sound like you've done everything right | 08:45 |
Vroomfondle | is your database private or public? | 08:45 |
sehh | does the Linux "apache" user have to have the same password as the "apache" user in the accessdb tool? | 08:45 |
Vroomfondle | no | 08:46 |
sehh | so which one of the two passwords does ingres use? the Linux apache user? or the accessdb user? | 08:46 |
sehh | the database (via the accessdb tool) says: Default Access: public | 08:47 |
Vroomfondle | it uses the accessdb user's password | 08:47 |
Vroomfondle | is there a tool called "ingvalidpw" in your ingres directory? | 08:48 |
sehh | yes there is, I tried running it from the shell but it doesn't return any messages to me | 08:48 |
Vroomfondle | I think it just has to exist | 08:50 |
sehh | hmm | 08:54 |
sehh | well | 08:54 |
sehh | not sure what else to check | 08:54 |
sehh | I can use "sql" or "isql" without a problem, but I still can't use apache+php's connect() function | 08:54 |
*** sehh has quit IRC | 09:53 | |
*** sehh has joined #ingres | 09:53 | |
*** Mud has quit IRC | 10:09 | |
*** Mud has joined #ingres | 10:14 | |
*** Alex| has quit IRC | 10:30 | |
*** Alex| has joined #ingres | 12:34 | |
*** ChanServ sets mode: +o Alex| | 12:34 | |
*** Mud has quit IRC | 14:10 | |
*** Mud has joined #ingres | 14:15 | |
*** stliu has quit IRC | 14:21 | |
*** Alex| has quit IRC | 15:03 | |
*** Mud has quit IRC | 17:33 | |
*** stliu has joined #ingres | 21:18 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!