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?cmd=lnk&kid0944&bid$1720&dat1642 _______________________________________________ Citrusdb-users mailing list Citrusdb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/citrusdb-users
