תחומים - פורום חרדי מקצועי

@ivrtikshoret עשיתי הפעלה מחדש לשרת, ונשאר אותו דבר
לא משנה אם אני מפעיל מחדש מהטרמינל או מלוח הבקרה של השרת, נכון?

@ivrtikshoret כתב בבעיה בשימוש עם הספריה Random ב PHP:

אתה משתמש עם apache?
א"כ אז sudo service apache2 restart

לא
עם nginx

@ivrtikshoret כתב בבעיה בשימוש עם הספריה Random ב PHP:

תנסה ככה:

apt remove php8.1*

זה מה שקיבלתי

Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
Note, selecting 'php8.1-enchant' for glob 'php8.1*'
Note, selecting 'php8.1-grpc' for glob 'php8.1*'
Note, selecting 'php8.1-simplexml' for glob 'php8.1*'
Note, selecting 'php8.1-mysqlnd' for glob 'php8.1*'
Note, selecting 'php8.1-pspell' for glob 'php8.1*'
Note, selecting 'php8.1-raphf' for glob 'php8.1*'
Note, selecting 'php8.1-protobuf' for glob 'php8.1*'
Note, selecting 'php8.1-interbase' for glob 'php8.1*'
Note, selecting 'php8.1-bcmath' for glob 'php8.1*'
Note, selecting 'php8.1-ctype' for glob 'php8.1*'
Note, selecting 'php8.1-pgsql' for glob 'php8.1*'
Note, selecting 'php8.1-gnupg' for glob 'php8.1*'
Note, selecting 'php8.1-iconv' for glob 'php8.1*'
Note, selecting 'php8.1-sass' for glob 'php8.1*'
Note, selecting 'php8.1-msgpack' for glob 'php8.1*'
Note, selecting 'php8.1-gmagick' for glob 'php8.1*'
Note, selecting 'php8.1-pdo-mysql' for glob 'php8.1*'
Note, selecting 'php8.1-xhprof' for glob 'php8.1*'
Note, selecting 'php8.1-inotify' for glob 'php8.1*'
Note, selecting 'php8.1-swoole' for glob 'php8.1*'
Note, selecting 'php8.1-snmp' for glob 'php8.1*'
Note, selecting 'php8.1-soap' for glob 'php8.1*'
Note, selecting 'php8.1-solr' for glob 'php8.1*'
Note, selecting 'php8.1-pdo-sqlite' for glob 'php8.1*'
Note, selecting 'php8.1-http' for glob 'php8.1*'
Note, selecting 'php8.1-yaml' for glob 'php8.1*'
Note, selecting 'php8.1-ssh2' for glob 'php8.1*'
Note, selecting 'php8.1-decimal' for glob 'php8.1*'
Note, selecting 'php8.1-opcache' for glob 'php8.1*'
Note, selecting 'php8.1-smbclient' for glob 'php8.1*'
Note, selecting 'php8.1-imagick' for glob 'php8.1*'
Note, selecting 'php8.1-mysql' for glob 'php8.1*'
Note, selecting 'php8.1-mailparse' for glob 'php8.1*'
Note, selecting 'php8.1-curl' for glob 'php8.1*'
Note, selecting 'php8.1' for glob 'php8.1*'
Note, selecting 'php8.1-shmop' for glob 'php8.1*'
Note, selecting 'php8.1-tidy' for glob 'php8.1*'
Note, selecting 'php8.1-libvirt-php' for glob 'php8.1*'
Note, selecting 'php8.1-imap' for glob 'php8.1*'
Note, selecting 'php8.1-intl' for glob 'php8.1*'
Note, selecting 'php8.1-calendar' for glob 'php8.1*'
Note, selecting 'php8.1-odbc' for glob 'php8.1*'
Note, selecting 'php8.1-pinba' for glob 'php8.1*'
Note, selecting 'php8.1-mysqli' for glob 'php8.1*'
Note, selecting 'php8.1-memcache' for glob 'php8.1*'
Note, selecting 'php8.1-mbstring' for glob 'php8.1*'
Note, selecting 'php8.1-zstd' for glob 'php8.1*'
Note, selecting 'php8.1-memcached' for glob 'php8.1*'
Note, selecting 'php8.1-facedetect' for glob 'php8.1*'
Note, selecting 'php8.1-stomp' for glob 'php8.1*'
Note, selecting 'php8.1-fileinfo' for glob 'php8.1*'
Note, selecting 'php8.1-phalcon5' for glob 'php8.1*'
Note, selecting 'php8.1-posix' for glob 'php8.1*'
Note, selecting 'php8.1-uopz' for glob 'php8.1*'
Note, selecting 'php8.1-common' for glob 'php8.1*'
Note, selecting 'php8.1-xmlrpc' for glob 'php8.1*'
Note, selecting 'php8.1-json' for glob 'php8.1*'
Note, selecting 'php8.1-pcov' for glob 'php8.1*'
Note, selecting 'php8.1-mongodb' for glob 'php8.1*'
Note, selecting 'php8.1-readline' for glob 'php8.1*'
Note, selecting 'php8.1-uuid' for glob 'php8.1*'
Note, selecting 'php8.1-phar' for glob 'php8.1*'
Note, selecting 'php8.1-pdo-dblib' for glob 'php8.1*'
Note, selecting 'php8.1-sockets' for glob 'php8.1*'
Note, selecting 'php8.1-ds' for glob 'php8.1*'
Note, selecting 'php8.1-gd' for glob 'php8.1*'
Note, selecting 'php8.1-ps' for glob 'php8.1*'
Note, selecting 'php8.1-igbinary' for glob 'php8.1*'
Note, selecting 'php8.1-uploadprogress' for glob 'php8.1*'
Note, selecting 'php8.1-mcrypt' for glob 'php8.1*'
Note, selecting 'php8.1-xmlreader' for glob 'php8.1*'
Note, selecting 'php8.1-phpdbg' for glob 'php8.1*'
Note, selecting 'php8.1-exif' for glob 'php8.1*'
Note, selecting 'php8.1-gettext' for glob 'php8.1*'
Note, selecting 'php8.1-redis' for glob 'php8.1*'
Note, selecting 'php8.1-sqlite3' for glob 'php8.1*'
Note, selecting 'php8.1-vips' for glob 'php8.1*'
Note, selecting 'php8.1-excimer' for glob 'php8.1*'
Note, selecting 'php8.1-gearman' for glob 'php8.1*'
Note, selecting 'php8.1-sybase' for glob 'php8.1*'
Note, selecting 'php8.1-pdo-odbc' for glob 'php8.1*'
Note, selecting 'php8.1-ast' for glob 'php8.1*'
Note, selecting 'php8.1-bz2' for glob 'php8.1*'
Note, selecting 'php8.1-cgi' for glob 'php8.1*'
Note, selecting 'php8.1-cli' for glob 'php8.1*'
Note, selecting 'php8.1-dba' for glob 'php8.1*'
Note, selecting 'php8.1-dev' for glob 'php8.1*'
Note, selecting 'php8.1-dom' for glob 'php8.1*'
Note, selecting 'php8.1-ffi' for glob 'php8.1*'
Note, selecting 'php8.1-fpm' for glob 'php8.1*'
Note, selecting 'php8.1-ftp' for glob 'php8.1*'
Note, selecting 'php8.1-ldap' for glob 'php8.1*'
Note, selecting 'php8.1-gmp' for glob 'php8.1*'
Note, selecting 'php8.1-sysvmsg' for glob 'php8.1*'
Note, selecting 'php8.1-xmlwriter' for glob 'php8.1*'
Note, selecting 'php8.1-lz4' for glob 'php8.1*'
Note, selecting 'php8.1-propro' for glob 'php8.1*'
Note, selecting 'php8.1-amqp' for glob 'php8.1*'
Note, selecting 'php8.1-pdo' for glob 'php8.1*'
Note, selecting 'php8.1-psr' for glob 'php8.1*'
Note, selecting 'php8.1-sysvsem' for glob 'php8.1*'
Note, selecting 'php8.1-sysvshm' for glob 'php8.1*'
Note, selecting 'php8.1-tideways' for glob 'php8.1*'
Note, selecting 'php8.1-apcu' for glob 'php8.1*'
Note, selecting 'php8.1-rrd' for glob 'php8.1*'
Note, selecting 'php8.1-xdebug' for glob 'php8.1*'
Note, selecting 'php8.1-rdkafka' for glob 'php8.1*'
Note, selecting 'php8.1-pdo-pgsql' for glob 'php8.1*'
Note, selecting 'php8.1-xml' for glob 'php8.1*'
Note, selecting 'php8.1-xsl' for glob 'php8.1*'
Note, selecting 'php8.1-yac' for glob 'php8.1*'
Note, selecting 'php8.1-zip' for glob 'php8.1*'
Note, selecting 'php8.1-zmq' for glob 'php8.1*'
Note, selecting 'php8.1-tokenizer' for glob 'php8.1*'
Note, selecting 'php8.1-pdo-firebird' for glob 'php8.1*'
Note, selecting 'php8.1-oauth' for glob 'php8.1*'
Note, selecting 'php8.1-maxminddb' for glob 'php8.1*'
Note, selecting 'php8.1-common' instead of 'php8.1-calendar'
Note, selecting 'php8.1-common' instead of 'php8.1-ctype'
Note, selecting 'php8.1-common' instead of 'php8.1-exif'
Note, selecting 'php8.1-common' instead of 'php8.1-ffi'
Note, selecting 'php8.1-common' instead of 'php8.1-fileinfo'
Note, selecting 'php8.1-common' instead of 'php8.1-ftp'
Note, selecting 'php8.1-common' instead of 'php8.1-gettext'
Note, selecting 'php8.1-common' instead of 'php8.1-iconv'
Note, selecting 'php8.1-common' instead of 'php8.1-pdo'
Note, selecting 'php8.1-common' instead of 'php8.1-phar'
Note, selecting 'php8.1-common' instead of 'php8.1-posix'
Note, selecting 'php8.1-common' instead of 'php8.1-shmop'
Note, selecting 'php8.1-common' instead of 'php8.1-sockets'
Note, selecting 'php8.1-common' instead of 'php8.1-sysvmsg'
Note, selecting 'php8.1-common' instead of 'php8.1-sysvsem'
Note, selecting 'php8.1-common' instead of 'php8.1-sysvshm'
Note, selecting 'php8.1-common' instead of 'php8.1-tokenizer'
Note, selecting 'php8.1-mysql' instead of 'php8.1-mysqli'
Note, selecting 'php8.1-mysql' instead of 'php8.1-mysqlnd'
Note, selecting 'php8.1-mysql' instead of 'php8.1-pdo-mysql'
Note, selecting 'php8.1-odbc' instead of 'php8.1-pdo-odbc'
Note, selecting 'php8.1-pgsql' instead of 'php8.1-pdo-pgsql'
Note, selecting 'php8.1-sqlite3' instead of 'php8.1-pdo-sqlite'
Note, selecting 'php8.1-xml' instead of 'php8.1-dom'
Note, selecting 'php8.1-xml' instead of 'php8.1-simplexml'
Note, selecting 'php8.1-xml' instead of 'php8.1-xmlreader'
Note, selecting 'php8.1-xml' instead of 'php8.1-xmlwriter'
Note, selecting 'php-sass' instead of 'php8.1-sass'
Note, selecting 'php8.1-interbase' instead of 'php8.1-pdo-firebird'
Note, selecting 'php8.1-sybase' instead of 'php8.1-pdo-dblib'
Package 'php8.1' is not installed, so not removed
Package 'php8.1-amqp' is not installed, so not removed
Package 'php8.1-apcu' is not installed, so not removed
Package 'php8.1-ast' is not installed, so not removed
Package 'php8.1-bcmath' is not installed, so not removed
Package 'php8.1-bz2' is not installed, so not removed
Package 'php8.1-cgi' is not installed, so not removed
Package 'php8.1-dba' is not installed, so not removed
Package 'php8.1-decimal' is not installed, so not removed
Package 'php8.1-dev' is not installed, so not removed
Package 'php8.1-ds' is not installed, so not removed
Package 'php8.1-enchant' is not installed, so not removed
Package 'php8.1-excimer' is not installed, so not removed
Package 'php8.1-facedetect' is not installed, so not removed
Package 'php8.1-gearman' is not installed, so not removed
Package 'php8.1-gmagick' is not installed, so not removed
Package 'php8.1-gmp' is not installed, so not removed
Package 'php8.1-gnupg' is not installed, so not removed
Package 'php8.1-grpc' is not installed, so not removed
Package 'php8.1-http' is not installed, so not removed
Package 'php8.1-igbinary' is not installed, so not removed
Package 'php8.1-imagick' is not installed, so not removed
Package 'php8.1-imap' is not installed, so not removed
Package 'php8.1-inotify' is not installed, so not removed
Package 'php8.1-interbase' is not installed, so not removed
Package 'php8.1-ldap' is not installed, so not removed
Package 'php8.1-libvirt-php' is not installed, so not removed
Package 'php8.1-lz4' is not installed, so not removed
Package 'php8.1-mailparse' is not installed, so not removed
Package 'php8.1-maxminddb' is not installed, so not removed
Package 'php8.1-mcrypt' is not installed, so not removed
Package 'php8.1-memcache' is not installed, so not removed
Package 'php8.1-memcached' is not installed, so not removed
Package 'php8.1-mongodb' is not installed, so not removed
Package 'php8.1-msgpack' is not installed, so not removed
Package 'php8.1-oauth' is not installed, so not removed
Package 'php8.1-odbc' is not installed, so not removed
Package 'php8.1-pcov' is not installed, so not removed
Package 'php8.1-pgsql' is not installed, so not removed
Package 'php8.1-phalcon5' is not installed, so not removed
Package 'php8.1-phpdbg' is not installed, so not removed
Package 'php8.1-pinba' is not installed, so not removed
Package 'php8.1-propro' is not installed, so not removed
Package 'php8.1-protobuf' is not installed, so not removed
Package 'php8.1-ps' is not installed, so not removed
Package 'php8.1-pspell' is not installed, so not removed
Package 'php8.1-psr' is not installed, so not removed
Package 'php8.1-raphf' is not installed, so not removed
Package 'php8.1-rdkafka' is not installed, so not removed
Package 'php8.1-redis' is not installed, so not removed
Package 'php8.1-rrd' is not installed, so not removed
Package 'php8.1-smbclient' is not installed, so not removed
Package 'php8.1-snmp' is not installed, so not removed
Package 'php8.1-soap' is not installed, so not removed
Package 'php8.1-solr' is not installed, so not removed
Package 'php8.1-sqlite3' is not installed, so not removed
Package 'php8.1-ssh2' is not installed, so not removed
Package 'php8.1-stomp' is not installed, so not removed
Package 'php8.1-swoole' is not installed, so not removed
Package 'php8.1-sybase' is not installed, so not removed
Package 'php8.1-tideways' is not installed, so not removed
Package 'php8.1-tidy' is not installed, so not removed
Package 'php8.1-uopz' is not installed, so not removed
Package 'php8.1-uploadprogress' is not installed, so not removed
Package 'php8.1-uuid' is not installed, so not removed
Package 'php8.1-vips' is not installed, so not removed
Package 'php8.1-xdebug' is not installed, so not removed
Package 'php8.1-xhprof' is not installed, so not removed
Package 'php8.1-xmlrpc' is not installed, so not removed
Package 'php8.1-xsl' is not installed, so not removed
Package 'php8.1-yac' is not installed, so not removed
Package 'php8.1-yaml' is not installed, so not removed
Package 'php8.1-zip' is not installed, so not removed
Package 'php8.1-zmq' is not installed, so not removed
Package 'php8.1-zstd' is not installed, so not removed
The following packages were automatically installed and are no longer required:
  jsonlint libonig5 libsnappy1v5 linux-headers-5.15.0-25 linux-headers-5.15.0-25-generic linux-image-5.15.0-25-generic
  linux-image-5.4.0-105-generic linux-modules-5.15.0-25-generic linux-modules-5.4.0-105-generic
  linux-modules-extra-5.15.0-25-generic php-composer-ca-bundle php-composer-metadata-minifier php-composer-pcre
  php-composer-semver php-composer-spdx-licenses php-composer-xdebug-handler php-intl php-json-schema
  php-psr-container php-psr-log php-react-promise php-symfony-deprecation-contracts php-symfony-finder
  php-symfony-polyfill-php80 php-symfony-process php-symfony-service-contracts php8.2-intl
Use 'apt autoremove' to remove them.
The following additional packages will be installed:
  php-intl php8.2-intl
The following packages will be REMOVED:
  composer php-symfony-console php-symfony-filesystem php-symfony-string php8.1-cli php8.1-common php8.1-curl
  php8.1-fpm php8.1-gd php8.1-intl php8.1-mbstring php8.1-mysql php8.1-opcache php8.1-readline php8.1-xml
The following NEW packages will be installed:
  php8.2-intl
The following packages will be upgraded:
  php-intl
1 upgraded, 1 newly installed, 15 to remove and 23 not upgraded.
Need to get 168 kB of archives.
After this operation, 27.1 MB disk space will be freed.
Do you want to continue? [Y/n] y
Abort.

ועדיין לא השתנה, יש צורך בהפעלה מחדש?

@ivrtikshoret כתב בבעיה בשימוש עם הספריה Random ב PHP:

apt remove php8.1

לא עזר

זה היה הפלט של הפקודה הנ"ל

Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
The following packages were automatically installed and are no longer required:
  libsnappy1v5 linux-headers-5.15.0-25 linux-headers-5.15.0-25-generic linux-image-5.15.0-25-generic
  linux-image-5.4.0-105-generic linux-modules-5.15.0-25-generic linux-modules-5.4.0-105-generic
  linux-modules-extra-5.15.0-25-generic
