Koozali.org: home of the SME Server

SME9 and phpmyadmin

Offline stephdl

  • *
  • 1,519
  • +0/-0
    • Linux et Geekeries
Re: SME9 and phpmyadmin
« Reply #15 on: October 11, 2014, 11:06:11 PM »
cat /etc/group|grep apache:
Code: [Select]
[root@www e-smith]# cat /etc/group|grep apache
apache:x:48:

Okay you have the bug 8549 : http://bugs.contribs.org/show_bug.cgi?id=8549

That's not a good new even if the way to solve it is easy., we need to find a solution to solve definitively the problem. However I understand better your first issue with the db yum repository since it comes from your usb-backup....quite surely

To answer to your question the correct uid for apache is 102

so please do

Code: [Select]
groupmod -g 102 apache
You should solve your issue and allow the admin login, please verify the correct password

EDIT: you are welcome to support financially the sme server
« Last Edit: October 11, 2014, 11:10:35 PM by stephdl »
See http://wiki.contribs.org/Koozali_Foundation
irc : Freenode #sme_server #sme-fr

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

Offline ReetP

  • *
  • 3,722
  • +5/-0
Re: SME9 and phpmyadmin
« Reply #16 on: October 12, 2014, 11:22:12 AM »
Not 100% sure but have a look at this

http://bugs.contribs.org/show_bug.cgi?id=8549

Install a clean v9, update, patch and then restore.

Please let us know what happens.
...
1. Read the Manual
2. Read the Wiki
3. Don't ask for support on Unsupported versions of software
4. I have a job, wife, and kids and do this in my spare time. If you want something fixed, please help.

Bugs are easier than you think: http://wiki.contribs.org/Bugzilla_Help

If you love SME and don't want to lose it, join in: http://wiki.contribs.org/Koozali_Foundation

Offline waldviertler

  • ***
  • 107
  • +0/-0
Re: SME9 and phpmyadmin
« Reply #17 on: October 12, 2014, 09:27:16 PM »
Ok, I have done:

Quote
Install a clean v9, update, patch and then restore.

I got the same result, as the last time.
After the restore and the installation of phpmyadmin, no phpmyadmin logon possible:

Code: [Select]
[Sun Oct 12 21:20:42 2014] [error] [client 192.168.1.48] AuthExtern pwauth [/usr/bin/pwauth]: Failed (255) for user admin
[Sun Oct 12 21:20:42 2014] [error] [client 192.168.1.48] user admin: authentication failure for "/phpmyadmin/": Password Mismatch

Even when I try:
Code: [Select]
groupmod -g 102 apache
Thanks
Martin

Offline ReetP

  • *
  • 3,722
  • +5/-0
Re: SME9 and phpmyadmin
« Reply #18 on: October 12, 2014, 09:38:29 PM »
Ok,

thanks for testing !!

Please follow up on the bug. Stephane has done some more work there.

We'll try and get you fixed :-)
...
1. Read the Manual
2. Read the Wiki
3. Don't ask for support on Unsupported versions of software
4. I have a job, wife, and kids and do this in my spare time. If you want something fixed, please help.

Bugs are easier than you think: http://wiki.contribs.org/Bugzilla_Help

If you love SME and don't want to lose it, join in: http://wiki.contribs.org/Koozali_Foundation

Offline waldviertler

  • ***
  • 107
  • +0/-0
Re: SME9 and phpmyadmin
« Reply #19 on: October 12, 2014, 09:54:06 PM »
Can it be, that there must be "admin" as user in mysql?

I tried:
Code: [Select]
[root@www etc]# mysql -uadmin -pmypassword
ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)

Not sure, but I think that is not ok.
But I have the same password on SME8 as on the new SME9.

Thanks again.
Martin

guest22

Re: SME9 and phpmyadmin
« Reply #20 on: October 12, 2014, 09:57:53 PM »
Hi Martin,


good question, please read the SME Server specifics on how MySQL is being managed.


http://wiki.contribs.org/MySQL#MySQL_root_password


guest


Offline waldviertler

  • ***
  • 107
  • +0/-0
Re: SME9 and phpmyadmin
« Reply #21 on: October 12, 2014, 10:20:55 PM »
Login with root-privileges work with simply "mysql".

That is ok!

Code: [Select]
[root@www ~]# mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 307
Server version: 5.1.73 Source distribution

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> GRANT SELECT ON test.* TO 'admin'@'host' IDENTIFIED BY 'mypassword';
Query OK, 0 rows affected (0.00 sec)

mysql>

guest22

Re: SME9 and phpmyadmin
« Reply #22 on: October 12, 2014, 10:24:05 PM »
Login with root-privileges work with simply "mysql".

That is ok!


AFAIK there is not other user. Per created database user/users have to be granted privileges. But that user has to be specifically granted access by any webapp.


Maybe your expectations of an admin user are the 'root' user?

Offline waldviertler

  • ***
  • 107
  • +0/-0
Re: SME9 and phpmyadmin
« Reply #23 on: October 12, 2014, 11:00:18 PM »
I have done the same login procedure with SME8.

best regards
Martin

Offline stephdl

  • *
  • 1,519
  • +0/-0
    • Linux et Geekeries
Re: SME9 and phpmyadmin
« Reply #24 on: October 12, 2014, 11:56:44 PM »
Ok, I have done:

I got the same result, as the last time.
After the restore and the installation of phpmyadmin, no phpmyadmin logon possible:

Code: [Select]
[Sun Oct 12 21:20:42 2014] [error] [client 192.168.1.48] AuthExtern pwauth [/usr/bin/pwauth]: Failed (255) for user admin
[Sun Oct 12 21:20:42 2014] [error] [client 192.168.1.48] user admin: authentication failure for "/phpmyadmin/": Password Mismatch

Even when I try:
Code: [Select]
groupmod -g 102 apache
Thanks
Martin
please return
Code: [Select]
cat /etc/group| grep -i apache
See http://wiki.contribs.org/Koozali_Foundation
irc : Freenode #sme_server #sme-fr

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

Offline waldviertler

  • ***
  • 107
  • +0/-0
Re: SME9 and phpmyadmin
« Reply #25 on: October 13, 2014, 01:12:22 AM »
It returns:
Code: [Select]
[root@www ~]# cat /etc/group| grep -i apache
apache:x:102:

Offline stephdl

  • *
  • 1,519
  • +0/-0
    • Linux et Geekeries
Re: SME9 and phpmyadmin
« Reply #26 on: October 13, 2014, 07:32:07 AM »
Ok, I have done:

I got the same result, as the last time.
After the restore and the installation of phpmyadmin, no phpmyadmin logon possible:

Code: [Select]
[Sun Oct 12 21:20:42 2014] [error] [client 192.168.1.48] AuthExtern pwauth [/usr/bin/pwauth]: Failed (255) for user admin
[Sun Oct 12 21:20:42 2014] [error] [client 192.168.1.48] user admin: authentication failure for "/phpmyadmin/": Password Mismatch

Even when I try:
Code: [Select]
groupmod -g 102 apache
Thanks
Martin

well not sure that the patch could work since it lacks some dependencies, how did you patch, what was the output of the terminal during the patch
See http://wiki.contribs.org/Koozali_Foundation
irc : Freenode #sme_server #sme-fr

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

Offline waldviertler

  • ***
  • 107
  • +0/-0
Re: SME9 and phpmyadmin
« Reply #27 on: October 13, 2014, 02:11:32 PM »
I will try it tonight again. I don't know the output anymore.

Shall I use both patches:

e-smith-backup apache group patch

and

patch to e-smith-base-5.6.0/root/etc/e-smith/events/actions/init-accounts?

I have done only the "e-smith-backup apache group patch ".

I made a file patch.sh copied the patch into it - chmod 775-  and started it.

Offline waldviertler

  • ***
  • 107
  • +0/-0
Re: SME9 and phpmyadmin
« Reply #28 on: October 14, 2014, 12:36:39 AM »
It looks that my way to patch does not work.
How is the correct way to patch the system with
e-smith-backup apache group patch
and
patch to e-smith-base-5.6.0/root/etc/e-smith/events/actions/init-accounts
??

Offline waldviertler

  • ***
  • 107
  • +0/-0
Re: SME9 and phpmyadmin
« Reply #29 on: October 15, 2014, 10:03:48 PM »
Ok, I think I figured it out!

patch "e-smith-backup apache group patch" runs without any message.

patch "patch to e-smith-base-5.6.0/root/etc/e-smith/events/actions/init-accounts"

stopps with following message:

Code: [Select]
[root@www tmp]# patch -p2 <patch2.pm
can't find file to patch at input line 4
Perhaps you used the wrong -p or --strip option?
The text leading up to this was:
--------------------------
|diff -Nur e-smith-base-5.6.0.old/root/etc/e-smith/events/actions/init-accounts e-smith-base-5.6.0/root/etc/e-smith/events/actions/init-accounts
|--- e-smith-base-5.6.0.old/root/etc/e-smith/events/actions/init-accounts       2014-10-12 16:28:02.872982921 +0200
|+++ e-smith-base-5.6.0/root/etc/e-smith/events/actions/init-accounts   2014-10-12 17:18:58.748369354 +0200
--------------------------
File to patch: