× 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

No luck, getting the same error for the missing templates directory.

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

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