Koozali.org: home of the SME Server

smeserver-phpmyadmin

Offline AusMounty

  • 13
  • +0/-0
smeserver-phpmyadmin
« on: March 23, 2014, 11:01:00 PM »
Hello all,
I have been wondering if anyone has had any luck installing smeserver-phpmyadmin on release 9b3? I have been trying to find someone who has it successfully running and if so, provide a HOWTO.

I have a couple of CMS packages which require MySQL and the easiest method for creating the database is via the web-interface.

Any assistance would be appreciated.

Regards,
David
(aka AusMounty)

Offline janet

  • ****
  • 4,812
  • +0/-0
Re: smeserver-phpmyadmin
« Reply #1 on: March 24, 2014, 04:21:50 AM »
AusMounty

Did you try installing it following this wiki article
http://wiki.contribs.org/PHPMyAdmin

You will have to setup a smecontribs-8 repo on your sme 9 server which points at the sme8 smecontribs repo location, & refer to that when installing phpmyadmin

eg
yum --enablerepo=smecontribs-8 install smeserver-phpmyadmin
etc etc

Let us know how you go & we can look at any issues you come across.

IMO it will probably work OK.
Many sme8 contribs will work on sme9 OK.

Edit: Based on advice from stephdl, contribs with server manger panels will not work correctly.
Back to testing.
« Last Edit: March 24, 2014, 09:12:06 PM by janet »
Please search before asking, an answer may already exist.
The Search & other links to useful information are at top of Forum.

Offline stephdl

  • *
  • 1,519
  • +0/-0
    • Linux et Geekeries
Re: smeserver-phpmyadmin
« Reply #2 on: March 24, 2014, 08:48:46 PM »
Many sme8 contribs will work on sme9 OK.

Just for your informations janet, contribs which have a panel in the server-manager can't work on sme9 mainly because the path to the perl library is not good.

For sme8
/usr/lib/perl5/site_perl/esmith/FormMagick/Panel/

For sme9
/usr/share/perl5/vendor_perl/esmith/FormMagick/Panel/

The file.pm of the contribs (raidstatus.pm for example) has to be moved to the new destination in sme9
See http://wiki.contribs.org/Koozali_Foundation
irc : Freenode #sme_server #sme-fr

!!! Please write your knowledge to the Wiki !!!

Offline janet

  • ****
  • 4,812
  • +0/-0
Re: smeserver-phpmyadmin
« Reply #3 on: March 24, 2014, 09:08:26 PM »
stephdl

Thanks, lesson learnt.
Please search before asking, an answer may already exist.
The Search & other links to useful information are at top of Forum.

Offline janet

  • ****
  • 4,812
  • +0/-0
Re: smeserver-phpmyadmin
« Reply #4 on: March 24, 2014, 10:02:16 PM »
I tried installing phpmyadmin from sme8 smecontribs repo but get dependency errors.

Can anyone advise what repo has the required dependencies
ie
php53-mbstring
php53-mysql
php53-gd
php53
php53-common

Here is the install log:
yum install --enablerepo=smecontribs-8 smeserver-phpmyadmin           

