Topic: WebCalendar

[Jules]

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

[Dan Brown]

In whatever config file is appropriate, set the database host to "localhost", not the full name of the server.  That should do the trick.

[Jules]

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

[Dan Brown]

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.

[Jules]

Hmmm There probably isn't an admin user.. Will try it

Thanks for your help

J™

[Jules]

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

[Dan Brown]

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';

[Jules]

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