Google OAUTH error

///Google OAUTH error
Google OAUTH error2017-12-19T12:23:22+00:00

Home Forums Abre Support Google OAUTH error

  • Author
    Posts
  • Anonymous
    Post count: 14

    I am trying to install ABRE on a local machine for testing purposes.  When I go to the local site and click student and staff login, I get an error message from google:

    <b>400.</b> <ins>That’s an error.</ins>
    <p id=”errorCode”><b>Error: invalid_request</b></p>
    <p id=”errorDescription”>device_id and device_name are required for private IP: http://10.125.252.15/index.php</p&gt;
    <p id=”errorUri”>Learn more</p>

    <div id=”request_info_header” class=”goog-zippy-header goog-zippy-expanded” tabindex=”0″ role=”tab” aria-expanded=”true”>Request Details
    <div>
    <ul id=”request_info_items”>
    <li id=”param_entry_0″ class=”param_entry”>response_type=code
    <li id=”param_entry_1″ class=”param_entry”>access_type=offline
    <li id=”param_entry_2″ class=”param_entry”>client_id=10935070969-tb2djk8i5g9qprse1d2hal1p2pqgfn1v.apps.googleusercontent.com
    <li id=”param_entry_3″ class=”param_entry”>redirect_uri=http://10.125.252.15/index.php
    <li id=”param_entry_4″ class=”param_entry”>state=
    <li id=”param_entry_5″ class=”param_entry”>scope=https://www.googleapis.com/auth/userinfo.email https://www.googleapis.com/auth/plus.login https://www.googleapis.com/auth/gmail.modify https://www.googleapis.com/auth/drive.readonly https://www.googleapis.com/auth/calendar.readonly https://www.googleapis.com/auth/classroom.courses.readonly https://www.googleapis.com/auth/classroom.rosters.readonly
    <li id=”param_entry_6″ class=”param_entry”>approval_prompt=auto
    <li id=”param_entry_7″ class=”param_entry”>include_granted_scopes=true

    </div>
    </div>
    <ins>That’s all we know.</ins>

     

    I have tried everything I can think of to change the OAUTH credentials.  Any advice?

     

  • Brandon Wilson
    Participant
    Post count: 17

    Hi Ben,

    They key in this error message is the description: “device_id and device_name are required for private IP”. Google does not allow raw IP addresses to be set in redirect URI’s. I would try setting a domain to this IP or try using localhost to satisfy this requirement.

     

    If you have any other questions, please feel free to post back.

     

    Best,

    Brandon

  • Anonymous
    Post count: 14

    Thanks Brandon.  I have tried using localhost.  Here is a screenshot:

    https://docs.google.com/document/d/1LQ-rWQttJm8exYNKbnwWDhQPYp-fyFnwOLS3DM01Tik/edit?usp=sharing

     

    I have also tried setting up a DNS record on our end pointing to that server and then using http://abretest.tvsd.us

    Thanks

  • Brandon Wilson
    Participant
    Post count: 17

    Ben,

    When you used localhost and http://abretest.tvsd.us did you update the configuration file within Abre? If you didn’t change the variable value on line 3 of the configuration.php file, Google would still see a redirect URI of your raw IP.

  • Anonymous
    Post count: 14

    Yes, that worked.  Thank you.  I never thought about modifying the php file.

     

    Thanks

  • Brandon Wilson
    Participant
    Post count: 17

    Great! Glad to hear you are up and running. Let me know if there is anything else I can help you or your district out with!

    Best,

    Brandon

  • Anonymous
    Post count: 14

    Alright, one more question, now that I modified the php code, I am stuck in a loop.  It asked for Google credentials, I enter them, and then it brings me right back to the sign in page.  The redirect on the Google OAUTH screen says /index.php.  Is there another place I need to change in the PHP script?  The portal_root is http://servername.domain.us.

     

    Thanks again for all your help

  • Brandon Wilson
    Participant
    Post count: 17

    Ben,

    Be sure that the end of your email address matches the value at the end of the line 5 in your configuration.php file.

    For example, if your email address ends with @gmail.com, be sure line 5 reads:

    if (!defined(‘SITE_GAFE_DOMAIN’)){ define(‘SITE_GAFE_DOMAIN’,’@gmail.com’); }

    This prevents users with emails outside of the listed domain from entering your site hence why you are stuck in a loop. You are able to list more than one domain by separating them by a comma.

    Let me know if this helps!

  • Anonymous
    Post count: 14

    Unfortunatly that did not work.  Here are the first several lines of my configuration:

    $portal_root = “http://abretest.tvsd.us”;
    $portal_private_root = “private_html”;
    if(!defined(‘SITE_GAFE_DOMAIN’)){ define(‘SITE_GAFE_DOMAIN’,’@teays.us’,’@tvsd.us’); }

     

    It still sends me in a loop.  @teays is our primary domain on Google, all staff are listed as a secondary domain.  I even tried logging in as @teays and still got in a loop.  Tried on Chrome as well as Firefox.

  • Brandon Wilson
    Participant
    Post count: 17

    Ben,

    Sorry what I posted might have been confusing. If you to list multiple domains, you need to list it as:

    if(!defined(‘SITE_GAFE_DOMAIN’)){ define(‘SITE_GAFE_DOMAIN’,’@teays.us,@tvsd.us’); }

    If this doesn’t work, a snapshot of your users database table would be helpful!

    Thanks again for reaching out!

  • Anonymous
    Post count: 14

    Thanks Brandon for all your help.  I was able to change the  config.php and it will now allow both domains to log in.  However, it still won’t let me all the way in with either domain.  When I log in with my normal account (@tvsd.us) it will log in and then go to a blank page.  When I log in with an @teays account (who I have made a super admin in Google) it logs in and brings me to the profile page.  From there, when I click done it brings me right back to the profile page and never to the home page.  When I look at the database, it shows both accounts created in the user database.  In the profile table, it shows only the @tvsd account created.  So it appears that it is erroring out on the profile page and not letting me past that point.  Here is copy of both tables;

    https://docs.google.com/document/d/1LQ-rWQttJm8exYNKbnwWDhQPYp-fyFnwOLS3DM01Tik/edit?usp=sharing

    Thanks again for all your help.

  • Brandon Wilson
    Participant
    Post count: 17

    Hey Ben,

    I am glad to hear that we were able to get your login working! From the entries in your database tables, the users seem to be being saved correctly. There are a couple approaches we can take to tracking down the problem now.

    1. When you log in with your @tvsd.us account, do you see Google Cards on your page, such as Drive, Calendar, Apps, etc? Also on the profile page, do you see a set of standard streams to opt into?

    2. Do you have access to your error logs? If so, check and see if you see any php fatal errors.

    I suspect your issues are either coming from a missing database table that wasn’t installed, or a server configuration issue.

    I look forward to hearing back from you and resolving these issues.

  • Anonymous
    Post count: 14

    When I log in with my tvsd account, I do not see anything, just a blank page.  When I log in with a teays account I see the default streams and can select the cards, but when I click on done it takes be right back to the profile page.

     

    Yes there is a fatal error.

    [Fri Dec 29 13:27:01.785902 2017] [:error] [pid 31638] [client 10.125.252.136:59796] PHP Fatal error: Uncaught Error: Call to undefined function curl_init() in /var/www/html/core/abre_ping.php:23\nStack trace:\n#0 /var/www/html/modules/se

     

    After looking through the PHP code, it looks like that curl_int function is supposed to take you to here  https://status.abre.io/installation.php   however that does not resolve to anything.  I’m wondering, can I replace that with our server IP?  Or is that trying to connect back somewhere else?

  • Anonymous
    Post count: 14

    Here are all the error logs from the last attempt

     

    [Fri Dec 29 13:36:29.389615 2017] [:error] [pid 31320] [client 10.125.252.136:62831] PHP Warning: fopen(/var/www/html/modules/directory/setup.txt): failed to open stream: Permission denied in /var/www/html/modules/directory/installer.php on line 153
    [Fri Dec 29 13:36:29.389696 2017] [:error] [pid 31320] [client 10.125.252.136:62831] PHP Warning: fwrite() expects parameter 1 to be resource, boolean given in /var/www/html/modules/directory/installer.php on line 154
    [Fri Dec 29 13:36:29.389711 2017] [:error] [pid 31320] [client 10.125.252.136:62831] PHP Warning: fclose() expects parameter 1 to be resource, boolean given in /var/www/html/modules/directory/installer.php on line 155
    [Fri Dec 29 13:36:29.398613 2017] [:error] [pid 31320] [client 10.125.252.136:62831] PHP Fatal error: Uncaught Error: Call to undefined function curl_init() in /var/www/html/core/abre_ping.php:23\nStack trace:\n#0 /var/www/html/modules/settings/installer.php(26): require()\n#1 /var/www/html/modules/settings/config.php(26): require(‘/var/www/html/m…’)\n#2 /var/www/html/core/abre_load_modules.php(42): require_once(‘/var/www/html/m…’)\n#3 /var/www/html/index.php(58): require_once(‘/var/www/html/c…’)\n#4 {main}\n thrown in /var/www/html/core/abre_ping.php on line 23
    [Fri Dec 29 13:36:29.446586 2017] [:error] [pid 31640] [client 10.125.252.136:62834] PHP Warning: fopen(/var/www/html/modules/apps/setup.txt): failed to open stream: Permission denied in /var/www/html/modules/apps/installer.php on line 115
    [Fri Dec 29 13:36:29.446789 2017] [:error] [pid 31640] [client 10.125.252.136:62834] PHP Warning: fwrite() expects parameter 1 to be resource, boolean given in /var/www/html/modules/apps/installer.php on line 116
    [Fri Dec 29 13:36:29.446805 2017] [:error] [pid 31640] [client 10.125.252.136:62834] PHP Warning: fclose() expects parameter 1 to be resource, boolean given in /var/www/html/modules/apps/installer.php on line 117
    [Fri Dec 29 13:36:29.458694 2017] [:error] [pid 31640] [client 10.125.252.136:62834] PHP Warning: fopen(/var/www/html/modules/directory/setup.txt): failed to open stream: Permission denied in /var/www/html/modules/directory/installer.php on line 153
    [Fri Dec 29 13:36:29.458742 2017] [:error] [pid 31640] [client 10.125.252.136:62834] PHP Warning: fwrite() expects parameter 1 to be resource, boolean given in /var/www/html/modules/directory/installer.php on line 154
    [Fri Dec 29 13:36:29.458755 2017] [:error] [pid 31640] [client 10.125.252.136:62834] PHP Warning: fclose() expects parameter 1 to be resource, boolean given in /var/www/html/modules/directory/installer.php on line 155
    [Fri Dec 29 13:36:29.464868 2017] [:error] [pid 31640] [client 10.125.252.136:62834] PHP Fatal error: Uncaught Error: Call to undefined function curl_init() in /var/www/html/core/abre_ping.php:23\nStack trace:\n#0 /var/www/html/modules/settings/installer.php(26): require()\n#1 /var/www/html/modules/settings/config.php(26): require(‘/var/www/html/m…’)\n#2 /var/www/html/core/abre_load_modules.php(42): require_once(‘/var/www/html/m…’)\n#3 /var/www/html/index.php(58): require_once(‘/var/www/html/c…’)\n#4 {main}\n thrown in /var/www/html/core/abre_ping.php on line 23

  • Anonymous
    Post count: 14

    Okay, ignore that, figured out that problem, I am into the home page.  I had to install curl extension.  However, my coworkers try and log in and they are faced with that repeating profile page that won’t let them out of it.

  • Brandon Wilson
    Participant
    Post count: 17

    Great! I was going to tell you to install the curl extension, so I am glad you did that. Try and have your coworkers select a stream and click done. This should solve the problem. We have a check in the code to make sure non super-admins are subscribed to at least 1 stream before moving them away from the profile page. We plan to remove this restriction with a release in the near future, however it is still present in today’s codebase.

    • Anonymous
      Post count: 14

      I am still stuck in a loop when it comes to selecting profile streams.  It will let me get through, however, no other users can get past the profile selection page.  When I look in the actual MySQL database, it is not writing the profiles to the database.  In the error logs, it is saying undefined variable and undefined index.

      [Tue Jan 02 09:47:28.938431 2018] [:error] [pid 11836] [client 10.125.252.136:50587] PHP Notice: Undefined variable: apps_order in /var/www/html/modules/apps/card.php on line 47, referer: http://abretest.tvsd.us/
      [Tue Jan 02 09:47:28.974904 2018] [:error] [pid 12014] [client 10.125.252.136:50576] PHP Notice: Undefined variable: setting_card_mail in /var/www/html/modules/profile/profile.php on line 122, referer: http://abretest.tvsd.us/

      • Brandon Wilson
        Participant
        Post count: 17

        Sorry for getting back to you so late Ben. I just want to confirm before we move forward; The others that are logging in have selected a stream and are still unable to get past the profile page?

        The error log you have posted here are just notices. They shouldn’t prevent anything from happening. Can you take another look at the logs and see if there are any fatal errors? I don’t suspect that there are any because I have replicated your scenario and don’t see any. Reply with some of this information and I will keep hunting a solution for you.

      • Anonymous
        Post count: 14

        https://drive.google.com/file/d/1Cuahc_K8wX4sn7-pB1KiNjREnm9XZmJ9/view?usp=sharing

         

        It seems as if Abre is not writing into the database.  Which seems weird since Abre created the tables int he database.  Here are all the error logs associated with that screen capture.  It is the same problem someone else on the forum had, which said it was resolved by installing CURL, however, I have CURL installed and that’s how I fixed the previous errors.

         

        Thanks again for everything.

        [Tue Jan 02 15:32:34.050000 2018] [:error] [pid 12319] [client 10.125.252.136:59629] PHP Notice: Undefined variable: profileupdatecount in /var/www/html/modules/profile/profile_update.php on line 66, referer: http://abretest.tvsd.us/
        [Tue Jan 02 15:32:34.050100 2018] [:error] [pid 12319] [client 10.125.252.136:59629] PHP Notice: Undefined index: checkbox_0 in /var/www/html/modules/profile/profile_update.php on line 68, referer: http://abretest.tvsd.us/
        [Tue Jan 02 15:32:34.050146 2018] [:error] [pid 12319] [client 10.125.252.136:59629] PHP Notice: Undefined index: checkbox_2 in /var/www/html/modules/profile/profile_update.php on line 68, referer: http://abretest.tvsd.us/
        [Tue Jan 02 15:32:34.050159 2018] [:error] [pid 12319] [client 10.125.252.136:59629] PHP Notice: Undefined index: checkbox_3 in /var/www/html/modules/profile/profile_update.php on line 68, referer: http://abretest.tvsd.us/
        [Tue Jan 02 15:32:35.183568 2018] [:error] [pid 12319] [client 10.125.252.136:59629] PHP Notice: Undefined variable: profileupdatecount in /var/www/html/modules/profile/profile_update.php on line 66, referer: http://abretest.tvsd.us/
        [Tue Jan 02 15:32:35.183619 2018] [:error] [pid 12319] [client 10.125.252.136:59629] PHP Notice: Undefined index: checkbox_0 in /var/www/html/modules/profile/profile_update.php on line 68, referer: http://abretest.tvsd.us/
        [Tue Jan 02 15:32:35.183638 2018] [:error] [pid 12319] [client 10.125.252.136:59629] PHP Notice: Undefined index: checkbox_3 in /var/www/html/modules/profile/profile_update.php on line 68, referer: http://abretest.tvsd.us/
        [Tue Jan 02 15:32:36.913810 2018] [:error] [pid 12319] [client 10.125.252.136:59629] PHP Notice: Undefined variable: streams in /var/www/html/modules/profile/check.php on line 29, referer: http://abretest.tvsd.us/
        [Tue Jan 02 15:32:40.479672 2018] [:error] [pid 12998] [client 10.125.252.136:59657] PHP Notice: Undefined variable: apps_order in /var/www/html/modules/apps/card.php on line 47, referer: http://abretest.tvsd.us/
        [Tue Jan 02 15:32:40.520198 2018] [:error] [pid 12319] [client 10.125.252.136:59629] PHP Notice: Undefined variable: setting_card_mail in /var/www/html/modules/profile/profile.php on line 122, referer: http://abretest.tvsd.us/
        [Tue Jan 02 15:32:40.520262 2018] [:error] [pid 12319] [client 10.125.252.136:59629] PHP Notice: Undefined variable: setting_card_drive in /var/www/html/modules/profile/profile.php on line 133, referer: http://abretest.tvsd.us/
        [Tue Jan 02 15:32:40.520274 2018] [:error] [pid 12319] [client 10.125.252.136:59629] PHP Notice: Undefined variable: setting_card_calendar in /var/www/html/modules/profile/profile.php on line 144, referer: http://abretest.tvsd.us/
        [Tue Jan 02 15:32:40.520285 2018] [:error] [pid 12319] [client 10.125.252.136:59629] PHP Notice: Undefined variable: setting_card_classroom in /var/www/html/modules/profile/profile.php on line 155, referer: http://abretest.tvsd.us/
        [Tue Jan 02 15:32:40.520295 2018] [:error] [pid 12319] [client 10.125.252.136:59629] PHP Notice: Undefined variable: setting_card_apps in /var/www/html/modules/profile/profile.php on line 166, referer: http://abretest.tvsd.us/
        [Tue Jan 02 15:32:40.521433 2018] [:error] [pid 12319] [client 10.125.252.136:59629] PHP Notice: Undefined variable: setting_streams in /var/www/html/modules/profile/profile.php on line 221, referer: http://abretest.tvsd.us/
        [Tue Jan 02 15:32:40.534664 2018] [:error] [pid 12319] [client 10.125.252.136:59629] PHP Notice: Undefined variable: streams in /var/www/html/modules/profile/check.php on line 29, referer: http://abretest.tvsd.us/
        [Tue Jan 02 15:32:41.905998 2018] [:error] [pid 12319] [client 10.125.252.136:59629] PHP Notice: Undefined variable: profileupdatecount in /var/www/html/modules/profile/profile_update.php on line 66, referer: http://abretest.tvsd.us/
        [Tue Jan 02 15:32:41.906053 2018] [:error] [pid 12319] [client 10.125.252.136:59629] PHP Notice: Undefined index: checkbox_0 in /var/www/html/modules/profile/profile_update.php on line 68, referer: http://abretest.tvsd.us/
        [Tue Jan 02 15:32:41.906072 2018] [:error] [pid 12319] [client 10.125.252.136:59629] PHP Notice: Undefined index: checkbox_2 in /var/www/html/modules/profile/profile_update.php on line 68, referer: http://abretest.tvsd.us/
        [Tue Jan 02 15:32:41.906083 2018] [:error] [pid 12319] [client 10.125.252.136:59629] PHP Notice: Undefined index: checkbox_3 in /var/www/html/modules/profile/profile_update.php on line 68, referer: http://abretest.tvsd.us/
        [Tue Jan 02 15:32:42.788578 2018] [:error] [pid 12319] [client 10.125.252.136:59629] PHP Notice: Undefined variable: profileupdatecount in /var/www/html/modules/profile/profile_update.php on line 66, referer: http://abretest.tvsd.us/
        [Tue Jan 02 15:32:42.788631 2018] [:error] [pid 12319] [client 10.125.252.136:59629] PHP Notice: Undefined index: checkbox_0 in /var/www/html/modules/profile/profile_update.php on line 68, referer: http://abretest.tvsd.us/
        [Tue Jan 02 15:32:42.788650 2018] [:error] [pid 12319] [client 10.125.252.136:59629] PHP Notice: Undefined index: checkbox_3 in /var/www/html/modules/profile/profile_update.php on line 68, referer: http://abretest.tvsd.us/
        [Tue Jan 02 15:32:43.627592 2018] [:error] [pid 12319] [client 10.125.252.136:59629] PHP Notice: Undefined variable: profileupdatecount in /var/www/html/modules/profile/profile_update.php on line 66, referer: http://abretest.tvsd.us/
        [Tue Jan 02 15:32:43.627641 2018] [:error] [pid 12319] [client 10.125.252.136:59629] PHP Notice: Undefined index: checkbox_0 in /var/www/html/modules/profile/profile_update.php on line 68, referer: http://abretest.tvsd.us/
        [Tue Jan 02 15:32:43.627660 2018] [:error] [pid 12319] [client 10.125.252.136:59629] PHP Notice: Undefined index: checkbox_3 in /var/www/html/modules/profile/profile_update.php on line 68, referer: http://abretest.tvsd.us/
        [Tue Jan 02 15:32:44.090291 2018] [:error] [pid 12319] [client 10.125.252.136:59629] PHP Notice: Undefined variable: profileupdatecount in /var/www/html/modules/profile/profile_update.php on line 66, referer: http://abretest.tvsd.us/
        [Tue Jan 02 15:32:44.090339 2018] [:error] [pid 12319] [client 10.125.252.136:59629] PHP Notice: Undefined index: checkbox_0 in /var/www/html/modules/profile/profile_update.php on line 68, referer: http://abretest.tvsd.us/
        [Tue Jan 02 15:32:44.090357 2018] [:error] [pid 12319] [client 10.125.252.136:59629] PHP Notice: Undefined index: checkbox_3 in /var/www/html/modules/profile/profile_update.php on line 68, referer: http://abretest.tvsd.us/
        [Tue Jan 02 15:32:45.021987 2018] [:error] [pid 12319] [client 10.125.252.136:59629] PHP Notice: Undefined variable: streams in /var/www/html/modules/profile/check.php on line 29, referer: http://abretest.tvsd.us/
        [Tue Jan 02 15:32:47.995905 2018] [:error] [pid 12066] [client 10.125.252.136:59687] PHP Notice: Undefined variable: apps_order in /var/www/html/modules/apps/card.php on line 47, referer: http://abretest.tvsd.us/
        [Tue Jan 02 15:32:48.030478 2018] [:error] [pid 12319] [client 10.125.252.136:59629] PHP Notice: Undefined variable: setting_card_mail in /var/www/html/modules/profile/profile.php on line 122, referer: http://abretest.tvsd.us/
        [Tue Jan 02 15:32:48.030532 2018] [:error] [pid 12319] [client 10.125.252.136:59629] PHP Notice: Undefined variable: setting_card_drive in /var/www/html/modules/profile/profile.php on line 133, referer: http://abretest.tvsd.us/
        [Tue Jan 02 15:32:48.030544 2018] [:error] [pid 12319] [client 10.125.252.136:59629] PHP Notice: Undefined variable: setting_card_calendar in /var/www/html/modules/profile/profile.php on line 144, referer: http://abretest.tvsd.us/
        [Tue Jan 02 15:32:48.030555 2018] [:error] [pid 12319] [client 10.125.252.136:59629] PHP Notice: Undefined variable: setting_card_classroom in /var/www/html/modules/profile/profile.php on line 155, referer: http://abretest.tvsd.us/
        [Tue Jan 02 15:32:48.030565 2018] [:error] [pid 12319] [client 10.125.252.136:59629] PHP Notice: Undefined variable: setting_card_apps in /var/www/html/modules/profile/profile.php on line 166, referer: http://abretest.tvsd.us/
        [Tue Jan 02 15:32:48.031998 2018] [:error] [pid 12319] [client 10.125.252.136:59629] PHP Notice: Undefined variable: setting_streams in /var/www/html/modules/profile/profile.php on line 221, referer: http://abretest.tvsd.us/
        [Tue Jan 02 15:32:48.042661 2018] [:error] [pid 12319] [client 10.125.252.136:59629] PHP Notice: Undefined variable: streams in /var/www/html/modules/profile/check.php on line 29, referer: http://abretest.tvsd.us/
        [Tue Jan 02 15:32:50.080775 2018] [:error] [pid 12319] [client 10.125.252.136:59629] PHP Notice: Undefined variable: profileupdatecount in /var/www/html/modules/profile/profile_update.php on line 66, referer: http://abretest.tvsd.us/
        [Tue Jan 02 15:32:50.080844 2018] [:error] [pid 12319] [client 10.125.252.136:59629] PHP Notice: Undefined index: checkbox_0 in /var/www/html/modules/profile/profile_update.php on line 68, referer: http://abretest.tvsd.us/
        [Tue Jan 02 15:32:50.080863 2018] [:error] [pid 12319] [client 10.125.252.136:59629] PHP Notice: Undefined index: checkbox_2 in /var/www/html/modules/profile/profile_update.php on line 68, referer: http://abretest.tvsd.us/
        [Tue Jan 02 15:32:50.080874 2018] [:error] [pid 12319] [client 10.125.252.136:59629] PHP Notice: Undefined index: checkbox_3 in /var/www/html/modules/profile/profile_update.php on line 68, referer: http://abretest.tvsd.us/
        [Tue Jan 02 15:32:50.981727 2018] [:error] [pid 12319] [client 10.125.252.136:59629] PHP Notice: Undefined variable: profileupdatecount in /var/www/html/modules/profile/profile_update.php on line 66, referer: http://abretest.tvsd.us/
        [Tue Jan 02 15:32:50.981772 2018] [:error] [pid 12319] [client 10.125.252.136:59629] PHP Notice: Undefined index: checkbox_0 in /var/www/html/modules/profile/profile_update.php on line 68, referer: http://abretest.tvsd.us/
        [Tue Jan 02 15:32:50.981791 2018] [:error] [pid 12319] [client 10.125.252.136:59629] PHP Notice: Undefined index: checkbox_3 in /var/www/html/modules/profile/profile_update.php on line 68, referer: http://abretest.tvsd.us/
        [Tue Jan 02 15:32:54.048261 2018] [:error] [pid 12319] [client 10.125.252.136:59629] PHP Notice: Undefined variable: streams in /var/www/html/modules/profile/check.php on line 29, referer: http://abretest.tvsd.us/
        [Tue Jan 02 15:32:55.927466 2018] [:error] [pid 12014] [client 10.125.252.136:59722] PHP Notice: Undefined variable: apps_order in /var/www/html/modules/apps/card.php on line 47, referer: http://abretest.tvsd.us/
        [Tue Jan 02 15:32:57.337380 2018] [:error] [pid 12319] [client 10.125.252.136:59629] PHP Notice: Undefined variable: setting_card_mail in /var/www/html/modules/profile/profile.php on line 122, referer: http://abretest.tvsd.us/
        [Tue Jan 02 15:32:57.337439 2018] [:error] [pid 12319] [client 10.125.252.136:59629] PHP Notice: Undefined variable: setting_card_drive in /var/www/html/modules/profile/profile.php on line 133, referer: http://abretest.tvsd.us/
        [Tue Jan 02 15:32:57.337451 2018] [:error] [pid 12319] [client 10.125.252.136:59629] PHP Notice: Undefined variable: setting_card_calendar in /var/www/html/modules/profile/profile.php on line 144, referer: http://abretest.tvsd.us/
        [Tue Jan 02 15:32:57.337462 2018] [:error] [pid 12319] [client 10.125.252.136:59629] PHP Notice: Undefined variable: setting_card_classroom in /var/www/html/modules/profile/profile.php on line 155, referer: http://abretest.tvsd.us/
        [Tue Jan 02 15:32:57.337472 2018] [:error] [pid 12319] [client 10.125.252.136:59629] PHP Notice: Undefined variable: setting_card_apps in /var/www/html/modules/profile/profile.php on line 166, referer: http://abretest.tvsd.us/
        [Tue Jan 02 15:32:57.338596 2018] [:error] [pid 12319] [client 10.125.252.136:59629] PHP Notice: Undefined variable: setting_streams in /var/www/html/modules/profile/profile.php on line 221, referer: http://abretest.tvsd.us/
        [Tue Jan 02 15:32:57.350114 2018] [:error] [pid 12319] [client 10.125.252.136:59629] PHP Notice: Undefined variable: streams in /var/www/html/modules/profile/check.php on line 29, referer: http://abretest.tvsd.us/

  • Anonymous
    Post count: 14

    It appears that this is happening with all the modules.  It is not writing into the corresponding tables.

    • Christopher Rose
      Keymaster
      Post count: 10

      Hello Ben,

      I’ve looked through your logs and don’t see any fatal errors (only notices). Abre was obviously able to create your tables during installation. Not sure why it wouldn’t be able to write to the database unless the permissions of the mysql user changed on your server.

      A couple of things that may be worth trying:

      • Try renaming the configuration.php file in the public root folder. When you visit your url you should be prompted to re-install (which will create a new configuration file). You could even give it a new database to see if it is able to create the tables and write to the database. If you try this an it doesn’t work you can send the configuration file to [email protected] and we can see how it performs on our servers.
      • Another option is to sign up for a free Cloudways account. This would allow you to have the LAMP environment set up automatically on AWS and run the community edition in the cloud. That way you wouldn’t need to spend time/energy configuring your LAMP environment. We test our installations very thoroughly on Cloudways and AWS LAMP instances. In the past we have had users of the community get a version up and running on Cloudways/AWS long enough to compare their settings to the managed hosting environment. Most of the time they are able to find the mysql/php setting that is causing the issue.

      I’m pretty certain if Abre isn’t able to write to the table then it’s a mysql user permission issue. I would recommend installing/using Abre with a root mysql account with full privileges at first just to troubleshoot.

      Hope this helps! Keep us posted.

  • Anonymous
    Post count: 14

    Thanks everyone for your help.  I was able to get ABRE up and running on a cloudways server.  I am trying to troubleshoot our hosted server by comparing the cloudways server.  The only difference that I can see that stands out to me is cloudways is using mysql 5.5 where as our server has mysql 5.7.  Could this be causing the problem?

    Also, are there any other extensions/add-ons that need to be installed, such as CURL?

    I also tried exporting the database from cloudways and importing into ours and still seeing the same behavior.  I am using a root account to connect to the DB with full privileges.

     

  • Brandon Wilson
    Participant
    Post count: 17

    Hi Ben!

    At this point it seems we have narrowed it down to a server configuration issue which makes it hard for us (the Abre team) to troubleshoot. However, I do have a couple ideas that may lead to something.

    • It seems you have done this, but ensure that the DB credentials you have for your root account match the values in your configuration.php file of Abre. These are the credentials used to make all DB connections throughout the system.
    • There are some other extensions that need to be installed alongside CURL. I am not sure if you have previously downloaded these, but if you haven’t it may be worth giving it a shot. Both Mcrypt and php gd library need to be installed on the server. Note: I don’t think either of these two libraries would be causing your SQL issue.

    If both of these are unsuccessful, send an email to [email protected] and we can discuss server specific solutions.

  • Anonymous
    Post count: 14

    I just wanted to give an update.  I was finally able to get it up and running on our servers.  To my best guess, the problem was running MYSQL 5.7 and not 5.5.  Once I was able to get MYSQL 5.5 installed, it seems most things are working now.

     

    Thanks again everyone for all your help.

    • Christopher Rose
      Keymaster
      Post count: 10

      Great to hear! We are here if you need us.

You must be logged in to reply to this topic.