Thanks to everyone that replied with answers involving user security. But
that is not the problem. Using the mysqlaccess utility I get the following
results...
Sele Inse Upda Dele Crea Drop Relo Shut Proc File Gran Refe Inde Alte |
Host,User,DB
---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ----
+ --------------------
Y Y Y Y Y Y N N N Y Y Y Y Y |
localhost,pamiri,d1844_net
N N N N N N N N N Y N N N N |
localhost,pamiri,ANY_NEW_DB
...this shows that user pamiri does indeed have access to database d1844_net
on server localhost.
When I set up a datasource in CF Administrator using the Merant mySQL driver
with the following settings...
Data Source Name = d1844_net
Description =
Database Name = d1844_net
Server Host Name = Localhost
Server Port = 3306
ColdFusion Login UserName = pamiri
Password = ******
...I get a failed verification. When I try...
Data Source Name = d1844_net
Description =
Database Name = d1844_net
Server Host Name = 127.0.0.1
Server Port = 3306
ColdFusion Login UserName = pamiri
Password = ******
...I get the same failed verification. I don't think CF is able to talk to
the mySQL engine at all. Here are a couple of theories I have.
One is that similar to the NT environment that the user ID the service is
running under must at times have network privileges in order to use network
resources, the user CF is running under on linux must have some special
privileges before the CF engine can talk to the mySQL engine using the
Merant mySQL Driver. Can anyone support or deny this theory?
My second theory involves Unix sockets and tcp/ip ports. Can both these be
active at the same time? I get the following results when I run
mysqladmin -p version...
Server version 3.23.21-beta-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 23 hours 55 min 0 sec
...which shows connection through Unix sockets not tcp/ip port but when I do
a mysqladmin -p variables I do get...
| port | 3306
| socket | /tmp/mysql.sock
...among other variables which I think means is listening on port 3306 as
well as the Unix socket. So I'm a little baffled.
Can anyone shed some light on this?
-Peter Amiri
Amiri Industries, Inc.
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 03, 2000 10:06 AM
To: CF-Linux
Subject: Re: Problems creating a mySQL datasource
Peter,
Have you set the privileges for the user in the mysql table?
Rob
> ----- Original Message -----
> From: "Peter Amiri" <[EMAIL PROTECTED]>
> To: "CF-Linux" <[EMAIL PROTECTED]>
> Sent: Tuesday, October 03, 2000 5:06 AM
> Subject: Problems creating a mySQL datasource
>
>
> > This is a multi-part message in MIME format.
> >
> > ------=_NextPart_000_000F_01C02C69.24F81440
> > Content-Type: text/plain;
> > charset="iso-8859-1"
> > Content-Transfer-Encoding: 7bit
> >
> > I'm having problems creating a mySQL datasource through the CF
> > Administrator. It comes back as not verified. This is the first
datasource
> > I'm trying to setup so I don't know where to start in diagnosing this. I
> > know mySQL is up and running, and php3 pages to mySQL and the particular
> > database I'm trying to connect to are working. What I've done so far is
to
> > create a mySQL database and using the phpMyAdmin tools created a table,
> > added columns, and created a row of data. I now want to connect CF to
the
> > database so I can run CF code against it.
> >
> > B. Peter Amiri Direct: 949-470-2093
> > Amiri Industries, Inc. Office: 949-470-2090
> > 23232 Peralta Drive, Suite 222 Fax: 949-470-2095
> > Laguna Hills, California 92653 E-Mail: [EMAIL PROTECTED]
> > URL: www.amiriindustries.com
> >
> >
> > ------=_NextPart_000_000F_01C02C69.24F81440
> > Content-Type: application/ms-tnef;
> > name="winmail.dat"
> > Content-Transfer-Encoding: base64
> > Content-Disposition: attachment;
> > filename="winmail.dat"
> >
> >
>
eJ8+IgYTAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
> >
>
b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEGgAMADgAAANAHCgACAAwABgAAAAEA9gAB
> >
>
A5AGAOwHAAAlAAAACwACAAEAAAALACMAAAAAAAMAJgAAAAAACwApAAAAAAADADYAAAAAAB4AcAAB
> >
>
AAAAJQAAAFByb2JsZW1zIGNyZWF0aW5nIGEgbXlTUUwgZGF0YXNvdXJjZQAAAAACAXEAAQAAABYA
> >
>
AAABwCyj0KR0Ox08mIYR1J7pAFCLE+KCAAACAR0MAQAAABUAAABTTVRQOlBFVEVSQEFNSVJJLk5F
> >
>
VAAAAAALAAEOAAAAAEAABg4A3C3NoyzAAQIBCg4BAAAAGAAAAAAAAAB+rZdbmV7UEZ7UAFCLE+KC
> >
>
woAAAAsAHw4BAAAAAgEJEAEAAACDAwAAfwMAAB4FAABMWkZ1jXHsEgMACgByY3BnMTI1FjIA+Atg
> >
>
bg4QMDMzTwH3AqQD4wIAY2gKwHPgZXQwIEcDEAMgBhMcTVQCgwBQEGZwcnFvDlAQ2AcTAoB9CoAI
> >
>
yCA2OwlvDjA1AoAUknN0lHlsB5BoCeB0ewewRwWwAMACc3MxIBdwYSJkC4BnIDEUY1x2SQiQd2sL
> >
>
gGQ0DGBjBwBQCwMLtDQgSSdtXRiQYRmQGPETIG8CYGUubQQgBQAYsHQY4mEggG15U1FMIGQcsARh
> >
>
cwhhY2UgdGgxA2B1Z2geMR4gQ0aZFABkbQuABAB0chywvQWwLhswBUAFoAeCYgDQpmsdAAQgbm8F
> >
>
QHYGcqUIkGQgAFRoBAAgIjF/HsIhsBEQBUAdmRtCH6B5yxjiH9AgESF1cCSwJKDWSR2AAiAnBUBr
> >
>
ITAH4P53F3AJcCSDAZAAICJQA6D5GNBhZyEwAJAkYiIhIAEfJcQdNCIxJPEAcGQgcix1bgMADyAs
> >
>
KXNwaPxwMxvgJ2AHkSSRHTQpgucewgqxHMBjdQtgBcAdkv8gsBEgI90FoCngBZAFQCSRWwrAHiB3
> >
>
BbAZ0WcgAFd/EPAFQBtAIXAlYh4gJSFm/wrBImIuURySHiAdGi1DKYLOdSelLDEqoE15HzMkgX8G
> >
>
8BxlCYAdAQGRF0AqMWTnAQApoAjhdW0AgCo0NSjzA2AH4G9mHYMoMiXjAHB/LtMudh8BJJEewi0H
> >
>
JSNjvwORKcEe8gWgAQAdAGcLcfEjAWl0LgqiCoQKhAswvmILIAAgPnMQsD6Cdw9AWT5xc3AB0AMw
> >
>
awngcNMLkCXhaWQuwGwKsRhhkQAQaTQ1AUB0cUFA0QzQNDY4QdY2DiAMEusSc0ABQiAAUBEwBJAU
> >
>
ANcfUAUQDINiEVBEIuAusQI6DIIgOTQ5LTTINzAtAdA5MwwhPdn/QKpBn0KqE/FEkhswGfAzcG8f
> >
>
oAiQNvFKwGM9UEXSTzsBIA3gZUW/AUA9czIz903xRBEfsGwBkEVABRAhcNkqMFN1PTAeIDJPoEXD
> >
>
6EZheEx/NUb/SA8M0MgzNjBCiiBMJ2Ap0O0dEEgRgTbxQwdABpAFsMMDAB0QOTI2NUbARdLoRS1N
> >
>
C3BsUFMI0ABB5yywG+BEMkBhRJIZ4Ur1/i4gUVeRAUAssCEwLqA9ZVFF0lVSTFBUd1uQLr9Yf1mB
> >
>
PdkaxT1kFIEAXtAACwABgAggBgAAAAAAwAAAAAAAAEYAAAAAA4UAAAAAAAADAAOACCAGAAAAAADA
> >
>
AAAAAAAARgAAAAAQhQAAAAAAAAMAB4AIIAYAAAAAAMAAAAAAAABGAAAAAFKFAAAnagEAHgAJgAgg
> >
>
BgAAAAAAwAAAAAAAAEYAAAAAVIUAAAEAAAAEAAAAOS4wAB4ACoAIIAYAAAAAAMAAAAAAAABGAAAA
> >
>
ADaFAAABAAAAAQAAAAAAAAAeAAuACCAGAAAAAADAAAAAAAAARgAAAAA3hQAAAQAAAAEAAAAAAAAA
> >
>
HgAMgAggBgAAAAAAwAAAAAAAAEYAAAAAOIUAAAEAAAABAAAAAAAAAAsADYAIIAYAAAAAAMAAAAAA
> >
>
AABGAAAAAIKFAAABAAAACwA6gAggBgAAAAAAwAAAAAAAAEYAAAAADoUAAAAAAAADADyACCAGAAAA
> >
>
AADAAAAAAAAARgAAAAARhQAAAAAAAAMAPYAIIAYAAAAAAMAAAAAAAABGAAAAABiFAAAAAAAACwBS
> >
>
gAggBgAAAAAAwAAAAAAAAEYAAAAABoUAAAAAAAADAFOACCAGAAAAAADAAAAAAAAARgAAAAABhQAA
> >
>
AAAAAAIB+A8BAAAAEAAAAH6tl1uZXtQRntQAUIsT4oICAfoPAQAAABAAAAB+rZdbmV7UEZ7UAFCL
> >
>
E+KCAgH7DwEAAACPAAAAAAAAADihuxAF5RAaobsIACsqVsIAAFBTVFBSWC5ETEwAAAAAAAAAAE5J
> >
>
VEH5v7gBAKoAN9luAAAAQzpcV0lOTlRcUHJvZmlsZXNccGV0ZXJcTG9jYWwgU2V0dGluZ3NcQXBw
> >
>
bGljYXRpb24gRGF0YVxNaWNyb3NvZnRcT3V0bG9va1xvdXRsb29rLnBzdAAAAwD+DwUAAAADAA00
> >
>
/TcAAAIBfwABAAAALwAAADxORUJCSk9ORUhPUE5CTUVJSExOTUVFRE5DUEFBLnBldGVyQGFtaXJp
> >
>
Lm5ldD4AAAMABhCFZ2ePAwAHEHICAAADABAQAAAAAAMAERAAAAAAHgAIEAEAAABlAAAASU1IQVZJ
> >
>
TkdQUk9CTEVNU0NSRUFUSU5HQU1ZU1FMREFUQVNPVVJDRVRIUk9VR0hUSEVDRkFETUlOSVNUUkFU
> > T1JJVENPTUVTQkFDS0FTTk9UVkVSSUZJRURUSElTSVNUSEVGSQAAAACL4A==
> >
> > ------=_NextPart_000_000F_01C02C69.24F81440--
> >
>
> --------------------------------------------------------------------------
> ----
> > Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/
> > To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux
or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> >
>
>
> --------------------------------------------------------------------------
----
> Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
**********************
* Rob Burtelow *
* Senior SMC Staff *
* [EMAIL PROTECTED] *
**********************
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
