CodeCharge Studio
search Register Login  

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> CodeCharge.Discussion

 Challenge connecting with MySQL database

Print topic Send  topic

Author Message
Jeri
Posted: 02/19/2001, 1:37 AM

I'm stumped.

I'm running the Nusphere package of Apache, MySQL, PHP and Perl on my
Computer.

I can run http://localhost/phpMyAdmin/index.php, Perl programs, PHP
programs and MySQL databases with no problem.

I just can't get Code Charge output to work properly. Maybe you can help.

Some error messages:

From http://localhost/bookstore/AdminMenu.php

Warning: open(/tmp\sess_c30c62829ca5c5a05eb3a4df2cc9b722, O_RDWR) failed: m
(2) in f:\nusphere\apache/htdocs/bookstore/AdminMenu.php on line 13

FRom http://localhost/bookstore/Login.php

I get this when I login.

Warning: open(/tmp\sess_c30c62829ca5c5a05eb3a4df2cc9b722, O_RDWR) failed: m
(2) in f:\nusphere\apache/htdocs/bookstore/Login.php on line 13
Database error: cannot use database bookstore
MySQL Error: 1049 (Unknown database 'bookstore')
Session halted.
Warning: open(/tmp\sess_c30c62829ca5c5a05eb3a4df2cc9b722, O_RDWR) failed: m
(2) in ./db_mysql.inc on line 0

Warning: Failed to write session data (files). Please verify that the
current setting of session.save_path is correct (/tmp) in ./db_mysql.inc on
line 0


Info:

OLE Provider is ODBC Drivers (downloaded from MySQL site, and installed)

Connection - Tried:

a. Use Datasource Name - Nusphere MySQL
b. Also built Connection Strings.

Design Database Connection is Info=False;User ID=root;Data Source=NuSphere
MySQL

I have read the docs and looked at the examples. I'm just missing something
and don't know what.

Thanks for any help.

Jer




Alexey Alexapolsky
Posted: 02/19/2001, 5:05 AM

It's all about a directory where php tries to store session data.
Please open your php.ini file and set session.save_path to your
temporary directory where you want to store your session info, for instance
:
session.save_path= C:\Program Files\PHP\sessiondata ; argument passed to
save_handler
You may also need to check your permissions on this directory.

--
Regards,
Alexey
CodeCharge Support



Jeri <jeri@marketingresource.com> wrote in > I'm stumped.
>
> I'm running the Nusphere package of Apache, MySQL, PHP and Perl on my
> Computer.
>
> I can run http://localhost/phpMyAdmin/index.php, Perl programs, PHP
> programs and MySQL databases with no problem.
>
> I just can't get Code Charge output to work properly. Maybe you can help.
>
> Some error messages:
>
> From http://localhost/bookstore/AdminMenu.php
>
> Warning: open(/tmp\sess_c30c62829ca5c5a05eb3a4df2cc9b722, O_RDWR) failed:
m
> (2) in f:\nusphere\apache/htdocs/bookstore/AdminMenu.php on line 13
>
> FRom http://localhost/bookstore/Login.php
>
> I get this when I login.
>
> Warning: open(/tmp\sess_c30c62829ca5c5a05eb3a4df2cc9b722, O_RDWR) failed:
m
> (2) in f:\nusphere\apache/htdocs/bookstore/Login.php on line 13
> Database error: cannot use database bookstore
> MySQL Error: 1049 (Unknown database 'bookstore')
> Session halted.
> Warning: open(/tmp\sess_c30c62829ca5c5a05eb3a4df2cc9b722, O_RDWR) failed:
m
> (2) in ./db_mysql.inc on line 0
>
> Warning: Failed to write session data (files). Please verify that the
> current setting of session.save_path is correct (/tmp) in ./db_mysql.inc
on
> line 0
>
>
> Info:
>
> OLE Provider is ODBC Drivers (downloaded from MySQL site, and installed)
>
> Connection - Tried:
>
> a. Use Datasource Name - Nusphere MySQL
> b. Also built Connection Strings.
>
> Design Database Connection is Info=False;User ID=root;Data Source=NuSphere
> MySQL
>
> I have read the docs and looked at the examples. I'm just missing
something
> and don't know what.
>
> Thanks for any help.
>
> Jer
>
>
>
>
>

Kevin Donnelly
Posted: 02/19/2001, 8:17 AM


> Some error messages:
>
> From http://localhost/bookstore/AdminMenu.php
>
> Warning: open(/tmp\sess_c30c62829ca5c5a05eb3a4df2cc9b722, O_RDWR) failed:
m
> (2) in f:\nusphere\apache/htdocs/bookstore/AdminMenu.php on line 13
>
> FRom http://localhost/bookstore/Login.php
>
> I get this when I login.
>
> Warning: open(/tmp\sess_c30c62829ca5c5a05eb3a4df2cc9b722, O_RDWR) failed:
m
> (2) in f:\nusphere\apache/htdocs/bookstore/Login.php on line 13
> Database error: cannot use database bookstore
> MySQL Error: 1049 (Unknown database 'bookstore')
> Session halted.
> Warning: open(/tmp\sess_c30c62829ca5c5a05eb3a4df2cc9b722, O_RDWR) failed:
m
> (2) in ./db_mysql.inc on line 0
>
> Warning: Failed to write session data (files). Please verify that the
> current setting of session.save_path is correct (/tmp) in ./db_mysql.inc
on
> line 0

