[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: ? 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]
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]
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]
[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]
