xampp 64bit

Problems with the Windows version of XAMPP, questions, comments, and anything related.

xampp 64bit

Postby ErtiAV » 07. December 2016 10:13

Hello dear,

I'm wondering, are you going to do the xampp 64 bit version?
I'm running xampp on my workstation with 32GB ram. But I couldn't this ram because of 32bit.
Always I'm getting php exhausted error.

It will be very helpful if 64bit is developed.

Thank you very much.

[EDIT by Altrea: moved to the english section of this board]
ErtiAV
 
Posts: 6
Joined: 07. December 2016 10:07
XAMPP version: 7.0.4
Operating System: Windows 10

Re: xampp 64bit

Postby Nobbie » 07. December 2016 13:09

ErtiAV wrote:Always I'm getting php exhausted error.


I dont think that error is due to 32/64 bit, its simply a question of php.ini configuration. If you provide the full error message, we can find out how to improve your php.ini. Would be better than waiting for a 64bit version (which would fail anyway with insufficient settings in php.ini). If you really really need an 64bit version, you have to switch to Linux (or another distribution than Xampp).

A last note: this is a german forum, the english part is in the bottom.
Nobbie
 
Posts: 9622
Joined: 09. March 2008 13:04

Re: xampp 64bit

Postby ErtiAV » 08. December 2016 11:48

Thank you for quick reply.
I have to use Windows and I am very pleased xampp.
My php.ini file

[PHP]
engine = On

short_open_tag = On

precision = 14

output_buffering = 4096

zlib.output_compression = Off

implicit_flush = Off

unserialize_callback_func =

serialize_precision = 17

disable_functions =

disable_classes =

zend.enable_gc = On

expose_php = On

max_execution_time = 300

max_input_time = 60

max_input_vars = 3000

memory_limit = 2048M

error_reporting = E_ALL | E_STRICT

display_errors = On

display_startup_errors = On

log_errors = On

log_errors_max_len = 1024

ignore_repeated_errors = Off

ignore_repeated_source = Off

report_memleaks = On

track_errors = On

html_errors = On

error_log = php_errors.log

variables_order = "GPCS"

request_order = "GP"

register_argc_argv = Off

auto_globals_jit = On

post_max_size = 1024M

auto_prepend_file =

auto_append_file =

default_mimetype = "text/html"

default_charset = "UTF-8"

include_path = \xampp\php\PEAR
doc_root =

user_dir =

extension_dir = "E:\xampp\php\ext"

enable_dl = On

file_uploads = On

upload_tmp_dir = "E:\xampp\tmp"

upload_max_filesize = 512M

max_file_uploads = 20

allow_url_fopen = On

allow_url_include = Off

default_socket_timeout = 60

extension=php_bz2.dll
extension=php_curl.dll
extension=php_fileinfo.dll
extension=php_gd2.dll
extension=php_gettext.dll
;extension=php_gmp.dll
;extension=php_intl.dll
extension=php_imap.dll
;extension=php_interbase.dll
;extension=php_ldap.dll
extension=php_mbstring.dll
extension=php_exif.dll
extension=php_mysqli.dll
extension=php_oci8_12c.dll
;extension=php_openssl.dll
;extension=php_pdo_firebird.dll
extension=php_pdo_mysql.dll
extension=php_pdo_oci.dll
extension=php_pdo_odbc.dll
extension=php_pdo_pgsql.dll
extension=php_pdo_sqlite.dll
;extension=php_pgsql.dll
;extension=php_shmop.dll
;extension=php_snmp.dll

extension=php_soap.dll
extension=php_sockets.dll
extension=php_sqlite3.dll
;extension=php_tidy.dll
extension=php_xmlrpc.dll
extension=php_xsl.dll
;extension=php_sqlsrv.dll
;extension=php_pdo_sqlsrv_56_ts.dll
;extension=php_sqlsrv_56_ts.dll
;extension=php_sqlsrv_7_nts.dll
extension=php_sqlsrv_7_ts.dll
;;;;;;;;;;;;;;;;;;;
; Module Settings ;
;;;;;;;;;;;;;;;;;;;
asp_tags=Off
display_startup_errors=On
track_errors=Off
y2k_compliance=On
allow_call_time_pass_reference=Off
safe_mode=Off
safe_mode_gid=Off
safe_mode_allowed_env_vars=PHP_
safe_mode_protected_env_vars=LD_LIBRARY_PATH
error_log="E:\xampp\php\logs\php_error_log"
register_globals=Off
register_long_arrays=Off
magic_quotes_gpc=Off
magic_quotes_runtime=Off
magic_quotes_sybase=Off
extension=php_openssl.dll
extension=php_ftp.dll

[CLI Server]
cli_server.color = On

[Date]

[filter]

[iconv]

[intl]

[sqlite3]

[Pcre]

[Pdo]
pdo_mysql.default_socket="MySQL"

[Pdo_mysql]
pdo_mysql.cache_size = 2000

pdo_mysql.default_socket=

[Phar]

[mail function]
SMTP = localhost
smtp_port = 25

mail.add_x_header = On

[SQL]
sql.safe_mode = Off

[ODBC]
odbc.allow_persistent = On

odbc.check_persistent = On

odbc.max_persistent = -1

odbc.max_links = -1

odbc.defaultlrl = 4096

odbc.defaultbinmode = 1

[Interbase]
ibase.allow_persistent = 1

ibase.max_persistent = -1

ibase.max_links = -1

ibase.timestampformat = "%Y-%m-%d %H:%M:%S"

ibase.dateformat = "%Y-%m-%d"

ibase.timeformat = "%H:%M:%S"

[MySQLi]
mysqli.max_persistent = -1

mysqli.allow_local_infile = On

mysqli.allow_persistent = On

mysqli.max_links = -1

mysqli.cache_size = 2000

mysqli.default_port = 3306

mysqli.default_socket = "MySQL"

mysqli.default_host =

mysqli.default_user =

mysqli.default_pw =

mysqli.reconnect = Off

[mysqlnd]
mysqlnd.collect_statistics = On

mysqlnd.collect_memory_statistics = Off

[OCI8]
oci8.max_persistent = 50

oci8.persistent_timeout = 300

oci8.ping_interval = 0

oci8.connection_class = MYPHPAPP

oci8.old_oci_close_semantics = On

[PostgreSQL]
pgsql.allow_persistent = On

pgsql.auto_reset_persistent = Off

pgsql.max_persistent = -1

pgsql.max_links = -1

pgsql.ignore_notice = 0

pgsql.log_notice = 0

[bcmath]
bcmath.scale = 0

[browscap]
browscap = "E:\xampp\php\extras\browscap.ini"

[Session]
session.save_handler = files

session.save_path = "E:\xampp\tmp"

session.use_strict_mode = 1

session.use_cookies = 1

session.use_only_cookies = 0

session.name = PHPSESSID

session.auto_start = 0

session.cookie_lifetime = 0

session.cookie_path = /

session.cookie_domain =

session.cookie_httponly =

session.serialize_handler = php

session.gc_probability = 1

session.gc_divisor = 1000

session.gc_maxlifetime = 1440

session.referer_check =

session.entropy_length = 0

session.cache_limiter = nocache

session.cache_expire = 180

session.use_trans_sid = 0

session.hash_function = 0

session.hash_bits_per_character = 5

url_rewriter.tags = "a=href,area=href,frame=src,input=src,form=fakeentry"

[Assertion]
zend.assertions = 1

[COM]

[mbstring]

[gd]

[exif]

[Tidy]
tidy.clean_output = Off

[soap]
soap.wsdl_cache_enabled=1

soap.wsdl_cache_dir="/tmp"

soap.wsdl_cache_ttl=86400

soap.wsdl_cache_limit = 5

[sysvshm]

[ldap]
ldap.max_links = -1

[mcrypt]

[dba]

[opcache]

[curl]

[openssl]

[Syslog]
define_syslog_variables=Off
[Session]
define_syslog_variables=Off
[Date]
date.timezone=Asia/Istanbul
[MySQL]
mysql.allow_local_infile=On
mysql.allow_persistent=On
mysql.cache_size=2000
mysql.max_persistent=-1
mysql.max_link=-1
mysql.default_port=3306
mysql.default_socket="MySQL"
mysql.connect_timeout=3
mysql.trace_mode=Off
[Sybase-CT]
sybct.allow_persistent=On
sybct.max_persistent=-1
sybct.max_links=-1
sybct.min_server_severity=10
sybct.min_client_severity=10
[MSSQL]
mssql.allow_persistent=On
mssql.max_persistent=-1
mssql.max_links=-1
mssql.min_error_severity=10
mssql.min_message_severity=10
mssql.compatability_mode=Off
mssql.secure_connection=Off
ErtiAV
 
