Unable to edit locations or initiatives in admin interface

[Brandon Walker]

I'm having a problem logging into our Suma admin interface. It will accept my initial login attempt, but when I select to edit locations or initiatives, it asks me to authenticate again and sends me back to the initial admin screen. I can never proceed. The client interface and reports seem to all still work just fine. I have checked the various yaml files and they appear to be correct as well. I just stashed my changes in GIT and pulled a new master but that hasn't changed anything. Any suggestions?

[Bret Davidson]

Hi Brandon,

Thanks for reaching out about Suma. You mentioned in another thread that your Suma instance was working previously but isn't now. This is difficult for us to troubleshoot, but it sounds like something has changed in your server environment. 

Here are two previous issues that folks have run into that might be useful:

Configuration File Permissions Issue (I suspect this is the cause)

https://github.com/suma-project/Suma/issues/63

Missing PHP Module

https://github.com/suma-project/Suma/issues/64

Thanks,

Bret

On Wed, Aug 23, 2017 at 2:12 PM, Brandon Walker <bwa...@jcu.edu> wrote:

I'm having a problem logging into our Suma admin interface. It will accept my initial login attempt, but when I select to edit locations or initiatives, it asks me to authenticate again and sends me back to the initial admin screen. I can never proceed. The client interface and reports seem to all still work just fine. I have checked the various yaml files and they appear to be correct as well. I just stashed my changes in GIT and pulled a new master but that hasn't changed anything. Any suggestions?

--
You received this message because you are subscribed to the Google Groups "Suma: mobile library assessment toolkit" group.
To unsubscribe from this group and stop receiving emails from it, send an email to suma-mobile-library-assessment-toolkit+unsub...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Walker, Brandon]

Hi Bret,

I do understand the difficulty in trying to feel out someone else's installation. I know that the log file is writable because I am able to check it and see updates to it (including failed?? authentication attempts). I also know that PDO is installed. I think the Zend Framework may have been altered (GIT status listed tons of Zend file changes), which is why I stashed in GIT and tried again afterwards. But I will also direct these questions to my web hosting service to see if they can look for anything that doesn't match, especially where these two potential issues are concerned. Any other possibilities I should be aware of?

Brandon Walker, MLIS, MS

Library Systems & Technology Coordinator

Grasselli Library & Breen Learning Center

John Carroll University

One John Carroll Blvd

University Heights, OH 44118

(216) 397- 1988

bwa...@jcu.edu

To unsubscribe from this group and stop receiving emails from it, send an email to suma-mobile-library-assessment-toolkit+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

[Bret Davidson]

Hi Brandon,

In addition to the log file, check that the suma server configuration file itself (service/config/config.yaml, depending on your installation) has the correct permissions. There are other possibilities like the Apache rewrite module not being installed, but that seems unlikely since it was working previously. It's probably worth checking with your web host to see if they've changed anything in the environment.

Thanks,

Bret

[Walker, Brandon]

Bret,

The web host hasn't changed anything in the environment, according to them. I am looking at the logs and am seeing the following entry:

2017-08-23T17:34:38+00:00 WARN (4): FAILED ADMIN LOGIN

This despite getting the the base admin interface successfully. I have checked my config files and I am using the correct login information, but clearly something's going wrong somewhere. Any thoughts on what could be causing that error in the logs despite using the configured login information?

Brandon Walker, MLIS, MS

Library Systems & Technology Coordinator

Grasselli Library & Breen Learning Center

John Carroll University

One John Carroll Blvd

University Heights, OH 44118

(216) 397- 1988

bwa...@jcu.edu

[Walker, Brandon]

Another question. Would having punctuation, specifically double quotes, in an initiative name cause problems?

Brandon Walker, MLIS, MS

Library Systems & Technology Coordinator

Grasselli Library & Breen Learning Center

John Carroll University

One John Carroll Blvd

University Heights, OH 44118

(216) 397- 1988

bwa...@jcu.edu

[Bret Davidson]

Hi Brandon,

No, double quotes shouldn't be an issue.

From the command line, can you go to the directory where your suma server configuration file is located, run the command "ls -l", and send me the output?

Thanks,

Bret

To unsubscribe from this group and stop receiving emails from it, send an email to suma-mobile-library-assessment-toolkit+unsub...@googlegroups.com.

[Walker, Brandon]

-rw-r--r-- 1 grassell grassell  3293 May 10 13:25 Globals.php

-rw-r--r-- 1 grassell grassell  1217 Aug 23 15:44 config.yaml

-rw-r--r-- 1 grassell grassell   682 May 10 13:25 config_example.ini

-rw-r--r-- 1 grassell grassell  1165 May 10 13:25 config_example.yaml

-rw-r--r-- 1 grassell grassell  3351 May 10 13:25 schema.sql

-rw-r--r-- 1 grassell grassell 34017 May 10 13:25 schema_w_sample.sql

-rw-r--r-- 1 grassell grassell    90 May 31 15:47 session.yaml

-rw-r--r-- 1 grassell grassell    86 May 10 13:25 session_example.ini

-rw-r--r-- 1 grassell grassell    94 May 10 13:25 session_example.yaml

Brandon Walker, MLIS, MS

Library Systems & Technology Coordinator

Grasselli Library & Breen Learning Center

John Carroll University

One John Carroll Blvd

University Heights, OH 44118

(216) 397- 1988

bwa...@jcu.edu

[Bret Davidson]

Hi Brandon,

Thanks for verifying those permissions. I'm grasping at straws at this point, but can you verify that a blank space hasn't been added to the end of the password field (or something of the sort) in the config file? 

Thanks,

Bret

[Walker, Brandon]

Nope, no spaces or errant characters. I am also confused. Does the admin interface drop a cookie or is that only the client interface? Because I notice there is no cookie being generated (or even offered) when I go to the admin side.

