Re: which package ?

[Patrick Barendregt <pbarendregt_(_at_)_amersfoort_(_dot_)_xs4all_(_dot_)_nl>]

Op za 14-12-2002, om 20:47 schreef Dom De Vitto:
> Excellent advice from Greg, always check the archives before posting.
> Tip: My previous answer to this problem involved changing /etc/my.cnf
> 
> Dom
> - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
> Dom De Vitto                                       Tel. 07855 805 271
> http://www.devitto.com                         mailto:dom_(_at_)_devitto_(_dot_)_com
> - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
> 
>  
> 
> 
> -----Original Message-----
> From: owner-misc_(_at_)_openbsd_(_dot_)_org [mailto:owner-misc_(_at_)_openbsd_(_dot_)_org] On Behalf
> Of Greg Thomas
> Sent: Saturday, December 14, 2002 7:40 PM
> To: Patrick Barendregt
> Cc: misc_(_at_)_openbsd_(_dot_)_org
> Subject: Re: which package ?
> 
> 
> On Saturday, Dec 14, 2002, at 11:35 US/Pacific, Patrick Barendregt 
> wrote:
> 
> > Op za 14-12-2002, om 20:18 schreef Greg Thomas:
> >> On Saturday, Dec 14, 2002, at 06:15 US/Pacific, Patrick Barendregt
> >> wrote:
> >>
> >>> Sorry but i (think) i found it...
> >>> I installed the core package and two other packages
> >>> one for imap and one for mysql.
> >>> I allso enabled the packages just like pkg_add said...
> >>> The strange thing is i get no errors what so ever but
> >>> the php pages are working but they do not find any row in the mysql 
> >>> database. when i check manual the tables do have rows and i can 
> >>> select them...
> >>> The php pages are good because the work for over a year now
> >>> on linux machines and on openbsd 2.9 and 3.0.
> >>> Did i do something wrong here or have i forgotten something ?
> >>
> >> Depends on how old your PHP code is.  They changed the way variables 
> >> are handled.  Things like $HTTP_GET_VARS have been deprecated.
> >>
> >> Greg
> >
> > the message i found is the following
> >  PHP Warning:  MySQL Connection Failed: Can't connect to local MySQL 
> > server through socket '/var/run/mysql/mysql.sock' (2)
> >
> 
> You also need to check into the fact that Apache is chrooted now and 
> what you need to do to mysql to accommodate  the chroot.  I use 
> PostgreSQL over the network so this didn't affect me.
> 
> > anyone who is using mysql with apache and php has the solution for me
> > ??
> 
> There are plenty of people.  If you check the mailing list archives 
> you'll probably come up with a couple of good answers.
> 
> Greg
Ok i checked the archives before i asked this question their was no
solution second on my system (openbsd 3.2) their is no file /etc/my.cnf

the problem mysql connecting i just solved with someone else on another
forum it's caused by chrooted etc. when i use the -u option to start
http it can connect again.
But another problem is establishing now i use the following code to
select a value (comes from a mysql db) and pass it on to another page
<FORM METHOD="get" ACTION="overzicht.php" Target="main">
<SELECT NAME="pr_linkt">
<OPTION>
<?php
         $aantal=1;
         while ($mylist[$aantal][0] != "")
                   {
                   $pr_linkt = $mylist[$aantal][0];
           print("<OPTION VALUE=$pr_linkt>$pr_linkt");
                   $aantal = $aantal + 1;
                   }
?>

-- 
Patrick Barendregt <pbarendregt_(_at_)_amersfoort_(_dot_)_xs4all_(_dot_)_nl>