Use 'apt autoremove' to remove them.
The following additional packages will be installed:
  php
The following packages will be REMOVED:
  php8.1
The following packages will be upgraded:
  php
1 upgraded, 0 newly installed, 1 to remove and 35 not upgraded.
Need to get 7,166 B of archives.
After this operation, 61.4 kB disk space will be freed.
Do you want to continue? [Y/n] y
Get:1 https://ppa.launchpadcontent.net/ondrej/php/ubuntu jammy/main amd64 php all 2:8.2+93+ubuntu22.04.1+deb.sury.org+2 [7,166 B]
Fetched 7,166 B in 0s (21.4 kB/s)
(Reading database ... 202683 files and directories currently installed.)
Preparing to unpack .../php_2%3a8.2+93+ubuntu22.04.1+deb.sury.org+2_all.deb ...
Unpacking php (2:8.2+93+ubuntu22.04.1+deb.sury.org+2) over (2:8.1+92ubuntu1) ...
(Reading database ... 202683 files and directories currently installed.)
Removing php8.1 (8.1.2-1ubuntu2.14) ...
Setting up php (2:8.2+93+ubuntu22.04.1+deb.sury.org+2) ...

עשיתי הפעלה מחדש וניסיתי להריץ שוב את הפקודה וקבלתי כבר את זה

Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
Package 'php8.1' is not installed, so not removed
The following packages were automatically installed and are no longer required:
  libsnappy1v5 linux-headers-5.15.0-25 linux-headers-5.15.0-25-generic linux-image-5.15.0-25-generic
  linux-image-5.4.0-105-generic linux-modules-5.15.0-25-generic linux-modules-5.4.0-105-generic
  linux-modules-extra-5.15.0-25-generic
