Topic: SME9 and phpmyadmin

[waldviertler]

Hi

I would like to install "phpmyadmin" and so I followed this instruction:

http://wiki.contribs.org/PHPMyAdmin#tab=For_SME9

First enabled the contribs

Code: [Select]

db yum_repositories set stephdl repository \
BaseURL http://mirror.de-labrusse.fr/smeserver/\$releasever \
EnableGroups no GPGCheck yes \
Name "Mirror de Labrusse" \
GPGKey http://mirror.de-labrusse.fr/RPM-GPG-KEY \
Visible yes status disabled
and

Code: [Select]

/sbin/e-smith/db yum_repositories set epel repository \
Name 'Epel - EL6' \
BaseUrl 'http://download.fedoraproject.org/pub/epel/6/$basearch' \
MirrorList 'http://mirrors.fedoraproject.org/mirrorlist?repo=epel-6&arch=$basearch' \
EnableGroups no \
GPGCheck yes \
GPGKey http://dl.fedoraproject.org/pub/epel/RPM-GPG-KEY-EPEL \
Visible no \
status disabled
then

Code: [Select]

signal-event yum-modify
and

Code: [Select]

yum install --enablerepo=stephdl,epel smeserver-phpmyadmin.

But after that, I got this errors:

Code: [Select]

[root@www httpd]# yum install --enablerepo=stephdl,epel smeserver-phpmyadmin
Loaded plugins: fastestmirror, smeserver
Loading mirror speeds from cached hostfile
 * epel: fedora.aau.at
 * smeaddons: mirror.absolutnet.de
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package smeserver-phpmyadmin.noarch 0:4.0.10.2-2.el6.sme will be installed
--> Processing Dependency: phpMyAdmin >= 4.0.10.1 for package: smeserver-phpmyadmin-4.0.10.2-2.el6.sme.noarch
--> Running transaction check
---> Package phpMyAdmin.noarch 0:4.0.10.4-1.el6 will be installed
--> Processing Dependency: php-mcrypt >= 5.2.0 for package: phpMyAdmin-4.0.10.4-1.el6.noarch
--> Processing Dependency: php-tcpdf-dejavu-sans-fonts for package: phpMyAdmin-4.0.10.4-1.el6.noarch
--> Processing Dependency: php-tcpdf for package: phpMyAdmin-4.0.10.4-1.el6.noarch
--> Processing Dependency: php-php-gettext for package: phpMyAdmin-4.0.10.4-1.el6.noarch
--> Running transaction check
---> Package php-mcrypt.x86_64 0:5.3.3-3.el6 will be installed
--> Processing Dependency: libmcrypt.so.4()(64bit) for package: php-mcrypt-5.3.3-3.el6.x86_64
---> Package php-php-gettext.noarch 0:1.0.11-3.el6 will be installed
---> Package php-tcpdf.noarch 0:6.0.091-1.el6 will be installed
--> Processing Dependency: php-tidy for package: php-tcpdf-6.0.091-1.el6.noarch
--> Processing Dependency: php-bcmath for package: php-tcpdf-6.0.091-1.el6.noarch
---> Package php-tcpdf-dejavu-sans-fonts.noarch 0:6.0.091-1.el6 will be installed
--> Processing Dependency: dejavu-sans-fonts for package: php-tcpdf-dejavu-sans-fonts-6.0.091-1.el6.noarch
--> Running transaction check
---> Package libmcrypt.x86_64 0:2.5.8-9.el6 will be installed
---> Package php-tcpdf.noarch 0:6.0.091-1.el6 will be installed
--> Processing Dependency: php-tidy for package: php-tcpdf-6.0.091-1.el6.noarch
--> Processing Dependency: php-bcmath for package: php-tcpdf-6.0.091-1.el6.noarch
---> Package php-tcpdf-dejavu-sans-fonts.noarch 0:6.0.091-1.el6 will be installed
--> Processing Dependency: dejavu-sans-fonts for package: php-tcpdf-dejavu-sans-fonts-6.0.091-1.el6.noarch
--> Finished Dependency Resolution
Error: Package: php-tcpdf-6.0.091-1.el6.noarch (epel)
           Requires: php-tidy
Error: Package: php-tcpdf-dejavu-sans-fonts-6.0.091-1.el6.noarch (epel)
           Requires: dejavu-sans-fonts
Error: Package: php-tcpdf-6.0.091-1.el6.noarch (epel)
           Requires: php-bcmath
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest
[root@www httpd]#

Any help appreciated!!
Thanks!

Martin

[guest22]

First enabled the contribs

Code: [Select]

db yum_repositories set stephdl repository \
BaseURL http://mirror.de-labrusse.fr/smeserver/\$releasever \
EnableGroups no GPGCheck yes \
Name "Mirror de Labrusse" \
GPGKey http://mirror.de-labrusse.fr/RPM-GPG-KEY \
Visible yes status disabled

