Well I copied login.com to pear.php and hack it up see below.
And the getOne function works get ..
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...
--------- 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.
>
> It looks like you did a pretty thorough job editing the config file, but
> to the best of my knowledge, this is an error that Pear throws when it has
> a problem with the DSN that it constructed using those settings you gave
> it in the config file. I've only seen it when that was misconfigured, so
> all I can suggest is to play with the user and the user's login
> permissions (and password) in pgsql.
>
> - paul
>
>
>
>
>
>
>
> -------------------------------------------------------
> This SF.Net email sponsored by: Free pre-built ASP.NET sites including
> Data Reports, E-commerce, Portals, and Forums are available now.
> Download today and enter to win an XBOX or Visual Studio .NET.
> http://aspnet.click-url.com/go/psa00100006ave/direct;at.asp_061203_01/01
> --
> 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/bulletproofapps
--
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