Use 'apt autoremove' to remove them.
0 upgraded, 0 newly installed, 0 to remove and 35 not upgraded.

אז מה זה?

@ivrtikshoret כתב בבעיה בשימוש עם הספריה Random ב PHP:

וכן זה מתכון לבעיות

למשל?
יש סיכוי שדברים לא יעבדו לי?
ואז זה יהיה בר תקנה קלה או שיהיה מסובך לתקן את זה?

@ivrtikshoret כתב בניסיון הורדת קובץ נתקל בשגיאה SSL operation failed with code 1, מה עושים?:

יש לך שרת?

כן

@ivrtikshoret כתב בניסיון הורדת קובץ נתקל בשגיאה SSL operation failed with code 1, מה עושים?:

עם cron

?

@ivrtikshoret כתב בניסיון הורדת קובץ נתקל בשגיאה SSL operation failed with code 1, מה עושים?:

אני מאמין שהפעולה בפועל לא הולך להתבצע ע"י פנייה לקישור כלשהוא

למה לא? אני מריץ את זה באופן קבוע בטופס PHP שיעשה לי את הפעולה כל X זמן

@ivrtikshoret כתב בבעיה בשימוש עם הספריה Random ב PHP:

לכאורה יש לך את שתיהם מותקנים הפיתרון הוא פשוט למחוק את php8.1

