[PHP] MySQL database
Yo, I'd like to use a MySQL database on my website. If I look at the PHP details of my site (see for yourself at http://infinity.shrimpwars.be/phpinfo.php) it says under the MySQL section: "enabled". Well, if I create a testpage with this as content: I get this: Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in /clans/infinity/mysql.php on line 2 unable to connect to database If I run the script on my local machine I get this: Warning: MySQL Connection Failed: Can't connect to MySQL server on 'localhost' (10061) in e:\webserver\phptest\mysql.php on line 2 unable to connect to database What is wrong? Do note that I don't know much about MySQL, I'm still learning :-P -- 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]
Re: [PHP] MySQL database
Erm..I'm using windows.
And euhI have MySQL installed, but I don't know if it's running. Anyway,
the phpinfo() returns that "MySQL" is enabled.so I guess it must be
working.
""Julia A. Case"" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> first off, is the MySQL database running? you can do a ps -xa | grep
> mysql to see... second you need to enter a username and password on the
> mysql_connect line..
>
> Hope this helps,
> Julia
>
> Quoting [Inf] F!RE-WALL ([EMAIL PROTECTED]):
> > Yo,
> >
> > I'd like to use a MySQL database on my website. If I look at the PHP
details
> > of my site (see for yourself at
http://infinity.shrimpwars.be/phpinfo.php)
> > it says under the MySQL section: "enabled". Well, if I create a testpage
> > with this as content:
> >
> > > mysql_connect("localhost", "", "")
> > or die ("unable to connect to database");
> > ?>
> >
> > I get this:
> >
> > Warning: MySQL Connection Failed: Can't connect to local MySQL server
> > through socket '/var/lib/mysql/mysql.sock' (111) in
> > /clans/infinity/mysql.php on line 2
> > unable to connect to database
> >
> > If I run the script on my local machine I get this:
> >
> > Warning: MySQL Connection Failed: Can't connect to MySQL server on
> > 'localhost' (10061) in e:\webserver\phptest\mysql.php on line 2
> > unable to connect to database
> >
> >
> > What is wrong? Do note that I don't know much about MySQL, I'm still
> > learning :-P
> >
> >
> >
> > --
> > 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]
>
> --
> [ Julia Anne Case ] [Ships are safe inside the harbor, ]
> [Programmer at large] [ but is that what ships are really for.]
> [ Admining Linux ] [ To thine own self be true. ]
> [ Windows/WindowsNT ] [ Fair is where you take your cows to be judged. ]
>
>
> --
> 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]
>
--
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]
Re: [PHP] MySQL database
Huh?
What about Windows?
"Jack Dempsey" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> setup an account with a username and password and flush your
> privileges...see if you can login on the command line...after that
> works, then try it with php
>
> -jack
>
> "[Inf] F!RE-WALL" wrote:
> >
> > Yo,
> >
> > I'd like to use a MySQL database on my website. If I look at the PHP
details
> > of my site (see for yourself at
http://infinity.shrimpwars.be/phpinfo.php)
> > it says under the MySQL section: "enabled". Well, if I create a testpage
> > with this as content:
> >
> > > mysql_connect("localhost", "", "")
> > or die ("unable to connect to database");
> > ?>
> >
> > I get this:
> >
> > Warning: MySQL Connection Failed: Can't connect to local MySQL server
> > through socket '/var/lib/mysql/mysql.sock' (111) in
> > /clans/infinity/mysql.php on line 2
> > unable to connect to database
> >
> > If I run the script on my local machine I get this:
> >
> > Warning: MySQL Connection Failed: Can't connect to MySQL server on
> > 'localhost' (10061) in e:\webserver\phptest\mysql.php on line 2
> > unable to connect to database
> >
> > What is wrong? Do note that I don't know much about MySQL, I'm still
> > learning :-P
> >
> > --
> > 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]
>
> --
> 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]
>
--
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]
[PHP] session handling
Every time I want to initiate a session i get this:
Warning: open(/tmp\sess_b18426d4011c38e033bd0ed54bd2d2f1, O_RDWR) failed: m
(2) in e:\webserver\phptest\page1.php on line 2
Warning: open(/tmp\sess_b18426d4011c38e033bd0ed54bd2d2f1, O_RDWR) failed: m
(2) in Unknown on line 0
Warning: Failed to write session data (files). Please verify that the
current setting of session.save_path is correct (/tmp) in Unknown on line 0
I run an Apache webserver under Windows and I have the latest version of
PHP. I looked up the "session.save_path" in the php.ini file and it sais:
[Session]
session.save_handler = files ; handler used to store/retrieve data
session.save_path = /tmp; argument passed to save_handler
; in the case of files, this is the
; path where data files are stored
session.use_cookies = 1 ; whether to use cookies
session.name = PHPSESSID
; name of the session
; is used as cookie name
session.auto_start= 0 ; initialize session on request startup
session.cookie_lifetime = 1814400 ; lifetime in seconds of cookie
; or if 0, until browser is restarted
session.cookie_path = / ; the path the cookie is valid for
session.cookie_domain = ; the domain the cookie is valid for
session.serialize_handler = php ; handler used to serialize data
; php is the standard serializer of PHP
session.gc_probability= 1 ; percentual probability that the
; 'garbage collection' process is
started
; on every session initialization
session.gc_maxlifetime= 1440; after this number of seconds, stored
; data will be seen as 'garbage' and
; cleaned up by the gc process
session.referer_check = ; check HTTP Referer to invalidate
; externally stored URLs containing ids
session.entropy_length= 0 ; how many bytes to read from the file
session.entropy_file = ; specified here to create the session
id
; session.entropy_length= 16
; session.entropy_file = /dev/urandom
session.cache_limiter = nocache ; set to {nocache,private,public} to
; determine HTTP caching aspects
session.cache_expire = 180 ; document expires after n minutes
session.use_trans_sid = 1 ; use transient sid support if enabled
; by compiling with --enable-trans-sid
url_rewriter.tags =
"a=href,area=href,frame=src,input=src,form=fakeentry"
What's wrong with /tmp ? Where's that map located? Do I need to change the
entry? Should I create the dir? If so, where?
--
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]
Re: [PHP] session handling
thanx m8
IT WORKS
""Andrius Lokotash"" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
if you use windows then paht myst be c:\tmp or somthing like that.
the difference between unix & windows systems are directory adressing
symbols, unix uses / windows on the oder hand \, fix this in php.ini and
it will work
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf
Of [Inf] F!RE-WALL
Sent: Wednesday, March 28, 2001 12:10 PM
To: [EMAIL PROTECTED]
Subject: [PHP] session handling
Every time I want to initiate a session i get this:
Warning: open(/tmp\sess_b18426d4011c38e033bd0ed54bd2d2f1, O_RDWR)
failed: m
(2) in e:\webserver\phptest\page1.php on line 2
Warning: open(/tmp\sess_b18426d4011c38e033bd0ed54bd2d2f1, O_RDWR)
failed: m
(2) in Unknown on line 0
Warning: Failed to write session data (files). Please verify that the
current setting of session.save_path is correct (/tmp) in Unknown on
line 0
I run an Apache webserver under Windows and I have the latest version of
PHP. I looked up the "session.save_path" in the php.ini file and it
sais:
[Session]
session.save_handler = files ; handler used to store/retrieve
data
session.save_path = /tmp; argument passed to save_handler
; in the case of files, this is the
; path where data files are stored
session.use_cookies = 1 ; whether to use cookies
session.name = PHPSESSID
; name of the session
; is used as cookie name
session.auto_start= 0 ; initialize session on request
startup
session.cookie_lifetime = 1814400 ; lifetime in seconds of
cookie
; or if 0, until browser is
restarted
session.cookie_path = / ; the path the cookie is valid for
session.cookie_domain = ; the domain the cookie is valid for
session.serialize_handler = php ; handler used to serialize data
; php is the standard serializer of
PHP
session.gc_probability= 1 ; percentual probability that the
; 'garbage collection' process is
started
; on every session initialization
session.gc_maxlifetime= 1440; after this number of seconds,
stored
; data will be seen as 'garbage' and
; cleaned up by the gc process
session.referer_check = ; check HTTP Referer to invalidate
; externally stored URLs containing
ids
session.entropy_length= 0 ; how many bytes to read from the
file
session.entropy_file = ; specified here to create the
session
id
; session.entropy_length= 16
; session.entropy_file = /dev/urandom
session.cache_limiter = nocache ; set to {nocache,private,public} to
; determine HTTP caching aspects
session.cache_expire = 180 ; document expires after n minutes
session.use_trans_sid = 1 ; use transient sid support if
enabled
; by compiling with
--enable-trans-sid
url_rewriter.tags =
"a=href,area=href,frame=src,input=src,form=fakeentry"
What's wrong with /tmp ? Where's that map located? Do I need to change
the
entry? Should I create the dir? If so, where?
--
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]
--
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]
--
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]
Re: [PHP] What is the difference between session_unset() and session_destroy()?
Erm...I believe session_unset unsets all variables in the session, leaving the session itself intact. While session_destroy deletes the entire session and all variables in it. But I'm not so sure. "Carfield Yim" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > From the manual, > session_unset ¡X Free all session variables > session_destroy ¡X Destroys all data registered to a session > > What do this document exactly mean? > > -- > 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] > -- 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]
Re: [PHP] sessions and cookies
I don't recommend putting the Session ID in the URL. Subscibed members could pass URL's to eachother and that way they could have eachother's settings. ""David Hynes"" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I am using sessions to password protect a section of a website. > > I am storing the session ID in a cookie but just in case cookies are not > enabled, I am also passing the session ID in the query string to each page > in the protected directory. > > Please can someone tell me if this could cause any problems, especially if > the user if tries to access a URL from their history bar in the browser with > an old session ID. > > i think what I'm trying to ask is , if the script receives a session ID from > a query string and cookie, which does it use ? > > Thanks, > David. > > --- > Fed202 Solutions > www.fed202solutions.com > Mobile : 07779 293368 > --- > > > -- > 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] > -- 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]
