Login tools MySQL issues
Posted: Wed Jul 22, 2020 12:42 am
Just need a bit of help with setup. Not sure what the problem might be but I am sure it is a simple fix.
Used the sample Login tool with a local file and it works as advertised. My problem started when I switched to the MySQL database.
I am using a localhost setup as follows:
Wampserver64 ver 3.2.0,
Apache 2.4.41,
PHP 7.3.12, (maybe using the wrong version?)
MySQL 8.0.18 (the MySQL setup is using port 3308)
I set up the login tool as follows:
Behavior
Admin Password: ********
Database
MySQL Database Name: 'opus20' (with all privileges turned on)
MySQL Password: '********' (tried with and without)
MySQL Server: 'localhost:3308' (also used 'localhost' by itself to no avail)
MySQL Table Name: 'users'
MySQL Username: 'opus20net'
Publishing the Login tools to Wampserver www folder (login) with all pages with the PHP file extension selected and document type as HTML 5 (also tried HTML 4.01 Transitional).
Accessing the site (localhost/login) (Microsoft Edge) everything seems to work until I access the "User Administrator" page. No errors are reported (no database connection fails) but the "User Administrator" Login box is missing. So I cannot log in and/or add any users. Added a user to the database manually, with no changes to the website's behavior. Tried login in using that user and received a "Fatal error: Uncaught Error: Call to undefined mysql_connect() in E:..." so this tells me is not connecting to the database but it does not show any fails in the 'User Administration' page. When publishing the same website to my server (actual website server) I get the same behavior. Seems to connect to the database but something is missing.
No code was altered, just following the tutorial as is.
I know is something very obvious but I can't seem to narrow it down.
Any help will be greatly appreciated.
Thank you in advance.
Used the sample Login tool with a local file and it works as advertised. My problem started when I switched to the MySQL database.
I am using a localhost setup as follows:
Wampserver64 ver 3.2.0,
Apache 2.4.41,
PHP 7.3.12, (maybe using the wrong version?)
MySQL 8.0.18 (the MySQL setup is using port 3308)
I set up the login tool as follows:
Behavior
Admin Password: ********
Database
MySQL Database Name: 'opus20' (with all privileges turned on)
MySQL Password: '********' (tried with and without)
MySQL Server: 'localhost:3308' (also used 'localhost' by itself to no avail)
MySQL Table Name: 'users'
MySQL Username: 'opus20net'
Publishing the Login tools to Wampserver www folder (login) with all pages with the PHP file extension selected and document type as HTML 5 (also tried HTML 4.01 Transitional).
Accessing the site (localhost/login) (Microsoft Edge) everything seems to work until I access the "User Administrator" page. No errors are reported (no database connection fails) but the "User Administrator" Login box is missing. So I cannot log in and/or add any users. Added a user to the database manually, with no changes to the website's behavior. Tried login in using that user and received a "Fatal error: Uncaught Error: Call to undefined mysql_connect() in E:..." so this tells me is not connecting to the database but it does not show any fails in the 'User Administration' page. When publishing the same website to my server (actual website server) I get the same behavior. Seems to connect to the database but something is missing.
No code was altered, just following the tutorial as is.
I know is something very obvious but I can't seem to narrow it down.
Any help will be greatly appreciated.
Thank you in advance.