Brandon Walker, MLIS, MS

Library Systems & Technology Coordinator

Grasselli Library & Breen Learning Center

John Carroll University

One John Carroll Blvd

University Heights, OH 44118

(216) 397- 1988

bwa...@jcu.edu

[Walker, Brandon]

So, I looked at the php code that handles the admin interface. I don't know php, but I can often follow the thread of code. I am seeing where the error points are in the initial authentication, and when it writes to the log. It's writing to the log that authentication fails, despite the config.yaml having the correct password information. However, it looks like my initial login works. But in choosing any of the admin options, it's dropping the session, maybe? And then failing to authenticate? I don't completely understand. I am seeing authentication failed errors written to the log, but it's clearly letting me in to the admin menu, initially. I have no understanding... I may try switching to the production database just to see if that changes anything. Is there a character limit on initiative names? Maybe that's breaking something. I do have an awfully long name.

Brandon Walker, MLIS, MS

Library Systems & Technology Coordinator

Grasselli Library & Breen Learning Center

John Carroll University

One John Carroll Blvd

University Heights, OH 44118

(216) 397- 1988

bwa...@jcu.edu

[Bret Davidson]

Hi Brandon,

Did something change in the session.yaml file? That config is optional, it might be worth trying without as a test.

Bret

To unsubscribe from this group and stop receiving emails from it, send an email to suma-mobile-library-assessment-toolkit+unsub...@googlegroups.com.

[Walker, Brandon]

The values in it are the same as the defaults in the example, but that doesn't mean anything to me. Should I rename it? Will the system regenerate what it needs?

Brandon Walker, MLIS, MS

Library Systems & Technology Coordinator

Grasselli Library & Breen Learning Center

John Carroll University

One John Carroll Blvd

University Heights, OH 44118

(216) 397- 1988

bwa...@jcu.edu

[Bret Davidson]

Yes, try renaming the file to something other than session.yaml. If you decide to use this optional configuration, you'll need to change the base_url value according to the way you installed Suma on your server.

From the installation docs:

This is an optional file to increase session security and allow the specification of custom session properties.

In the /SUMA_SERVER_INSTALL_DIR/services/config/ directory, copy session_example.yaml to a new file session.yaml. SUMA_BASE_URL must be set to the URL path for the Suma server. For example, if the URL is http://YOUR_HOST/sumaserver, set this to /sumaserver.

[Walker, Brandon]

I renamed the session.yaml file and now it works. There was something off in that file. I wonder what was throwing stuff off. Someday I would like it to work, but for now, I'm more interested in the admin interface working.

Brandon Walker, MLIS, MS

Library Systems & Technology Coordinator

Grasselli Library & Breen Learning Center

John Carroll University

One John Carroll Blvd

University Heights, OH 44118

(216) 397- 1988

bwa...@jcu.edu

[Bret Davidson]

Hi Brandon,

Great, I'm glad things are working!

Best,

Bret

[Walker, Brandon]

Bret,

Thanks very much for your help. This community is clearly worth its weight in space assessment.

Brandon Walker, MLIS, MS

Library Systems & Technology Coordinator

Grasselli Library & Breen Learning Center

John Carroll University

One John Carroll Blvd

University Heights, OH 44118

(216) 397- 1988

bwa...@jcu.edu

[Bret Davidson]

Sure thing, please let me know if you run into anything else.

Bret

[Mark Swenson]

I just encountered this exact same problem after years of having Suma in place.  Presumably, again, an update broke something.  I found that I needed to delete both a settings.yaml file and a setting.ini file which had been established in the directory before I could get the admin interface to work correctly again.

Mark Swenson

IT Manager

Winnetka-Northfield Public Library District

To unsubscribe from this group and stop receiving emails from it, send an email to suma-mobile-library-asses...@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Suma: mobile library assessment toolkit" group.

To unsubscribe from this group and stop receiving emails from it, send an email to suma-mobile-library-asses...@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Suma: mobile library assessment toolkit" group.

To unsubscribe from this group and stop receiving emails from it, send an email to suma-mobile-library-asses...@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Suma: mobile library assessment toolkit" group.

To unsubscribe from this group and stop receiving emails from it, send an email to suma-mobile-library-asses...@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Suma: mobile library assessment toolkit" group.

To unsubscribe from this group and stop receiving emails from it, send an email to suma-mobile-library-asses...@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Suma: mobile library assessment toolkit" group.

To unsubscribe from this group and stop receiving emails from it, send an email to suma-mobile-library-asses...@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Suma: mobile library assessment toolkit" group.

To unsubscribe from this group and stop receiving emails from it, send an email to suma-mobile-library-asses...@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Suma: mobile library assessment toolkit" group.

To unsubscribe from this group and stop receiving emails from it, send an email to suma-mobile-library-asses...@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Suma: mobile library assessment toolkit" group.

To unsubscribe from this group and stop receiving emails from it, send an email to suma-mobile-library-asses...@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Suma: mobile library assessment toolkit" group.

To unsubscribe from this group and stop receiving emails from it, send an email to suma-mobile-library-asses...@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Suma: mobile library assessment toolkit" group.

To unsubscribe from this group and stop receiving emails from it, send an email to suma-mobile-library-asses...@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Suma: mobile library assessment toolkit" group.

To unsubscribe from this group and stop receiving emails from it, send an email to suma-mobile-library-asses...@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Suma: mobile library assessment toolkit" group.

To unsubscribe from this group and stop receiving emails from it, send an email to suma-mobile-library-asses...@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Suma: mobile library assessment toolkit" group.

To unsubscribe from this group and stop receiving emails from it, send an email to suma-mobile-library-asses...@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.