Posts: 6
Joined: 07. December 2016 10:07
XAMPP version: 7.0.4
Operating System: Windows 10

Re: xampp 64bit

Postby Nobbie » 08. December 2016 12:36

ErtiAV wrote:My php.ini file


??

Thats not what i asked for:

Nobbie wrote:If you provide the full error message, we can find out how to improve your php.ini.
Nobbie
 
Posts: 9622
Joined: 09. March 2008 13:04

Re: xampp 64bit

Postby ErtiAV » 21. December 2016 06:02

[21-Dec-2016 02:34:30 Europe/Istanbul] PHP Fatal error: Out of memory (allocated 138412032) (tried to allocate 20480 bytes) in E:\xampp\htdocs\excel_spread\PHPExcel\CachedObjectStorage\CacheBase.php on line 177

[21-Dec-2016 02:35:22 Europe/Istanbul] PHP Fatal error: Out of memory (allocated 134217728) (tried to allocate 20480 bytes) in E:\xampp\htdocs\excel_spread\PHPExcel\CachedObjectStorage\CacheBase.php on line 177

[21-Dec-2016 02:36:10 Europe/Istanbul] PHP Fatal error: Out of memory (allocated 115343360) (tried to allocate 3670016 bytes) in E:\xampp\htdocs\excel_spread\PHPExcel\CachedObjectStorage\CacheBase.php on line 177

[21-Dec-2016 02:36:44 Europe/Istanbul] PHP Fatal error: Out of memory (allocated 44040192) (tried to allocate 30579920 bytes) in E:\xampp\htdocs\defect_details.php on line 189

[21-Dec-2016 02:37:10 Europe/Istanbul] PHP Fatal error: Out of memory (allocated 2097152) (tried to allocate 917504 bytes) in E:\xampp\htdocs\repairgeneral.php on line 202

[21-Dec-2016 02:37:10 Europe/Istanbul] PHP Fatal error: Out of memory (allocated 125829120) (tried to allocate 4096 bytes) in E:\xampp\htdocs\excel_spread\PHPExcel\CachedObjectStorage\PHPTemp.php on line 60

[21-Dec-2016 02:39:00 Europe/Istanbul] PHP Fatal error: Out of memory (allocated 117440512) (tried to allocate 3670016 bytes) in E:\xampp\htdocs\excel_spread\PHPExcel\CachedObjectStorage\CacheBase.php on line 177

[21-Dec-2016 03:11:16 Europe/Istanbul] PHP Fatal error: Out of memory (allocated 140509184) (tried to allocate 7340032 bytes) in E:\xampp\htdocs\excel_spread\PHPExcel\CachedObjectStorage\CacheBase.php on line 177

[21-Dec-2016 03:12:13 Europe/Istanbul] PHP Fatal error: Out of memory (allocated 115343360) (tried to allocate 20480 bytes) in E:\xampp\htdocs\excel_spread\PHPExcel\CachedObjectStorage\CacheBase.php on line 177

[21-Dec-2016 03:13:11 Europe/Istanbul] PHP Fatal error: Out of memory (allocated 106954752) (tried to allocate 20480 bytes) in E:\xampp\htdocs\excel_spread\PHPExcel\CachedObjectStorage\CacheBase.php on line 177

[21-Dec-2016 03:13:32 Europe/Istanbul] PHP Fatal error: Out of memory (allocated 54525952) (tried to allocate 4096 bytes) in E:\xampp\htdocs\excel_spread\PHPExcel\CachedObjectStorage\PHPTemp.php on line 60

[21-Dec-2016 03:15:02 Europe/Istanbul] PHP Fatal error: Out of memory (allocated 140509184) (tried to allocate 7340032 bytes) in E:\xampp\htdocs\excel_spread\PHPExcel\CachedObjectStorage\CacheBase.php on line 177
ErtiAV
 
Posts: 6
Joined: 07. December 2016 10:07
XAMPP version: 7.0.4
Operating System: Windows 10

Re: xampp 64bit

Postby Nobbie » 21. December 2016 12:22

I wonder that even in the worst case PHP only allocated less than 150MB and then failed, this is not quite a limit for a 32bit environment, which is restricted to 4096MB and each thread (process) is restricted to 2048MB - both by far more than only 150MB. In some case it already fails far earlier after only allocating 2MB.

