sa2blv / SVXportal

A web portal for svxlink reflector
http://svxportal.sm2ampr.net/
19 stars 13 forks source link

Cannot log in and other issues #31

Closed f5vmr closed 1 year ago

f5vmr commented 1 year ago

New database Version 2.6 svxportal - All correctly configured as per .pdf. Cannot access database from log in on the portal front page - Wrong Database or password. config.php has correct details. Also Flag arrives "cannot connect to reflektor server"......which is odd because reflector_proxy is set as per instructions "http://192.168.1.213:8181/status" Both the Reflector, Portal and DB are on the same VM 192.168.1.213, however the external address svxportal-uk.ddns.net:81 does not connect, but displays less information than the IP address for the status . Strangely svxportal-uk.ddns.net:8181 displays the server content easily, but displays less information than the IP address for the status . All DNS settings are correct.

In case I made an error, I reinstalled the 2.4 and 2.5 versions, the results are the same. The previous versions all worked until the hard drive crash, so new eyes needed to see where I have gone wrong.

Fail no contact to proxy check serveradress in config.php HTTP_SRV_PORT in svxreflector.conf and reflector_proxy/config.php url fail arrives on the Log in test. The database created is good according to phpmyadmin, and passwords are set as requested.

sa2blv commented 1 year ago

i cant acess svxportal-uk.ddns.net:81 maby you have an NAT issue ?

f5vmr commented 1 year ago

Yes. I think now I may have misconfiguration in the proxmox server that gives access to the portal. Strangely g4nab.co.uk is visible and that is on another VM on the same server. However svxreflector is working and that relies on the same address.

Very odd. Chris

On Sun, 13 Aug 2023, 11:48 Peter, @.***> wrote:

i cant acess svxportal-uk.ddns.net:81 maby you have an NAT issue ?

— Reply to this email directly, view it on GitHub https://github.com/sa2blv/SVXportal/issues/31#issuecomment-1676317042, or unsubscribe https://github.com/notifications/unsubscribe-auth/ACAKA5ABPNMJL7N5GO4UYFDXVCWIBANCNFSM6AAAAAA3OREANI . You are receiving this because you authored the thread.Message ID: @.***>

f5vmr commented 1 year ago

Well it was the NAT, which I have corrected, but the DB is reports wrong name or password....Which I know are correct. Onward and upward. It will not accept root and the password there either which are also correct. Still showing 2.4 though which is odd!

f5vmr commented 1 year ago

Ok so I have resolved the NAT issue and the Svx reflector_proxy issue and that now works. I ran the install from SVXportal-uk.ddns.net and I got green from the test, but on entering the admin I so far have failed to access the database. But I suspect I haven’t read the default password correctly maybe?

Chris

On 13 Aug 2023, at 11:48, Peter @.***> wrote:

i cant acess svxportal-uk.ddns.net:81 maby you have an NAT issue ?

— Reply to this email directly, view it on GitHub https://github.com/sa2blv/SVXportal/issues/31#issuecomment-1676317042, or unsubscribe https://github.com/notifications/unsubscribe-auth/ACAKA5ABPNMJL7N5GO4UYFDXVCWIBANCNFSM6AAAAAA3OREANI. You are receiving this because you authored the thread.

sa2blv commented 1 year ago

It tested with default password and login worked from the adminin interface. i think you my have an php issue try run "php index.php" in terminal

f5vmr commented 1 year ago

This error - PHP Notice: Undefined index: is_admin in /var/www/html/admin.php on line 210

Chris

On 13 Aug 2023, at 16:32, Peter @.***> wrote:

It tested with default password and it worked from the adminin interface. i think you my have an php issue try run "php index.php" in terminal

— Reply to this email directly, view it on GitHub https://github.com/sa2blv/SVXportal/issues/31#issuecomment-1676393469, or unsubscribe https://github.com/notifications/unsubscribe-auth/ACAKA5HH3NKODQ6P4VZO2VLXVDXQRANCNFSM6AAAAAA3OREANI. You are receiving this because you authored the thread.

