Sounds like your include_path in the php.ini is incorrect. Usually it allows the directory one is operating from to be included also so it needs to have a period "." in it to indicate that. To include that plus the path you already have (according to the error message) It should be something like:
include_path = ".:/usr/local/canopy/include/php:/usr/share/pear" This could also be affected if safe_mode is turned on in the php.ini. Paul On 3/21/06, Chris Hale <[EMAIL PROTECTED]> wrote: > Great - that worked. I just used the last GRANT ALL statement for the > username/password I added, and changed the /include/config.inc.php file. > > However - now when I log in, I get an initial screen, but whenever I try to > navigate to other links, I get a menu screen at top and left, but no other > content. > > I am getting these errors in the httpd/error_log files: > > [client 67.99.82.210] PHP Warning: main(include/permissions.inc.php): > failed to open stream: No such file or directory in > /var/www/html/citrusdb/modules/customer/index.php on line 18, referer: > http://bam3.pipelinewireless.us/citrusdb/index.php?load=customer&type=module > [client 67.99.82.210] PHP Fatal error: main(): Failed opening required > 'include/permissions.inc.php' > (include_path='/usr/local/canopy/include/php:/usr/share/pear') in > /var/www/html/citrusdb/modules/customer/index.php on line 18, referer: > http://bam3.pipelinewireless.us/citrusdb/index.php?load=customer&type=module > > I did have to modify the /var/www/html/citrusdb/include/database.inc.php > file to show the full path to the ADOdb file: > > include('/var/www/html/citrusdb/include/adodb/adodb.inc.php'); > > It wouldn't work otherwise. All I received was a blank login screen. > > Chris > > -----Original Message----- > From: José Pablo Orozco Marín [mailto:[EMAIL PROTECTED] > Sent: Tuesday, March 21, 2006 1:01 PM > To: citrusdb-users@lists.sourceforge.net > Subject: Re: [Citrusdb-users] New username/password? > > > Not being a SQL-minded person, can you suggest a SQL statement to run > that > > would give these appropriate privileges to a citrusdb user account? > > > /sometimes_your_path_to_mysql/mysql -u root -p > > SHOW DATABASES; > SELECT user,host FROM mysql.user; > > REVOKE ALL PRIVILEGES ON YOUR_TABLE_NAME.* FROM [EMAIL PROTECTED]; > SELECT user,host FROM mysql.user; > > DELETE FROM mysql.user WHERE Host='localhost' AND User='your_username'; > FLUSH PRIVILEGES; > SELECT user,host FROM mysql.user; > > DROP DATABASE YOUR_TABLE_NAME; > SHOW DATABASES; > > CREATE DATABASE YOUR_TABLE_NAME; > SHOW DATABASES; > > GRANT ALL PRIVILEGES ON YOUR_TABLE_NAME.* TO [EMAIL PROTECTED] > IDENTIFIED BY 'your_passsword'; > SELECT user,host FROM mysql.user; > > > more info in: > http://dev.mysql.com/ > > > > Chris Hale wrote: > > Not being a SQL-minded person, can you suggest a SQL statement to run that > > would give these appropriate privileges to a citrusdb user account? > > > > Chris > > > > -----Original Message----- > > From: Paul Yasi [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, March 21, 2006 12:36 PM > > To: citrusdb-users@lists.sourceforge.net > > Subject: [Citrusdb-users] New username/password? > > > > It should work with any user that has been given access to open and > > use the database. You can edit the privileges in the mysql server to > > add a new user to open and use the database. In a production > > installation it would be best to make a new username/password for > > citrus, and if you are going to use the online part, a seperate > > username/password for online with select and restricted insert access > > to only the customer_history table. > > > > I would have thought that a mysql root user would work too, remember > > though that the root password for mysql is not necessarily the same as > > the root password for the server itself. Those can be two different > > things. > > > > Paul > > > > On 3/21/06, Chris Hale <[EMAIL PROTECTED]> wrote: > > > >>Do we need to create a new username/password for the initial installation > > > > on > > > >>the db? > >> > >>I can open the main login screen, but I get an error even when using the > >>root login: > >> > >>Access denied for user 'root'@'localhost' (using password: YES) > >> > >>How do we set up a new user/account in mysql for the citrusdb? > >> > >>Chris > >> > > > > > > > > ------------------------------------------------------- > > This SF.Net email is sponsored by xPML, a groundbreaking scripting > language > > that extends applications into web and mobile media. Attend the live > webcast > > and join the prime developer group breaking into this new coding > territory! > > http://sel.as-us.falkag.net/sel?cmd=k&kid0944&bid$1720&dat1642 > > _______________________________________________ > > Citrusdb-users mailing list > > Citrusdb-users@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/citrusdb-users > > > > > > > > > > > -- > ----------------------------- > > Estrategias Electrónicas > > José Pablo Orozco Marín > [EMAIL PROTECTED] > Tel. (506) 820 7280 > > http://www.Open-Antz.com/ > San José - Costa Rica > > Comunicación y Colaboración > > > ------------------------------------------------------- > This SF.Net email is sponsored by xPML, a groundbreaking scripting language > that extends applications into web and mobile media. Attend the live webcast > and join the prime developer group breaking into this new coding territory! > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 > _______________________________________________ > Citrusdb-users mailing list > Citrusdb-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/citrusdb-users > > > > > -- > No virus found in this incoming message. > Checked by AVG Free Edition. > Version: 7.1.385 / Virus Database: 268.2.6/287 - Release Date: 3/21/2006 > > > > > ------------------------------------------------------- > This SF.Net email is sponsored by xPML, a groundbreaking scripting language > that extends applications into web and mobile media. Attend the live webcast > and join the prime developer group breaking into this new coding territory! > http://sel.as-us.falkag.net/sel?cmdlnk&kid0944&bid$1720&dat1642 > _______________________________________________ > Citrusdb-users mailing list > Citrusdb-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/citrusdb-users > ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642 _______________________________________________ Citrusdb-users mailing list Citrusdb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/citrusdb-users
