× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. OPENSOURCE
  3. June 2020

Re: [IBMiOSS] phpMyAdmin on IBM i

@ Kevin

Please find the config for this test server:

# Configuration originally created by Create HTTP Server wizard on Sat Jun
06 11:34:19 CEST 2020
Listen *:80
DocumentRoot /www/httpphp/htdocs
TraceEnable Off
Options -FollowSymLinks
LogFormat "%h %T %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-Agent}i\""
combined
LogFormat "%{Cookie}n \"%r\" %t" cookie
LogFormat "%{User-agent}i" agent
LogFormat "%{Referer}i -> %U" referer
LogFormat "%h %l %u %t \"%r\" %>s %b" common
CustomLog logs/access_log combined
LogMaint logs/access_log 7 0
LogMaint logs/error_log 7 0
SetEnvIf "User-Agent" "Mozilla/2" nokeepalive
SetEnvIf "User-Agent" "JDK/1\.0" force-response-1.0
SetEnvIf "User-Agent" "Java/1\.0" force-response-1.0
SetEnvIf "User-Agent" "RealPlayer 4\.0" force-response-1.0
SetEnvIf "User-Agent" "MSIE 4\.0b2;" nokeepalive
SetEnvIf "User-Agent" "MSIE 4\.0b2;" force-response-1.0

# This loads the Apache FastCGI support originally created for Zend
LoadModule zend_enabler_module /QSYS.LIB/QHTTPSVR.LIB/QZFAST.SRVPGM
# These lines will add gzip compression to the data served. You want these
near the top
LoadModule deflate_module /QSYS.LIB/QHTTPSVR.LIB/QZSRCORE.SRVPGM
AddOutputFilterByType DEFLATE application/x-httpd-php application/json
text/css application/x-javascript application/javascript text/html


# This tells Apache that any file with a .php extension should be
# executed by the FastCGI application/x-httpd-php handler
AddType application/x-httpd-php .php
AddHandler fastcgi-script .php

# Let's you go to http://example.com instead of http://example.com/index.php
DirectoryIndex index.php index.html

# This will turn on Keep Alive and allow users to reuse older connections,
making the serving of data faster.
TimeOut 30000
KeepAliveTimeout 30
HotBackup Off

# If your code looks funky a lot of times it is your CCSID. This seems to
help
DefaultFsCCSID 1148
CGIJobCCSID 1148


<Directory />
Require all denied
</Directory>
<Directory /www/httpphp/htdocs>
Require all granted
</Directory>

Nothing secret about it.

-----Original Message-----
From: OpenSource <opensource-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Kevin
Bucknum
Sent: maandag 8 juni 2020 19:20
To: opensource@xxxxxxxxxxxxxxxxxx
Subject: Re: [IBMiOSS] phpMyAdmin on IBM i

The mailing list must be stripping it out. Have to put it inline or on
something like pastebin maybe.



On Mon, 2020-06-08 at 18:15 +0200, Danny Rodius wrote:

@ Kevin,


Included the apache config.


Have unzipped the phpMyAdmin in a directory www/httpphp/htdocs/phpMyAdmin


So browser access <system>/phpMyAdmin/index.php


Hope you can find a solution


-----Original Message-----

From: OpenSource <

<mailto:opensource-bounces@xxxxxxxxxxxxxxxxxx>

opensource-bounces@xxxxxxxxxxxxxxxxxx

On Behalf Of Kevin

Bucknum

Sent: maandag 8 juni 2020 17:28

To:

<mailto:opensource@xxxxxxxxxxxxxxxxxx>

opensource@xxxxxxxxxxxxxxxxxx


Subject: Re: [IBMiOSS] phpMyAdmin on IBM i


I'll have to remember that adminer doesn't work for the ibmdb2i. You

attached the php call stack, but not the apache config. If you don't have

phpadmin in your document root, then I suspect that your alias statement in

the apache config isn't correct.


On Sat, 2020-06-06 at 17:55 +0200, Danny Rodius wrote:


@ Kevin



Have tryed adminer but was a little disappointed. Creating a db with the


ibmdb2i engine seems not to work.



So I'm back here looking for the phpMyAdmin solution.



So included the apache error log and the phpMyAdmin config file.









[

<https://www.medtronsoftware.com/img/MedtronMinilogo.bmp>

https://www.medtronsoftware.com/img/MedtronMinilogo.bmp

] Kevin Bucknum

Senior Programmer Analyst

MEDDATA / MEDTRON

120 Innwood Drive

Covington LA 70433

Local: 985-893-2550

Toll Free: 877-893-2550



<https://www.medtronsoftware.com>

https://www.medtronsoftware.com





CONFIDENTIALITY NOTICE


This document and any accompanying this email transmission contain

confidential information, belonging to the sender that is legally

privileged. This information is intended only for the use of the individual

or entity named above. The authorized recipient of this information is

prohibited from disclosing this information to any other party and is

required to destroy the information after its stated need has been

fulfilled. If you are not the intended recipient, or the employee of agent

responsible to deliver it to the intended recipient, you are hereby notified

that any disclosure, copying, distribution or action taken in reliance on

the contents of these documents is STRICTLY PROHIBITED. If you have

received this email in error, please notify the sender immediately to

arrange for return or destruction of these documents.

--

This is the IBMi Open Source Roundtable (OpenSource) mailing list To post a

message email:

<mailto:OpenSource@xxxxxxxxxxxxxxxxxx>

OpenSource@xxxxxxxxxxxxxxxxxx

To subscribe, unsubscribe, or

change list options,

visit:

<https://lists.midrange.com/mailman/listinfo/opensource>

https://lists.midrange.com/mailman/listinfo/opensource


or email:

<mailto:OpenSource-request@xxxxxxxxxxxxxxxxxx>

OpenSource-request@xxxxxxxxxxxxxxxxxx


Before posting, please take a moment to review the archives at

<https://archive.midrange.com/opensource>

https://archive.midrange.com/opensource

.


Help support midrange.com by shopping at amazon.com with our affiliate

link:

<https://amazon.midrange.com>

https://amazon.midrange.com




[https://www.medtronsoftware.com/img/MedtronMinilogo.bmp] Kevin Bucknum
Senior Programmer Analyst
MEDDATA / MEDTRON
120 Innwood Drive
Covington LA 70433
Local: 985-893-2550
Toll Free: 877-893-2550
https://www.medtronsoftware.com



CONFIDENTIALITY NOTICE

This document and any accompanying this email transmission contain
confidential information, belonging to the sender that is legally
privileged. This information is intended only for the use of the individual
or entity named above. The authorized recipient of this information is
prohibited from disclosing this information to any other party and is
required to destroy the information after its stated need has been
fulfilled. If you are not the intended recipient, or the employee of agent
responsible to deliver it to the intended recipient, you are hereby notified
that any disclosure, copying, distribution or action taken in reliance on
the contents of these documents is STRICTLY PROHIBITED. If you have
received this email in error, please notify the sender immediately to
arrange for return or destruction of these documents.
--
This is the IBMi Open Source Roundtable (OpenSource) mailing list To post a
message email: OpenSource@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: https://lists.midrange.com/mailman/listinfo/opensource
or email: OpenSource-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/opensource.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com


As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.