[PHP-DB] Re: Remote ODBC Connection to IBMi Db2/iAccess Very Slow to Fetch Results

Hello again, It looks like the most recent PHP version (8.3.4) fixed this slow result fetching problem, so long as the SQL_CUR_USE_ODBC option is passed to the odbc_connect() function. I was going to post a bug report, when I tested it one last time, and lo-and-behold, the fetching performance

Re: spam>[PHP-DB] Remove

Yes, just send an e-mail to "php-db+unsubscr...@lists.php.net" I imagine it will ask for confirmation. From: Kevin McColl Sent: March 12, 2024 10:53 AM To: php-db@lists.php.net Subject: spam>[PHP-DB] Remove Is there a way to stop or remove receiving these

[PHP-DB] Remove

Is there a way to stop or remove receiving these emails?

[PHP-DB] Re: Remote ODBC Connection to IBMi Db2/iAccess Very Slow to Fetch Results

I found the options for "odbc.default_cursortype" here: https://www.php.net/manual/en/odbc.configuration.php (not sure why I didn't see it before). However, none of the options (0 to 3) made any difference. Zachary From: Zachary Menzies Sent: March 12, 2024

[PHP-DB] Remote ODBC Connection to IBMi Db2/iAccess Very Slow to Fetch Results

Hello, At work, we have an IBM Db2 database. Until recently, it lived within our local network, but has since been moved off-site (to the cloud). We connect to it using an iSeries Access ODBC driver. For communication, I typically use PHP's ODBC interface (sometimes other languages). When the

[PHP-DB] Requesting a feature change to PHP mysqli

Hi How should I go about requesting a feature change to mysqli.php. When using mysql_real_connect with SSL and certificates. The underlying libraries have the ability to disable certificate verification, peer name verification, and pass in a peer name to use in the verification. Currently

Re: [PHP-DB] use php variable within postgresql query

Oh I see now I am late to the conversation. Slow email load. Carry on. > On Jun 12, 2023, at 1:42 PM, Karl DeSaulniers wrote: > > Hi, > I am assuming this is just a typo in your post and not your code, correct? > (see quoted text below) > If not, then try the other bracket? > >

Re: [PHP-DB] use php variable within postgresql query