f5vmr commented 1 year ago

I need to tell you I am running PHP 8.0 with apache2

On 13 Aug 2023, at 16:32, Peter @.***> wrote:

It tested with default password and it worked from the adminin interface. i think you my have an php issue try run "php index.php" in terminal

— Reply to this email directly, view it on GitHub https://github.com/sa2blv/SVXportal/issues/31#issuecomment-1676393469, or unsubscribe https://github.com/notifications/unsubscribe-auth/ACAKA5HH3NKODQ6P4VZO2VLXVDXQRANCNFSM6AAAAAA3OREANI. You are receiving this because you authored the thread.

f5vmr commented 1 year ago

Oh yes and mariadb….- phpmyadmin access is good.

On 13 Aug 2023, at 16:32, Peter @.***> wrote:

It tested with default password and it worked from the adminin interface. i think you my have an php issue try run "php index.php" in terminal

— Reply to this email directly, view it on GitHub https://github.com/sa2blv/SVXportal/issues/31#issuecomment-1676393469, or unsubscribe https://github.com/notifications/unsubscribe-auth/ACAKA5HH3NKODQ6P4VZO2VLXVDXQRANCNFSM6AAAAAA3OREANI. You are receiving this because you authored the thread.

sa2blv commented 1 year ago

have you try login witdth user svxportal and svxportal or have you changed it ?

try run "php index.php" in terminal and write me the output

f5vmr commented 1 year ago

I think I may have the problem solution - In Visual Studio Code, I see that you have typed Is_admin and is_admin differently in some places. Is this deliberate? Or is it something to check?

Chris

On 13 Aug 2023, at 16:52, Peter @.***> wrote:

have you try login witdth user svxportal and svxportal or have you changed it ?

try run "php index.php" in terminal and write me the output

— Reply to this email directly, view it on GitHub https://github.com/sa2blv/SVXportal/issues/31#issuecomment-1676397772, or unsubscribe https://github.com/notifications/unsubscribe-auth/ACAKA5CK36M3LX4WVAUJMY3XVDZ2VANCNFSM6AAAAAA3OREANI. You are receiving this because you authored the thread.

sa2blv commented 1 year ago

this is not the problem you don't have the is_admin created until you login. this is an warning not en fault or error.

do this try run "php index.php" in terminal and write me the output

f5vmr commented 1 year ago

File user_action.php has it both ways…. Surely this is likely to be mis-interpreted?

Chris

On 13 Aug 2023, at 16:52, Peter @.***> wrote:

have you try login witdth user svxportal and svxportal or have you changed it ?

try run "php index.php" in terminal and write me the output

— Reply to this email directly, view it on GitHub https://github.com/sa2blv/SVXportal/issues/31#issuecomment-1676397772, or unsubscribe https://github.com/notifications/unsubscribe-auth/ACAKA5CK36M3LX4WVAUJMY3XVDZ2VANCNFSM6AAAAAA3OREANI. You are receiving this because you authored the thread.

f5vmr commented 1 year ago

It’s not working correctly. Clearly I have done something wrong - I’ll get back to you…. At least I’ve sorted the NAT. Chris

On 13 Aug 2023, at 16:52, Peter @.***> wrote:

have you try login witdth user svxportal and svxportal or have you changed it ?

try run "php index.php" in terminal and write me the output

— Reply to this email directly, view it on GitHub https://github.com/sa2blv/SVXportal/issues/31#issuecomment-1676397772, or unsubscribe https://github.com/notifications/unsubscribe-auth/ACAKA5CK36M3LX4WVAUJMY3XVDZ2VANCNFSM6AAAAAA3OREANI. You are receiving this because you authored the thread.

f5vmr commented 1 year ago

Ok I re-installed everything direct from your zip.

This is the result - I still cannot access the database with my created user and password.

I can with phpmyadmin

Chris

On 13 Aug 2023, at 16:56, Peter @.***> wrote:

this is not the problem you don't have the is_admin created until you login. this is an warning not en fault or error.

do this try run "php index.php" in terminal and write me the output