You might try creating a directory C:\tmp, since this is what it is looking
for.

Kevin

Jeri
Posted: 02/19/2001, 3:45 PM

Thanks,

That helped eliminate one problem.

"Alexey Alexapolsky" <alexa@codecharge.com> wrote in message
news:96r5mc$fn4$1@news.codecharge.com...
> It's all about a directory where php tries to store session data.
> Please open your php.ini file and set session.save_path to your
> temporary directory where you want to store your session info, for
instance
> :
> session.save_path= C:\Program Files\PHP\sessiondata ; argument passed
to
> save_handler
> You may also need to check your permissions on this directory.
>
> --
> Regards,
> Alexey
> CodeCharge Support
>
>
>
> Jeri <jeri@marketingresource.com> wrote in > I'm stumped.
> >
> > I'm running the Nusphere package of Apache, MySQL, PHP and Perl on my
> > Computer.
> >
> > I can run http://localhost/phpMyAdmin/index.php, Perl programs, PHP
> > programs and MySQL databases with no problem.
> >
> > I just can't get Code Charge output to work properly. Maybe you can
help.
> >
> > Some error messages:
> >
> > From http://localhost/bookstore/AdminMenu.php
> >
> > Warning: open(/tmp\sess_c30c62829ca5c5a05eb3a4df2cc9b722, O_RDWR)
failed:
> m
> > (2) in f:\nusphere\apache/htdocs/bookstore/AdminMenu.php on line 13
> >
> > FRom http://localhost/bookstore/Login.php
> >
> > I get this when I login.
> >
> > Warning: open(/tmp\sess_c30c62829ca5c5a05eb3a4df2cc9b722, O_RDWR)
failed:
> m
> > (2) in f:\nusphere\apache/htdocs/bookstore/Login.php on line 13
> > Database error: cannot use database bookstore
> > MySQL Error: 1049 (Unknown database 'bookstore')
> > Session halted.
> > Warning: open(/tmp\sess_c30c62829ca5c5a05eb3a4df2cc9b722, O_RDWR)
failed:
> m
> > (2) in ./db_mysql.inc on line 0
> >
> > Warning: Failed to write session data (files). Please verify that the
> > current setting of session.save_path is correct (/tmp) in ./db_mysql.inc
> on
> > line 0
> >
> >
> > Info:
> >
> > OLE Provider is ODBC Drivers (downloaded from MySQL site, and installed)
> >
> > Connection - Tried:
> >
> > a. Use Datasource Name - Nusphere MySQL
> > b. Also built Connection Strings.
> >
> > Design Database Connection is Info=False;User ID=root;Data
Source=NuSphere
> > MySQL
> >
> > I have read the docs and looked at the examples. I'm just missing
> something
> > and don't know what.
> >
> > Thanks for any help.
> >
> > Jer
> >
> >
> >
> >
> >
>
>

Jeri
Posted: 02/19/2001, 3:45 PM

Thank you.

Jer
"Kevin Donnelly" <kevin@dotmon.uklinux.net> wrote in message
news:96rgv6$61r$1@news.codecharge.com...
>
> > Some error messages:
> >
> > From http://localhost/bookstore/AdminMenu.php
> >
> > Warning: open(/tmp\sess_c30c62829ca5c5a05eb3a4df2cc9b722, O_RDWR)
failed:
> m
> > (2) in f:\nusphere\apache/htdocs/bookstore/AdminMenu.php on line 13
> >
> > FRom http://localhost/bookstore/Login.php
> >
> > I get this when I login.
> >
> > Warning: open(/tmp\sess_c30c62829ca5c5a05eb3a4df2cc9b722, O_RDWR)
failed:
> m
> > (2) in f:\nusphere\apache/htdocs/bookstore/Login.php on line 13
> > Database error: cannot use database bookstore
> > MySQL Error: 1049 (Unknown database 'bookstore')
> > Session halted.
> > Warning: open(/tmp\sess_c30c62829ca5c5a05eb3a4df2cc9b722, O_RDWR)
failed:
> m
> > (2) in ./db_mysql.inc on line 0
> >
> > Warning: Failed to write session data (files). Please verify that the
> > current setting of session.save_path is correct (/tmp) in ./db_mysql.inc
> on
> > line 0
>
> You might try creating a directory C:\tmp, since this is what it is
looking
> for.
>
> Kevin
>
>


   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

PHP Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by UltraApps.com  and YesSoftware, Inc.