Need HELP with WebCalendar

[GUMCAdmin]

I'm trying to install WebCalendar 1.0.5 and I'm at a total loss as to what to do next after I have unziped the folder and moved everything to public_html on the server. The instructions that I'm using has me at a total loss as to what to do next..... I'm looking for someone has installed and used this app.

[shadmego]

I've not used it before but I am in the process of installing it on my demo site. I will post back with what I've learned.

In the meantime, can you give us a clue as to what you are stuck with?

~regards, and welcome to the Hostmonster User Community!

[shadmego]

I just downloaded the program from the official website, uploaded it to my demo site, unpacked it and installed it in about an hour. Most of the time was spent looking at the general settings and trying to determine how insecure it is. More time will be needed to determine that, but for now, the install is pretty straight forward.

There are basically three things you have to do (after you upload and uncompress the zip file).

1. Create the database, user and password
2. input the database settings into the config file webcalendar uses
3. Insert the MySQL database table and data to be able to configure and view the calendar.

In order to complete step 1, you will log into CPanel and go to the MySQL Databases link. Follow the instructions on creating the database, user and password. You will also have to attach the user to the database.

REMEMBER!!! The database AND username will and your CPanel account name appended to the beginning of the name for each. For example, the database is named webcal and the user you create is named caladmn. When you go to insert this information into the webcalendar setup, the database will be <accountname>_webcal and the user will be <accountname>_caladmn where <accountname> is your CPanel username.

Once you have this complete, point your browser to the URL where you uploaded your calendar. http://www.domain.com/calendar, if you uploaded the calendar files to public_html/calendar.

The program will point you to the correct place to input the database information. Test and save this. You will then have to create a password in order to access the admin area. REMEMBER THIS PASSWORD!!

After you complete this, you will have to do possibly the most important step ... insert the database tables and information. Don't worry, it is actually quite simple ...

Back in your CPanel go to the File Manager and open the directory where you installed all the files for the calendar program and look for a file called, tables-mysql.sql. Open that file and copy ALL the contents to your clipboard by tapping the keys <Ctrl> + A and then <Ctrl> + C.

Now go back to the CPanel main window and find and click phpMyAdmin. If you have multiple databases, find the calendar database from the dropdown list on the left. Once the database is selected, look above the list of databases and look for an icon with SQL in it. It should be just to the right of the logout icon. If you hover your mouse over the icons, the one you want should say Query window. Clicking this link will open a popup window. Paste the contents you copied from tables-mysql.sql into this window by holding <Ctrl> + V. Click Go in the lower right corner and you should be ok. If you get any errors, they will show up in the right panel of phpMyAdmin. If you completed this with no errors, you can point your browser to the location of your calendar and start setting it up.

Post back to let me know how close I got. You can view the demo install here ('http://demos.4christministry.org/webcal').

[GUMCAdmin]

I setup the DB, username and password as indicated in your step 1. However, you have a step 2 listed but no instructions on how to set the config file that webcalendar uses. So I went on to pointing my browser to the URL www.domain.org/WebCal105 and the I get the following:
WebCalendar Error
Error connecting to database:
Access denied for user 'gumcadm'@'localhost' (using password: YES)

Now I'm stuck at what to do now..

[shadmego]

The database config information should be as follows:

When you created your database through CPanel, you gave it a name, say webcal. You then created a user -- caladm -- and a password. You then assigned the user to the database, giving the user all permissions to that database.

Now you are being asked to input the database information in the config setup script. It should go as follows:

database hostname: localhost
datavase name: <cpanel_accountname>_databasename (where <cpanel_accountname> is the name used to log into CPanel. For instance, using the example above, the database name would be:

database name: gumcadm_webcal (if gumcadm were your cpanel username)

database username: Follow the same instructions here as for the database name

database username: gumcadm_caladm
password: enter the password for the above user. Hopefully you wrote it down or remembered it.

That's it. Most people forget to add the CPanel username to the front of the database and user name. Thus they always have issues when connecting to their MySQL database.

~regards

[GUMCAdmin]

I have the info from creating the db. The current issue is you talk about running a config script. I don't know where this script is or how to execute it.

Lets look at an example:
DB=gumc_webcal
USER=gumc_caladmn

I next tried entering the following url's in a new IE window, all of which returned "page not found".
gumc_caladmn/webcal105
gumc_webcal/webcal105

I even tried logging out of CPanel and then login a gumc_caladmn
and that did not work.

Where should I be logging in from? I'm lost at this point. My knowledge base limited to html ans CSS.

[shadmego]

Are you trying to install this program via Fantastico, or do a manual install?

Based on what you are saying, I would imagine you are doing a manual install, because Fantastico will create the database and username automatically.

If doing the manual install, then after uploading the wecal files to the webserver, and doing the steps to create the database and username, you should only have to point your browser to the URL where you installed the calander. For instance, if you installed the calander in your public_html directory, then you would point your browser to www.yourdomain.com (http://www.yourdomain.com).

If you installed the calander in a directory called calandar, then you would navigate to www.yourdomain.com/calander (http://www.yourdomain.com/calander). The install process should walk your through step-by-step. It's a bit connfusing because you are going to have to manually put the tables into the database, but once you get to that point, I can help you through that too.

The important thing now is to get your script to connect to the database.

~regards

I apologize if I didn't answer your questions ... I'm afraid your last post was very confusing. To sign into CPanel, you have to use the CPanel username provided to you by HM .... not your database username.

Perhaps a link to the page you are getting confused on ... you can pm me the link if you don't want it to be public ...

[GUMCAdmin]

Let me start from the beginning as to what I did in trying to install WebCalendar:

1. I logged into CPanel.
2. Then clicked on Fantastico De Luxe.
3. Then clicked on WebCalendar
4. Under “short description” I clicked on the link to WebCalendaer’s homepage.
5. On their web site I clicked on “Download”
6. Then clicked on “Download WebCalendar-1.0.5” and downloaded the zip file to my desktop
7. I unzipped the file to create a folder named WebCalendar-1.0.5
8. Went back to CPanel and clicked on UnlimitedFTP
9. I uploaded the folder WebCalendar-1.0.5 to public_html
10. I went back to my desktop and printed the System Admin Guide from the WebCalendar folder

This is were the confusion begins:
1. I went to the section that says “Database Setup” and then the MySQL section.
2. There it said to create db named “intranet” using the following:
mysqladmin create intranet
This looks like script and/or a command procedure but I don’t have any idea as to how invoke and/or execute it.
3. So, since I couldn’t do anything at this point, I noticed farther down in this section of instructions a NOTE that says that if I’m using phpMyAdmin to follow the instructions in Appendix A. Once I read over this information, I BECOME REALY CONFUSED…..
4. It was at this point I started using the forum for HELP.
5. I followed your instructions to go to CPanel and click on MySQL Daatabases and built a DB called webcal, username and password, and attached it to the DB.

That is where I’m at, at this moment and don't know what to do next..

[shadmego]

Ok. I see where you are .... me thinks .....

Do this:

1. Log back into CPanel and via the File Manager, go into your public_html directory and rename the folder WebCalendar-1.0.5 to calendar.

2. You can log out of CPanel now.

3. Point your browser to www.yourdomain.com/calendar (http://www.yourdomain.com/calendar).

4. I can't remember the exact screens, but you should be able to find your way to the database setup screen (if it's not the first screen you see) and input the proper information for the MySQL database.

5. Once entered, there should be a button labeled something like "Test Settings". Click that button and make sure the program can connect to the database.

6. Once successful, make sure to save your settings. You may have to create a password to protect that page from public viewing so make sure you write the password down ... and make it HARD (not the word, just make the password difficult ... not the word ... wait .... I digress) ...

7. Come back here once you complete these steps successfully or if you have any questions about this part of the setup.

The next part will be a bit more difficult, but should go smoothly once we get the database connection working.

~regards

[GUMCAdmin]

Thanks for the help.
Those instructions worked just fine and now I'm ready for the next step(s).

[shadmego]

I am happy to hear everything has worked out so far. Now for the interesting part.

This is where I feel the installation is incredibly weak for this program. There are ways to automate this next step and I wonder why it isn't implemented in the official release .... maybe the next time.

What I am referring to is the creation of the database tables and default data, like the admin user. You will have to install the tables manually into the database we created in the first part of the setup. Don't worry, it isn't hard, but it might be confusing at first. I will try to walk you through as best I can.

Here we go:


Log back into your CPanel area and make your way to the folder where you installed (uploaded) the program files. In our case, it would be public_html/caledar.
Once there, look for a file titled, tables-mysql.sql.
Highlight that file and click Edit in the top menu bar. It should open a new window that *might* tell you you are not using a utf-8 language file. Ignore the warning.
Highlight ALL the text in that file.
Click inside the window with the test and press <Ctrl> + A at the same time.
Now press <Ctrl> + C to copy the highlighted text to your clipboard.
Leave this window open and go back to your main CPanel Admin page.
In the Databases section, find and click on phpMyAdmin. Once loaded, you should see a bunch of information in the right panel of the new window and a drop down list of current databases installed for your account. There should also be a small menu above the dropdown list.
Find your database by selecting it from the dropdown.
Normally, you would see a list of tables in the left panel and the structure of the database in the right panel. Since you don't have any tables created, you should not see any tables listed in the left panel.
Making SURE you have your webcal database selected, look for the menu icon with SQL in it. If you hover over the icon with your cursor, it should show you that is the Query window.
Click that icon. You should now see a new popup, much smaller with a text area. The tabular-type menu items should read SQL, Import Files and SQL History. Make sure SQL is selected.
Put your mouse cursor in the text area and click.
Now paste the contents of your clipboard into that text area by pressing <Ctrl> + V on your keyboard.
Click the Go button in the lower right corner of the SQL Query window. If you can't see it, scroll down. It's there.
You should get a response back that the query finished successfully. If not, report back here any errors you received. You should also now see a list of about 23 tables in the left pane of the phpMyAdmin window. If this is so,
Close the phpMyAdmin window and the File Editor window.
Point your browser to the webcalendar page now by going to www.yourdomain.com/calendar (http://www.yourdomain.com/calendar).
I can't really remember what you see now, but I think you will be presented with a login screen. You can login with the default admin info (username: admin ... password: admin) <-- double check this.
You should now be golden and on your way to setting up your very own webcalendar for your users.Let me know how it goes.

~regards

[GUMCAdmin]

This is the error that I got when I ran the SQL Query:

SQL query:

Editing : /* * Description: * This file is used to create all tables used by WebCalendar and * initialize some of those tables with the required data. * * The comments in the table definitions will be parsed to * generate a document (in HTML) that describes these tables. * * History: * 21-Oct-2002 Added this file header and additional comments * below. *//* * Defines a WebCalendar user. */ CREATE TABLE webcal_user(

/* the unique user login */cal_login VARCHAR( 25 ) NOT NULL ,
/* the user's password. (not used for http or ldap authentication) */cal_passwd VARCHAR( 32 ) ,
/* user's last name */cal_lastname VARCHAR( 25 ) ,
/* user's first name */cal_firstname VARCHAR( 25 ) ,
/* is the user a WebCalendar administrator ('Y' = yes, 'N' = no) */cal_is_adminCHAR( 1 ) DEFAULT 'N',
/* user's email address */cal_email VARCHAR( 75 ) NULL ,
PRIMARY KEY ( cal_login )
);



MySQL said:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Editing:

CREATE TABLE webcal_user (

cal_login VARCHAR(25) NOT' at line 1

[shadmego]

I apologize. I went too fast in writting those last steps and failed to mention that you should delete everything before the

CREATE TABLE webcal_user (

line in the SQL query window.

Comments in MySQL start with " /* " and end with " */ " (without the quotes). Since the "Editing :" line was not commented out, MySQL tried to run that as a command and it is not a MySQL command.

It was my fault, not yours.

Go ahead and redo the steps, remembering to delete everything in the query window BEFORE the line mentioned above.

Before you do though, make sure you don't have any tables in the webcal database. You shouldn't, but check just to make sure.

~regards, and more apologies!!

[GUMCAdmin]

I now have WebCalendar up and working.

However, I did notice that when the calendar is initally loaded there is an error in the status line that reads: DONE, BUT WITH ERRORS ON PAGE
I'm using IE7. Should I be concerned with this message?

Anyways, THANKS FOR ALL OF YOUR HELP

I'll open a new thread if I have any other issues.

[shadmego]

I'm getting the error too. It's a javascript error I haven't been able to drill down to where it's coming from though, as I don't understand javascript (one of my weaknesses!).