Koozali.org: home of the SME Server

phpmyadmin on SME8

Offline jonash

  • ***
  • 120
  • +0/-0
phpmyadmin on SME8
« on: June 27, 2012, 11:01:33 PM »
Hi,
I try to install phpmyadmin on sem8
The page SME8.0_Contribs_QA it states
smeserver-phpmyadmin
PHPMyAdmin - install as per wiki, works as expected

I was able to intstall, but nothing more.
signal-event post-upgrade; signal-event reboot does not help

I tried:
expand-template /usr/share/phpmyadmin/config.inc.php
expand-template /etc/httpd/conf/httpd.conf
/usr/local/bin/svc -h /service/httpd-e-smith

but the first commad gives error:
Code: [Select]
[root@fs phpmyadmin]# expand-template /usr/share/phpmyadmin/config.inc.php
ERROR: No templates were found for /usr/share/phpmyadmin/config.inc.php.
 at /sbin/e-smith/expand-template line 45

Any suggestions?
Thanks
Jonas
.........

Offline janet

  • ****
  • 4,812
  • +0/-0
Re: phpmyadmin on SME8
« Reply #1 on: June 28, 2012, 05:20:21 AM »
jonash

"no templates ....."

If you used this command
yum --enablerepo=smecontribs install smeserver-phpmyadmin
then it probably/possibly did not install, as you need to configure sme7contribs repo until all contribs are added to the sme8 contribs repo

Check if installed by doing
rpm -q smeserver-phpmyadmin
and show us the output here.
Please search before asking, an answer may already exist.
The Search & other links to useful information are at top of Forum.

Offline jonash

  • ***
  • 120
  • +0/-0
Re: phpmyadmin on SME8
« Reply #2 on: June 28, 2012, 06:01:53 AM »
Hmm...
This is what I thought I did...
Code: [Select]
db yum_repositories set sme7contribs repository \
GPGCheck yes \
MirrorList http://distro.ibiblio.org/pub/linux/distributions/smeserver/mirrorlist/smecontribs-7 \
Name 'SME 7 - contribs' \
Visible no \
status disabled
signal-event yum-modify
yum clean all

yum --enablerepo=sme7contribs install smeserver-phpmyadmin
But I must have missed something along the way. I did it again and now it works! But the file /usr/share/phpmyadmin/config.inc.php was there when I did the "template command", that's why I didnt do rpm -q smeserver-phpmyadmin to check the installation.

Thanks Mary!

Jonas

.........

Offline mike_mattos

  • *
  • 313
  • +0/-0
Re: phpmyadmin on SME8
« Reply #3 on: July 03, 2012, 07:09:23 PM »
I got these errors
smeserver-phpmyadmin-2.11.1.2-3.el4.sme.noarch from sme7contribs has depsolving problems
  --> Missing Dependency: phpmyadmin is needed by package smeserver-phpmyadmin-2.11.1.2-3.el4.sme.noarch (sme7contribs)
Error: Missing Dependency: phpmyadmin is needed by package smeserver-phpmyadmin-2.11.1.2-3.el4.sme.noarch (sme7contribs)


after running

db yum_repositories set sme7contribs repository \ GPGCheck yes \ MirrorList http://distro.ibiblio.org/pub/linux/distributions/smeserver/mirrorlist/smecontribs-7 \ Name 'SME 7 - contribs' \ Visible no \ status disabled

signal-event yum-modify

yum clean all

yum --enablerepo=sme7contribs install smeserver-phpmyadmin

...

Offline johnp

  • ****
  • 312
  • +0/-0
Re: phpmyadmin on SME8
« Reply #4 on: July 03, 2012, 08:02:37 PM »
Did you try yum --enablerepo=sme7contribs --enablerepo=smecontribs install smeserver-phpmyadmin

Offline mike_mattos

  • *
  • 313
  • +0/-0
Re: phpmyadmin on SME8
« Reply #5 on: July 04, 2012, 12:18:34 AM »
Why would I try that when the contrib says

Installation

This contrib can be found in the smecontribs repository. To install this contrib you will have to get shell access as root user, and issue the following command:

yum --enablerepo=smecontribs install smeserver-phpmyadmin



and elsewhere to use sme7contribs, but I didn't encounter the double enable!   I do appreciate the tip, perhaps the documentation can be updated too! 
...

Offline mike_mattos

  • *
  • 313
  • +0/-0
Re: phpmyadmin on SME8
« Reply #6 on: July 10, 2012, 10:18:23 PM »
Neither repo works at present,   
Error getting repository data for sme7contribs, repository not found
or
No package smeserver-phpmyadmin available.
...

Offline johnp

  • ****
  • 312
  • +0/-0
Re: phpmyadmin on SME8
« Reply #7 on: July 11, 2012, 12:38:53 AM »
I see the files in http://distro.ibiblio.org/pub/linux/distributions/smeserver/releases/