Resolving Dependencies
--> Running transaction check
---> Package smeserver-phpmyadmin.noarch 0:3.5.2.2-6.el5.sme will be installed
--> Processing Dependency: phpMyAdmin3 >= 3.5.2.2 for package: smeserver-phpmyadmin-3.5.2.2-6.el5.sme.noarch
--> Running transaction check
---> Package phpMyAdmin3.noarch 0:3.5.8.1-1.el5 will be installed
--> Processing Dependency: php53-php-gettext for package: phpMyAdmin3-3.5.8.1-1.el5.noarch
--> Processing Dependency: php53-mysql for package: phpMyAdmin3-3.5.8.1-1.el5.noarch
--> Processing Dependency: php53-mcrypt for package: phpMyAdmin3-3.5.8.1-1.el5.noarch
--> Processing Dependency: php53-mbstring for package: phpMyAdmin3-3.5.8.1-1.el5.noarch
--> Processing Dependency: php53-gd for package: phpMyAdmin3-3.5.8.1-1.el5.noarch
--> Processing Dependency: php53 for package: phpMyAdmin3-3.5.8.1-1.el5.noarch
--> Running transaction check
---> Package php53-mcrypt.i386 0:5.3.3-1.el5 will be installed
--> Processing Dependency: libmcrypt.so.4 for package: php53-mcrypt-5.3.3-1.el5.i386
---> Package php53-php-gettext.noarch 0:1.0.11-3.el5 will be installed
--> Processing Dependency: php53-mbstring for package: php53-php-gettext-1.0.11-3.el5.noarch
--> Processing Dependency: php53-common for package: php53-php-gettext-1.0.11-3.el5.noarch
---> Package phpMyAdmin3.noarch 0:3.5.8.1-1.el5 will be installed
--> Processing Dependency: php53-mysql for package: phpMyAdmin3-3.5.8.1-1.el5.noarch
--> Processing Dependency: php53-mbstring for package: phpMyAdmin3-3.5.8.1-1.el5.noarch
--> Processing Dependency: php53-gd for package: phpMyAdmin3-3.5.8.1-1.el5.noarch
--> Processing Dependency: php53 for package: phpMyAdmin3-3.5.8.1-1.el5.noarch
--> Running transaction check
---> Package libmcrypt.i386 0:2.5.8-4.el5.centos will be installed
---> Package php53-php-gettext.noarch 0:1.0.11-3.el5 will be installed
--> Processing Dependency: php53-mbstring for package: php53-php-gettext-1.0.11-3.el5.noarch
--> Processing Dependency: php53-common for package: php53-php-gettext-1.0.11-3.el5.noarch
---> Package phpMyAdmin3.noarch 0:3.5.8.1-1.el5 will be installed
--> Processing Dependency: php53-mysql for package: phpMyAdmin3-3.5.8.1-1.el5.noarch
--> Processing Dependency: php53-mbstring for package: phpMyAdmin3-3.5.8.1-1.el5.noarch
--> Processing Dependency: php53-gd for package: phpMyAdmin3-3.5.8.1-1.el5.noarch
--> Processing Dependency: php53 for package: phpMyAdmin3-3.5.8.1-1.el5.noarch
--> Finished Dependency Resolution
Error: Package: php53-php-gettext-1.0.11-3.el5.noarch (smecontribs-8)
           Requires: php53-mbstring
Error: Package: phpMyAdmin3-3.5.8.1-1.el5.noarch (smecontribs-8)
           Requires: php53-mbstring
Error: Package: phpMyAdmin3-3.5.8.1-1.el5.noarch (smecontribs-8)
           Requires: php53-mysql
Error: Package: phpMyAdmin3-3.5.8.1-1.el5.noarch (smecontribs-8)
           Requires: php53-gd
Error: Package: phpMyAdmin3-3.5.8.1-1.el5.noarch (smecontribs-8)
           Requires: php53
Error: Package: php53-php-gettext-1.0.11-3.el5.noarch (smecontribs-8)
           Requires: php53-common
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest
« Last Edit: March 24, 2014, 10:08:47 PM by janet »
Please search before asking, an answer may already exist.
The Search & other links to useful information are at top of Forum.

Offline janet

  • ****
  • 4,812
  • +0/-0
Re: smeserver-phpmyadmin
« Reply #5 on: March 24, 2014, 10:07:21 PM »
Then I added the remi repo & get the following
Can anybody suggest what's going on here.
Does it suggest that smeserver-phpmyadmin should be rewritten to use phpMyAdmin rather than phpMyAdmin3, & should these changes go into the sme repos.


/sbin/e-smith/db yum_repositories set remi repository \
> Name 'Remi - EL6' \
> BaseURL 'http://rpms.famillecollet.com/enterprise/6/remi/$basearch/' \
> EnableGroups no \
> GPGCheck yes \
> GPGKey http://rpms.famillecollet.com/RPM-GPG-KEY-remi \
> Visible no \
> status disabled

signal-event yum-modify

yum install --enablerepo=smecontribs-8 --enablerepo=remi smeserver-phpmyadmin

