Skip to content
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

[URGENT!!! HELP ]after logged in its redirect back to login page unable to log in and see dashboard, v3.1.3 #1985

Open
anik4good opened this issue Oct 18, 2024 · 13 comments

Comments

@anik4good
Copy link

image

i have uploaded the image after log in its redirect back to this page, I tested with PHP 7.2 and 7.4 still same issue

@anik4good anik4good changed the title after logged in its redirect back to login page unable to log in and see dashboard, v3.1.3 [URGENT!!! HELP ]after logged in its redirect back to login page unable to log in and see dashboard, v3.1.3 Oct 18, 2024
@shoulders
Copy link
Owner

let me have a think an ge back to you

@anik4good
Copy link
Author

thanks do you need any information from me ? i am using windows 11 and laragon
I tested with MySQL 5.7 and MySQL 8.0 still the same whenever I try to login it redirect me but if I use wrong password it gives me error that password is wrong , also in my db there is info for users
image

@shoulders
Copy link
Owner

  • Most of my testing was done on Xampp (php/MariaDB).
  • I have never used laragon but I will try over the week end to get that installed and see what is happing.
  • There might be an issue with the hashing algorithm

I want to get my next version out soon which has a massive amount of fixes.

@anik4good
Copy link
Author

I'm using the MD5 hashing algorithm for passwords, and I've noticed that Laragon and XAMPP are pretty similar since both come with PHP, Apache, and MySQL. I've followed all the steps and made the necessary modifications to the database, and everything went smoothly during the installation—no errors at all! However, when I tried to log in, I ran into an issue. I'm hoping to figure it out soon!

@shoulders
Copy link
Owner

I don't have the code open but it might be the session handling is not working and it needs swapping to database.

I think in the qwcrm config there is a variable called session handler, make sure this is set to "database"

@anik4good
Copy link
Author

anik4good commented Oct 18, 2024

this is the config

<?php
class QConfig
{
    public $db_host = 'localhost';
    public $db_name = 'test_db';
    public $db_user = 'root';
    public $db_pass = '';
    public $db_prefix = 'vykl_';
    public $sef = '0';
    public $gzip = '0';
    public $maintenance = '0';
    public $theme_name = 'default';
    public $default_language = 'en_GB';
    public $autodetect_language = '1';
    public $google_server = 'https://www.google.com/';
    public $email_online = '1';
    public $email_mailer = 'phpmail';
    public $email_mailfrom = '[email protected]';
    public $email_fromname = 'From QWcrm';
    public $email_replyto = '';
    public $email_replytoname = 'Reply to QWcrm';
    public $email_sendmail_path = '/usr/sbin/sendmail';
    public $email_smtp_host = 'localhost';
    public $email_smtp_port = '25';
    public $email_smtp_security = '';
    public $email_smtp_auth = '0';
    public $email_smtp_username = '';
    public $email_smtp_password = '';
    public $secret_key = 'WkF5pnvbsgWUIFs5YrkWq2DSKYxzkDSP';
    public $force_ssl = '0';
    public $recaptcha = '0';
    public $recaptcha_site_key = '';
    public $recaptcha_secret_key = '';
    public $session_handler = 'database';
    public $session_lifetime = '1440';
    public $shared_session = '0';
    public $remember_me = '1';
    public $cookie_lifetime = '60';
    public $cookie_token_length = '16';
    public $cookie_domain = '';
    public $cookie_path = '';
    public $workorder_history_notes = '0';
    public $qwcrm_access_log = '0';
    public $qwcrm_activity_log = '0';
    public $qwcrm_error_log = '0';
    public $qwcrm_sql_logging = '0';
    public $qwcrm_email_error_log = '0';
    public $qwcrm_email_transport_log = '0';
    public $error_reporting = 'default';
    public $error_page_raw_output = '0';
    public $error_handler_whoops = '1';
    public $qwcrm_debug = '0';
    public $qwcrm_advanced_debug = '0';
    public $qwcrm_smarty_debugging = '0';
    public $smarty_debugging = '0';
    public $smarty_debugging_ctrl = 'NONE';
    public $smarty_force_compile = '0';
    public $smarty_force_cache = '0';
    public $smarty_caching = '0';
    public $smarty_cache_lifetime = '3600';
    public $smarty_cache_modified_check = '0';
    public $smarty_cache_locking = '0';
}

yes it sets to database

this is my db config
image

image

@shoulders
Copy link
Owner

you should be using php 7.4

@anik4good
Copy link
Author

anik4good commented Oct 18, 2024

i changed to php 7.4

image

image

@shoulders
Copy link
Owner

thanks for the heads up., leave it with me.

@anik4good
Copy link
Author

Thank you for your prompt response and support on this matter. I appreciate getting good news from you soon.

@shoulders
Copy link
Owner

is STRICT_TRANS_TABLES enables on you DB server?

This will not be an issue in the new version.

Try turning debug on and see if it gives you any errors when logging.

  • enable php errors

tar

@shoulders
Copy link
Owner

also my version I have running seems to be on php 7.3 which is not ideal but with no errors. I think 7.4 works but with exceptions and some minor issues.

@shoulders
Copy link
Owner

does this do the same thing on Xampp. I am just putting together my dev setup.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants