subject:"\[PHP\] PDO"

Re: [PHP] PDO Transaction

2013-03-16 Thread Simon Dániel

2013/3/15 Lester Caine les...@lsces.co.uk

 Simon Dániel wrote:

 Hi,

 I have a trouble with PDO transactions.

 I would like to start using transactions, but I am not familiar with it. I
 have got a 'There is no active transaction' exception, however, I am using
 beginTransaction method, and also I have set PDO::ATTR_AUTOCOMMIT to false
 right after connecting to the database.
 In my whole code I have used the commit method only once.

 Between beginTransaction and commit methods, as far as I know, I did not
 use anything that could activate auto-commit. In my test code, there is
 only an exec method of PDO, and an execute of PDOStatement. Maybe one of
 these activated auto-commit?

 And what are the possible commands which are able to activate auto-commit?
 I know that the commit method can do that, but - as I already wrote - I
 have issued it only once, and it is in the destructor of a singleton
 class.

 So what could be the problem?


 You don't say which database you are trying to access. Not all actually
 support transactions, and some need a connection correctly set.



I am using MySQL.

Re: [PHP] PDO Transaction

2013-03-16 Thread Lester Caine


Simon Dániel wrote:

2013/3/15 Lester Caine les...@lsces.co.uk


Simon Dániel wrote:


Hi,

I have a trouble with PDO transactions.

I would like to start using transactions, but I am not familiar with it. I
have got a 'There is no active transaction' exception, however, I am using
beginTransaction method, and also I have set PDO::ATTR_AUTOCOMMIT to false
right after connecting to the database.
In my whole code I have used the commit method only once.

Between beginTransaction and commit methods, as far as I know, I did not
use anything that could activate auto-commit. In my test code, there is
only an exec method of PDO, and an execute of PDOStatement. Maybe one of
these activated auto-commit?

And what are the possible commands which are able to activate auto-commit?
I know that the commit method can do that, but - as I already wrote - I
have issued it only once, and it is in the destructor of a singleton
class.

So what could be the problem?



You don't say which database you are trying to access. Not all actually
support transactions, and some need a connection correctly set.


I am using MySQL.


Have you read the warning on http://php.net/manual/en/ref.pdo-mysql.php?
It would be of more use if it actually identified what works and what does not 
:( I think you need to be running in the InnoDB engine to get transactions? 
MyISAM will throw errors on transactions.


--
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] PDO Transaction

2013-03-15 Thread Simon Dániel

Hi,

I have a trouble with PDO transactions.

I would like to start using transactions, but I am not familiar with it. I
have got a 'There is no active transaction' exception, however, I am using
beginTransaction method, and also I have set PDO::ATTR_AUTOCOMMIT to false
right after connecting to the database.
In my whole code I have used the commit method only once.

Between beginTransaction and commit methods, as far as I know, I did not
use anything that could activate auto-commit. In my test code, there is
only an exec method of PDO, and an execute of PDOStatement. Maybe one of
these activated auto-commit?

And what are the possible commands which are able to activate auto-commit?
I know that the commit method can do that, but - as I already wrote - I
have issued it only once, and it is in the destructor of a singleton class.

So what could be the problem?

Re: [PHP] PDO Transaction

2013-03-15 Thread Lester Caine


Simon Dániel wrote:

Hi,

I have a trouble with PDO transactions.

I would like to start using transactions, but I am not familiar with it. I
have got a 'There is no active transaction' exception, however, I am using
beginTransaction method, and also I have set PDO::ATTR_AUTOCOMMIT to false
right after connecting to the database.
In my whole code I have used the commit method only once.

Between beginTransaction and commit methods, as far as I know, I did not
use anything that could activate auto-commit. In my test code, there is
only an exec method of PDO, and an execute of PDOStatement. Maybe one of
these activated auto-commit?

And what are the possible commands which are able to activate auto-commit?
I know that the commit method can do that, but - as I already wrote - I
have issued it only once, and it is in the destructor of a singleton class.

So what could be the problem?


You don't say which database you are trying to access. Not all actually support 
transactions, and some need a connection correctly set.


--
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] PDO question

2012-11-29 Thread admin

 -Original Message-
 From: Jim Lucas [mailto:li...@cmsws.com]
 Sent: Wednesday, November 28, 2012 9:23 PM
 To: ad...@buskirkgraphics.com
 Cc: php-general@lists.php.net
 Subject: Re: [PHP] PDO question

 On 11/28/2012 12:58 PM, ad...@buskirkgraphics.com wrote:

  Guys,
  I am not quiet sure what is happening but every time i try to connect
  to a remote host it refers back to localhost.

  $pdo = new PDO('mysql:host=171.16.23.44;dbname=test',
  'user','password');

  ERROR: Access denied for user 'user'@'localhost' (using password:
 YES)
  in /var/www/html/text.php

  Any clue as to WHY it keeps referring back to localhost when i
 clearly
  set the host parameter to another server.
  I checked the /etc/hosts records to see if there was a referral for
  that domain back to it's self there is NOT.

 There is a warning on the following page that talks about a possible
 issue with connections.  Might give it a look.

 http://www.php.net/manual/en/ref.pdo-mysql.connection.php

 --
 Jim Lucas

 http://www.cmsws.com/
 http://www.cmsws.com/examples/