Hi Martin,

For sanity sake the mentioned 'contribs' repo should be the stephdl repo.

I just checked, the php-tidy rpm is definitely in the epel repo (yum install php-tidy --enablerepo=epel)
That said, PHP had some serious upgrades last week. Did you do a yum update before you applied the how-to? Things may have changed.

I guess we have to wait a bit for the author and other phpmyadmin guru's are in a different TZ then yours.

guest

[waldviertler]

Thanks for your help!

That is what I've done:
I've installed SME9 freshly today.
After that, I tried yum update, but no "No Packages marked for Update".
Then I tried to install phpmyadmin.

Best regards
Martin

[guest22]

Then something is wrong. If you've installed from the SME9 CD, then there should be many updates form several official repo's when you perform a 'yum update'.

I guess about 200Mb. Can you post the output from 'yum update' through 'no packages to update' ?

So why is yum not seeing any new updates would be the question.

Anything in the logs?

[waldviertler]

Yes, I installed it from SME9 CD.

This is the output from yum update:

Code: [Select]

[root@www ~]# yum update
Loaded plugins: fastestmirror, smeserver
Loading mirror speeds from cached hostfile
 * smeaddons: mirror.absolutnet.de
Setting up Update Process
No Packages marked for Update
[root@www ~]#


[guest22]

Ok, definitely a problem.

What is the output from:

db yum_repositories show

please?

[waldviertler]

The output from db yum_repositories show:

Code: [Select]

[root@www ~]# db yum_repositories show
base=repository
    BaseURL=http://vault.centos.org/4.9/os/$basearch
    EnableGroups=no
    Exclude=initscripts,libgsf
    GPGCheck=yes
    MirrorList=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=os
    Name=CentOS - os
    Visible=yes
    status=disabled
centosplus=repository
    BaseURL=http://vault.centos.org/4.9/centosplus/$basearch
    EnableGroups=no
    GPGCheck=yes
    MirrorList=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=centosplus
    Name=CentOS - centosplus
    Visible=no
    status=disabled
contrib=repository
    BaseURL=http://vault.centos.org/4.9/contrib/$basearch
    EnableGroups=no
    GPGCheck=yes
    MirrorList=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=contrib
    Name=CentOS - contrib
    Visible=no
    status=disabled
epel=repository
    BaseUrl=http://download.fedoraproject.org/pub/epel/6/$basearch
    EnableGroups=no
    GPGCheck=yes
    GPGKey=http://dl.fedoraproject.org/pub/epel/RPM-GPG-KEY-EPEL
    MirrorList=http://mirrors.fedoraproject.org/mirrorlist?repo=epel-6&arch=$basearch
    Name=Epel - EL6
    Visible=no
    status=disabled
extras=repository
    BaseURL=http://vault.centos.org/4.9/extras/$basearch
    EnableGroups=no
    GPGCheck=yes
    MirrorList=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=extras
    Name=CentOS - extras
    Visible=no
    status=disabled
fasttrack=repository
    EnableGroups=no
    GPGCheck=yes
    MirrorList=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=fasttrack
    Name=CentOS - fasttrack
    Visible=no
    status=disabled
fws=repository
    BaseURL=http://repo.firewall-services.com/centos/$releasever
    EnableGroups=no
    GPGCheck=yes
    GPGKey=http://repo.firewall-services.com/RPM-GPG-KEY
    Name=Firewall Services
    Visible=yes
    status=disabled
smeaddons=repository
    EnableGroups=yes
    GPGCheck=yes
    MirrorList=http://mirrorlist.contribs.org/mirrorlist/smeaddons-9
    Name=SME Server - addons
    Visible=yes
    status=enabled
smecontribs=repository
    EnableGroups=yes
    GPGCheck=yes
    MirrorList=http://mirrorlist.contribs.org/mirrorlist/smecontribs-9
    Name=SME Server - contribs
    Visible=no
    status=disabled
smedev=repository
    EnableGroups=yes
    GPGCheck=yes
    MirrorList=http://mirrorlist.contribs.org/mirrorlist/smedev-9
    Name=SME Server - dev
    Visible=no
    status=disabled
smeextras=repository
    EnableGroups=yes
    GPGCheck=yes
    MirrorList=http://mirrorlist.contribs.org/mirrorlist/smeextras-9
    Name=SME Server - extras
    Visible=yes
    status=disabled
smeos=repository
    EnableGroups=yes
    GPGCheck=yes
    MirrorList=http://mirrorlist.contribs.org/mirrorlist/smeos-9
    Name=SME Server - os
    Visible=yes
    status=disabled
smetest=repository
    EnableGroups=yes
    GPGCheck=yes
    MirrorList=http://mirrorlist.contribs.org/mirrorlist/smetest-9
    Name=SME Server - test
    Visible=no
    status=disabled
