Koozali.org: home of the SME Server
Legacy Forums => Experienced User Forum => Topic started by: Jules on May 29, 2001, 06:19:37 AM
-
Help if you can.
I am trying to use the webcalendar on e-smith. I 'think' I have set everything correctly but I get the following error message. Any ideas or suggestion please let me know.
Thanks J™
Warning: Host 'HubTU-mcr-24-xxx-xxx-xxx.rr.com' is not allowed to connect to this MySQL server in /home/e-smith/files/ibays/webcalendar/html/includes/php-dbi.inc on line 40
Error connecting to database:
Unknown error
-
In whatever config file is appropriate, set the database host to "localhost", not the full name of the server. That should do the trick.
-
Hmmmm
Thanks for the help but now I get the following...
Am I just being Stupid or what ?
Warning: Access denied for user: 'admin@localhost' (Using password: YES) in /home/e-smith/files/ibays/webcalendar/html/includes/php-dbi.inc on line 40
Error connecting to database:
Unknown error
-
Well, is there a MySQL user called "admin"? Probably not, unless you created one. You really should create a MySQL user for webcalendar, but if you don't want to do that (read the MySQL docs for information how), tell it to use the "root" user with the password in /root/.my.cnf.
-
Hmmm There probably isn't an admin user.. Will try it
Thanks for your help ;-)
J™
-
There was NOT an admin user I used the following to set up a user if anyone is interested ...seemed to be missing from the docs in webcalendar
>>>>>>>>>>>>>>>>>>>>>
You can add new users by issuing GRANT statements:
shell> mysql --user=root mysql
mysql> GRANT ALL PRIVILEGES ON *.* TO monty@localhost
IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
mysql> GRANT ALL PRIVILEGES ON *.* TO monty@"%"
IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
mysql> GRANT RELOAD,PROCESS ON *.* TO admin@localhost;
mysql> GRANT USAGE ON *.* TO dummy@localhost;
These GRANT statements set up three new users:
monty
A full superuser who can connect to the server from anywhere, but who must use a password 'some_pass' to do so. Note that we must issue GRANT statements for both monty@localhost and monty@"%". If we don't add the entry with localhost, the anonymous user entry for localhost that is created by mysql_install_db will take precedence when we connect from the local host, because it has a more specific Host field value and thus comes earlier in the user table sort order.
admin
A user who can connect from localhost without a password and who is granted the reload and process administrative privileges. This allows the user to execute the mysqladmin reload, mysqladmin refresh, and mysqladmin flush-* commands, as well as mysqladmin processlist . No database-related privileges are granted. (They can be granted later by issuing additional GRANT statements.)
dummy
A user who can connect without a password, but only from the local host. The global privileges are all set to 'N' -- the USAGE privilege type allows you to create a user with no privileges. It is assumed that you will grant database-specific privileges later.
Thanks
Jules
-
You could do that, but what's the point? You have a mysql root user who can do everything monty can do. Better to create users with specific access. For example:
grant all on webcalendar.* to webcalendar@localhost identified by 'somepassword';
-
Thanks for the input ...
I just copied the instructions verbatim from the MYSQL user guide ....
Will try it your way now I have it working :-)