New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

daloRADIUS PHP-7 Support #5

Closed
lirantal opened this Issue Jul 8, 2016 · 49 comments

Comments

Projects
None yet
@lirantal
Owner

lirantal commented Jul 8, 2016

How to get daloRADIUS to work in PHP-7?

Dependencies

  • This assumes an Ubuntu 16.04 OS installled
  • This assumes PHP 7 installed
  • This assumes MySQL >= 5.7.5 installed
  • This assumes you have already installed all the LAMP related packages and have a working LAMP environment.
    Next, is to make sure you have the required extra packages for daloRADIUS, run:
sudo apt-get install php-common php-gd php-curl php-mail php-mail-mime php-pear php-db

and then

pear install DB

daloRADIUS internal change

Changing file library/daloradius.conf.php

It's required to update daloRADIUS's database connection code so that it identifies the MySQL server using the new and improved mysqli driver:

  1. Open for editing the file library/daloradius.conf.php and locate the configuration variable CONFIG_DB_ENGINE and change it to the value of mysqli (it is now probably set to mysql, notice the extra i). It should end up looking as follows: $configValues['CONFIG_DB_ENGINE'] = 'mysqli';

Changing file library/opendb.php

  1. Open for editing the file library/opendb.php
  2. At the very end of the file just add this new line of code: $dbSocket->query("SET GLOBAL sql_mode = '';"); which makes the MySQL version work with less strict SQL syntax

@lirantal lirantal self-assigned this Jul 8, 2016

@lirantal lirantal added the bug label Jul 8, 2016

@lirantal lirantal closed this in #6 Jul 9, 2016

@lirantal

This comment has been minimized.

Show comment
Hide comment
@lirantal

lirantal Jul 9, 2016

Owner

Re-opening for issue to be pinned at the top for everyone to consult

Owner

lirantal commented Jul 9, 2016

Re-opening for issue to be pinned at the top for everyone to consult

@lirantal lirantal reopened this Jul 9, 2016

@Riply

This comment has been minimized.

Show comment
Hide comment
@Riply

Riply Aug 18, 2016

Thanks for this man.
I'm still getting the error, but at least I'm that little bit closer!

Riply commented Aug 18, 2016

Thanks for this man.
I'm still getting the error, but at least I'm that little bit closer!

@lirantal

This comment has been minimized.

Show comment
Hide comment
@lirantal

lirantal Aug 18, 2016

Owner

@Riply np. what error are you getting?

Owner

lirantal commented Aug 18, 2016

@Riply np. what error are you getting?

@Riply

This comment has been minimized.

Show comment
Hide comment
@Riply

Riply Aug 19, 2016

