php-windows Digest 22 Jun 2010 08:15:39 -0000 Issue 3827
Topics (messages 30156 through 30169):
Re: ODBC access denied in wampserver
30156 by: Pierre Joye
30157 by: Jacob Kruger
30158 by: Jacob Kruger
30159 by: Jacob Kruger
Next issue
30160 by: Jacob Kruger
Still got issue with 'odbc' user
30161 by: Jacob Kruger
30162 by: Sascha Meyer
30164 by: Edward W. Rouse
30165 by: Edward W. Rouse
30166 by: Jacob Kruger
30167 by: Jacob Kruger
30168 by: Jacob Kruger
PHP Job Search
30163 by: Jim MacDiarmid
PHP 5.3 php_interbase.dll missing - I need help of a kind hero ^-^
30169 by: cp
Administrivia:
To subscribe to the digest, e-mail:
php-windows-digest-subscr...@lists.php.net
To unsubscribe from the digest, e-mail:
php-windows-digest-unsubscr...@lists.php.net
To post to the list, e-mail:
php-wind...@lists.php.net
----------------------------------------------------------------------
--- Begin Message ---
hi,
On Mon, Jun 21, 2010 at 12:20 PM, Jacob Kruger <jac...@mailzone.co.za> wrote:
> Access denied for user 'ODBC'@'localhost' (using password: NO) in
> C:\wamp\www\spiraleye\sql.php on line 9
> (Problem: Access denied for user 'ODBC'@'localhost' (using password: NO)
> Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link
> resource in C:\wamp\www\spiraleye\sql.php on line 15
The use called "ODBC" has no access to the mysql database. Check the
mysql manual to know how to create new users or give existing users
the correct permissions.
Cheers,
--
Pierre
@pierrejoye | http://blog.thepimp.net | http://www.libgd.org
--- End Message ---
--- Begin Message ---
I am actually using the root user, and via MySQL-Front, it has rights to
create structures, etc., so I think it's more to do with a setting of
another type...?
Stay well
Jacob Kruger
Blind Biker
Skype: BlindZA
'...fate had broken his body, but not his spirit...'
----- Original Message -----
From: "Pierre Joye" <pierre....@gmail.com>
To: "Jacob Kruger" <jac...@mailzone.co.za>
Cc: <php-wind...@lists.php.net>
Sent: Monday, June 21, 2010 12:47 PM
Subject: Re: [PHP-WIN] ODBC access denied in wampserver
hi,
On Mon, Jun 21, 2010 at 12:20 PM, Jacob Kruger <jac...@mailzone.co.za>
wrote:
Access denied for user 'ODBC'@'localhost' (using password: NO) in
C:\wamp\www\spiraleye\sql.php on line 9
(Problem: Access denied for user 'ODBC'@'localhost' (using password: NO)
Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link
resource in C:\wamp\www\spiraleye\sql.php on line 15
The use called "ODBC" has no access to the mysql database. Check the
mysql manual to know how to create new users or give existing users
the correct permissions.
Cheers,
--
Pierre
@pierrejoye | http://blog.thepimp.net | http://www.libgd.org
__________ Information from ESET NOD32 Antivirus, version of virus
signature database 5213 (20100621) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
__________ Information from ESET NOD32 Antivirus, version of virus signature
database 5213 (20100621) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
--- End Message ---
--- Begin Message ---
Will try creating another user as well, but PHPMyAdmin isn't too great when
used with a screenreader <smile>
Stay well
Jacob Kruger
Blind Biker
Skype: BlindZA
'...fate had broken his body, but not his spirit...'
----- Original Message -----
From: "Pierre Joye" <pierre....@gmail.com>
To: "Jacob Kruger" <jac...@mailzone.co.za>
Cc: <php-wind...@lists.php.net>
Sent: Monday, June 21, 2010 12:47 PM
Subject: Re: [PHP-WIN] ODBC access denied in wampserver
hi,
On Mon, Jun 21, 2010 at 12:20 PM, Jacob Kruger <jac...@mailzone.co.za>
wrote:
Access denied for user 'ODBC'@'localhost' (using password: NO) in
C:\wamp\www\spiraleye\sql.php on line 9
(Problem: Access denied for user 'ODBC'@'localhost' (using password: NO)
Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link
resource in C:\wamp\www\spiraleye\sql.php on line 15
The use called "ODBC" has no access to the mysql database. Check the
mysql manual to know how to create new users or give existing users
the correct permissions.
Cheers,
--
Pierre
@pierrejoye | http://blog.thepimp.net | http://www.libgd.org
__________ Information from ESET NOD32 Antivirus, version of virus
signature database 5213 (20100621) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
__________ Information from ESET NOD32 Antivirus, version of virus signature
database 5213 (20100621) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
--- End Message ---
--- Begin Message ---
The following lines set variable values:
$mySQLServer = "localhost";
$mySQLUsername = "root";
$mySQLPassword = "root";
The following line then tries to connect:
$con = mysql_connect($mySQLServer,$mySQLUsername, $mySQLPassword);
Stay well
Jacob Kruger
Blind Biker
Skype: BlindZA
'...fate had broken his body, but not his spirit...'
----- Original Message -----
From: "George Pitcher" <george.pitc...@publishingtechnology.com>
To: "'Jacob Kruger'" <jac...@mailzone.co.za>
Sent: Monday, June 21, 2010 12:42 PM
Subject: RE: [PHP-WIN] ODBC access denied in wampserver
Jacob,
The comment (using password: NO) is telling you that no password is being
presented to MySQL.
Check your script where the password is entered into the login script.
Cheers
George
-----Original Message-----
From: Jacob Kruger [mailto:jac...@mailzone.co.za]
Sent: 21 June 2010 11:21
To: php-wind...@lists.php.net
Subject: [PHP-WIN] ODBC access denied in wampserver
Access denied for user 'ODBC'@'localhost' (using password: NO) in
C:\wamp\www\spiraleye\sql.php on line 9
(Problem: Access denied for user 'ODBC'@'localhost' (using password: NO)
Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link
resource in C:\wamp\www\spiraleye\sql.php on line 15
Line 9 is the following:
$con = mysql_connect($mySQLServer,$mySQLUsername, $mySQLPassword);
Line 15 is the following:
mysql_select_db($mySQLDB, $con);
I initially had this issue while trying to connect with the default, blank
password for user, root, but now set the password to something else using
phpmyadmin, and it works via mysql-front, but still gives me the same
error/issue when trying to access the database via a PHP page?
Any thoughts?
TIA
Jacob Kruger
Blind Biker
Skype: BlindZA
'...fate had broken his body, but not his spirit...'
__________ Information from ESET NOD32 Antivirus, version of virus
signature
database 5213 (20100621) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
__________ Information from ESET NOD32 Antivirus, version of virus
signature database 5213 (20100621) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
__________ Information from ESET NOD32 Antivirus, version of virus signature
database 5214 (20100621) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
--- End Message ---
--- Begin Message ---
Ok, tried setting the root password to a non blank one via PHPMyAdmin, but can
still not connect to it via PHP pages, and can now no longer connect to
PHPMyAdmin either.
Tried changing settings in various config.inc.php files, and tried uninstalling
wampserver, cleaning out all files in c:\wamp, etc. etc., but still can't
connect to PHPMyAdmin at all, although using MySQL-Front, I can again connect
to database server using blank password again.
I did manually stop services, and then try restart WampServer again, and just
haven't been able to restart the machine as such since am busy with a rather
slow download in the background, but anyway.
Stay well
Jacob Kruger
Blind Biker
Skype: BlindZA
'...fate had broken his body, but not his spirit...'
__________ Information from ESET NOD32 Antivirus, version of virus signature
database 5214 (20100621) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
--- End Message ---
--- Begin Message ---
Still getting the following error although now created a specific user that
granted all privileges to for the specific database, using PHPMyAdmin, and the
error returned is still the following:
(Problem: Access denied for user 'ODBC'@'localhost' (using password: NO)
I am specifically connecting using the new username/password combo, so no idea
why it's 'ignoring' them...?
$con = mysql_connect($mySQLServer,$mySQLUsername, $mySQLPassword);
Stay well
Jacob Kruger
Blind Biker
Skype: BlindZA
'...fate had broken his body, but not his spirit...'
__________ Information from ESET NOD32 Antivirus, version of virus signature
database 5215 (20100621) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
--- End Message ---
--- Begin Message ---
Hi Jacob,
Jacob wrote:
> Still getting the following error although now created a specific user
> that granted all privileges to for the specific database, using PHPMyAdmin,
> and the error returned is still the following:
> (Problem: Access denied for user 'ODBC'@'localhost' (using password: NO)
I bet the MySQL connection fails because of uninitialized variables, otherwise
you'd see your passed username in the error message ('root'@'localhost')
instead of ODBC.
Could you try the following instead to connect to MySQL:
[CODE]
$dbServer = "localhost";
$dbUser = "root";
$dbPass = "root";
$dbName = "YOURDB";
$conn = mysql_connect($dbServer, $dbUser, $dbPass);
if ($conn){
$res = mysql_select_db($dbName);
if ($res){
print "Connection established";
} else {
print "Selecting db failed";
}
} else {
print "Connection failed with ".mysql_error();
}
[/CODE]
Could you give us some more info about your file structure of your web?
Especially, where are the $my... variables initialized used in the
mysql_connect() call?
Best regards,
Sascha
--
Freundliche Grüße / Kind regards,
Sascha Meyer
--------------------------------------------------
EE: http://www.experts-exchange.com/M_761556.html
ZCE: http://www.zend.com/en/yellow-pages#show-ClientCandidateID=ZEND011290
GRATIS für alle GMX-Mitglieder: Die maxdome Movie-FLAT!
Jetzt freischalten unter http://portal.gmx.net/de/go/maxdome01
--- End Message ---
--- Begin Message ---
I'm not a big php user, but, if you have set and are using a password, why
does the access denied message show (using password: NO). If memory serves
(and it has been a while) using ODBC means that you have to set up an ODBC
'proxy' that you use to actually make the DB connection. So my question
would be: Did you specify a password when you set up the ODBC connection?
I don't remember if ODBC allows password pass-through (or if it does now).
Edward W. Rouse
-----Original Message-----
From: Jacob Kruger [mailto:jac...@mailzone.co.za]
Sent: Monday, June 21, 2010 11:19 AM
To: php-wind...@lists.php.net
Subject: [PHP-WIN] Still got issue with 'odbc' user
Still getting the following error although now created a specific user that
granted all privileges to for the specific database, using PHPMyAdmin, and
the error returned is still the following:
(Problem: Access denied for user 'ODBC'@'localhost' (using password: NO)
I am specifically connecting using the new username/password combo, so no
idea why it's 'ignoring' them...?
$con = mysql_connect($mySQLServer,$mySQLUsername, $mySQLPassword);
Stay well
Jacob Kruger
Blind Biker
Skype: BlindZA
'...fate had broken his body, but not his spirit...'
__________ Information from ESET NOD32 Antivirus, version of virus signature
database 5215 (20100621) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
--- End Message ---
--- Begin Message ---
If I misunderstood the user ODBC, then try this link:
http://forums.mysql.com/read.php?35,185032,246936#msg-246936
Edward W. Rouse
-----Original Message-----
From: Jacob Kruger [mailto:jac...@mailzone.co.za]
Sent: Monday, June 21, 2010 11:19 AM
To: php-wind...@lists.php.net
Subject: [PHP-WIN] Still got issue with 'odbc' user
Still getting the following error although now created a specific user that
granted all privileges to for the specific database, using PHPMyAdmin, and
the error returned is still the following:
(Problem: Access denied for user 'ODBC'@'localhost' (using password: NO)
I am specifically connecting using the new username/password combo, so no
idea why it's 'ignoring' them...?
$con = mysql_connect($mySQLServer,$mySQLUsername, $mySQLPassword);
Stay well
Jacob Kruger
Blind Biker
Skype: BlindZA
'...fate had broken his body, but not his spirit...'
__________ Information from ESET NOD32 Antivirus, version of virus signature
database 5215 (20100621) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
--- End Message ---
--- Begin Message ---
Ok, your mail made me realise why it wasn't working...the variable values
were being assigned above, but outside the function I was enclosing the
connect etc. in, but when I moved their assignment inside the function, it
now seems to work.
This database specific code is also being set apart in a separate file that
am including/requiring in the other pages using the require() function, and
then am calling the connectDB() function that now includes assigning values
to those variables, so seems like maybe it wasn't seeing the value
assignments before trying to call the function or something.
The idea behind that part of it was to allow me to make one change to
database details that would still affect all the pages as such.
Thanks either way, since it's now working.
Stay well
Jacob Kruger
Blind Biker
Skype: BlindZA
'...fate had broken his body, but not his spirit...'
----- Original Message -----
From: "Sascha Meyer" <harlequ...@gmx.de>
To: "Jacob Kruger" <jac...@mailzone.co.za>; <php-wind...@lists.php.net>
Sent: Monday, June 21, 2010 5:45 PM
Subject: Re: [PHP-WIN] Still got issue with 'odbc' user
Hi Jacob,
Jacob wrote:
Still getting the following error although now created a specific user
that granted all privileges to for the specific database, using
PHPMyAdmin,
and the error returned is still the following:
(Problem: Access denied for user 'ODBC'@'localhost' (using password: NO)
I bet the MySQL connection fails because of uninitialized variables,
otherwise you'd see your passed username in the error message
('root'@'localhost') instead of ODBC.
Could you try the following instead to connect to MySQL:
[CODE]
$dbServer = "localhost";
$dbUser = "root";
$dbPass = "root";
$dbName = "YOURDB";
$conn = mysql_connect($dbServer, $dbUser, $dbPass);
if ($conn){
$res = mysql_select_db($dbName);
if ($res){
print "Connection established";
} else {
print "Selecting db failed";
}
} else {
print "Connection failed with ".mysql_error();
}
[/CODE]
Could you give us some more info about your file structure of your web?
Especially, where are the $my... variables initialized used in the
mysql_connect() call?
Best regards,
Sascha
--
Freundliche Grüße / Kind regards,
Sascha Meyer
--------------------------------------------------
EE: http://www.experts-exchange.com/M_761556.html
ZCE: http://www.zend.com/en/yellow-pages#show-ClientCandidateID=ZEND011290
GRATIS für alle GMX-Mitglieder: Die maxdome Movie-FLAT!
Jetzt freischalten unter http://portal.gmx.net/de/go/maxdome01
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
__________ Information from ESET NOD32 Antivirus, version of virus
signature database 5216 (20100621) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
__________ Information from ESET NOD32 Antivirus, version of virus signature
database 5216 (20100621) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
--- End Message ---
--- Begin Message ---
Wasn't using ODBC, but I think that like Sasha mentioned it seemed to not be
assigning values to the variables, so it was reacting to empty variables in
some other way.
Stay well
Jacob Kruger
Blind Biker
Skype: BlindZA
'...fate had broken his body, but not his spirit...'
----- Original Message -----
From: "Edward W. Rouse" <ero...@comsquared.com>
To: "'Jacob Kruger'" <jac...@mailzone.co.za>; <php-wind...@lists.php.net>
Sent: Monday, June 21, 2010 8:58 PM
Subject: RE: [PHP-WIN] Still got issue with 'odbc' user
I'm not a big php user, but, if you have set and are using a password, why
does the access denied message show (using password: NO). If memory serves
(and it has been a while) using ODBC means that you have to set up an ODBC
'proxy' that you use to actually make the DB connection. So my question
would be: Did you specify a password when you set up the ODBC connection?
I don't remember if ODBC allows password pass-through (or if it does now).
Edward W. Rouse
-----Original Message-----
From: Jacob Kruger [mailto:jac...@mailzone.co.za]
Sent: Monday, June 21, 2010 11:19 AM
To: php-wind...@lists.php.net
Subject: [PHP-WIN] Still got issue with 'odbc' user
Still getting the following error although now created a specific user
that
granted all privileges to for the specific database, using PHPMyAdmin, and
the error returned is still the following:
(Problem: Access denied for user 'ODBC'@'localhost' (using password: NO)
I am specifically connecting using the new username/password combo, so no
idea why it's 'ignoring' them...?
$con = mysql_connect($mySQLServer,$mySQLUsername, $mySQLPassword);
Stay well
Jacob Kruger
Blind Biker
Skype: BlindZA
'...fate had broken his body, but not his spirit...'
__________ Information from ESET NOD32 Antivirus, version of virus
signature
database 5215 (20100621) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
__________ Information from ESET NOD32 Antivirus, version of virus
signature database 5216 (20100621) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
__________ Information from ESET NOD32 Antivirus, version of virus signature
database 5216 (20100621) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
--- End Message ---
--- Begin Message ---
Wasn't using ODBC, but I think that like Sasha mentioned it seemed to not be
assigning values to the variables, so it was reacting to empty variables in
some other way.
Stay well
Jacob Kruger
Blind Biker
Skype: BlindZA
'...fate had broken his body, but not his spirit...'
----- Original Message -----
From: "Edward W. Rouse" <ero...@comsquared.com>
To: "'Jacob Kruger'" <jac...@mailzone.co.za>; <php-wind...@lists.php.net>
Sent: Monday, June 21, 2010 8:58 PM
Subject: RE: [PHP-WIN] Still got issue with 'odbc' user
I'm not a big php user, but, if you have set and are using a password, why
does the access denied message show (using password: NO). If memory serves
(and it has been a while) using ODBC means that you have to set up an ODBC
'proxy' that you use to actually make the DB connection. So my question
would be: Did you specify a password when you set up the ODBC connection?
I don't remember if ODBC allows password pass-through (or if it does now).
Edward W. Rouse
-----Original Message-----
From: Jacob Kruger [mailto:jac...@mailzone.co.za]
Sent: Monday, June 21, 2010 11:19 AM
To: php-wind...@lists.php.net
Subject: [PHP-WIN] Still got issue with 'odbc' user
Still getting the following error although now created a specific user
that
granted all privileges to for the specific database, using PHPMyAdmin, and
the error returned is still the following:
(Problem: Access denied for user 'ODBC'@'localhost' (using password: NO)
I am specifically connecting using the new username/password combo, so no
idea why it's 'ignoring' them...?
$con = mysql_connect($mySQLServer,$mySQLUsername, $mySQLPassword);
Stay well
Jacob Kruger
Blind Biker
Skype: BlindZA
'...fate had broken his body, but not his spirit...'
__________ Information from ESET NOD32 Antivirus, version of virus
signature
database 5215 (20100621) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
__________ Information from ESET NOD32 Antivirus, version of virus
signature database 5216 (20100621) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
__________ Information from ESET NOD32 Antivirus, version of virus signature
database 5216 (20100621) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
__________ Information from ESET NOD32 Antivirus, version of virus signature
database 5216 (20100621) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
--- End Message ---
--- Begin Message ---
Hi everyone,
My apologies for the ad in this mailing list but I'm trying to use all my
resources in my job hunt. I wanted to reach out to you all and see what the
job market was like for PHP Developers in Virginia/Washington DC area. I
have been working with computers for over 20 years and have been in
developing software and web applications both in Classic ASP/VB6, and PHP
for roughly 11 years. A have also developed some modifications for the
vBulletin forum software. If any of you are vBulletin forum admins you may
be familiar with the mod that sends email reminders to inactive members.
That is the one I've recently been working on. Here is the link as a
reference: http://www.vbulletin.org/forum/showthread.php?t=237531
Please feel free to contact me off-line with questions, info on job leads,
or resume requests. Thank you so much and have a great day!
Jim
--- End Message ---
--- Begin Message ---
Hello folks,
I recently upgraded to PHP5.3 installation for my IIS server running in
fast-cgi mode.
I found the php_interbase.dll extension missing in the download package.
I already tried to compile it myself but after installing tons of tools for
development I got stuck with some strange errors and I simply cannot manage
to compile it myself :(
Is anyone out there able to provide me with an php_interbase.dll for PHP
5.3.2????
Or at least provide me with an idiot proof manual on how to compile this
version under winxp32?
I just need this dll and nothing else - it's the very only component I need
but it is missing :(
kind regards
cp
--- End Message ---