Resolving Dependencies
--> Running transaction check
---> Package smeserver-phpmyadmin.noarch 0:3.5.2.2-6.el5.sme will be installed
--> Processing Dependency: phpMyAdmin3 >= 3.5.2.2 for package: smeserver-phpmyadmin-3.5.2.2-6.el5.sme.noarch
Package phpMyAdmin3 is obsoleted by phpMyAdmin, but obsoleting package does not provide for requirements
--> Finished Dependency Resolution
Error: Package: smeserver-phpmyadmin-3.5.2.2-6.el5.sme.noarch (smecontribs-8)
           Requires: phpMyAdmin3 >= 3.5.2.2
           Available: phpMyAdmin3-3.5.8.1-1.el5.noarch (smecontribs-8)
               phpMyAdmin3 = 3.5.8.1-1.el5
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest



Please search before asking, an answer may already exist.
The Search & other links to useful information are at top of Forum.

Offline janet

  • ****
  • 4,812
  • +0/-0
Re: smeserver-phpmyadmin
« Reply #6 on: March 27, 2014, 07:03:37 AM »
AusMounty

Until a suitable contrib package is available, you can manually install using generic instructions from
http://www.phpmyadmin.net/home_page/index.php

Just check which version is compatible with your sme OS & other pkgs eg php & mysql versions.
Please search before asking, an answer may already exist.
The Search & other links to useful information are at top of Forum.

Offline Xavier.A

  • ***
  • 104
  • +0/-0
Re: smeserver-phpmyadmin
« Reply #7 on: March 28, 2014, 12:18:49 PM »
@AusMounty
or if you could install SME, may-be you could try to learn SQL   :P
and may-be you should try to use professionnal tools :
Debian
Code: [Select]
sudo apt-get install mysql-workbenchCentOS
Code: [Select]
yum install mysql-workbench
but may-be it's easier to try to install phpmyadmin  :lol:
“When the wise man points to the moon, the fool looks at the finger.”

Offline janet

  • ****
  • 4,812
  • +0/-0
Re: smeserver-phpmyadmin
« Reply #8 on: March 29, 2014, 06:13:16 AM »
kid_of_leognan

Quote
CentOS
yum install mysql-workbench

That will not & does not work as the default repos do not contain that pkg.
You must also specify a suitable repo (reponame), & have that repo configured on your sme server eg
yum install mysql-workbench --enablerepo=reponame
Please search before asking, an answer may already exist.
The Search & other links to useful information are at top of Forum.

Offline magwm

  • *
  • 157
  • +0/-0
  • SmeLover
    • Gadis Tourist Service Italia SRL
Re: smeserver-phpmyadmin
« Reply #9 on: May 19, 2014, 12:33:17 PM »
I am seeing the same problems trying to install phpmyadmin.

entered bug http://bugs.contribs.org/show_bug.cgi?id=8387
MagWm

Offline stephdl

  • *
  • 1,519
  • +0/-0
    • Linux et Geekeries
Re: smeserver-phpmyadmin
« Reply #10 on: May 19, 2014, 01:02:01 PM »
I will take a look...on your bug report.
You are welcome to test and report all contribs for sme9....we need a lot of testers....
See http://wiki.contribs.org/Koozali_Foundation
irc : Freenode #sme_server #sme-fr

!!! Please write your knowledge to the Wiki !!!

Offline Stefano

  • *
  • 10,836
  • +2/-0
Re: smeserver-phpmyadmin
« Reply #11 on: May 19, 2014, 02:20:35 PM »
@AusMounty
or if you could install SME, may-be you could try to learn SQL   :-P
and may-be you should try to use professionnal tools :
Debian
Code: [Select]
sudo apt-get install mysql-workbenchCentOS
Code: [Select]
yum install mysql-workbench
but may-be it's easier to try to install phpmyadmin  :lol:

mysql-workbench will not work without a G.U.I... so it will be unusable on SME
« Last Edit: May 20, 2014, 10:40:58 AM by Stefano »

Offline stephdl

  • *
  • 1,519
  • +0/-0
    • Linux et Geekeries
Re: smeserver-phpmyadmin
« Reply #12 on: May 19, 2014, 07:25:39 PM »
I am seeing the same problems trying to install phpmyadmin.

entered bug http://bugs.contribs.org/show_bug.cgi?id=8387
please report to bugzilla, a new version of smeserver-phpmyadmin is waiting you
See http://wiki.contribs.org/Koozali_Foundation
irc : Freenode #sme_server #sme-fr

!!! Please write your knowledge to the Wiki !!!