(:

On the http://xxxxyyyzzzz/dologin.php page, I'm getting:

Database connection error
Error Message: DB Error: connect failed

Even after making your suggested changes.

edit:

Ah. Having a look at the debug..
root@auth1:/var/log/mysql# tail -f error.log
2016-08-19T06:44:04.894817Z 18 [Note] Access denied for user 'radiusauth'@'localhost' (using password: YES)

edit:

Confirmed working! Thanks for the tutorial mate! I had not given sufficient priv to the user xD

Riply commented Aug 19, 2016

(:

On the http://xxxxyyyzzzz/dologin.php page, I'm getting:

Database connection error
Error Message: DB Error: connect failed

Even after making your suggested changes.

edit:

Ah. Having a look at the debug..
root@auth1:/var/log/mysql# tail -f error.log
2016-08-19T06:44:04.894817Z 18 [Note] Access denied for user 'radiusauth'@'localhost' (using password: YES)

edit:

Confirmed working! Thanks for the tutorial mate! I had not given sufficient priv to the user xD

@lirantal

This comment has been minimized.

Show comment
Hide comment
@lirantal

lirantal Aug 19, 2016

Owner

@Riply which version of daloRADIUS? MySQL? PHP? etc can you provide these details?
In a nutshell it seems you don't have the correct settings to connect to the MySQL database in library/daloradius.conf.php

Owner

lirantal commented Aug 19, 2016

@Riply which version of daloRADIUS? MySQL? PHP? etc can you provide these details?
In a nutshell it seems you don't have the correct settings to connect to the MySQL database in library/daloradius.conf.php

@Riply

This comment has been minimized.

Show comment
Hide comment
@Riply

Riply Aug 22, 2016

It was even worse that that - I had the wrong user stipulated in the library/daloradius.conf.php.. it didn't have permissions to use the DB.

Riply commented Aug 22, 2016

It was even worse that that - I had the wrong user stipulated in the library/daloradius.conf.php.. it didn't have permissions to use the DB.

@lirantal

This comment has been minimized.

Show comment
Hide comment
@lirantal

lirantal Aug 22, 2016

Owner

Ok thanks for the update. Just noticed now that you updated your previous comment.

Owner

lirantal commented Aug 22, 2016

Ok thanks for the update. Just noticed now that you updated your previous comment.

@amlluch

This comment has been minimized.

Show comment
Hide comment
@amlluch

amlluch Aug 23, 2016

Now I can access to Daloradius after applying the changes but I can't change any value of the database. If I try change a reply value for a user or anything else I get an error 500. I have read that may be an error with pear-db. Has anyone the same issue?

Thanks in advance

amlluch commented Aug 23, 2016

Now I can access to Daloradius after applying the changes but I can't change any value of the database. If I try change a reply value for a user or anything else I get an error 500. I have read that may be an error with pear-db. Has anyone the same issue?

Thanks in advance

@lirantal

This comment has been minimized.

Show comment
Hide comment
@lirantal

lirantal Aug 23, 2016

Owner

@amlluch never heard of it... not even on the forums on SF.

Owner

lirantal commented Aug 23, 2016

@amlluch never heard of it... not even on the forums on SF.

@NCKCN

This comment has been minimized.

Show comment
Hide comment
@NCKCN

NCKCN Aug 23, 2016

Liran, Same exact thing here as amlluch with Apache throwing a 500 error. Everything appeared to work initially. Was able to add a new User, add a new Profile, add an Filter-ID Attribute to that Profile. Then nothing can be written to the database...
Ubuntu 16.04.2
daloRADIUS version 0.9.9
MySQL version 5.7.13
Apache version 2.4.18
PHP version7.0.8

Thanks

#Edit
Liran, I did notice a warning on "pear install DB", Ubuntu stated this was being Deprecated. "WARNING: "pear/DB" is deprecated in favor of "pear/MDB2"

NCKCN commented Aug 23, 2016

Liran, Same exact thing here as amlluch with Apache throwing a 500 error. Everything appeared to work initially. Was able to add a new User, add a new Profile, add an Filter-ID Attribute to that Profile. Then nothing can be written to the database...
Ubuntu 16.04.2
daloRADIUS version 0.9.9
MySQL version 5.7.13
Apache version 2.4.18
PHP version7.0.8

Thanks

#Edit
Liran, I did notice a warning on "pear install DB", Ubuntu stated this was being Deprecated. "WARNING: "pear/DB" is deprecated in favor of "pear/MDB2"

@amlluch

This comment has been minimized.

Show comment
Hide comment
@amlluch

amlluch Aug 24, 2016

More on this ... I can add a new user but I can't change any value. I can't clear sessions disconnected but hanged on the data base. Not sure if this helps.

amlluch commented Aug 24, 2016

More on this ... I can add a new user but I can't change any value. I can't clear sessions disconnected but hanged on the data base. Not sure if this helps.

@NCKCN

This comment has been minimized.

Show comment
Hide comment
@NCKCN

NCKCN Aug 24, 2016

amlluch, exact same here. Apache always throws a PHP error such as: "PHP Fatal error: Uncaught Error: Call to undefined function split() in /var/www/html/mng-rad-profiles-edit.php:53\nStack trace:\n#0 {main}\n thrown in /var/www/html/mng-rad-profiles-edit.php on line 53, referer: https://radius.nck-wifi.com/mng-rad-profiles-edit.php?profile=NCK-WiFi-Guest".

Tried the pear/MDB2 and that broke everything.

NCKCN commented Aug 24, 2016

amlluch, exact same here. Apache always throws a PHP error such as: "PHP Fatal error: Uncaught Error: Call to undefined function split() in /var/www/html/mng-rad-profiles-edit.php:53\nStack trace:\n#0 {main}\n thrown in /var/www/html/mng-rad-profiles-edit.php on line 53, referer: https://radius.nck-wifi.com/mng-rad-profiles-edit.php?profile=NCK-WiFi-Guest".

Tried the pear/MDB2 and that broke everything.

@lirantal

This comment has been minimized.

Show comment
Hide comment
@lirantal

lirantal Aug 24, 2016

Owner

Can you revert back to the Pear DB driver and then continue testing?
The issue with split is that it's deprecated in PHP 7:
image

I'll evaluate what's the required effort to refactor the split function to fix this.

Owner

lirantal commented Aug 24, 2016

Can you revert back to the Pear DB driver and then continue testing?
The issue with split is that it's deprecated in PHP 7:
image

I'll evaluate what's the required effort to refactor the split function to fix this.

@NCKCN

This comment has been minimized.

Show comment
Hide comment
@NCKCN

NCKCN Aug 24, 2016

Liran, already switched back to Pear DB. Thanks for the quick response!

NCKCN commented Aug 24, 2016

Liran, already switched back to Pear DB. Thanks for the quick response!

@amlluch

This comment has been minimized.

Show comment
Hide comment
@amlluch

amlluch Aug 26, 2016

when I try to delete a user staled, on /var/log/apache2/error.log I get:

[Fri Aug 26 10:48:12.451397 2016] [:error] [pid 14461] [client xxx.xx.xx.xxx:59869] PHP Fatal error: Uncaught Error: Call to undefined function split() in /var/www/daloradius/mng-del.php:157\nStack trace:\n#0 {main}\n thrown in /var/www/daloradius/mng-del.php on line 157, referer: http://radius.anonymousvpn.es/rep-online.php?usernameOnline=

May be this could help.

amlluch commented Aug 26, 2016

when I try to delete a user staled, on /var/log/apache2/error.log I get:

[Fri Aug 26 10:48:12.451397 2016] [:error] [pid 14461] [client xxx.xx.xx.xxx:59869] PHP Fatal error: Uncaught Error: Call to undefined function split() in /var/www/daloradius/mng-del.php:157\nStack trace:\n#0 {main}\n thrown in /var/www/daloradius/mng-del.php on line 157, referer: http://radius.anonymousvpn.es/rep-online.php?usernameOnline=

May be this could help.

@amlluch

This comment has been minimized.

Show comment
Hide comment
@amlluch

amlluch Aug 26, 2016

Ok ... finally I fixed the error changing at line 157 of /var/www/daloradius/mng-del.php from split('||', $value) to explode('||', $value)

The point is that there are many erros with php7. I get errors in more places, mainly using "split" function. I am trying to change that for fixing it.

amlluch commented Aug 26, 2016

Ok ... finally I fixed the error changing at line 157 of /var/www/daloradius/mng-del.php from split('||', $value) to explode('||', $value)

The point is that there are many erros with php7. I get errors in more places, mainly using "split" function. I am trying to change that for fixing it.

@NCKCN

This comment has been minimized.

Show comment
Hide comment
@NCKCN

NCKCN Aug 26, 2016

amlluch, I think Liran is working on fixing the PHP code for an updated release of the daloRADIUS if I understood his post correctly? I'll bet he'll get back with us an put out a new version with all the corrected old split functions. Since he's the one who knows all the "under the hood" stuff, I'll wait for this input. In the meantime, Liran, let us know if you need us to test anything on our end. :)

NCKCN commented Aug 26, 2016

amlluch, I think Liran is working on fixing the PHP code for an updated release of the daloRADIUS if I understood his post correctly? I'll bet he'll get back with us an put out a new version with all the corrected old split functions. Since he's the one who knows all the "under the hood" stuff, I'll wait for this input. In the meantime, Liran, let us know if you need us to test anything on our end. :)