Hi, I am assuming this is just a typo in your post and not your code, correct? (see quoted text below) If not, then try the other bracket? $query=$_GET['databasecolumn']; > On Jun 9, 2023, at 4:05 AM, e-letter wrote: > > $query=$_GET['databasecolumn'[;

[PHP-DB] Re: use php variable within postgresql query

Yes, aware but one step at a time, slowly(!) As a non-programmer, want to test ability to comprehend the concepts first, before security implementations. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] use php variable within postgresql query

Meanwhile, you should probably use prepared statements to avoid SQL injection. On Mon, 12 Jun 2023 at 16:03, e-letter wrote: > First, sorry for the mistake to type a sanitised version of code. > Should have been: > "$query=$_GET['databasecolumn'];" > > After some rtfm, confused as a

Re: [PHP-DB] use php variable within postgresql query

First, sorry for the mistake to type a sanitised version of code. Should have been: "$query=$_GET['databasecolumn'];" After some rtfm, confused as a non-computer-programmer why it is necessary to set the $_GET parameter. The overall simple scenario is to view a postgresql database in a series of

Re: [PHP-DB] use php variable within postgresql query

That was a bad copy/paste on his part. Syntax errors will not allow PHP to even run the code. On Fri, Jun 9, 2023 at 11:14 AM G. Franklin wrote: > My friends, > > Would not the syntax of "$query=$_GET['databasecolumn'[;" be part of the > issue? > > I believe the brackets should be closed like

Re: [PHP-DB] use php variable within postgresql query

My friends, Would not the syntax of "$query=$_GET['databasecolumn'[;" be part of the issue? I believe the brackets should be closed like this, no? "$query=$_GET['databasecolumn'];" ~G. On Fri, 9 Jun 2023 at 10:53, Aziz Saleh wrote: > Read and understand these, should help you: > >

Re: [PHP-DB] use php variable within postgresql query

Read and understand these, should help you: https://www.php.net/manual/en/language.types.array.php Basically its databasecolumnname get param is not defined (set) causing the query to fail also. On Fri, Jun 9, 2023 at 5:06 AM e-letter wrote: > Readers, > > Suppose: > >

[PHP-DB] use php variable within postgresql query

Readers, Suppose: $query=$_GET['databasecolumn'[; $anotherquery=pg_query($databaseconnection, 'SELECT * FROM databasename WHERE databasecolumnname="'.$query.';"'); Two errors are reported: PHP Notice: Undefined index: databasecolumnname PHP Warning: pg_query(): Query failed: ERROR: column

[PHP-DB] Imap-Connection fails, how do I have to define imap_open

Hi, I want to connect within a php-Script to my Imapserver at all-inkl. In my Thunderbird the account-settings are: Server: w017fd8a.kasserver.com Port: 993 Connecting-Way: SSL/TLS Authication-Method: normal Password this settings are function in the Thunderbird-Client. But in the

[PHP-DB] PDO::quote is only *theoretically* safe ?

The documentation for PDO::quote [0] says that a processed string is "theoretically safe to pass into an SQL statement". Understandably, prepared statements should be preferred when possible. But I need to change some stuff where integrating them is impossible, and some values must be securely

RE: [PHP-DB] what does the mysqli real connect MYSQLI_CLIENT_SSL_DONT_VERIFY_SERVER_CERT flag do? How to disable only CN validation?

Thanks, I already saw that from the documentation. I wanted to know what is validation in this context? Complete verification of the cert, or only CN verification. Looking at the source it appears this flag disables both, in the underlying php/openssl, plus does something with

Re: [PHP-DB] what does the mysqli real connect MYSQLI_CLIENT_SSL_DONT_VERIFY_SERVER_CERT flag do? How to disable only CN validation?

That flag uses SSL encryption but disables validation of the provided SSL certificate. This is only for installations using MySQL Native Driver and MySQL 5.6 or later. On Wed, Mar 22, 2023 at 4:50 PM John Wythe wrote: > mysqli_real_connect has a parameter called flags than can be passed to >

[PHP-DB] what does the mysqli real connect MYSQLI_CLIENT_SSL_DONT_VERIFY_SERVER_CERT flag do? How to disable only CN validation?

mysqli_real_connect has a parameter called flags than can be passed to it. One of the flags in MYSQLI_CLIENT_SSL_DONT_VERIFY_SERVER_CERT. What does this flag do? Does it only disable the CN validation, or does it also disable the certificate validation against a CA authority. SSL_CONEXT

[PHP-DB] Php mariadb unique field selection for index of query result.

Hi, Quick question. I may be missing something but for years I've been processing the output of a query into a new array using the unique(normally primary key) field in the table as the index so I can pull data matches simply further into the script without another loop through all the

[PHP-DB] Bolt and PDO Bolt support for CQL and graph databases

Hi. What is Bolt? Bolt is specification made by Neo4j for communication with graph databases and it runs over TCP socket which is uses for transfering messages in binary. Currently this specification is used by Neo4j, Memgraph and Amazon Neptune. Documentation is available at:

[PHP-DB] A pdo extension for TDengine database

Hi, I use Swoole for IoT projects at work. I recently discovered an efficient IoT database TDengine, but found that there is no PHP extension. So based on the official C language document and the client source code, I develop the PDO extension, hoping to publish it on PECL, so that more people

[PHP-DB] Re: [External] : [PHP-DB] PDO to Oracle db and secure external password store aka wallet for authentication

On 28/9/21 6:59 pm, Mathias Zarick wrote: Hi there, I am wondering how it would be possible to use authentication using a secure external password store aka wallet with PDO OCI. See Oracle external authentication and OCI_CRED_EXT in the underground php oracle manual. and

[PHP-DB] PDO to Oracle db and secure external password store aka wallet for authentication

Hi there, I am wondering how it would be possible to use authentication using a secure external password store aka wallet with PDO OCI. See Oracle external authentication and OCI_CRED_EXT in the underground php oracle manual. and

Re: [PHP-DB] MySQLnd support for ed25519

Hi Ruprecht, yes, if a provider not changed the default authentication (mysql_nativ_password) there is nothing customers have to do, because the default authentication on mysql 5.7 and 10.5 is the same (SHA-1 based). Mysql changed this starting from version 8, were the default authentication

RE: [PHP-DB] MySQLnd support for ed25519

Mysql 8 is already the stable version and has been for a while. I for development use it on windows and its v8 -Original Message- From: Ruprecht Helms Sent: 08 September 2021 16:02 To: php-db@lists.php.net Subject: Re: [PHP-DB] MySQLnd support for ed25519 Hi Dimi, I think mysql 8

Re: [PHP-DB] MySQLnd support for ed25519

Hi Dimi, I think mysql 8 is the new version of mysql. I don't know if there a exists a stable release or only a beta. My thoughts are that the last php-version maybe can handle the mentioned authentication method or you have to try to compile the handling for the mysql-plugin in the

[PHP-DB] MySQLnd support for ed25519

Hi everyone, i just wanted to ask if the authentication with ed25519 algorithm with the MySQLnd is maybe possible in the future? I use mariadb which currently not support either the sha256_password or the caching_sha2_password, therefore i have to use the standard mysql_native_password

Re: [PHP-DB] MySQLnd support for ed25519

Hi Dimi, hi everyone, I don't know about this algorithm. On one running server and on my local linuxbox there is Mysql running. On another server the provider changed from mysql to mariadb. As reason for the change from mysql 5.7 to mariadb 10.5 the provider only told his customers that

[PHP-DB] How to get mysqli to allow SQL-based User-Defined Variables as column aliases?

Hi all, I’m able to get mysqli to set a user-defined variable and the use it later on either in a column value definition or a conditional, I.e. (semi-pseudocode since I’m not in front of my work computer) First do mysqli $conn->query(‘Set @foo = “bar”;’); …which will prepare the database

Re: [PHP-DB] Realtime connection to postgres database

Is this what you are looking for? https://www.postgresql.org/docs/9.6/monitoring-stats.html or maybe this? https://github.com/supabase/realtime Google Foo: real-time connection to postgresql

[PHP-DB] Realtime connection to postgres database

Hi everyone, I have a table (html), that is connected to postgresql database (v9.6). I want that every time there is a change in the database, the table changes immediately. I am talking about a realtime connection between html table and postgres database via php (v7.4). (without having to

Re: [PHP-DB] Realtime connection to postgres database

Sounds like a good cron job candidate. Best, Karl Sent from losPhone > On Oct 25, 2020, at 4:43 PM, Aziz Saleh wrote: > > Another way to do this is to have an ajax call on timeout to an update > endpoint, if there is an update inject that update on the page (or refresh > it). > > Some js

Re: [PHP-DB] Realtime connection to postgres database

Another way to do this is to have an ajax call on timeout to an update endpoint, if there is an update inject that update on the page (or refresh it). Some js examples (both short/long polling): https://stackoverflow.com/questions/42825972/update-html-when-change-is-noticed-in-mysql-database

[PHP-DB] Realtime connection to postgres database

Hi everyone, I made a table in html that reads a table from a postgres database (easy part). The postgres database grows every time an earthquake occurs. What is the best way to keep the table updated automatically, each time a new earthquake is added to the database? (I mean, not having

Re: [PHP-DB] Can connect to Mysql via command line but not via browser

Please try with this answer... https://stackoverflow.com/questions/41178774/connect-database-error-type-2002-permission-denied El jue., 3 sept. 2020 a las 17:23, Tai Larson () escribió: > The are connected to the same network. I’m setting up a development > environment. > > From: Aziz Saleh

RE: [PHP-DB] Can connect to Mysql via command line but not via browser

The are connected to the same network. I’m setting up a development environment. From: Aziz Saleh Sent: Thursday, September 3, 2020 3:09 PM To: Tai Larson Cc: php-db@lists.php.net Subject: Re: [PHP-DB] Can connect to Mysql via command line but not via browser Are both connected to the same

Re: [PHP-DB] Can connect to Mysql via command line but not via browser

Are both connected to the same network? Just asking because I see a local ip for server ip/name. Maybe try with public IP instead see if it helps. On Thu, Sep 3, 2020 at 5:51 PM Tai Larson wrote: > I have a MySQL database server and a separate web sever running Apache. > Both are running Centos

[PHP-DB] Can connect to Mysql via command line but not via browser

I have a MySQL database server and a separate web sever running Apache. Both are running Centos 8. I can connect to my database server from my web server via the command line, but I get permission denied whenever I try to connect to the server via a browser. Here is the code I'm running:

[PHP-DB] MySQLi, MongoDB and MySQL work together

Hi, I have a large application that uses MySQLi and MySQL. We are planning to add few custom plug-in written in MEAN stack with Node.JS and MongoDB. Before integration, is there any precaution we should consider. Also, if data is shared between MongoDB db and MySQLi, should I create an API to

Re: [PHP-DB] Getting PDO-OCI to work in PHP 7

Possibly try a two stage build: - build your main PHP without PDO_OCI - build PDO_OCI as a shared library with a simplified configure command that doesn't have ldap. Then move the resulting PDO_OCI library to your first PHP install and update php.ini. Then test thoroughly. I have had to do

[PHP-DB] Getting PDO-OCI to work in PHP 7

I have made multiple attempts to get PDO-OCI to work in PHP 7. Sometimes it fails to compile at all, other times appears to compile correctly, but I can't connect to any Oracle databases. Thus far, this has kept me stuck on PHP 5.x. The relevant part of my configure statement is: ./configure \

Re: [PHP-DB] PHP mysqli is NOT trapping some errors when calling stored procedure

Yes, I do have all reqd privs. In fact, as long as a duplicate key situation isnt encountered, I am able to invoke the stored proc from PHP alright and the record gets saved in the database. But when I try to re-do it using the same value (thereby I am expecting that 1062-DUPLICATE KEY error

Re: [PHP-DB] PHP mysqli is NOT trapping some errors when calling stored procedure

Do you have sufficient privileges to execute stored procedures (procs_priv) on PHP's end? On Tue, Feb 12, 2019 at 11:07 AM Venkat Hariharan wrote: > Can you take a look at the issue that I've described at > >

[PHP-DB] [SOLVED] Re: Weird error... (after server crash @ISP)

I have not remarked, that > [64] function db_query($query, $link='db_link') { was messed up. It should be: function db_query($link='db_link', $query) { Thanks -- Michelle KonzackMiila ITSystems @ TDnet GNU/Linux Developer 00372-54541400 signature.asc Description: Digital

[PHP-DB] Weird error... (after server crash @ISP)

Hello Guys, I was just informed by a visitor, that a bunch of my websites show PHP/pgsql errors... Of course, they relay all on the same database scripts and now I discovered, that the physical server had an error, my ISP replaced the harddisks and put a backup of the content on it!

Re: [PHP-DB] MySQL connection

That makes complete sense. Thank you Joshua. Best, Karl DeSaulniers Design Drumm http://designdrumm.com > On Mar 5, 2017, at 6:44 PM, Arneson, Joshua wrote: > > If you have multiple calls to the database that are grouped, definitely > perform them during the same

Re: [PHP-DB] MySQL connection

If you have multiple calls to the database that are grouped, definitely perform them during the same connection session. The bottom line is unless the overhead associated with opening and closing the connection is going to be an issue programmatically, keep connections brief and group your

Re: [PHP-DB] MySQL connection

Ah, thanks for the reply Joshua. Duly noted. So when is it bad to make multiple open and close connections then? I am guessing that could have some impact with lots of users too. Yes? If the website in question does not have a lot of users (less than 1,000), is this still a bad call to keep an

Re: [PHP-DB] MySQL connection

Right off the bat, you need to consider concurrency issues. Depending on the size of your user base and level of activity this could become a major issue. In the end, why hold an open connection for 15 minutes just to process 20-30 transactions that take 20-30ms each? Just better (under most

[PHP-DB] MySQL connection

Hello everyone, Long time. Hope all are well. Quick question. How should MySQL connections be treated? Is it ok to leave them open or is it better to close them after transactions? I have a website that uses sessions and was wondering if there was any situations where I should be closing the

Re: [PHP-DB] Re: CHAR field with charset UTF8 and COLLATION UNICODE_CI_AI or UTF8PHP is loading white spaces

On 22/11/16 18:01, Delmar Wichnieski wrote: > 2016-11-22 12:42 GMT-02:00 Lester Caine : > >> > needs help to move >> > the string to a variable that it can check if the UTF8 data is a single >> > character or multiple characters. >> > >> > > I believe it is a single byte, the

Re: [PHP-DB] Re: CHAR field with charset UTF8 and COLLATION UNICODE_CI_AI or UTF8PHP is loading white spaces

2016-11-22 12:42 GMT-02:00 Lester Caine : > needs help to move > the string to a variable that it can check if the UTF8 data is a single > character or multiple characters. > > I believe it is a single byte, the goal is to simulate a boolean field, where I only use S for yes

Re: [PHP-DB] Re: CHAR field with charset UTF8 and COLLATION UNICODE_CI_AI or UTF8PHP is loading white spaces

On 22/11/16 13:56, Delmar Wichnieski wrote: > But VARCHAR fields work correctly. Problem only in CHAR. VARCHAR is trimmed to the number of bytes used ... not the number of 'characters'! CHAR is only designed for single byte characters IN PHP so providing multi byte characters to a CHAR(1) field

Re: [PHP-DB] Re: CHAR field with charset UTF8 and COLLATION UNICODE_CI_AI or UTF8PHP is loading white spaces

But VARCHAR fields work correctly. Problem only in CHAR. And it should not be gambol, because "Each UTF is reversible, thus every UTF supports lossless round tripping: mapping from any Unicode coded character sequence S to a sequence of bytes and back will produce S again." Source

Re: [PHP-DB] Re: CHAR field with charset UTF8 and COLLATION UNICODE_CI_AI or UTF8PHP is loading white spaces

On 22/11/16 12:58, Delmar Wichnieski wrote: > Since there was no answer here on the list, I was feeling alone and afraid > and wondering why no one else has this problem. Delmar I must apologise as I HAD posted a reply, but it did not actually go through ... list in bounce emails mode which I

[PHP-DB] Re: CHAR field with charset UTF8 and COLLATION UNICODE_CI_AI or UTF8PHP is loading white spaces

For 30 days, I avoided opening as a bug, because I researched a lot, I asked in some forums with more than 50 thousand users and I did not find anyone else with this problem, so much so that in the initial post, I asked if it could be a configuration problem, or bug or lack of full UFT8 support

[PHP-DB] Re: CHAR field with charset UTF8 and COLLATION UNICODE_CI_AI or UTF8PHP is loading white spaces

On 22.11.2016 at 12:27, Delmar Wichnieski wrote: > This issue also occurs with folow PHP versions (for any collate - UTF8) > PHP 7.0.12+ > PHP 7.1.0 RC4+ > Firebir 2.5.5 + and Firebird-3.0.1.32609_0_x64 > I have no test with other versions. > > > The driver could map the SQLVARs of SQL_TEXT to

[PHP-DB] RE: [PHP-WIN] Re: CHAR field with charset UTF8 and COLLATION UNICODE_CI_AI or UTF8 PHP is loading white spaces

Hi Delmar, > -Original Message- > From: Delmar Wichnieski [mailto:delmar.del...@gmail.com] > Sent: Tuesday, November 22, 2016 12:27 PM > To: php-wind...@lists.php.net; php-db@lists.php.net > Subject: [PHP-WIN] Re: CHAR field with charset UTF8 and COLLATION > UNICODE_CI_AI or UTF8 PHP is

[PHP-DB] Re: CHAR field with charset UTF8 and COLLATION UNICODE_CI_AI or UTF8 PHP is loading white spaces

This issue also occurs with folow PHP versions (for any collate - UTF8) PHP 7.0.12+ PHP 7.1.0 RC4+ Firebir 2.5.5 + and Firebird-3.0.1.32609_0_x64 I have no test with other versions. The driver could map the SQLVARs of SQL_TEXT to SQL_VARYING and adjust offsets and lengths? Or else it has to do

[PHP-DB] CHAR field with charset UTF8 and COLLATION UNICODE_CI_AI or UTF8 PHP is loading white spaces

Subject: CHAR field with charset UTF8 and COLLATION UNICODE_CI_AI or UTF8 PHP is loading white spaces Example 'S ' instead of 'S' Environment Windows 10 PHP 7.0.12 x64 VC14 TS Apache Lounge 2.4.23 x64 VC14 firebird 2.5.5 configuration php.ini default_charset = "UTF-8" connection to the

[PHP-DB] Re: Re

Something up here... Probably not fixable by me. But this is the second of what appear to be identical messages. On 2016-10-17 23:51, php-db@lists.php.net wrote: > "Re: [PHP-DB] SQL Injection" > JigmeRasku doc >

Re: [PHP-DB] Any method to get primary key matching a given value ?

Hi Ratin, check out this FAQ : https://sqlite.org/faq.html#q7 SQlite has a read-only table that holds the creation query for each table. By doing a text analysis of this query, you can find out which field is declared as primary key. Regards, Bert On 11/10/16 02:12, Ratin wrote: Sorry

Re: [PHP-DB] Any method to get primary key matching a given value ?

You may be correct. Admittedly, I am stabbing in the dark here. I work on MySQL, not SQLite. Just good at key word searches. :) This link seems to be promising. http://www.sqlite.org/c3ref/table_column_metadata.html Sorry I can't help more. Best, Karl DeSaulniers Design Drumm

Re: [PHP-DB] Any method to get primary key matching a given value ?

Hi Karl, Isnt it the same ? I am doing the check if ($result['pk'] == 1), and you are doing if ($result['pk'] !== null). I wanted to make sure I dont get false positives, what if $result['pk'] is set to zero, in your case it will be a match but thats probably not what we want, cuz the pk field

[PHP-DB] Incorporating latest version of sqlite.c and making a sqlite3.so for php

Trying to build the latest released version, how should I go about doing it? Currently I installed the php5-sqlite package on ubuntu 14.04 but its a bit outdated and its not working correctly with the c++ library properly (can't open the DB while c++ app is running even when both parties opened

Re: [PHP-DB] Any method to get primary key matching a given value ?

Hi Ratin, I "think" you can just do this and not have to store the table name. However, I have no way of testing this. You will have to test on your end. while ($result = $query->fetchArray()) { if ($result['pk'] !== null) { $primary_key=$result['pk']; } } Best,

Re: [PHP-DB] Any method to get primary key matching a given value ?

Sorry about my late reply but this was my function - a bit of a hack but works properly on my version of php-sqlite3: function get_primary_key_name($table) { $primary_key=''; $db = new MyDB(); if(!$db) { echo

Re: [PHP-DB] Corn job anomaly

> On Sep 27, 2016, at 2:24 AM, Ford, Mike wrote: > >> -Original Message- >> From: Karl DeSaulniers [mailto:k...@designdrumm.com] >> Sent: 25 September 2016 09:59 >> To: PHP List Database >> Subject: Re: [PHP-DB] Corn job anomaly >> >>

RE: [PHP-DB] Corn job anomaly

> -Original Message- > From: Karl DeSaulniers [mailto:k...@designdrumm.com] > Sent: 25 September 2016 09:59 > To: PHP List Database > Subject: Re: [PHP-DB] Corn job anomaly > > Now I am getting an error with mysql syntax. > > "SELECT otn.*, cf.* FROM ".ORDER_TABLE."

Re: [PHP-DB] Corn job anomaly

Oops. I actually ran it with single and double quotes and got the same error both times. I am using single quotes originally. I think the query is getting the \ (backslash) read literally. I did not add those manually. Best, Karl Sent from losPhone > On Sep 25, 2016, at 9:17 AM, Richard >

Re: [PHP-DB] Corn job anomaly

> Date: Sunday, September 25, 2016 08:37:14 -0400 > From: Aziz Saleh > Subject: Re: [PHP-DB] Corn job anomaly > > On Sun, Sep 25, 2016 at 4:59 AM, Karl DeSaulniers > wrote: > >> > On Sep 23, 2016, at 5:38 AM, Richard wrote: >> > >> > -- Try the

Re: [PHP-DB] Corn job anomaly

On Sun, Sep 25, 2016 at 4:59 AM, Karl DeSaulniers wrote: > > On Sep 23, 2016, at 5:38 AM, Richard innovate.net> wrote: > > > > > > > >> Date: Friday, September 23, 2016 03:28:47 -0500 > >> From: Karl DeSaulniers > >> >

Re: [PHP-DB] Corn job anomaly

> On Sep 23, 2016, at 5:38 AM, Richard > wrote: > > > >> Date: Friday, September 23, 2016 03:28:47 -0500 >> From: Karl DeSaulniers >> >> Ok, so I have run down all the possible things (that I know of) >> that could be keeping

Re: [PHP-DB] Corn job anomaly

> Date: Friday, September 23, 2016 03:28:47 -0500 > From: Karl DeSaulniers > > Ok, so I have run down all the possible things (that I know of) > that could be keeping this from working. I have checked with my > hosting service that: > > 1. MySQL is accessible with the

Re: [PHP-DB] Corn job anomaly

Ok, so I have run down all the possible things (that I know of) that could be keeping this from working. I have checked with my hosting service that: 1. MySQL is accessible with the original user I started with (for this case were using db123456) via ssh. 2. The cron is accessing my php script

Re: [PHP-DB] Corn job anomaly

> On Sep 20, 2016, at 10:09 PM, Peter Beckman wrote: > > I suspect you are taking the pipe or semicolon literally. > > Drop the pipe and semicolon entirely. This should work: > >/usr/bin/php5 -c /home/123456/etc/php.ini -f > /home/123456/data/auto_reminder.php > >

Re: [PHP-DB] Corn job anomaly

I suspect you are taking the pipe or semicolon literally. Drop the pipe and semicolon entirely. This should work: /usr/bin/php5 -c /home/123456/etc/php.ini -f /home/123456/data/auto_reminder.php The "pipe" (|) in unix (and I assume this is unix) means to pipe the output of php5 -c config

Re: [PHP-DB] Corn job anomaly

Hi Richard & Bert, Thanks for the responses. I think I understand what you are both saying. Not sure where my database is housed as I am using a hosting provider (Mediatemple) and they allow limited access to such things or I am unaware how to access them. For my current issue, lets just say

Re: [PHP-DB] Corn job anomaly

On 20/09/16 10:06, Lester Caine wrote: On 20/09/16 06:16, Karl DeSaulniers wrote: Was probably a newb question, however, now it is saying that my database user is not allowed access. I have a mysql connection inside my script that reads the database to get user email addresses to send a

Re: [PHP-DB] Corn job anomaly

Original Message > Date: Tuesday, September 20, 2016 12:54:38 -0500 > From: Karl DeSaulniers > > On Sep 20, 2016, at 7:21 AM, Richard > wrote: >> >> >> >>> Date: Tuesday, September 20, 2016 03:26:39

Re: [PHP-DB] Corn job anomaly

On Sep 20, 2016, at 7:21 AM, Richard wrote: > > > >> Date: Tuesday, September 20, 2016 03:26:39 -0500 >> From: Karl DeSaulniers >> >>> On Sep 20, 2016, at 3:22 AM, Lester Caine >>> wrote: >>> On

Re: [PHP-DB] Corn job anomaly

> Date: Tuesday, September 20, 2016 03:26:39 -0500 > From: Karl DeSaulniers > >> On Sep 20, 2016, at 3:22 AM, Lester Caine >> wrote: >> >> On 20/09/16 09:14, Karl DeSaulniers wrote: >>> Pardon my ignorance, but what do you mean full path? >> Full path

Re: [PHP-DB] Corn job anomaly

On 20/09/16 09:19, Karl DeSaulniers wrote: > The command line I am using is as follows. > > /usr/bin/php5 /home/(directory name removed)/auto_reminder.php Which runs when entered on YOUR command line, but fails in the cron job? Something in auto_reminder.php needs replacing with the 'full' text

Re: [PHP-DB] Corn job anomaly

> On Sep 20, 2016, at 3:22 AM, Lester Caine wrote: > > On 20/09/16 09:14, Karl DeSaulniers wrote: >> Pardon my ignorance, but what do you mean full path? > Full path to php application. > Cron jobs run as 'root' and so need and user account settings added > manually if they

Re: [PHP-DB] Cron job anomaly

> On Sep 20, 2016, at 3:20 AM, Lester Caine wrote: > > On 20/09/16 09:10, Karl DeSaulniers wrote: >> Hi Lester, >> They are listed inside the php file. >> >> The error message I get is: >> >> Access denied for user '(user name removed)'@'%' to database '(database name >>

Re: [PHP-DB] Corn job anomaly

On 20/09/16 09:14, Karl DeSaulniers wrote: > Pardon my ignorance, but what do you mean full path? Full path to php application. Cron jobs run as 'root' and so need and user account settings added manually if they do not match the 'root' environment. -- Lester Caine - G8HFL

Re: [PHP-DB] Cron job anomaly

On 20/09/16 09:10, Karl DeSaulniers wrote: > Hi Lester, > They are listed inside the php file. > > The error message I get is: > > Access denied for user '(user name removed)'@'%' to database '(database name > removed)' > > Thanks for your response. Need a mysql guy to deal with that ;) I

Re: [PHP-DB] Corn job anomaly

> On Sep 20, 2016, at 3:14 AM, Karl DeSaulniers wrote: > >> On Sep 20, 2016, at 3:06 AM, Lester Caine wrote: >> >> On 20/09/16 06:16, Karl DeSaulniers wrote: >>> Was probably a newb question, however, now it is saying that my database >>> user is not

Re: [PHP-DB] Corn job anomaly

> On Sep 20, 2016, at 3:06 AM, Lester Caine wrote: > > On 20/09/16 06:16, Karl DeSaulniers wrote: >> Was probably a newb question, however, now it is saying that my database >> user is not allowed access. >> I have a mysql connection inside my script that reads the database

Re: [PHP-DB] Corn job anomaly

> On Sep 20, 2016, at 3:06 AM, Lester Caine wrote: > > On 20/09/16 06:16, Karl DeSaulniers wrote: >> Was probably a newb question, however, now it is saying that my database >> user is not allowed access. >> I have a mysql connection inside my script that reads the database

Re: [PHP-DB] Corn job anomaly

On 20/09/16 06:16, Karl DeSaulniers wrote: > Was probably a newb question, however, now it is saying that my database user > is not allowed access. > I have a mysql connection inside my script that reads the database to get > user email addresses to send a reminder email to. > > Is there

Re: [PHP-DB] Corn job anomaly

> On Sep 20, 2016, at 12:16 AM, Karl DeSaulniers wrote: > >> On Sep 19, 2016, at 6:14 AM, Richard >> wrote: >> >> >> >>> Date: Monday, September 19, 2016 03:26:54 -0500 >>> From: Karl DeSaulniers >>> >>>

Re: [PHP-DB] MySQL two tables and an uneven number of rows

Thanks Bert, Sorry for late response, but I had to step away from this for a moment to work on other things. Will most likely be back though as things are not working still. Thank you for your responses. Best, Karl DeSaulniers Design Drumm http://designdrumm.com > On Sep 13, 2016, at 2:15

Re: [PHP-DB] Corn job anomaly

> On Sep 19, 2016, at 6:14 AM, Richard > wrote: > > > >> Date: Monday, September 19, 2016 03:26:54 -0500 >> From: Karl DeSaulniers >> >> I am hoping someone can enlighten me on this issue I am having. >> I am trying to set up a

Re: [PHP-DB] Corn job anomaly

> Date: Monday, September 19, 2016 03:26:54 -0500 > From: Karl DeSaulniers > > I am hoping someone can enlighten me on this issue I am having. > I am trying to set up a cron job to run a php file. > I am getting a strange error though. > > /home/(protected

[PHP-DB] ANN: PHP Generator 16.9 released

Hi! SQL Maestro Group announces the release of PHP Generator 16.9, a family of GUI frontends for Windows that allow you to generate feature-rich CRUD web applications for your databases. There are versions for MySQL, MS SQL Server, PostgreSQL, Oracle, SQLite, Firebird, DB2, SQL Anywhere and

[PHP-DB] Corn job anomaly

I am hoping someone can enlighten me on this issue I am having. I am trying to set up a cron job to run a php file. I am getting a strange error though. /home/(protected directory)/auto_reminder.php: line 1: ?php: No such file or directory /home/(protected directory)/auto_reminder.php: line 2:

Re: [PHP-DB] MySQL two tables and an uneven number of rows

On 13/09/16 08:42, Karl DeSaulniers wrote: On Sep 12, 2016, at 2:53 PM, B. Aerts wrote: On 12/09/16 05:24, Karl DeSaulniers wrote: Hello All, Hoping you can help clear my head on this. I have two MySQL tables for custom fields data to be stored. custom_fields

  1   2   3   4   5   6   7   8   9   10   >