Re: [IBMiOSS] phpMyAdmin on IBM i -- OPENSOURCE

Yep - looks pretty standard. You shouldn't need this, but worth a try. After the CCSID stuff add an alias line, and then a directory to go with it.

Alias /phpMyAdmin /www/httpphp/htdocs/phpMyAdmin

<Directory /www/httpphp/htdocs/phpMyAdmin>
Require all granted
</Director

On Mon, 2020-06-08 at 19:58 +0200, Danny Rodius wrote:

@ 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>

http://example.com

instead of

<http://example.com/index.php>

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 <

<mailto:opensource-bounces@xxxxxxxxxxxxxxxxxx>

opensource-bounces@xxxxxxxxxxxxxxxxxx

On Behalf Of Kevin

Bucknum

Sent: maandag 8 juni 2020 19:20

To:

<mailto:opensource@xxxxxxxxxxxxxxxxxx>

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:

<mailto:opensource-bounces@xxxxxxxxxxxxxxxxxx>

opensource-bounces@xxxxxxxxxxxxxxxxxx

<mailto:opensource-bounces@xxxxxxxxxxxxxxxxxx>

opensource-bounces@xxxxxxxxxxxxxxxxxx

On Behalf Of Kevin

Bucknum

Sent: maandag 8 juni 2020 17:28

To:

<mailto:

<mailto:opensource@xxxxxxxxxxxxxxxxxx>

opensource@xxxxxxxxxxxxxxxxxx

<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

<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

<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:

<mailto:OpenSource@xxxxxxxxxxxxxxxxxx>

OpenSource@xxxxxxxxxxxxxxxxxx

<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

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

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

or email:

<mailto:

<mailto:OpenSource-request@xxxxxxxxxxxxxxxxxx>

OpenSource-request@xxxxxxxxxxxxxxxxxx

<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

<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://amazon.midrange.com>

https://amazon.midrange.com

[

<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.