lirantal added a commit that referenced this issue Aug 27, 2016

Replacing deprecated split function
Replacing deprecated split function in PHP7 with explode() or preg_split()
Fixes #5
@lirantal

This comment has been minimized.

Show comment
Hide comment
@lirantal

lirantal Aug 27, 2016

Owner

Hey guys @amlluch , @NCKCN
I fixed the issues in this PR #8 - can you please test the fix there? you need to checkout that branch locally and test it. Will you handle doing that?

It should fix the PHP7 errors with the split function because I replaced all occurrences of it.
I need someone to confirm that it's fixed so I can merge it to the master branch.

Owner

lirantal commented Aug 27, 2016

Hey guys @amlluch , @NCKCN
I fixed the issues in this PR #8 - can you please test the fix there? you need to checkout that branch locally and test it. Will you handle doing that?

It should fix the PHP7 errors with the split function because I replaced all occurrences of it.
I need someone to confirm that it's fixed so I can merge it to the master branch.

@NCKCN

This comment has been minimized.

Show comment
Hide comment
@NCKCN

NCKCN Aug 27, 2016

Liran,
Updated the 18 files, restarted and I see no errors. Doing some more thorough testing and let you know if I do see any anomalies. Are they any specific functions/features you want tested? Excellent work my friend!

