Topic: WebCal

[Guy McLean]

Hi All,

I just installed webcal-3.03-2ps.noarch.rpm  from http://www.geocities.com/lapsch/webcal-e-smith-howto.html on my server running 5.5 with all updates. The installation went fine with two small problems, the two required perl rpms are older than what is on my system so they were not installed. When I try to access the main page I get the following error.

DBI->connect(database=webcal;host=localhost) failed: Access denied for user: 'webcal@localhost' (Using password: YES) at /opt/WebCal/cgi-bin/webcal_io.pm line 282

I also now get an error at start-up

Dec 16 09:19:49 e-smith httpd-admin: httpd-admin startup succeeded
Dec 16 09:20:06 e-smith mysql.init: Loading data into mysql failed
Dec 16 09:33:28 e-smith e-smith[2245]: Setting up MySQL....ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
09:48:23 e-smith rc: Starting mysqld:  succeeded
Dec 16 09:48:32 e-smith snort-mysql: Kernel filter,
Dec 16 09:48:32 e-smith snort-mysql: Initializing daemon mode
Dec 16 09:48:32 e-smith snort-mysql: protocol ALL, raw packet socket
Dec 16 09:48:32 e-smith snortd: snort-mysql startup succeeded
Dec 16 09:48:32 e-smith snort-mysql: PID stat checked out ok, PID set to /var/run/
Dec 16 09:48:32 e-smith snort-mysql: Writing PID file to "/var/run/"
Dec 16 09:48:34 e-smith snort-mysql: Snort initialization completed successfully, Snort running
Dec 16 09:48:37 e-smith mysql.init: loading /etc/e-smith/sql/init/30mysql.create.horde.sql into mysql
Dec 16 09:48:37 e-smith mysql.init: ERROR
Dec 16 09:48:37 e-smith mysql.init: Loading data into mysql
Dec 16 09:48:37 e-smith mysql.init:  1061 at line 74: Duplicate key name 'category_category_name_idx'
Dec 16 09:48:37 e-smith mysql.init: Loading data into mysql failed
Dec 16 09:48:37 e-smith mysql.init: ^[[60G
Dec 16 09:48:37 e-smith mysql.init:
Dec 16 09:48:37 e-smith rc: Starting mysql.init:  succeeded.

Any suggestions on how to fix this.

Guy


 
 



--------------------------------------------------------------------------------



------------------------------------------------------------------------------------------------------------------------------------------
"Zathras understand. No, Zathras not understand, but Zathras do."
"Very sad life. Probably have very sad death. But at least there is symmetry."
"Babylon 5 was our last, best hope for peace."
----------------------------------------------------------------------------------------------------------------------------

[Bob Todd]

DBI->connect(database=webcal;host=localhost) failed: Access denied for user: 'webcal@localhost' (Using password: YES) at /opt/WebCal/cgi-bin/webcal_io.pm line 282

This looks like the installer hasnt properly created the user for accessing the mysql database. Either the password its logging in with doesnt match the one assigned to the user or the user hasnt been given the necessary rights to access the database. I assume you followed the instructions fully and read any help files withing the application folder?

"If you need the webcal database password, it is in ~/.webcal.pw (usually /root/.webcal.pw), username=webcal. This password was generated when installing the RPM"

try re-assigning the permissions to the my-sql database using

mysql
grant all on webcal.* to webcal@localhost identified by 'password';
quit

where password is that found in the file mentioned in the webcal.pw file

[Guy McLean]

Hi Bob,

    I tried your suggestion  here are the results.

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1817 to server version: 3.23.41

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> GRANT ALL PRIVILEGES ON webcal.* TO webcal@localhost IDENTIFIED BY 'ctIrePEZ' ;
 0 rows affected (0.00 sec)

I am still getting the same error message when trying to access the web page as well it has been pointed out to me that my site is no longer accessable from the internet.  A port scan shows port  80 as open but when someone attempts to check my main page they get a address not found error.
Thanks for you help
Any other suggestions?

Guy