This looks like a very bad memory management in PHPExcel and I also found many forums and postings in the internet, which also tells about these kind of problems with PHPExcel. I am not sure if a 64bit environment would help to solve the problem, as it is also reported that PDFExcel also has big runtime problems, it takes too long for large excel spreadsheets.

Here http://stackoverflow.com/questions/4817 ... 4mb-of-ram a few alternative libraries are recommended, you may try to adapt your scripts to these libraries. Or try to run your code on an Linux 64bit environment, there is a 64bit Xampp as well, but as i told before, i am unsure if 64bit really helps in this case. All in all the PDFExcel API seems to waist ressources in a very bad way.
Nobbie
 
Posts: 9622
Joined: 09. March 2008 13:04

Re: xampp 64bit

Postby ErtiAV » 22. December 2016 12:46

Thank you for quick reply.

I am aware of PHPExcel memory issues. I have to use PHPExcel because very develop create excel sheet. If there are alternative have same capabilities like PHPExcel please let me know.

The article you sent is just for reading, so this useless for me.

On the other hand, It works fine on IIS same machine. But I have to use Xammp, because I am using several script/function. And some script/function doesn't run IIS.

The site I made consists of about 1000 pages. So revision is a really hard work.

I hope the Xampp 64 bit is done as soon as possible.

Thank you for your support.
ErtiAV
 
Posts: 6
Joined: 07. December 2016 10:07
XAMPP version: 7.0.4
Operating System: Windows 10

Re: xampp 64bit

Postby Altrea » 22. December 2016 17:46

Do it yourself.
Use the Apache Win64 Binaries from here https://www.apachelounge.com/download/
Use the PHP x64 version from here http://windows.php.net/download/
and put it all together.

XAMPP is not made for production environments. It is for local test and development purposes only.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8889
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: xampp 64bit

Postby Nobbie » 22. December 2016 19:23

ErtiAV wrote:The article you sent is just for reading, so this useless for me.


Are you kidding?? You either did not read it carefully, or you did not understand it. There are lots of hints how to fix the memory problem, as well there are links to other solutions and APIs. I cannot believe that you really overlooked all that. But finally, it is your problem, i tried to help, it is on you make the best out of it.

ErtiAV wrote:I hope the Xampp 64 bit is done as soon as possible.


There is already Xampp 64 bit, your problem is WIndows. Use Linux instead (or OSX) and you have a 64bit Xampp installation immediately. As Apache, Php etc. are developed and maintained in Linux environments, this is superior to any poor Windows installation. Why WIndows??
Nobbie
 
Posts: 9622
Joined: 09. March 2008 13:04

Re: xampp 64bit

Postby ErtiAV » 23. December 2016 06:21

Nobbie be sure. I read a lot of documents this issue. Many of them about reading excel.

I want to use Linux but company rules! I think I do it myself.

thanks both of you.
ErtiAV
 
Posts: 6
Joined: 07. December 2016 10:07
XAMPP version: 7.0.4
Operating System: Windows 10

Re: xampp 64bit

Postby Nobbie » 23. December 2016 12:08

ErtiAV wrote:I want to use Linux but company rules! I think I do it myself.


If I were you, what about this idea:

a) setup Linux server with Xampp 64bit and try to solve the problems on that server. If it works...

b) ... call your boss, show him the well working Linux server, after then show him the struggling Windows environment incuding all crashes ...

c) ... and then ask your boss, which server should we use?

Merry Christmas!
Nobbie
 
Posts: 9622
Joined: 09. March 2008 13:04

Re: xampp 64bit

Postby ErtiAV » 27. December 2016 06:12

Sounds great, but unfortunately I'm working for a multinational company. And my company signed a software contract with Microsoft.
I will build up one by one.
Thank you very much.

Marry Chirstmas
ErtiAV
 
Posts: 6
Joined: 07. December 2016 10:07
XAMPP version: 7.0.4
Operating System: Windows 10

Re: xampp 64bit

Postby Nobbie » 27. December 2016 12:39

ErtiAV wrote:Sounds great, but unfortunately I'm working for a multinational company. And my company signed a software contract with Microsoft.


That is real strange - on the one hand, your company goes with Microsoft and denies Linux, but the Webserver is build with Apache (Xampp) instead of IIS. That is crazy!
Nobbie
 
Posts: 9622
Joined: 09. March 2008 13:04


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 37 guests