NCKCN commented Aug 27, 2016

Liran,
Updated the 18 files, restarted and I see no errors. Doing some more thorough testing and let you know if I do see any anomalies. Are they any specific functions/features you want tested? Excellent work my friend!

@lirantal

This comment has been minimized.

Show comment
Hide comment
@lirantal

lirantal Aug 27, 2016

Owner

Awesome! thanks for the feedback @NCKCN
Would be great if you can generally just test through-out the functionality and see if there are PHP7 related issues and I'll be happy to apply some more fixes.

Happy to help :)

Owner

lirantal commented Aug 27, 2016

Awesome! thanks for the feedback @NCKCN
Would be great if you can generally just test through-out the functionality and see if there are PHP7 related issues and I'll be happy to apply some more fixes.

Happy to help :)

@NCKCN

This comment has been minimized.

Show comment
Hide comment
@NCKCN

NCKCN Aug 27, 2016

Liran,
I've pretty much threw everything that I have configured for my part, and seems to be working like a champ. Granted, I don't have all the bells and whistles, but functioning exactly as my PHP5.6 install. I'd say you have the split error exploded >;0

NCKCN commented Aug 27, 2016

Liran,
I've pretty much threw everything that I have configured for my part, and seems to be working like a champ. Granted, I don't have all the bells and whistles, but functioning exactly as my PHP5.6 install. I'd say you have the split error exploded >;0

@lirantal

This comment has been minimized.

Show comment
Hide comment
@lirantal

lirantal Aug 28, 2016

Owner

LOL

Cool, so thanks a lot in helping test this out.

On Aug 28, 2016 01:48, "NCKCN" notifications@github.com wrote:

Liran,
I've pretty much threw everything that I have configured for my part, and
seems to be working like a champ. Granted, I don't have all the bells and
whistles, but functioning exactly as my PHP5.6 install. I'd say you have
the split error exploded >;0


You are receiving this because you modified the open/close state.
Reply to this email directly, view it on GitHub
#5 (comment),
or mute the thread
https://github.com/notifications/unsubscribe-auth/AATT05t3DYFm__2fSNpMqzfNZnTbU1VYks5qkL7agaJpZM4JIV7d
.

Owner

lirantal commented Aug 28, 2016

LOL

Cool, so thanks a lot in helping test this out.

On Aug 28, 2016 01:48, "NCKCN" notifications@github.com wrote:

Liran,
I've pretty much threw everything that I have configured for my part, and
seems to be working like a champ. Granted, I don't have all the bells and
whistles, but functioning exactly as my PHP5.6 install. I'd say you have
the split error exploded >;0


You are receiving this because you modified the open/close state.
Reply to this email directly, view it on GitHub
#5 (comment),
or mute the thread
https://github.com/notifications/unsubscribe-auth/AATT05t3DYFm__2fSNpMqzfNZnTbU1VYks5qkL7agaJpZM4JIV7d
.

@lirantal lirantal closed this in #8 Aug 29, 2016

@hmachine1999

This comment has been minimized.

Show comment
Hide comment
@hmachine1999

hmachine1999 Sep 3, 2016

its help me solve troubles,thx

hmachine1999 commented Sep 3, 2016

its help me solve troubles,thx

@amlluch

This comment has been minimized.

Show comment
Hide comment
@amlluch

amlluch Oct 18, 2016

Hi Liran ... everything was working more or less fine but after making a dist-upgrade I get again next error:

Database connection error
Error Message: DB Error: connect failed

Not sure what can I do

amlluch commented Oct 18, 2016