— Reply to this email directly, view it on GitHub https://github.com/sa2blv/SVXportal/issues/31#issuecomment-1676398639, or unsubscribe https://github.com/notifications/unsubscribe-auth/ACAKA5DOK3DG6BM5W27NFFDXVD2LRANCNFSM6AAAAAA3OREANI. You are receiving this because you authored the thread.

@.***:/var/www/html# php admin.php PHP Notice: Undefined index: languge in /var/www/html/function.php on line 83

<!DOCTYPE html>

SVX Portal 2.4 PHP Notice: Undefined index: is_admin in /var/www/html/admin.php on line 210

Sign In

sa2blv commented 1 year ago

how do you create your user ? witch feild are use setting and is the password md5 crypto ?

f5vmr commented 1 year ago

That's a good question. I haven't. I have been relying on the parameters of the database, user Svxportal with a password as the starting point. Is that wrong?

On Sun, 13 Aug 2023, 18:16 Peter, @.***> wrote:

how do you create your user ?

— Reply to this email directly, view it on GitHub https://github.com/sa2blv/SVXportal/issues/31#issuecomment-1676416233, or unsubscribe https://github.com/notifications/unsubscribe-auth/ACAKA5FC7Y7DPKJHP3DOZ4LXVEDV3ANCNFSM6AAAAAA3OREANI . You are receiving this because you authored the thread.Message ID: @.***>

sa2blv commented 1 year ago

it a svxportal and password svxportal ;) New sql files avalbe on git. new source files aswell

sa2blv commented 1 year ago

try this manual. we found some issues in some files. it shout work know! SvxPortal2.6.pdf

f5vmr commented 1 year ago

No, still not working..... I have created the database in mysql, with my own password, and I have run the install. With phpmyadmin I have checked that the user svxportal and his password svxportal has been created correctly, but using these to log into the admin page just produces "svxportal-uk.ddns.net:81 says Wrong username or password". I have followed the svx.sql and associated files. I have checked that everything is as it should be. I have verified everything with Visual Studio Code, and apart from the one code error I pointed out to the other Peter, I can see nothing obvious. I do see that the table User_premission is empty. Could this be the problem?

sa2blv commented 1 year ago

Sorry i don't understand the problem. Are you running 2.6? When i open your page http://svxportal-uk.ddns.net:81/ i see a 2.4 installation.

Have you installed the portal using this manual?

SvxPortal2.6.pdf

f5vmr commented 1 year ago

I cannot explain further. I have downloaded the zip file containing the 2.6 SQL change. I've used the latest pdf to create the install. I have followed the instructions to the letter. I cannot understand it either. Chris

On Sat, 19 Aug 2023 at 06:47, Peter @.***> wrote:

Sorry i don't understand the problem. Are you running 2.6? When i open your page http://svxportal-uk.ddns.net:81/ i see a 2.4 installation.

Have you installed the portal using this manual?

SvxPortal2.6.pdf https://github.com/sa2blv/SVXportal/files/12330345/SvxPortal2.6.pdf

— Reply to this email directly, view it on GitHub https://github.com/sa2blv/SVXportal/issues/31#issuecomment-1684838177, or unsubscribe https://github.com/notifications/unsubscribe-auth/ACAKA5AZMFNPSQLZXMHPBGTXWBHQPANCNFSM6AAAAAA3OREANI . You are receiving this because you authored the thread.Message ID: @.***>

f5vmr commented 1 year ago

I have correctly configured everything now - Not without cloning your repository and forcing the 2-6-beta to be the master. I had to repeat every stage, and everything worked. I can only suggest that git clone took the master rather than the new repository. All I need to find out now is how the update works as that did not appear to have happened.

f5vmr commented 1 year ago

Register Button does not function when trying to create a user to access.

f5vmr commented 1 year ago

Found a typo - Search for element_id...... in a couple of places it is elenent_id

sa2blv commented 1 year ago

even if it is a typo in the source code it maybe by for the variable to have an unikness, so we don't have conflict between JS and PHP