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
> 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 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 tai.lar...@weierlaw.com>> wrote:
> 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:
> $servername = "192.168.10.XXX";
> $username = "root";
> $password = "123456789";
> $conn = new mysqli($servername, $username, $password); if
> ($conn->connect_error) {
> die("Connection failed: " . $conn->connect_error); } echo "Connected
> successfully"; ?>
>
> I SSH into my web server and run this command "php TestMySQL.php". I
> receive the output of "Connected successfully".
>
> When I attempt through my browser or curl, I receive the output of
> "Connection failed: Permission denied".
>
> I can also connect to the remote database with the local mysql client.
>
> Thank you all in advance for your help.
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
Re: [PHP-DB] Stuck trying to upload and grab file name
The table ñame need The ñame var not tmp_name tmp_name contains / bar
El miércoles, 25 de julio de 2012, Brad escribió:
> Switching it to -> ALTER TABLE `{$memberID}` ADD {$tmp_name} VARCHAR(60);
> produces the same error.
> For the record $tmp_name is just gibberish and should not be the final
> column name.
>
> Brad
>
> -Original Message-
> From: Karl DeSaulniers [mailto:k...@designdrumm.com ]
> Sent: Wednesday, July 25, 2012 7:18 PM
> To: php-db@lists.php.net
> Subject: Re: [PHP-DB] Re: Stuck trying to upload and grab file name
>
> On Jul 25, 2012, at 6:11 PM, Brad wrote:
>
> > I am only uploading the temporary file. The filename is acquired via
> > -> $file = $_FILES["file"]; and that is what is included in the naming
> > of the column.
> >
> >
> >
> > -Original Message-
> > From: Karl DeSaulniers [mailto:k...@designdrumm.com]
> > Sent: Wednesday, July 25, 2012 7:05 PM
> > To: php-db@lists.php.net
> > Subject: Re: [PHP-DB] Re: Stuck trying to upload and grab file name
> >
> > On Jul 25, 2012, at 5:49 PM, Brad wrote:
> >
> >> I revamped my logic, proved the SQL works in a client the way I want
> >> and once again, I am hitting the same mysql brick wall.
> >>
> >>
> >>
> >> >>
> >> var_dump($_FILES);
> >>
> >> //db connection
> >>
> >> require 'dbConnect.php';
> >>
> >> //session file
> >>
> >> require_once('../auth.php');
> >>
> >> function uploadList(){
> >>
> >> $file = $_FILES["file"];
> >>
> >> $memberID = $_SESSION["SESS_MEMBER_ID"];
> >>
> >> if ($file["type"] == "text/plain")
> >>
> >> {
> >>
> >> if ($file["error"] > 0)
> >>
> >> {
> >>
> >> echo "Return Code: " . $file['error'] . " >>> ";
> >>
> >> }
> >>
> >> else
> >>
> >> {
> >>
> >> dbConnect();
> >>
> >> mysql_select_db('mailList') or
> >> die(mysql_error());
> >>
> >> $tmp_name = $file["tmp_name"];
> >>
> >> $presql = "CREATE TABLE IF NOT EXISTS
> >> `{$memberID}` (id MEDIUMINT AUTO_INCREMENT PRIMARY KEY UNIQUE)";
> >>
> >> $sql = << >>
> >> LOAD DATA LOCAL INFILE '{$tmp_name}'
> >>
> >> ALTER TABLE `{$memberID}` ADD {$file}
> >> VARCHAR(60);
> >>
> >> FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY
> >> '\\''
> >>
> >> LINES TERMINATED BY "\\r\\n"
> >>
> >> IGNORE 1 LINES
> >>
> >> EOF;
> >>
> >> mysql_query($presql);
> >>
> >> mysql_query($sql);
> >>
> >> //var_dump($sql);
> >>
> >> echo '$sql';
> >>
> >> if(mysql_error())
> >>
> >> {
> >>
> >>
Re: [PHP-DB] Stuck trying to upload and grab file name
Use
$_FILES["file"]["tmp_name"]
El martes, 24 de julio de 2012, Brad escribió:
>
> var_dump($_FILES);
>
> //db connection
>
> require 'dbConnect.php';
>
> //session file
>
> require_once('../auth.php');
>
> function uploadList(){
>
> //var_dump($_FILES['file']);
>
> if ($_FILES["file"]["type"] == "text/plain")
>
> {
>
> if ($_FILES["file"]["error"] > 0)
>
> {
>
> echo "Return Code: " . $_FILES['file']['error'] .
> "";
>
> }
>
> else
>
> {
>
> dbConnect();
>
> mysql_select_db('mailList') or die(mysql_error());
>
>
> //$file=''
>
> $file = $_FILES['tmp_name'];
>
> //$presql = "CREATE TABLE IF NOT EXISTS
> (`$_SESSION[SESS_MEMBER_ID]_$file`)";
>
> $presql = "CREATE TABLE IF NOT EXISTS
> `$_SESSION[SESS_MEMBER_ID]_$file`";
>
> $sql = <<
> LOAD DATA LOCAL INFILE '{$_FILES['tmp_name']}'
>
> INTO TABLE `$_SESSION[SESS_MEMBER_ID]_$file`
>
> FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY
> '\\'
>
> LINES TERMINATED BY "\\r\\n"
>
> IGNORE 1 LINES
>
> EOF;
>
> mysql_query($presql);
>
> mysql_query($sql);
>
> //var_dump($sql);
>
> echo '$sql';
>
> if(mysql_error())
>
> {
>
> echo(mysql_error());
>
> }
>
> else
>
> {
>
> print('Import of campaign emails
> sucessfull into mysql table.');
>
> }
>
> }
>
> }
>
> else
>
> {
>
> print('Invalid file type. Please make sure it is a text
> file.');
>
> }
>
> }
>
> ** **
>
> //var_dump($_FILES);
>
> uploadList();
>
> ?>
>
> ** **
>
> ** **
>
> array(1) { ["file"]=> array(5) { ["name"]=> string(14) "emailsTest.txt"
> ["type"]=> string(10) "text/plain" ["tmp_name"]=> string(14)
> "/tmp/phpq8pi44" ["error"]=> int(0) ["size"]=> int(61) } }
> *Notice*: Undefined index: tmp_name in */home/
> nyctelecomm.com/www/mail/import.php* on line *20*
>
> *Notice*: Undefined index: tmp_name in */home/
> nyctelecomm.com/www/mail/import.php* on line *24*
> $sqlYou have an error in your SQL syntax; check the manual that
> corresponds to your MySQL server version for the right syntax to use near
> ''\' LINES TERMINATED BY "\r\n" IGNORE 1 LINES' at line 3
>
> ** **
>
> *From:* Roberto Carlos Garcia Luis
> [mailto:legnakar...@gmail.com 'legnakar...@gmail.com');>]
>
> *Sent:* Tuesday, July 24, 2012 5:12 AM
> *To:* Brad
> *Cc:* php-db@lists.php.net 'php-db@lists.php.net');>
> *Subject:* Re: [PHP-DB] Stuck trying to upload and grab file name
>
> ** **
>
> In the
> LOAD DATA LOCAL INFILE '{$_FILES['file']['name']}'
>
> You need use The tmp_name to load The file contents.
>
> And The SQL var result as a string diferent of The SQL that you insert in
> console
>
> ** **
>
>
> El martes, 24 de julio de 2012, Brad escribió:
>
> The tmp_file is just gibberish. I ‘truly’ do not want that as the table
> name.
>
>
>
>
>
>
>
>
>
> *From:* Roberto Carlos Garcia Luis [mailto:legnakar...@gmail.com]
> *Sent:* Tuesday, July 24, 2012 4:26 AM
> *To:* Brad
> *Cc:* php-db@lists.php.net
> *Subject:* Re: [PHP-DB] Stuck trying to upload and grab file name
>
>
>
> You need to use t
Re: [PHP-DB] Stuck trying to upload and grab file name
In the
LOAD DATA LOCAL INFILE '{$_FILES['file']['name']}'
You need use The tmp_name to load The file contents.
And The SQL var result as a string diferent of The SQL that you insert in
console
El martes, 24 de julio de 2012, Brad escribió:
> The tmp_file is just gibberish. I ‘truly’ do not want that as the table
> name.
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> *From:* Roberto Carlos Garcia Luis
> [mailto:legnakar...@gmail.com 'legnakar...@gmail.com');>]
>
> *Sent:* Tuesday, July 24, 2012 4:26 AM
> *To:* Brad
> *Cc:* php-db@lists.php.net 'php-db@lists.php.net');>
> *Subject:* Re: [PHP-DB] Stuck trying to upload and grab file name
>
> ** **
>
> You need to use te tmp_name ... The plain text file is in path indicated
> by The string...
>
> ** **
>
> Regards,
>
>
> El martes, 24 de julio de 2012, Brad escribió:
>
> I am making a function that uploads a txt file in csv format and the grabs
> uploaded file name and the memberID from the sessions login and names the
> new table memberID_filename.
>
> The program error on line 24 @ 'name'.
>
>
>
> I have tried '{$_FILES[file][name]}' '{$_FILES[file]['name']}'
> '{$_FILES['file']['name']}' {$_FILES[file][name]}
> {$_FILES['file']['name']}
> $_FILES[file][name]$_FILES[file]['name'] $_FILES['file']['name']
> '$_FILES[file][name]' '$_FILES['file']['name']' and '$_FILES[0]['name']'
>
>
>
> code*
>
>
>
>
> var_dump($_FILES);
>
> //db connection
>
> require 'dbConnect.php';
>
> //session file
>
> require_once('../auth.php');
>
> function uploadList(){
>
> //var_dump($_FILES);
>
> if ($_FILES["file"]["type"] == "text/plain")
>
> {
>
> if ($_FILES["file"]["error"] > 0)
>
> {
>
> echo "Return Code: " . $_FILES['file']['error'] .
> "";
>
> }
>
> else
>
> {
>
> dbConnect();
>
> mysql_select_db('mailList') or die(mysql_error());
>
> //$file=''
>
> $file = $_FILES['file']['name'];
>
> //$presql = "CREATE TABLE IF NOT EXISTS
> (`$_SESSION[SESS_MEMBER_ID]_$file`)";
>
> $presql = "CREATE TABLE IF NOT EXISTS
> `$_SESSION[SESS_MEMBER_ID]_$file`";
>
> $sql = <<
> LOAD DATA LOCAL INFILE '{$_FILES['file']['name']}'
>
> INTO TABLE `$_SESSION[SESS_MEMBER_ID]_$file`
>
> FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY
> '\\'
>
> LINES TERMINATED BY "\\r\\n"
>
> IGNORE 1 LINES
>
> EOF;
>
> mysql_query($presql);
>
> mysql_query($sql);
>
> var_dump($sql);
>
> echo '$sql';
>
> if(mysql_error())
>
> {
>
> echo(mysql_error());
>
> }
>
> else
>
> {
>
> print('Import of campaign emails sucessfull
> into mysql table.');
>
> }
>
> }
>
> }
>
> else
>
> {
>
> print('Invalid file type. Please make sure it is a text
> file.');
>
> }
>
> }
>
>
>
> //var_dump($_FILES);
>
> uploadList();
>
> ?>
>
>
>
>
>
>
>
>
>
> **error*
>
>
>
>
>
>
>
> array(1) { ["file"]=> array(5) { ["name"]=> string(14) "emailsTest.txt"
> ["type"]=> string(10) "text/plain" ["tmp_name"]=> string(14)
> "/tmp/phpmycbhK" ["error"]=> int(0) ["size"]=> int(61) } } $sqlYou have an
> error in your SQL syntax; check the manual that corresponds to your MySQL
> server version for the right syntax to use near ''\' LINES TERMINATED BY
> "\r\n" IGNORE 1 LINES' at line 3
>
>
>
>
>
>
>
> SQL query works when removed from the php
>
>
>
> mysql> LOAD DATA LOCAL INFILE '/home/
> nyctelecomm.com/www/mail/emailtist.txt'
>
> -> INTO TABLE `mailTest`
>
> -> FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\\'
>
> -> LINES TERMINATED BY "\\r\\n"
>
> -> IGNORE 1 LINES;
>
> Query OK, 0 rows affected (0.00 sec)
>
> Records: 0 Deleted: 0 Skipped: 0 Warnings: 0
>
>
>
> ***show create*
>
>
>
> mysql> SHOW CREA
>
Re: [PHP-DB] Stuck trying to upload and grab file name
Pelase, print The SQL var and show here The result.
El martes, 24 de julio de 2012, Roberto Carlos Garcia Luis escribió:
> You need to use te tmp_name ... The plain text file is in path indicated
> by The string...
>
> Regards,
>
> El martes, 24 de julio de 2012, Brad escribió:
>
> I am making a function that uploads a txt file in csv format and the grabs
> uploaded file name and the memberID from the sessions login and names the
> new table memberID_filename.
>
> The program error on line 24 @ 'name'.
>
>
>
> I have tried '{$_FILES[file][name]}' '{$_FILES[file]['name']}'
> '{$_FILES['file']['name']}' {$_FILES[file][name]}
> {$_FILES['file']['name']}
> $_FILES[file][name]$_FILES[file]['name'] $_FILES['file']['name']
> '$_FILES[file][name]' '$_FILES['file']['name']' and '$_FILES[0]['name']'
>
>
>
> code*
>
>
>
>
> var_dump($_FILES);
>
> //db connection
>
> require 'dbConnect.php';
>
> //session file
>
> require_once('../auth.php');
>
> function uploadList(){
>
> //var_dump($_FILES);
>
> if ($_FILES["file"]["type"] == "text/plain")
>
> {
>
> if ($_FILES["file"]["error"] > 0)
>
> {
>
> echo "Return Code: " . $_FILES['file']['error'] .
> "";
>
> }
>
> else
>
> {
>
> dbConnect();
>
> mysql_select_db('mailList') or die(mysql_error());
>
> //$file=''
>
> $file = $_FILES['file']['name'];
>
> //$presql = "CREATE TABLE IF NOT EXISTS
> (`$_SESSION[SESS_MEMBER_ID]_$file`)";
>
> $presql = "CREATE TABLE IF NOT EXISTS
> `$_SESSION[SESS_MEMBER_ID]_$file`";
>
> $sql = <<
> LOAD DATA LOCAL INFILE '{$_FILES['file']['name']}'
>
> INTO TABLE `$_SESSION[SESS_MEMBER_ID]_$file`
>
> FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY
> '\\'
>
> LINES TERMINATED BY "\\r\\n"
>
> IGNORE 1 LINES
>
> EOF;
>
> mysql_query($presql);
>
> mysql_query($sql);
>
> var_dump($sql);
>
> echo '$sql';
>
> if(mysql_error())
>
> {
>
> echo(mysql_error());
>
> }
>
> else
>
> {
>
> print('Import of campaign emails sucessfull
> into mysql table.');
>
> }
>
> }
>
> }
>
> else
>
> {
>
> print('Invalid file type. Please make sure it is a text
> file.');
>
> }
>
> }
>
>
>
> //var_dump($_FILES);
>
> uploadList();
>
> ?>
>
>
>
>
>
>
>
>
>
> **error*
>
>
>
>
>
>
>
> array(1) { ["file"]=> array(5) { ["name"]=> string(14) "emailsTest.txt"
> ["type"]=> string(10) "text/plain" ["tmp_name"]=> string(14)
> "/tmp/phpmycbhK" ["error"]=> int(0) ["size"]=> int(61) } } $sqlYou have an
> error in your SQL syntax; check the manual that corresponds to your MySQL
> server version for the right syntax to use near ''\' LINES TERMINATED BY
> "\r\n" IGNORE 1 LINES' at line 3
>
>
>
>
>
>
>
> SQL query works when removed from the php
>
>
>
> mysql> LOAD DATA LOCAL INFILE '/home/
> nyctelecomm.com/www/mail/emailtist.txt'
>
> -> INTO TABLE `mailTest`
>
> -> FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\\'
>
> -> LINES TERMINATED BY "\\r\\n"
>
> -> IGNORE 1 LINES;
>
> Query OK, 0 rows affected (0.00 sec)
>
> Records: 0 Deleted: 0 Skipped: 0 Warnings: 0
>
>
>
> ***show create*
>
>
>
> mysql> SHOW CREATE TABLE mailTest\G
>
> *** 1. row ***
>
>Table: mailTest
>
> Cre
>
>
Re: [PHP-DB] Stuck trying to upload and grab file name
You need to use te tmp_name ... The plain text file is in path indicated by
The string...
Regards,
El martes, 24 de julio de 2012, Brad escribió:
> I am making a function that uploads a txt file in csv format and the grabs
> uploaded file name and the memberID from the sessions login and names the
> new table memberID_filename.
>
> The program error on line 24 @ 'name'.
>
>
>
> I have tried '{$_FILES[file][name]}' '{$_FILES[file]['name']}'
> '{$_FILES['file']['name']}' {$_FILES[file][name]}
> {$_FILES['file']['name']}
> $_FILES[file][name]$_FILES[file]['name'] $_FILES['file']['name']
> '$_FILES[file][name]' '$_FILES['file']['name']' and '$_FILES[0]['name']'
>
>
>
> code*
>
>
>
>
> var_dump($_FILES);
>
> //db connection
>
> require 'dbConnect.php';
>
> //session file
>
> require_once('../auth.php');
>
> function uploadList(){
>
> //var_dump($_FILES);
>
> if ($_FILES["file"]["type"] == "text/plain")
>
> {
>
> if ($_FILES["file"]["error"] > 0)
>
> {
>
> echo "Return Code: " . $_FILES['file']['error'] .
> "";
>
> }
>
> else
>
> {
>
> dbConnect();
>
> mysql_select_db('mailList') or die(mysql_error());
>
> //$file=''
>
> $file = $_FILES['file']['name'];
>
> //$presql = "CREATE TABLE IF NOT EXISTS
> (`$_SESSION[SESS_MEMBER_ID]_$file`)";
>
> $presql = "CREATE TABLE IF NOT EXISTS
> `$_SESSION[SESS_MEMBER_ID]_$file`";
>
> $sql = <<
> LOAD DATA LOCAL INFILE '{$_FILES['file']['name']}'
>
> INTO TABLE `$_SESSION[SESS_MEMBER_ID]_$file`
>
> FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY
> '\\'
>
> LINES TERMINATED BY "\\r\\n"
>
> IGNORE 1 LINES
>
> EOF;
>
> mysql_query($presql);
>
> mysql_query($sql);
>
> var_dump($sql);
>
> echo '$sql';
>
> if(mysql_error())
>
> {
>
> echo(mysql_error());
>
> }
>
> else
>
> {
>
> print('Import of campaign emails sucessfull
> into mysql table.');
>
> }
>
> }
>
> }
>
> else
>
> {
>
> print('Invalid file type. Please make sure it is a text
> file.');
>
> }
>
> }
>
>
>
> //var_dump($_FILES);
>
> uploadList();
>
> ?>
>
>
>
>
>
>
>
>
>
> **error*
>
>
>
>
>
>
>
> array(1) { ["file"]=> array(5) { ["name"]=> string(14) "emailsTest.txt"
> ["type"]=> string(10) "text/plain" ["tmp_name"]=> string(14)
> "/tmp/phpmycbhK" ["error"]=> int(0) ["size"]=> int(61) } } $sqlYou have an
> error in your SQL syntax; check the manual that corresponds to your MySQL
> server version for the right syntax to use near ''\' LINES TERMINATED BY
> "\r\n" IGNORE 1 LINES' at line 3
>
>
>
>
>
>
>
> SQL query works when removed from the php
>
>
>
> mysql> LOAD DATA LOCAL INFILE '/home/
> nyctelecomm.com/www/mail/emailtist.txt'
>
> -> INTO TABLE `mailTest`
>
> -> FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\\'
>
> -> LINES TERMINATED BY "\\r\\n"
>
> -> IGNORE 1 LINES;
>
> Query OK, 0 rows affected (0.00 sec)
>
> Records: 0 Deleted: 0 Skipped: 0 Warnings: 0
>
>
>
> ***show create*
>
>
>
> mysql> SHOW CREATE TABLE mailTest\G
>
> *** 1. row ***
>
>Table: mailTest
>
> Create Table: CREATE TABLE `mailTest` (
>
> `temp` tinyint(4) DEFAULT NULL
>
> ) ENGINE=MyISAM DEFAULT CHARSET=utf8
>
> 1 row in set (0.00 sec)
>
>
>
>
>
> *sample data*
>
>
>
>
>
> k2jthep...@hotmail.com
>
> annama...@gmail.com
>
> ken_cas...@yahoo.com
>
> jmakse...@gmail.com
>
> janegre...@hotmail.com
>
> mitcha...@yahoo.com
>
> klj...@hotmail.com
>
>
>
> var_dump($_FILES["file"]) at line 8
>
>
>
> array(1) { ["file"]=> array(5) { ["name"]=> string(14) "emailsTest.txt"
> ["type"]=> string(10) "text/plain" ["tmp_name"]=> string(14)
> "/tmp/php98AolN" ["error"]=> int(0) ["size"]=> int(61) } } array(5) {
> ["name"]=> string(14) "emailsTest.txt" ["type"]=> string(10) "text/plain"
> ["tmp_name"]=> string(14) "/tmp/php98AolN" ["error"]=> int(0) ["size"]=>
> int(61) }
>
>
>
>
>
>
