Authentication when run by cron

[redbeanbuns]

When I hit my script in a browser, everything goes fine. When cron runs the script, it builds the tweet, and carries out the database stuff, but the tweet never appears. My logs show error code 32 - "could not authenticate you". Here's the code, sorry for the long code entry, I thought I better post the whole thing since I have no idea what could be causing the problem...

<?php
$test = false;
$go_tweet = false;

function tweet($message,$image,$link,$queue_id) {

	// add the codebird library
	require_once('codebird/codebird.php');

	// note: consumerKey, consumerSecret, accessToken, and accessTokenSecret all come from your twitter app at https://apps.twitter.com/
	\Codebird\Codebird::setConsumerKey("xxxxxxxxxxxxxxxxxxxxx", "xxxxxxxxxxxxxxxxxxxxxxxxxxx");
	$cb = \Codebird\Codebird::getInstance();
	$cb->setToken("xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx", "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx");

	//build an array of images to send to twitter
	$reply = $cb->media_upload(array(
		'media' => realpath($image)
	));
	//upload the file to your twitter account
	$mediaID = $reply->media_id_string;

	//build the data needed to send to twitter, including the tweet and the image id
	$params = array(
		'status' => $message,
		'media_ids' => $mediaID
	);
	//post the tweet with codebird
	$reply = $cb->statuses_update($params);
	$log = print_r($reply, true);
	
	$log_query = "INSERT INTO tweet_log (log) VALUES ('".pg_escape_string($log)."')";
	$log_result = pg_exec($link,$log_query);
	
	$u_query = "UPDATE tweet_queue SET sent = 1 WHERE id = ".$queue_id;
	$u_result = pg_exec($link,$u_query);

}

$host = "xx.xx.xx.xx.xx";
$port =  "xxxxxxxxxxxxx";
$DbName = "xxxxxxxxxxxx";
$user = "xxxxxxxxxxxxxxxx";
$password = "xxxxxxxxxxx";
$link = pg_connect("host=".$host." port=".$port." dbname=".$DbName." user=".$user." password=".$password);

//look for a tweet scheduled for NOW
$t_query = "SELECT * FROM tweet_queue WHERE post_time = '".date("Y-m-d H:i").":00' AND sent = 0 LIMIT 1";
$t_result = pg_exec($link,$t_query);
$t_numrows = pg_numrows($t_result);
if($t_numrows>0){
	
	$t_raw = pg_fetch_assoc($t_result);
	$tweet = $t_raw['tweet'];
	$img = $t_raw['img'];
	$queue_id = $t_raw['id'];
	$go_tweet = true;

}else{
	
	//tweet the next tweet in the queue
	$t_query2 = "SELECT * FROM tweet_queue WHERE sent = 0 ORDER BY id ASC LIMIT 1";
	$t_result2 = pg_exec($link,$t_query2);
	$t_numrows2 = pg_numrows($t_result2);
	if($t_numrows2>0){
		
		$t_raw = pg_fetch_assoc($t_result2);
		$tweet = $t_raw['tweet'];
		$img = $t_raw['img'];
		$queue_id = $t_raw['id'];
		$go_tweet = true;
		
	}else{
		
		//nothing to tweet
		$go_tweet = false;
		
	}
	
}

//send the tweet
if($test){
	echo 'will tweet: '.$tweet.'<br>will add image: '.$img;
}else{
	if($go_tweet){
		tweet($tweet,$img,$link,$queue_id);
	}
}
?>

[redbeanbuns]

I've also tried:

require_once(__DIR__ .'/codebird/codebird.php');

[mynetx]

Does the CLI PHP load the same required extensions as the web server one?

[RahulRawat1994]

I am facing the same problem, during media_upload API call, it always sends "could not authenticate" errors.

[mynetx]

@redbeanbuns @RahulRawat1994 You can help us find the problem by posting a self-contained code that will read the image from the same folder and send the media/upload call, and pasting the entire code here (masking your tokens).