smeupdates=repository
    EnableGroups=yes
    GPGCheck=yes
    MirrorList=http://mirrorlist.contribs.org/mirrorlist/smeupdates-9
    Name=SME Server - updates
    Visible=yes
    status=disabled
smeupdates-testing=repository
    EnableGroups=yes
    GPGCheck=yes
    MirrorList=http://mirrorlist.contribs.org/mirrorlist/smeupdates-testing-9
    Name=SME Server - updates testing
    Visible=yes
    status=disabled
stephdl=repository
    BaseURL=http://mirror.de-labrusse.fr/smeserver/$releasever
    EnableGroups=no
    GPGCheck=yes
    GPGKey=http://mirror.de-labrusse.fr/RPM-GPG-KEY
    Name=Mirror de Labrusse
    Visible=yes
    status=disabled
testing=repository
    BaseURL=http://mirror.centos.org/centos/4/testing/$basearch
    EnableGroups=no
    GPGCheck=yes
    Name=CentOS - testing
    Visible=no
    status=disabled
updates=repository
    BaseURL=http://vault.centos.org/4.9/updates/$basearch
    EnableGroups=no
    Exclude=initscripts,libgsf
    GPGCheck=yes
    MirrorList=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=updates
    Name=CentOS - updates
    Visible=yes
    status=disabled
[root@www ~]#

Thanks!

[guest22]

Try this: http://wiki.contribs.org/Useful_Commands#Restoring_Default_Yum_Repositories

[guest22]

Did you use SME Server 9.0 final release? for:

base=repository
    BaseURL=http://vault.centos.org/4.9/os/$basearch

Is completely wrong....

[waldviertler]

I have downloaded this:

64 bit version - http://mirror.contribs.org/smeserver/releases/9/iso/x86_64/

Now after your hint

Try this: http://wiki.contribs.org/Useful_Commands#Restoring_Default_Yum_Repositories

It installs 1 Package, and upgrades 58 Packages. 114 MB.

[waldviertler]

Hmm.
Now phpmyadmin installs without any problems.
But when I login to https://myurl.com/phpmyadmin/

I get the login window over and over again.

And in the error.log are following lines:

Code: [Select]

[Sat Oct 11 01:21:27 2014] [error] [client 192.168.1.48] AuthExtern pwauth [/usr/bin/pwauth]: Failed (255) for user admin
[Sat Oct 11 01:21:27 2014] [error] [client 192.168.1.48] user admin: authentication failure for "/phpmyadmin/": Password Mismatch
So I changed the System-Admin Password and tried it again.
But no success.

Should I start from the scratch?

[stephdl]

I have downloaded this:

64 bit version - http://mirror.contribs.org/smeserver/releases/9/iso/x86_64/

Now after your hint
It installs 1 Package, and upgrades 58 Packages. 114 MB.

I cannot reproduce, I have downloaded an iso of sme964 and my repositories are correctly settled, do other takers can try

[stephdl]

Hmm.
Now phpmyadmin installs without any problems.
But when I login to https://myurl.com/phpmyadmin/

I get the login window over and over again.

And in the error.log are following lines:

Code: [Select]

[Sat Oct 11 01:21:27 2014] [error] [client 192.168.1.48] AuthExtern pwauth [/usr/bin/pwauth]: Failed (255) for user admin
[Sat Oct 11 01:21:27 2014] [error] [client 192.168.1.48] user admin: authentication failure for "/phpmyadmin/": Password Mismatch
So I changed the System-Admin Password and tried it again.
But no success.

Should I start from the scratch?

what about :

Code: [Select]

ll /usr/bin/pwauthand

Code: [Select]

cat /etc/group|grep apacheand

Code: [Select]

id apacheand

Code: [Select]

groups apache

[guest22]

Now after your hint
It installs 1 Package, and upgrades 58 Packages. 114 MB.

So what could be the root cause of the fact that your default repo's were replaced?

My best guess would be that you installed an old contrib not suited for SME9. Could that be?

guest

(typo)

[waldviertler]

I have installed the iso "smeserver-9.0-x86_64.iso " from http://mirror.contribs.org/smeserver/releases/9/iso/x86_64/.

Then I restored my usb-backup from my 8.0 Server.

ll /usr/bin/pwauth:

Code: [Select]

[root@www e-smith]# ll /usr/bin/pwauth
-rwsr-x--- 1 root root 11032  5. Jun 2013  /usr/bin/pwauth
cat /etc/group|grep apache:

Code: [Select]

[root@www e-smith]# cat /etc/group|grep apache
apache:x:48:
id apache:

Code: [Select]

[root@www e-smith]# id apache
uid=102(apache) gid=102 Gruppen=102
groups apache:

Code: [Select]

[root@www e-smith]# groups apache
apache : groups: Es ist kein Name zur GruppenâID 102 zu finden
102
Uid=102 seems wrong!?
This could be a result from my usb-backup?

Thanks, I will donate!!