Mailing Lists: Apple Mailing Lists
Image of Mac OS face in stamp
 
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Webmin & sql

At 7:17 AM -0500 1/31/03, Ray Srour jr. wrote:
First - thanks to everyone for the help yesterday with finding the mysql
directory - although I couldn't get the 'locate' command to work to save my
life, I was able to find what I needed. Thanks

I was able to get mysql running and also get webmin successfully installed.
It's really a great tool. Also - I can successfully log into the php module
and look around, etc... But what I can't do is create a new database. I
get the following error:

Failed to create database : SQL create database phpbb failed :

But no further info. I checked the database directory and there was no new
directory created for the phpbb database I was trying to create - so truly
it was correct, database creation failed.

Have you actually configured mysql with account information? Did you read the large README file that accompanies the source?

The only clue I can come up with is that in the module config page the
option: "Path to MySQL shared libraries directory" is set to:
/usr/local/mysql/lib - I'm pretty sure that's incorrect but I cannot find
where this is supposed to be.

That would indeed be incorrect. Again, use locate to find these files. If the locate database hasn't been updated as part of the 'periodic' tasks, you may have to update it manually. See the man page for locate.

One other clue is that the webmin app defaulted all mysql stuff to
/usr/local when it was supposed to be /usr/bin/ - I corrected all the
others but cannot figure this one out.

As I pointed out, on most unix systems this is where the sysadmin generally would install it.

Anyone have any clues? I used the standard apple mysql installer (ie:
install, start/stop being the only options) to install mysql originally.

An Apple mysql installer?

Again, just installing the product may not be enough, you will probably need to configure it. Again, see the mysql documentation for how to do this.
--

-dhan
via email@hidden

------------------------------------------------------------------------
Dan Shoop 127 East Prospect Street
Consulting Internet Architect Waldwick, NJ 07463
email@hidden

pgp public key available on the canonical key servers
pgp key fingerprint: FAC0 9434 B5A5 24A8 D0AF 12B1 7840 3BE7 3736 DE0B

"Sadly, text alone cannot convey the depths of my sarcasm."
_______________________________________________
macos-x-server mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/macos-x-server
Do not post admin requests to the list. They will be ignored.
References: 
 >Webmin & sql (From: "Ray Srour jr." <email@hidden>)



Visit the Apple Store online or at retail locations.
1-800-MY-APPLE

Contact Apple | Terms of Use | Privacy Policy

Copyright © 2007 Apple Inc. All rights reserved.