turns out that those of us using postgres will find a big problem. pear wants pgsql but the config.php and related files want postgresql ( as the db type ) I hard coded the type to pgsql in login.php and it connects just fine.... but as a whole webcalendar is still on working
Thought everyone would like to be aware of the postgres issue. >> Well I copied login.com to pear.php and hack it up see below. > > you mean your copy is called pear.php? not sure why, but not really > relevant, right? > >> And the getOne function works get .. > > it DOES work? but the regular webcal stuff doesn't? huh. you might try > going directly to the webcalendar people and seeing if anyone else has had > problems with Postgress and webcal. Webcal is nice, but it seems a little > hacked up to me. I'm not sure what else to say - it looks like you have > the php skills to debug it, and since you have the system that is > producing the errors, you're probably the best person.... ;> If it's a > problem with the plugin, let me or the author know. > >> I still looking into ... but any insight would help! >> >> By the way ... why is the public access removed from the squirrel version >> of >> webcalendar? >> Won't want to still hare we people who don't have email accounts ... >> vendors ...etc... > > Sure I suppose so. The author I think mentioned something about that in > one of the documents... readme, install, or even on the plugin download > page... i forget, but you should re-read that stuff, because I think he > specifically addressed how to keep the calendar public. if you still > can't figure it out, I can probably track it down or lend a hand. but > sounds like you have bigger fish to fry in the mean time! ;> > > - paul > >> >> --------- code --------- >> >> .. >> .. >> .. >> do_hook('login_form'); >> echo '</form>' . "\n"; >> >> //hack >> $user = 'webcalendar'; >> $pass = ''; >> $host = 'localhost'; >> $db_name = 'webcalendar'; >> >> $dsn = "pgsql://$user:[EMAIL PROTECTED]/$db_name"; >> $db = DB::connect($dsn); >> if (DB::isError($db)) { >> die ($db->getMessage()); >> } >> echo "<h2>pear test</h2>"; >> $sql = "select * from webcal_user"; >> $result = $db->query($sql); >> if (DB::isError($result)) { >> die ($result->getMessage()); >> } >> echo "do the count"; >> $num = $db->getOne('select count(*) from webcal_user'); >> echo 'result'; >> echo $num; >> echo "finished"; >> $db->disconnect(); >> >> do_hook('login_bottom'); >> echo "</body>\n". >> "</html>\n"; >> ?> >> >>>> Hey I having the same problem. >>>> >>>> Did you every get this working? >>>> >>>> I read the INSTALL but I guess I just don't see it. >>>> >>>> I: >>>> reinstalled php with PEAR >>>> created the db (in postgresql) >>>> modified ./includes/config.php >>>> >>>> #--------------------- db info >>>> $db_type = "postgresql"; >>>> $db_host = "localhost"; >>>> $db_login = "<user>"; >>>> $db_password = ""; >>>> $db_database = "webcalendar"; >>>> >>>> This works great from a psql command. ? pg_hda.conf is set to allow >>>> <user> to login from localhost >>>> ( DB user shouldn't matter ) if psql connects webcalendar should. >>> >>> Sorry for the delayed response, >>> >>> Per INSTALL: >>> >>> 4. Do anything extra that the INSTALL.html says or the README.html >>> THAT MEANS EDIT THE webcalendar/includes/config.php >>> if you get "getOne" errors on pages that means you >>> either edited that file wrong or not at all. > > > > > ------------------------------------------------------- > This SF.Net email sponsored by: Parasoft > Error proof Web apps, automate testing & more. > Download & eval WebKing and get a free book. > www.parasoft.com/bulletproofapps > -- > squirrelmail-users mailing list > List Address: [EMAIL PROTECTED] > List Archives: http://sourceforge.net/mailarchive/forum.php?forum_id)95 > List Info: https://lists.sourceforge.net/lists/listinfo/squirrelmail-users > ----------------------------------------- ABC Labs: http://abclabs.com ------------------------------------------------------- This SF.Net email sponsored by: Parasoft Error proof Web apps, automate testing & more. Download & eval WebKing and get a free book. www.parasoft.com/bulletproofapps1 -- squirrelmail-users mailing list List Address: [EMAIL PROTECTED] List Archives: http://sourceforge.net/mailarchive/forum.php?forum_id=2995 List Info: https://lists.sourceforge.net/lists/listinfo/squirrelmail-users