Worst case you could copy the files to your server and do a yum localinstall. I installed it this last weekend on a test server and if memory is correct you would need the smeserver-phpmyadmin from 7 contribs and phpmyadmin and php53-mcrypt from 8

Offline xinspirit

  • 14
  • +0/-0
Re: phpmyadmin on SME8
« Reply #8 on: August 12, 2012, 02:58:33 PM »
I have the same, I tried PHPMyAdmin and Phpmyadminmulti. There is nothing at 192.168.3.2/phpmyadmin

Quote
login as: root
root@192.168.3.2's password:
Last login: Sun Aug 12 14:36:23 2012 from 192.168.1.35
[root@webbi ~]# db configuration show phpmyadmin
[root@webbi ~]#




Offline xinspirit

  • 14
  • +0/-0
Re: phpmyadmin on SME8
« Reply #9 on: August 12, 2012, 05:05:09 PM »
[root@webbi ~]# yum --enablerepo=smecontribs install smeserver-phpmyadmin
Loaded plugins: fastestmirror, protect-packages, smeserver
Loading mirror speeds from cached hostfile
 * base: centos.copahost.com
 * smeaddons: mirror.hakkers.com
 * smecontribs: mirror.hakkers.com
 * smeextras: mirror.hakkers.com
 * smeos: mirror.hakkers.com
 * smeupdates: mirror.hakkers.com
 * updates: centos.copahost.com
Excluding Packages from CentOS - os
Finished
Excluding Packages from CentOS - updates
Finished
Setting up Install Process
No package smeserver-phpmyadmin available.
Nothing to do
[root@webbi ~]# db configuration show phpmyadmin
[root@webbi ~]#

Offline johnp

  • ****
  • 312
  • +0/-0
Re: phpmyadmin on SME8
« Reply #10 on: August 12, 2012, 07:13:01 PM »
Did you read http://wiki.contribs.org/SME8.0_Contribs_QA? You'll likely need to setup the sme7contribs repo. I would also use:
 
yum --enablerepo=sme7contribs --enablerepo=smecontribs install smeserver-phpmyadmin

to install



Offline xinspirit

  • 14
  • +0/-0
Re: phpmyadmin on SME8
« Reply #11 on: August 12, 2012, 09:10:25 PM »
Hi John,

thank you for your answer. It seems not to work:

[root@webbi /]# yum --enablerepo=sme7contribs --enablerepo=smecontribs install smeserver-phpmyadmin
Loaded plugins: fastestmirror, protect-packages, smeserver

Error getting repository data for sme7contribs, repository not found
[root@webbi /]#

Offline Stefano

  • *
  • 10,839
  • +2/-0
Re: phpmyadmin on SME8
« Reply #12 on: August 12, 2012, 11:16:34 PM »
xinspirit
please re-read carefully and twice the page johnp suggested to you, thank you
« Last Edit: August 13, 2012, 09:12:50 AM by Stefano »

Offline chris burnat

  • ****
  • 1,135
  • +2/-0
    • http://www.burnat.com
Re: phpmyadmin on SME8
« Reply #13 on: August 13, 2012, 02:01:32 AM »
xinspirit
please re-read carefully and twice the page johnp succested to you, thank you

And in particular:
"Create a repo named sme7contribs, which points at the SME7 smecontribs repo"
- chris
If it does not work out of the box, please fill in a Bug Report @ Bugzilla (http://bugs.contribs.org)  - check: http://wiki.contribs.org/Bugzilla_Help .  Thanks.

Offline Jean-Philippe Pialasse

  • *
  • 2,767
  • +11/-0
  • aka Unnilennium
    • http://smeserver.pialasse.com
Re: phpmyadmin on SME8
« Reply #14 on: August 13, 2012, 08:46:13 PM »
in fact the as per wiki need some adaptation :

first you need to do  this :
http://wiki.contribs.org/SME8.0_Contribs_QA#Setup

then you need to follow the wiki with this minor adaptation :

http://wiki.contribs.org/PHPMyAdmin
Quote
Code: [Select]
yum --enablerepo=smecontribs install smeserver-phpmyadmin --enablerepo=sme7contribs
and either

Code: [Select]
signal-event post-upgrade; signal-event reboot
or

Code: [Select]
expand-template /usr/share/phpmyadmin/config.inc.php
expand-template /etc/httpd/conf/httpd.conf
/usr/local/bin/svc -h /service/httpd-e-smith

by the way, this is useless as the version available in sme7contribs and in centos 5 repos  of phpmyadmin are not compatible with sme 8 and php 5.3. It seems to work, but there is a lot of deprecated command in it, and by experience it may issue bad mysql request ( introducing errors in your data)

An alternative would be to use this version http://rpms.famillecollet.com/el5.i386/phpMyAdmin-3.5.2.1-1.el5.remi.noarch.rpm as it will be ok with php 5.3 , but i do not know what need to be modified in smeserver-phpmyadmin or smeserver-phpmyadmin-multiuser to be compatible with this rpm.


I do not have enough time to to test currently, but if you have you should give a try on a test server.