Hi Liran ... everything was working more or less fine but after making a dist-upgrade I get again next error:

Database connection error
Error Message: DB Error: connect failed

Not sure what can I do

@lirantal

This comment has been minimized.

Show comment
Hide comment
@lirantal

lirantal Oct 19, 2016

Owner

That's very vague, I can't really understand what is going on.
Possibly your database is down? the db has changed? access details (user/pass) changed?

Owner

lirantal commented Oct 19, 2016

That's very vague, I can't really understand what is going on.
Possibly your database is down? the db has changed? access details (user/pass) changed?

@bredis

This comment has been minimized.

Show comment
Hide comment
@bredis

bredis Dec 2, 2016

lirantal, thank you.
For its setting the problem figured out all the instructions on the Ubuntu.
Everything works, thank you.https://github.com/lirantal/daloradius/issues/11

bredis commented Dec 2, 2016

lirantal, thank you.
For its setting the problem figured out all the instructions on the Ubuntu.
Everything works, thank you.https://github.com/lirantal/daloradius/issues/11

@lirantal

This comment has been minimized.

Show comment
Hide comment
@lirantal

lirantal Dec 3, 2016

Owner

@bredis awesome, happy you got it working! :)

Owner

lirantal commented Dec 3, 2016

@bredis awesome, happy you got it working! :)

@plnavarro76

This comment has been minimized.

Show comment
Hide comment
@plnavarro76

plnavarro76 Feb 26, 2017

It works for me. Thanks!! Ubuntu 16.04 server.

plnavarro76 commented Feb 26, 2017

It works for me. Thanks!! Ubuntu 16.04 server.

@lirantal

This comment has been minimized.

Show comment
Hide comment
@lirantal

lirantal Mar 3, 2017

Owner

Great, happy to hear

Owner

lirantal commented Mar 3, 2017

Great, happy to hear

@zukimonster

This comment has been minimized.

Show comment
Hide comment
@zukimonster

zukimonster May 10, 2017

I'm getting the following:
PHP Parse error: syntax error, unexpected ';', expecting ',' or ')' in /var/www/html/daloradius/library/opendb.php

I've got PHP 7.0.15 cli, and apache2 is using php 7.

zukimonster commented May 10, 2017

I'm getting the following:
PHP Parse error: syntax error, unexpected ';', expecting ',' or ')' in /var/www/html/daloradius/library/opendb.php

I've got PHP 7.0.15 cli, and apache2 is using php 7.

@lirantal

This comment has been minimized.

Show comment
Hide comment
@lirantal

lirantal May 10, 2017

Owner

@zukimonster you omitted the most important debug info - which line is it complaining about? :)

Owner

lirantal commented May 10, 2017

@zukimonster you omitted the most important debug info - which line is it complaining about? :)

@lirantal

This comment has been minimized.

Show comment
Hide comment
@lirantal

lirantal May 10, 2017

Owner

@zukimonster I can't find any such static code analysis issues on that file.
Can you make sure you pulled the latest code from the master branch and try again? If it happens please be more verbose in the error you provide

Owner

lirantal commented May 10, 2017

@zukimonster I can't find any such static code analysis issues on that file.
Can you make sure you pulled the latest code from the master branch and try again? If it happens please be more verbose in the error you provide

@zukimonster

This comment has been minimized.

Show comment
Hide comment
@zukimonster

zukimonster May 10, 2017

[:error] [pid 29920] [client ip:port] PHP Parse error: syntax error, unexpected ';', expecting ',' or ')' in /var/www/html/daloradius/library/opendb.php on line 97, referer: http://server.ip/daloradius/login.php

