help with mySQL!

linuxrunner · 02-14-2006, 10:03 PM

ok, i am trying to get this webcalendar thing to work, and i have to setup mysql, php and apache. here is what i have apache is good, php is good and running with apache. But i cannot figure out the sql part her is the instruction... i have no idea what i am doing so be kind...

The following will create a database named "intranet".

mysqladmin create intranet

Next, create the database user account that will be used to access the database.

mysql --user=root mysql
mysql> GRANT ALL PRIVILEGES ON *.* TO webcalendar@localhost
IDENTIFIED BY 'webcal01' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;
mysql> QUIT

If you will be accessing MySQL from a different machine than the one running the web server, repeat the command above and replace 'localhost' with the hostname of the other machine.

Create the calendar tables using the supplied tables-mysql.sql file:

mysql intranet < tables-mysql.sql

In the above example, "intranet" is the name of your database.

Ok, so i am doing this in windows xp not linux as instructions seem to think but none of the commands seem to work, i just get a syntax error.
Now i was able to use different commands to get some of the stuff done, like to create the database i used.. "create database intranet"
And i think the mysql intranet < tables-mysql.sql command worked, because if i enter it again i get all these errors about how it is already created.

So when i try to go ahead with the instructions and configure the software to match the database it can't find the database...

If anybody knows what i am really doing (or not doing) in SQL (or should be doing) please let me know i am so lost

If you would like to look at the software and try to figure out how it is to be done check it out HERE

This ad is not displayed to registered members.
Register your free account today and become a member on Yotatech!

marko3xl3 · 02-14-2006, 10:13 PM

I am really tired right know, and even though I am usually able to help with these errors (mainly because I have been through a lot), I have a total brain fart.

But here is my pathetic try... is the "Database Type" supposed to be "OBDC" and not mySQL? What are the other choices?

jacksonpt · 02-15-2006, 05:15 AM

From the error, it looks like the webserver doesn't have the ODBC driver for that database installed.

Is this webcalendar thing a app you downloaded then tried to install? The screenshot is not an interface I'm used to.

lee · 02-15-2006, 05:50 AM

yea, is this supposed to be webbased or on your computer? i bet youre just missing a driver.

that interface is typical of mysql... oversimplified. i hate it, i used it to make the board on NE4ROC and it is so crappy.

i wish i couldve just directly used sql.

jacksonpt · 02-15-2006, 06:03 AM

do you have access to a mysqladmin interface? you can write straight SQL there... kind of command line-ish.

lee · 02-15-2006, 06:31 AM

well luckily i didnt need it for more than creating a database and an admin user. the board script took care of the rest.

but thanks for the heads up, i never did see that.

linuxrunner · 02-15-2006, 09:38 AM

um lets see that is the only thing on the drop down menu, i am entering the commands at the command prompt supplyed by sql, i didn't really have to install the program it is just a bunch of php and some sql files and all i really have to do is find a way to connect everything and host it. webcalendar is set up to use many database applications, i just already had mysql and that one was the recomended. There are actully a lot of people on here who know alot about SQL, thanks for the help.

jacksonpt · 02-15-2006, 09:42 AM

is apache setup to run mysql? it might just be a matter of adding a line to you http.conf file.

linuxrunner · 02-15-2006, 02:09 PM

Quote:

Originally Posted by jacksonpt

is apache setup to run mysql? it might just be a matter of adding a line to you http.conf file.

This is what i was thinking. I had to edit http.conf for php to work, what do i need to do to get mysql to play with apache?

jacksonpt · 02-15-2006, 04:28 PM

Quote:

Originally Posted by linuxrunner

This is what i was thinking. I had to edit http.conf for php to work, what do i need to do to get mysql to play with apache?

I don't remember off the top of my head, and now that I'm at home, I can't easily check the .conf file on my server at work. Google will give you the answers pretty quickly I would think, or you can just wait till I get to work in the morning.

If you don't see a reply from me in the AM, bump this thread as a reminder.

linuxrunner · 02-15-2006, 10:57 PM

ok, i checked google alot and found lots of info about editing the .conf file to configure PHP, but nothing about editing for SQL. The program also has instructions for useing phpmyadmin instead of SQL, which i guess is just a fancy way to use SQL. But when i try to run phpmyadmin i get ...

phpMyAdmin - Error
Cannot load mysql extension. Please check your PHP configuration. - Documentation

So i guess something is not right here also, i found that you have to configure phpMyAdmin also, but configureation refers the the config.inc.php file for editing and i simply do not have this file, so what now?

jacksonpt · 02-16-2006, 05:04 AM

You're right... you shouldn't have to configure your .conf file for MySQL (I couldn't remember for sure last night or not). When you installed MySQL, did you pick all the default settings? Did you get any error messages?

If you run phpinfo.php and check your settings, is there a MySQL section?

linuxrunner · 02-16-2006, 03:35 PM

ok, well i finally gave up and got phpMyAdmin to work and was able to configure it that way. So it's all good, and it only took my about 18 hours to figure this out.

ricky · 02-21-2006, 08:58 AM

Yeah, database type is definitely not odbc. You need to use the native MySQL database connectivity if it is offered. YOu don't want to use odbc, period.

Apache and mysql have nothing to do with each other unless you're using mod_auth_mysql. PHP is what is actually making the connection to the mysql server. know I"m a little late on this, but I thought I'd throw this in. This is what I do on a daily basis. (PHP/MySQL development)

ldivinag · 02-24-2006, 12:02 AM

Quote:

Originally Posted by jacksonpt

is apache setup to run mysql? it might just be a matter of adding a line to you http.conf file.

no. mysql doesnt need apache.

php needs apache to properly serve up php pages.

mysql can be called by either apache (in case of MOD_MYSQL for authenticantion needs) and by php... of course...

02-14-2006, 10:13 PM	#2 (permalink)
marko3xl3 Contributing Member Join Date: Jun 2005 Location: San Jose, CA Posts: 1,709	I am really tired right know, and even though I am usually able to help with these errors (mainly because I have been through a lot), I have a total brain fart. But here is my pathetic try... is the "Database Type" supposed to be "OBDC" and not mySQL? What are the other choices? __________________ :Marko: Supercharged 98 4Runner SR5 4x4 3.4L 4" Deckplate :: TrueFlow Air Intake System :: Magnaflow 18" Muffler w/ Resonator XM Satellite Radio (Roady 2) :: Autometer Boost Gauge :: Color Keyed Spoiler TOYOTA\|moving forward

02-15-2006, 05:15 AM	#3 (permalink)
jacksonpt Senior Member Join Date: May 2002 Location: Binghamton, NY Posts: 2,753	From the error, it looks like the webserver doesn't have the ODBC driver for that database installed. Is this webcalendar thing a app you downloaded then tried to install? The screenshot is not an interface I'm used to. __________________ Jackson - My Site 96 SR5 4x4 - 33" MTs, open diffs, and 3.90s - LET'S ROCK! My runner has bee traded in sniff on an 06 SR5 long bed d-cab Tacoma. The tacoma is nice, but... sniff ... I'll update my site when I'm done grieving.

02-15-2006, 06:03 AM	#5 (permalink)
jacksonpt Senior Member Join Date: May 2002 Location: Binghamton, NY Posts: 2,753	do you have access to a mysqladmin interface? you can write straight SQL there... kind of command line-ish. __________________ Jackson - My Site 96 SR5 4x4 - 33" MTs, open diffs, and 3.90s - LET'S ROCK! My runner has bee traded in sniff on an 06 SR5 long bed d-cab Tacoma. The tacoma is nice, but... sniff ... I'll update my site when I'm done grieving.

02-15-2006, 09:42 AM	#8 (permalink)
jacksonpt Senior Member Join Date: May 2002 Location: Binghamton, NY Posts: 2,753	is apache setup to run mysql? it might just be a matter of adding a line to you http.conf file. __________________ Jackson - My Site 96 SR5 4x4 - 33" MTs, open diffs, and 3.90s - LET'S ROCK! My runner has bee traded in sniff on an 06 SR5 long bed d-cab Tacoma. The tacoma is nice, but... sniff ... I'll update my site when I'm done grieving.

02-16-2006, 05:04 AM	#12 (permalink)
jacksonpt Senior Member Join Date: May 2002 Location: Binghamton, NY Posts: 2,753	You're right... you shouldn't have to configure your .conf file for MySQL (I couldn't remember for sure last night or not). When you installed MySQL, did you pick all the default settings? Did you get any error messages? If you run phpinfo.php and check your settings, is there a MySQL section? __________________ Jackson - My Site 96 SR5 4x4 - 33" MTs, open diffs, and 3.90s - LET'S ROCK! My runner has bee traded in sniff on an 06 SR5 long bed d-cab Tacoma. The tacoma is nice, but... sniff ... I'll update my site when I'm done grieving.

02-15-2006, 05:50 AM	#4 (permalink)
lee Contributing Member Join Date: Dec 2003 Location: boston, ma Posts: 6,756	yea, is this supposed to be webbased or on your computer? i bet youre just missing a driver. that interface is typical of mysql... oversimplified. i hate it, i used it to make the board on NE4ROC and it is so crappy. i wish i couldve just directly used sql.

02-15-2006, 06:31 AM	#6 (permalink)
lee Contributing Member Join Date: Dec 2003 Location: boston, ma Posts: 6,756	well luckily i didnt need it for more than creating a database and an admin user. the board script took care of the rest. but thanks for the heads up, i never did see that.

02-21-2006, 08:58 AM	#14 (permalink)
ricky Registered User Join Date: Jul 2005 Location: Denver, CO Posts: 116	Yeah, database type is definitely not odbc. You need to use the native MySQL database connectivity if it is offered. YOu don't want to use odbc, period. Apache and mysql have nothing to do with each other unless you're using mod_auth_mysql. PHP is what is actually making the connection to the mysql server. know I"m a little late on this, but I thought I'd throw this in. This is what I do on a daily basis. (PHP/MySQL development)

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Setting up a new database in Mysql	Cebby	Computer Talk	3	09-16-2005 04:44 AM
MySQL errors, php, etc... Help	Jason B	Computer Talk	2	07-21-2004 10:37 AM