Thank you issue resolved for some reason it was passing the credentials with 
the fully qualified domain name and NOT the IP and the permission failed to 
match.
Not sure why it is suddenly passing the fully qualified domain name now but as 
long and this works I really don’t care thanks.

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] PDO question

2012-11-28 Thread ad...@buskirkgraphics.com


Guys,
I am not quiet sure what is happening but every time i try to connect to a
remote host it refers back to localhost.

$pdo = new PDO('mysql:host=171.16.23.44;dbname=test', 'user','password');

ERROR: Access denied for user 'user'@'localhost' (using password: YES) in
/var/www/html/text.php

Any clue as to WHY it keeps referring back to localhost when i clearly set the
host parameter to another server.
I checked the /etc/hosts records to see if there was a referral for that domain
back to it's self there is NOT.

[PHP] PDO mysql Connection issue

2012-11-28 Thread ad...@buskirkgraphics.com

I am having a PDO mysql connection issue I cant explain.

On server server1.mydomain.com
I have a test script
?php
$pdo = new PDO('mysql:host=171.16.23.44;dbname=test', 'user','password');
?
171.16.23.44 is by an A record called server2.mydoamin.com  they are 2 different
servers.
This script returns an error:
ERROR: Access denied for user 'user'@'server1.mydomain.com' (using password:
YES)

I find this ODD because that is not the server i am connecting TO but FROM.
Why would the PDO connection be referring back to its own localhost instead of
the intended domain.
I have tried this by fully qualified domain name, same thing.
I have ensured the route does exist on the connecting server.
I have ensured there is no local reference to the domain name/IP back to its
self.

I log into 171.16.23.44 and there is NO record of the failed attempt.
I validate the user has remote access rights.
I validate there is not a firewall rule blocking the host/port/you name it.
I telnet from the server to the destination via port 3306 it connects.

BTW (171.16.23.44) IS FAKE I AM USING THE IP AS AN EXAMPLE HERE.

Any clue as to WHY the host parameter is not setting or is it setting and
something else is wrong?

Re: [PHP] PDO mysql Connection issue

2012-11-28 Thread Mike Mackintosh

On Wednesday, November 28, 2012 at 4:50 PM, ad...@buskirkgraphics.com wrote:
I am having a PDO mysql connection issue I cant explain.

On server server1.mydomain.com (http://server1.mydomain.com)
I have a test script
?php
$pdo = new PDO('mysql:host=171.16.23.44;dbname=test', 'user','password');
?
171.16.23.44 is by an A record called server2.mydoamin.com
(http://server2.mydoamin.com) they are 2 different
servers.
This script returns an error:
ERROR: Access denied for user 'user'@'server1.mydomain.com
(http://server1.mydomain.com)' (using password:
YES)

I find this ODD because that is not the server i am connecting TO but FROM.
Why would the PDO connection be referring back to its own localhost instead of
the intended domain.
I have tried this by fully qualified domain name, same thing.
I have ensured the route does exist on the connecting server.
I have ensured there is no local reference to the domain name/IP back to its
self.

I log into 171.16.23.44 and there is NO record of the failed attempt.
I validate the user has remote access rights.
I validate there is not a firewall rule blocking the host/port/you name it.
I telnet from the server to the destination via port 3306 it connects.

BTW (171.16.23.44) IS FAKE I AM USING THE IP AS AN EXAMPLE HERE.

Any clue as to WHY the host parameter is not setting or is it setting and
something else is wrong?

Have you tried running FLUSH HOSTS on the MySQL server?

Also, i would try to disable DNS within MYSQL by starting with
--skip-name-resolve
(http://dev.mysql.com/doc/refman/5.0/en/server-options.html#option_mysqld_skip-name-resolve);

--
Mike Mackintosh
PHP 5.3 ZCE

Re: [PHP] PDO mysql Connection issue

2012-11-28 Thread Admin

On Wednesday, November 28, 2012 at 4:50 PM, ad...@buskirkgraphics.com wrote:
I am having a PDO mysql connection issue I cant explain.

I find this ODD because that is not the server i am connecting TO but FROM.
Why would the PDO connection be referring back to its own localhost instead
of
the intended domain.
I have tried this by fully qualified domain name, same thing.
I have ensured the route does exist on the connecting server.
I have ensured there is no local reference to the domain name/IP back to its
self.

BTW (171.16.23.44) IS FAKE I AM USING THE IP AS AN EXAMPLE HERE.

Any clue as to WHY the host parameter is not setting or is it setting and
something else is wrong?

Have you tried running FLUSH HOSTS on the MySQL server?

Also, i would try to disable DNS within MYSQL by starting with
--skip-name-resolve
(http://dev.mysql.com/doc/refman/5.0/en/server-options.html#option_mysqld_skip-name-resolve);

1 2 >

1 - 100 of 167 matches

Mail list logo