line 97: $dbSocket->query("SET GLOBAL sql_mode = ";");

edit:
oops, the second quotation mark should be two single apostrophes. I had used code from another how-to website. I'll fix it and try that.

zukimonster commented May 10, 2017

[:error] [pid 29920] [client ip:port] PHP Parse error: syntax error, unexpected ';', expecting ',' or ')' in /var/www/html/daloradius/library/opendb.php on line 97, referer: http://server.ip/daloradius/login.php

line 97: $dbSocket->query("SET GLOBAL sql_mode = ";");

edit:
oops, the second quotation mark should be two single apostrophes. I had used code from another how-to website. I'll fix it and try that.

@zukimonster

This comment has been minimized.

Show comment
Hide comment
@zukimonster

zukimonster May 11, 2017

Now I'm getting:

Database connection error
Error Message: DB Error: connect failed

zukimonster commented May 11, 2017

Now I'm getting:

Database connection error
Error Message: DB Error: connect failed

@lirantal

This comment has been minimized.

Show comment
Hide comment
@lirantal

lirantal May 12, 2017

Owner

can you check your database details to figure it out?
would be good if you can also look into mysql log or anything else that gives an idea for why the connection failed.

Owner

lirantal commented May 12, 2017

can you check your database details to figure it out?
would be good if you can also look into mysql log or anything else that gives an idea for why the connection failed.

@amuiruri

This comment has been minimized.

Show comment
Hide comment
@amuiruri

amuiruri May 18, 2017

@lirantal I am new in github, where can I download all daloradius files working with php7 without errors ??

amuiruri commented May 18, 2017

@lirantal I am new in github, where can I download all daloradius files working with php7 without errors ??

@lirantal

This comment has been minimized.

Show comment
Hide comment
@lirantal

lirantal May 18, 2017

Owner

if you're new to git/github and you don't know how to clone a project you can also just click the green button and choose to download a .zip file of the current 'master' branch. unzip it can continue regularly...
daloradius-download

Owner

lirantal commented May 18, 2017

if you're new to git/github and you don't know how to clone a project you can also just click the green button and choose to download a .zip file of the current 'master' branch. unzip it can continue regularly...
daloradius-download

@amuiruri

This comment has been minimized.

Show comment
Hide comment
@amuiruri

amuiruri commented May 18, 2017

Thanks @lirantal

@bhesterberg78

This comment has been minimized.

Show comment
Hide comment
@bhesterberg78

bhesterberg78 May 23, 2017

Your php7 trick worked, I can now log into daloradius and navigate it. It seems I can create a new user as well, but when I go to "List Users" under "Users Management", I get the following error...
Error Message: DB Error: unknown error
Debug info: SELECT distinct(radcheck.username),radcheck.value, radcheck.id,radusergroup.groupname as groupname, attribute FROM radcheck LEFT JOIN radusergroup ON radcheck.username=radusergroup.username WHERE (Attribute='Auth-Type') or (Attribute LIKE '%-Password') GROUP BY UserName [nativecode=1055 ** Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'radius.radcheck.value' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by]

Can anyone help with this?

bhesterberg78 commented May 23, 2017

Your php7 trick worked, I can now log into daloradius and navigate it. It seems I can create a new user as well, but when I go to "List Users" under "Users Management", I get the following error...
Error Message: DB Error: unknown error
Debug info: SELECT distinct(radcheck.username),radcheck.value, radcheck.id,radusergroup.groupname as groupname, attribute FROM radcheck LEFT JOIN radusergroup ON radcheck.username=radusergroup.username WHERE (Attribute='Auth-Type') or (Attribute LIKE '%-Password') GROUP BY UserName [nativecode=1055 ** Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'radius.radcheck.value' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by]

Can anyone help with this?

@lirantal

This comment has been minimized.

Show comment
Hide comment
@lirantal

lirantal May 25, 2017

Owner

Not sure about that, sorry. Either the schema doesn't match anymore the query or it's related to the sql_mode we set.

Can you investigate and let me know if you find a fix for it?

Owner

lirantal commented May 25, 2017

Not sure about that, sorry. Either the schema doesn't match anymore the query or it's related to the sql_mode we set.

Can you investigate and let me know if you find a fix for it?

@Sailing74

This comment has been minimized.

Show comment
Hide comment
@Sailing74

Sailing74 Aug 13, 2017

Running into the same issue.
The error message some other place is Database error Error Message: DB Error: unknown error Debug info: SET GLOBAL sql_mode = ''; [nativecode=1227 ** Access denied; you need (at least one of) the SUPER privilege(s) for this operation]
That gave me a pretty good hint. Apparently, the user I was using did not have sufficient rights for the work around. I granted all rights to the user, and the error messages - including the one reported by @bhesterberg78 - are gone. Maybe this helps someone.

Sailing74 commented Aug 13, 2017

Running into the same issue.
The error message some other place is Database error Error Message: DB Error: unknown error Debug info: SET GLOBAL sql_mode = ''; [nativecode=1227 ** Access denied; you need (at least one of) the SUPER privilege(s) for this operation]
That gave me a pretty good hint. Apparently, the user I was using did not have sufficient rights for the work around. I granted all rights to the user, and the error messages - including the one reported by @bhesterberg78 - are gone. Maybe this helps someone.

@Sailing74

This comment has been minimized.

Show comment
Hide comment
@Sailing74

Sailing74 Aug 13, 2017

Ok, now I'm running into other php7 related issues reported here, mostly regarding split () so far. I'm using 0.9.9 currently. Which branch should I check out? Master? Feature/daloradius-php7-support?

Sailing74 commented Aug 13, 2017

Ok, now I'm running into other php7 related issues reported here, mostly regarding split () so far. I'm using 0.9.9 currently. Which branch should I check out? Master? Feature/daloradius-php7-support?

@lirantal

This comment has been minimized.

Show comment
Hide comment
@lirantal

lirantal Aug 13, 2017

Owner

just master, that should be compatible with php7.
let me know which issues you're having.

Owner

lirantal commented Aug 13, 2017

just master, that should be compatible with php7.
let me know which issues you're having.

@Carlospenate

This comment has been minimized.

Show comment
Hide comment
@Carlospenate

Carlospenate Oct 12, 2017

It works for me, thanks!

Carlospenate commented Oct 12, 2017

It works for me, thanks!

@lirantal

This comment has been minimized.

Show comment
Hide comment
@lirantal

lirantal Oct 12, 2017

Owner

Awesome :-)

Owner

lirantal commented Oct 12, 2017

Awesome :-)

