Re: [PHP] Mac OSX !?!?!?

2002-01-17 Thread Erik Price

There is a utility called daemonic which is designed to deal with this 
as well, but works for more than just MySQL -- it's intended to be used 
for all server daemons.

http://daemonic.sourceforge.net/

It is Mac OS X-specific at this time, but according to the web site is 
designed for future compatibility with any operating system.  It can be 
installed via Fink (http://fink.sourceforge.net) very easily, and is in 
fact required by many Fink packages.

I must confess that I do not know much about it.

Erik



On Wednesday, January 16, 2002, at 08:01  PM, Richard Baskett wrote:

  Although the
 MySQL warnings, I got those because MySQL does not automatically start 
 in
 OSX, if you know it's started then Im not sure, but if not.. go here to 
 get
 the autostart utility:

 http://www.entropy.ch/software/macosx/mysql/


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: [PHP] Mac OSX !?!?!?

2002-01-17 Thread Jim Dickenson

There is a link at http://www.entropy.ch/software/macosx/mysql/ for a
startup items package. This will cause MySQL to start when you restart the
Mac OS X system.


On 1/17/2002 8:30 AM, Erik Price [EMAIL PROTECTED] wrote:

 There is a utility called daemonic which is designed to deal with this
 as well, but works for more than just MySQL -- it's intended to be used
 for all server daemons.
 
 http://daemonic.sourceforge.net/
 
 It is Mac OS X-specific at this time, but according to the web site is
 designed for future compatibility with any operating system.  It can be
 installed via Fink (http://fink.sourceforge.net) very easily, and is in
 fact required by many Fink packages.
 
 I must confess that I do not know much about it.
 
 Erik
 
 
 
 On Wednesday, January 16, 2002, at 08:01  PM, Richard Baskett wrote:
 
  Although the
 MySQL warnings, I got those because MySQL does not automatically start
 in
 OSX, if you know it's started then Im not sure, but if not.. go here to
 get
 the autostart utility:
 
 http://www.entropy.ch/software/macosx/mysql/
 
 
 -
 Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)
 
 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-- 
Jim Dickenson
mailto:[EMAIL PROTECTED]

Computers for Marketing Corporation
http://www.cfmc.com/

eFax: 1-419-791-8924



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: [PHP] Mac OSX !?!?!?

2002-01-16 Thread Richard Baskett

Kind of hard to say without source code for the session part..  Although the
MySQL warnings, I got those because MySQL does not automatically start in
OSX, if you know it's started then Im not sure, but if not.. go here to get
the autostart utility:

http://www.entropy.ch/software/macosx/mysql/

This link will have information and a link of where you can download the
utility.

Rick


The human mind is not capable of grasping the Universe. We are like a
little child entering a huge library. The walls are covered to the ceilings
with books in many different tongues. The child knows that someone must have
written these books. It does not know who or how. It does not understand the
languages in which they are written. But the child notes a definite plan in
the arrangement of the books---a mysterious order which it does not
comprehend, but only dimly suspects. - Albert Einstein

 From: René Fournier [EMAIL PROTECTED]
 Date: Wed, 16 Jan 2002 17:50:06 -0700
 To: [EMAIL PROTECTED], [EMAIL PROTECTED]
 Subject: [PHP] Mac OSX !?!?!?
 
 Can someone PLEASE explain why I get the following error message under
 OSX (PHP+MySQL), but not under Windows ME or Linux?
 
 
 Warning: Cannot send session cache limiter - headers already sent
 (output started at
 /Users/rene/Sites/smartslitters/jupiter/europa/header.inc:6) in
 /Users/rene/Sites/smartslitters/jupiter/europa/header.inc on line 19
 
 Warning: Unable to save MySQL query result in
 /Users/rene/Sites/smartslitters/jupiter/europa/header.inc on line 44
 
 Warning: Supplied argument is not a valid MySQL result resource in
 /Users/rene/Sites/smartslitters/jupiter/europa/header.inc on line 45
 ---
 
 After these lines, the pages load fine. I'm using PHP Session ID
 variables (or trying to)--they work fine as I said under other OSes, but
 now break under OSX.
 
 ...Rene
 
 ---
 René Fournier
 [EMAIL PROTECTED]
 
 
 -- 
 PHP General Mailing List (http://www.php.net/)
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail: [EMAIL PROTECTED]
 To contact the list administrators, e-mail: [EMAIL PROTECTED]
 


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: [PHP] Mac OSX !?!?!?

2002-01-16 Thread René Fournier

Somebody suggested I post the source--good idea! So here it is... The 
header.inc file, in its entirety:


html
head
titleSite :: Jupiter :: Europa/title
meta http-equiv=Content-Type content=text/html; charset=iso-8859-1
link rel=stylesheet href=../../common/styles.css type=text/css
?php

// DETERMINE THE LANGUAGE FROM THE PARENT DIRECTORY
// GENERATE VARIABLES FOR LANGUAGE, FILENAME AND NAME

$path = explode(/,$PHP_SELF);
if (!$lang) { $lang = $path[sizeof($path)-2]; }
$file = $path[sizeof($path)-1];
$prename = explode(.,$file);
$name = $prename[sizeof($prename)-2];

// SECURITY CHECK

session_start();
if (!$PHPSESSID) { die;
} elseif (!$auth) { die;
} elseif ($auth != $path[sizeof($path)-2]) { die; }

$language = All Languages;
if ($lang == en) { $language = English; }
if ($lang == fr) { $language = FranÁais; }
if ($lang == es) { $language = EspaÒol; }
if ($lang == de) { $language = Deutsch; }
if ($lang == it) { $language = Italiano; }

$priv = 2;

// CONNECT TO DATABASE

$db = mysql_connect(localhost,database,password);
mysql_select_db(database,$db);

// FETCH TABLE NAMES

$listtables = mysql_list_tables(database,$db);

// FETCH SELECTED TABLE DATA

$fields = mysql_list_fields(database, $table, $db);
$columns = mysql_num_fields($fields);

?
script language=JavaScript
!--
function GP_popupConfirmMsg(msg) { //v1.0
   document.MM_returnValue = confirm(msg);
}
//--
/script
/head

body bgcolor=#FF text=#00 link=#00 vlink=#00 
alink=#00 leftmargin=20 topmargin=20 marginwidth=0 
marginheight=0 background=../../common/bg.gif
?php
if ($language) { echo span class=adminnormalgreya 
href=../index.php4Europa/a/span; }
if ($table) { echo span class=adminnormalgrey : /spanspan 
class=adminnormalgreya href=tables.php4Tables/a/span; }
?
pnbsp;


On Wednesday, January 16, 2002, at 06:01  PM, Richard Baskett wrote:

 Kind of hard to say without source code for the session part..  
 Although the
 MySQL warnings, I got those because MySQL does not automatically start 
 in
 OSX, if you know it's started then Im not sure, but if not.. go here to 
 get
 the autostart utility:

 http://www.entropy.ch/software/macosx/mysql/

 This link will have information and a link of where you can download the
 utility.

 Rick


 The human mind is not capable of grasping the Universe. We are like a
 little child entering a huge library. The walls are covered to the 
 ceilings
 with books in many different tongues. The child knows that someone must 
 have
 written these books. It does not know who or how. It does not 
 understand the
 languages in which they are written. But the child notes a definite 
 plan in
 the arrangement of the books---a mysterious order which it does not
 comprehend, but only dimly suspects. - Albert Einstein

 From: René Fournier [EMAIL PROTECTED]
 Date: Wed, 16 Jan 2002 17:50:06 -0700
 To: [EMAIL PROTECTED], [EMAIL PROTECTED]
 Subject: [PHP] Mac OSX !?!?!?

 Can someone PLEASE explain why I get the following error message under
 OSX (PHP+MySQL), but not under Windows ME or Linux?

 
 Warning: Cannot send session cache limiter - headers already sent
 (output started at
 /Users/rene/Sites/smartslitters/jupiter/europa/header.inc:6) in
 /Users/rene/Sites/smartslitters/jupiter/europa/header.inc on line 19

 Warning: Unable to save MySQL query result in
 /Users/rene/Sites/smartslitters/jupiter/europa/header.inc on line 44

 Warning: Supplied argument is not a valid MySQL result resource in
 /Users/rene/Sites/smartslitters/jupiter/europa/header.inc on line 45
 ---

 After these lines, the pages load fine. I'm using PHP Session ID
 variables (or trying to)--they work fine as I said under other OSes, 
 but
 now break under OSX.

 ...Rene

---
René Fournier
[EMAIL PROTECTED]


 --
 PHP General Mailing List (http://www.php.net/)
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail: [EMAIL PROTECTED]
 To contact the list administrators, e-mail: php-list-
 [EMAIL PROTECTED]



 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail mysql-unsubscribe-
 [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: [PHP] Mac OSX !?!?!?

2002-01-16 Thread René Fournier

Somebody suggested I post the source--good idea! So here it is... The 
header.inc file, in its entirety:


html
head
titleSite :: Jupiter :: Europa/title
meta http-equiv=Content-Type content=text/html; charset=iso-8859-1
link rel=stylesheet href=../../common/styles.css type=text/css
?php

// DETERMINE THE LANGUAGE FROM THE PARENT DIRECTORY
// GENERATE VARIABLES FOR LANGUAGE, FILENAME AND NAME

$path = explode(/,$PHP_SELF);
if (!$lang) { $lang = $path[sizeof($path)-2]; }
$file = $path[sizeof($path)-1];
$prename = explode(.,$file);
$name = $prename[sizeof($prename)-2];

// SECURITY CHECK

session_start();
if (!$PHPSESSID) { die;
} elseif (!$auth) { die;
} elseif ($auth != $path[sizeof($path)-2]) { die; }

$language = All Languages;
if ($lang == en) { $language = English; }
if ($lang == fr) { $language = FranÁais; }
if ($lang == es) { $language = EspaÒol; }
if ($lang == de) { $language = Deutsch; }
if ($lang == it) { $language = Italiano; }

$priv = 2;

// CONNECT TO DATABASE

$db = mysql_connect(localhost,database,password);
mysql_select_db(database,$db);

// FETCH TABLE NAMES

$listtables = mysql_list_tables(database,$db);

// FETCH SELECTED TABLE DATA

$fields = mysql_list_fields(database, $table, $db);
$columns = mysql_num_fields($fields);

?
script language=JavaScript
!--
function GP_popupConfirmMsg(msg) { //v1.0
   document.MM_returnValue = confirm(msg);
}
//--
/script
/head

body bgcolor=#FF text=#00 link=#00 vlink=#00 
alink=#00 leftmargin=20 topmargin=20 marginwidth=0 
marginheight=0 background=../../common/bg.gif
?php
if ($language) { echo span class=adminnormalgreya 
href=../index.php4Europa/a/span; }
if ($table) { echo span class=adminnormalgrey : /spanspan 
class=adminnormalgreya href=tables.php4Tables/a/span; }
?
pnbsp;


On Wednesday, January 16, 2002, at 06:01  PM, Richard Baskett wrote:

 Kind of hard to say without source code for the session part..  
 Although the
 MySQL warnings, I got those because MySQL does not automatically start 
 in
 OSX, if you know it's started then Im not sure, but if not.. go here to 
 get
 the autostart utility:

 http://www.entropy.ch/software/macosx/mysql/

 This link will have information and a link of where you can download the
 utility.

 Rick


 The human mind is not capable of grasping the Universe. We are like a
 little child entering a huge library. The walls are covered to the 
 ceilings
 with books in many different tongues. The child knows that someone must 
 have
 written these books. It does not know who or how. It does not 
 understand the
 languages in which they are written. But the child notes a definite 
 plan in
 the arrangement of the books---a mysterious order which it does not
 comprehend, but only dimly suspects. - Albert Einstein

 From: René Fournier [EMAIL PROTECTED]
 Date: Wed, 16 Jan 2002 17:50:06 -0700
 To: [EMAIL PROTECTED], [EMAIL PROTECTED]
 Subject: [PHP] Mac OSX !?!?!?

 Can someone PLEASE explain why I get the following error message under
 OSX (PHP+MySQL), but not under Windows ME or Linux?

 
 Warning: Cannot send session cache limiter - headers already sent
 (output started at
 /Users/rene/Sites/smartslitters/jupiter/europa/header.inc:6) in
 /Users/rene/Sites/smartslitters/jupiter/europa/header.inc on line 19

 Warning: Unable to save MySQL query result in
 /Users/rene/Sites/smartslitters/jupiter/europa/header.inc on line 44

 Warning: Supplied argument is not a valid MySQL result resource in
 /Users/rene/Sites/smartslitters/jupiter/europa/header.inc on line 45
 ---

 After these lines, the pages load fine. I'm using PHP Session ID
 variables (or trying to)--they work fine as I said under other OSes, 
 but
 now break under OSX.

 ...Rene

---
René Fournier
[EMAIL PROTECTED]


 --
 PHP General Mailing List (http://www.php.net/)
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail: [EMAIL PROTECTED]
 To contact the list administrators, e-mail: php-list-
 [EMAIL PROTECTED]



 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail mysql-unsubscribe-
 [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: [PHP] Mac OSX !?!?!?

2002-01-16 Thread Joel Wickard

try calling session_start() as the very first thing in your php script.

- Original Message -
From: René Fournier [EMAIL PROTECTED]
To: PHP General [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, January 16, 2002 7:41 PM
Subject: Re: [PHP] Mac OSX !?!?!?


 Somebody suggested I post the source--good idea! So here it is... The
 header.inc file, in its entirety:

 
 html
 head
 titleSite :: Jupiter :: Europa/title
 meta http-equiv=Content-Type content=text/html; charset=iso-8859-1
 link rel=stylesheet href=../../common/styles.css type=text/css
 ?php

 // DETERMINE THE LANGUAGE FROM THE PARENT DIRECTORY
 // GENERATE VARIABLES FOR LANGUAGE, FILENAME AND NAME

 $path = explode(/,$PHP_SELF);
 if (!$lang) { $lang = $path[sizeof($path)-2]; }
 $file = $path[sizeof($path)-1];
 $prename = explode(.,$file);
 $name = $prename[sizeof($prename)-2];

 // SECURITY CHECK

 session_start();
 if (!$PHPSESSID) { die;
 } elseif (!$auth) { die;
 } elseif ($auth != $path[sizeof($path)-2]) { die; }

 $language = All Languages;
 if ($lang == en) { $language = English; }
 if ($lang == fr) { $language = FranÁais; }
 if ($lang == es) { $language = EspaÒol; }
 if ($lang == de) { $language = Deutsch; }
 if ($lang == it) { $language = Italiano; }

 $priv = 2;

 // CONNECT TO DATABASE

 $db = mysql_connect(localhost,database,password);
 mysql_select_db(database,$db);

 // FETCH TABLE NAMES

 $listtables = mysql_list_tables(database,$db);

 // FETCH SELECTED TABLE DATA

 $fields = mysql_list_fields(database, $table, $db);
 $columns = mysql_num_fields($fields);

 ?
 script language=JavaScript
 !--
 function GP_popupConfirmMsg(msg) { //v1.0
document.MM_returnValue = confirm(msg);
 }
 //--
 /script
 /head

 body bgcolor=#FF text=#00 link=#00 vlink=#00
 alink=#00 leftmargin=20 topmargin=20 marginwidth=0
 marginheight=0 background=../../common/bg.gif
 ?php
 if ($language) { echo span class=adminnormalgreya
 href=../index.php4Europa/a/span; }
 if ($table) { echo span class=adminnormalgrey : /spanspan
 class=adminnormalgreya href=tables.php4Tables/a/span; }
 ?
 pnbsp;
 

 On Wednesday, January 16, 2002, at 06:01  PM, Richard Baskett wrote:

  Kind of hard to say without source code for the session part..
  Although the
  MySQL warnings, I got those because MySQL does not automatically start
  in
  OSX, if you know it's started then Im not sure, but if not.. go here to
  get
  the autostart utility:
 
  http://www.entropy.ch/software/macosx/mysql/
 
  This link will have information and a link of where you can download the
  utility.
 
  Rick
 
 
  The human mind is not capable of grasping the Universe. We are like a
  little child entering a huge library. The walls are covered to the
  ceilings
  with books in many different tongues. The child knows that someone must
  have
  written these books. It does not know who or how. It does not
  understand the
  languages in which they are written. But the child notes a definite
  plan in
  the arrangement of the books---a mysterious order which it does not
  comprehend, but only dimly suspects. - Albert Einstein
 
  From: René Fournier [EMAIL PROTECTED]
  Date: Wed, 16 Jan 2002 17:50:06 -0700
  To: [EMAIL PROTECTED], [EMAIL PROTECTED]
  Subject: [PHP] Mac OSX !?!?!?
 
  Can someone PLEASE explain why I get the following error message under
  OSX (PHP+MySQL), but not under Windows ME or Linux?
 
  
  Warning: Cannot send session cache limiter - headers already sent
  (output started at
  /Users/rene/Sites/smartslitters/jupiter/europa/header.inc:6) in
  /Users/rene/Sites/smartslitters/jupiter/europa/header.inc on line 19
 
  Warning: Unable to save MySQL query result in
  /Users/rene/Sites/smartslitters/jupiter/europa/header.inc on line 44
 
  Warning: Supplied argument is not a valid MySQL result resource in
  /Users/rene/Sites/smartslitters/jupiter/europa/header.inc on line 45
  ---
 
  After these lines, the pages load fine. I'm using PHP Session ID
  variables (or trying to)--they work fine as I said under other OSes,
  but
  now break under OSX.
 
  ...Rene
 
 ---
 René Fournier
 [EMAIL PROTECTED]
 
 
  --
  PHP General Mailing List (http://www.php.net/)
  To unsubscribe, e-mail: [EMAIL PROTECTED]
  For additional commands, e-mail: [EMAIL PROTECTED]
  To contact the list administrators, e-mail: php-list-
  [EMAIL PROTECTED]
 
 
 
  -
  Before posting, please check:
 http://www.mysql.com/manual.php   (the manual)
 http://lists.mysql.com/   (the list archive)
 
  To request this thread, e-mail [EMAIL PROTECTED]
  To unsubscribe, e-mail mysql-unsubscribe-
  [EMAIL PROTECTED]
  Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 
 


 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive

Re: [PHP] Mac OSX and MySQL

2001-12-05 Thread Erik Price


On Wednesday, December 5, 2001, at 12:24  AM, René Fournier wrote:


 I have to create a MySQL for my PHP scripts. How do I do this in Mac 
 OSX? There are a bunch of command line tools, but I'm not sure which 
 one[s] to use.


Well, if you already have MySQL installed, then just use them as 
normal.  Just remember that Unix syntax is different from DOS (lets you 
do more, actually).

If you need to install MySQL, try these:

http://developer.apple.com/internet/macosx/osdb.html

the above link is for Apple's own recommendations for installing MySQL 
on Darwin.  Just make sure that you use the source code for 3.23.45, not 
3.43.44 (because the .44 doesn't shut down properly in Darwin).  I used 
this technique (not the binary) and it works great.

http://fink.sourceforge.net

if you use Fink (debian-style package installer) you can have it install 
MySQL for you (as well as PHP and Apache) but I didn't go this route 
because I wanted more control over the install process.

http://www.stepwise.com/Articles/Workbench/2001-10-11.01.html

the above link isn't for MySQL at all, it's for PHP, but it's a useful 
article.  Remember to add the --with-mysql configure option because 
this tutorial doesn't assume that you want to install MySQL.

Any questions, email me.


Erik


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php