איך?
ידנית או שיש דרך?
וזה לא יעשה לי בעיות?

@dovid עכשיו בדקתי, הארכיון דווקא לא פגום, אבל ירדו רק 185MB והגודל האמיתי הוא 210MB
אני מבין שהשגיאה הנ"ל הוא בגלל שלא התקבלה שום תגובה מהשרת הרבה זמן?
אז מה עושים?

@dovid הוא אכן יורד, אבל נהיה לי

ואני לא יודע אם הוא סיים
מה עושים שזה לא יקרה?

@dovid כתב ביש דרך ישירה להכנסת נתונים מקובץ טקסט מחולק בפסיק (קובץ CSV) ל mysql בשפת PHP?:

אם הmysql למשל על מחשב מרוחק,

מה זאת אומרת? אני עובד על שרת שלי שעליו מותקן SQL

@dovid כתב ביש דרך ישירה להכנסת נתונים מקובץ טקסט מחולק בפסיק (קובץ CSV) ל mysql בשפת PHP?:

בPHP אתה יכול להריץ פקודות SQL.

אני יכול להריץ רגיל את כל הפקודות של SQL
למשל את זה

CREATE TABLE internet_names

?
אז זה ממש פשוט!
את SQL אני די מכיר, אבל SQL עם PHP פחות...

@dovid בקוד הזה, לאיפה יורד הקובץ ובאיזה שם?
וכן איך עושים שלא יחזיר שגיאה בגלל שלוקח לו מידי הרבה זמן עד שהוא מסיים?

@dovid אני באמת רואה שיש לו 8.1 PHP (0.54 ILS), מה עושים?

@yossiz

@chagold כתב ביש דרך ישירה להכנסת נתונים מקובץ טקסט מחולק בפסיק (קובץ CSV) ל mysql בשפת PHP?:

https://www.mysqltutorial.org/import-csv-file-mysql-table/

ברור שתצטרך להגדיר את העמודות בmysql בדיוק כמו באקסל,

אתה בטוח שזה ל PHP?

יש לי קובץ טקסט שמחולק בפסיק-כמו קובץ CSV ואני רוצה להכניס את כל הנתונים בטבלת SQL - כל תא בתא נפרד ב SQL.
יש דרך ישירה לעשות את זה או צריך לעבור אחד אחד?
מישהו יכול לכוון אותי?

אני מנסה להוריד קובץ עם הקוד הבא

$myfile = 'https://gtfs.mot.gov.il/gtfsfiles/israel-public-transportation.zip';
 
$file = file_put_contents("aaa",file_get_contents($myfile));
echo $file;

ואני מקבל את השגיאה הבאה
SSL operation failed with code 1

ניסיתי לחפש בגוגל פיתרון ולא בדיוק הבנתי, מישהו יכול לעזור לי?

@dovid צודק, סליחה.

@ivrtikshoret אז לפני ששאלתי חיפשתי, ונאבדתי ולא הצלחתי להבין מה למעשה לעשות...

@ivrtikshoret כתב במישהו יכול לעזור לי ב API של משרד התחבורה- למידע על תחבורה ציבורית?:

@ששא
איך אתה מוריד?

$myfile = 'https://gtfs.mot.gov.il/gtfsfiles/israel-public-transportation.zip';

$file = file_put_contents("aaa",file_get_contents($myfile));
echo $file;