@crgl2002

This comment has been minimized.

Show comment
Hide comment
@crgl2002

crgl2002 May 10, 2018

Liran, Thans for such a good work.
Ive followed PR #8 fix and got a problem, cannot disconnect users. The error One of NAS Address, NAS Port or NAS Secret fields were left empty
Looking at apache error log:
Undefined index: customAttributes in /var/www/daloradius-0.9-9/config-maint-disconnect-user.php on line 194
Undefined variable: customAttributes in /var/www/daloradius-0.9-9/config-maint-disconnect-user.php on line 195
What Im doing wrong or missing?
Thanks.

crgl2002 commented May 10, 2018

Liran, Thans for such a good work.
Ive followed PR #8 fix and got a problem, cannot disconnect users. The error One of NAS Address, NAS Port or NAS Secret fields were left empty
Looking at apache error log:
Undefined index: customAttributes in /var/www/daloradius-0.9-9/config-maint-disconnect-user.php on line 194
Undefined variable: customAttributes in /var/www/daloradius-0.9-9/config-maint-disconnect-user.php on line 195
What Im doing wrong or missing?
Thanks.

@lirantal

This comment has been minimized.

Show comment
Hide comment
@lirantal

lirantal May 11, 2018

Owner

Hey @crgl2002

Looks like they are just warnings.
Regardless seems you're using the tar'ed package downloaded from SF so I suggest cloning the master's branch repository here and working with that instead.

Owner

lirantal commented May 11, 2018

Hey @crgl2002

Looks like they are just warnings.
Regardless seems you're using the tar'ed package downloaded from SF so I suggest cloning the master's branch repository here and working with that instead.

@crgl2002

This comment has been minimized.

Show comment
Hide comment
@crgl2002

crgl2002 May 11, 2018

Hi Liran, may be they are but the user is not disconnected. This started to happen after I updated to php7. I m new to github, downloading the .zip file and unzip it will keep all actual configs? Thanks.

crgl2002 commented May 11, 2018

Hi Liran, may be they are but the user is not disconnected. This started to happen after I updated to php7. I m new to github, downloading the .zip file and unzip it will keep all actual configs? Thanks.

@lirantal

This comment has been minimized.

Show comment
Hide comment
@lirantal

lirantal May 11, 2018

Owner

So you can download the zip from GitHub too and try it.
Don't forget to make a backup of the existing daloRADIUS directory and then just copy over the config files

Owner

lirantal commented May 11, 2018

So you can download the zip from GitHub too and try it.
Don't forget to make a backup of the existing daloRADIUS directory and then just copy over the config files

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment