Support Forums - All Posts - XOOPS Web Application System

21

Re: New users: cannot register with firefox, chrome, can with explorer

2019/12/17 21:06
rossb
Just popping in
Posts: 77
Since: 2006/8/28

certs OK and current;

guess you're implying turn off tracking protection. Chrome has same?

will turn off and get back to you once I drain another swamp...

If this is the issue, is xoops working on compliance?

Thanks;
Bill

22

New users: cannot register with firefox, chrome, can with explorer

2019/12/17 12:24
rossb
Just popping in
Posts: 77
Since: 2006/8/28

Title sez it all...

Minimum PHP required: 5.5 (your version is 5.6.40)
MYSQL Minimum version required: 5.5 (your version is 5.5.60)
Minimum XOOPS required: 2.5.9 (your version is 2.5.9)
Minimum ModuleAdmin required: 1.2 (your version is 1.2)

What may be a bug:

At first I had a conflict with duplicate registration email address (already had another user with same email). Symptoms:
firefox, chrome: no error message informing me of this. Kept returning to basic registration page.
explorer: got duplicate email message.

Did this:
deleted offending user from user and session db tables
checked all file ownership / permissions - OK
deleted all entries in session table
cleared xoops and browser caches, cookies included.
restarted browsers

Stuck here:
firefox, chrome, keeps returning to basic registration page.
explorer, can register new users OK, email sent, can complete registration.

I have searched the forums / docs. What is lacking is a current checklist for debugging registration issues. Have tried all suggestions, to no avail.

Have run out of ideas apart from recommending explorer on my site. Hate windoze and, recommending it is "not me".

Anyone have suggestions?

Site: www.rossco.org

Thanks;
Bill

23

Re: Oledrion(ecommerce) RC2 update available for testing / blessing (mamba?)

2019/12/16 13:04
rossb
Just popping in
Posts: 77
Since: 2006/8/28

sorry Mamba;

getting Oledrion working blew my schedule. No time for forking about:)

Regards;
Bill

24

Oledrion(ecommerce) RC2 update available for testing / blessing (mamba?)

2019/12/15 13:09
rossb
Just popping in
Posts: 77
Since: 2006/8/28

Changes:

- rossbcan: www.rossco.org
- cleaned up dead / commented code
- changed minimum xoops version to 2.5.9
- re-worked gateway / paypal code
- fixed gateway classname bug
- fixed paypal intermittent failures due to pcntl_fork child losing DB connection at parent exit
- added "Note to Vendor" field in checkout and email templates - persian not done
- (sql init) changed product_recommended DATETIME init value to '1970-01-01 00:00:01' for broader DB compatability
- added example DB update script (update_sales.php) for updating other DB's when product is sold (OLEDRION_DB_UPDATE_SCRIPT)
- (sql/mysql.sql) pre-populated several db tables: missing, no UI or UI failure at entry
- fgrep -r "TODO" modules/oledrion for to do suggestions
- this module needs major theming updates - make it pretty
- "somebody" needs to document paypal account setup

Download:
https://www.rossco.org/Downloads/OpenWrt/Files/oledrion-2.35_RC2.tar.gz

RC1 -> RC2 Patch:
https://www.rossco.org/Downloads/OpenWrt/Files/oledrion_rc2.patch


Hello,



This email informs you of a new order on the website.

The user's IP was x.y.z.aa



- Order number : 51

- Transaction ID : 2B953910EC258071J

- Details on the client :

First name and last name : Ross 

Address : 

Post code and town : noe1l0 Oakland

country : United States

Telephone : 

Email : hidden

Note to Vendor : another note



Invoice wanted : Yes





- Order details :

Product's Title                                                  Qty     Price      Shipping

---------------------------------------------------------------------------------------------

1     SecureOffice Repository Access - annual        1          $20.00 





Total $20.00







This email was automatically generated, please do not reply.

-------------------------

SecureOffice (https://www.rossco.dynu.com/)

Site www.rossco.org will be going live for sales in a week or so. Thus far, only known e-commerce site using oledrion.

Enjoy;
Bill

25

Re: Really NOT a stupid php / sql problem

2019/12/14 11:44
rossb
Just popping in
Posts: 77
Since: 2006/8/28

I caused the problem in the first place. No longer fork is the solution I chose for oledrion-2.35_RC2 which I will be releasing a patch set for after testing is complete.

26

Re: How to create a new xoopsDB connection - from scratch

2019/12/13 18:06
rossb
Just popping in
Posts: 77
Since: 2006/8/28

Thanks geekwright.

Got it working.
Needed:
$xoopsDB = XoopsDatabaseFactory::getDatabaseConnection(); -without this, hangs
$xoopsDB->conn = new mysqli( XOOPS_DB_HOST, XOOPS_DB_USER, XOOPS_DB_PASS, XOOPS_DB_NAME );

and, after all the hassle, using pcntl_fork, shaved 200milliseconds off return to paypal. Max observed transaction time is < 2 seconds; paypal requires < 30 seconds.

hardly worth it; so paypal callback is now single process / thread.

...B

27

How to create a new xoopsDB connection - from scratch

2019/12/12 22:01
rossb
Just popping in
Posts: 77
Since: 2006/8/28

Hi;

I am using pcntl_fork and ran into this issue:
https://www.php.net/manual/en/function.pcntl-fork.php#70721
- no database connection in child, after parent exits.

so; I need a new db connection and am not sure how to do so properly.

something along lines of:


$xoopsDB = new XoopsMySQLDatabase();

$xoopsDB->connect();

just need to know the "proper way"

Anyone?
Thanks;
Bill

28

Progress: Re: Really stupid php / sql problem

2019/12/12 21:56
rossb
Just popping in
Posts: 77
Since: 2006/8/28

OK; starting to make sense.

Code forks to return to return paypal callback quickly (they spec 30 seconds max). Parent returns immediately, child (time consuming work) does db updates, sends confirmation emails, etc.

apparently, when the parent exits, db connection is closed after an indeterminate time. This causes a race condition where child may or may not have a db connection.

It is a known "issue":
https://www.php.net/manual/en/function.pcntl-fork.php#70721

Starting a new thread regarding how to get a new database connection within the child process.

I'll leave it to the reader to decide whether it is a stupid problem or coder...

29

Re: Really stupid php / sql problem

2019/12/12 20:04
rossb
Just popping in
Posts: 77
Since: 2006/8/28

Thanks; caught that one already. Not the issue.

Issue is: code is called out of site context by paypal callback.
...and, it forks to offload processing.

All attempts to use database fail: "MySQL server has gone away", even though db object exists.

have run outa theories....

30

Re: Really stupid php / sql problem

2019/12/11 15:48
rossb
Just popping in
Posts: 77
Since: 2006/8/28

Here's the EXACT code that is failing:


public static function getUsersFromGroup($groupId)

    {

        /** @var XoopsMemberHandler $memberHandler */

        $memberHandler = xoops_getHandler('member');

        file_put_contents(OLEDRION_GATEWAY_LOG_PATH, "memberHandler: " . print_r($memberHandler,true) . "n", FILE_APPEND | LOCK_EX);

        $users         = $memberHandler->getUsersByGroup($groupId, true);

        file_put_contents(OLEDRION_GATEWAY_LOG_PATH, "users: " . print_r($users,true) . "n", FILE_APPEND | LOCK_EX);

        return $users;

    }



    /**

     * Retourne la liste des emails des utilisateurs membres d'un groupe

     *

     * @param $groupId

     * @return array Emails list

     * @internal param int $group_id Group's number

     */

    public static function getEmailsFromGroup($groupId)

    {

        $ret = [];

        file_put_contents(OLEDRION_GATEWAY_LOG_PATH, "groupId: " . print_r($groupId) . "n", FILE_APPEND | LOCK_EX);

        $member_handler = xoops_getHandler('member');

        $user_ids = static::getUsersFromGroup($groupId);

        file_put_contents(OLEDRION_GATEWAY_LOG_PATH, "users_ids: " . print_r($user_ids,true) . "n", FILE_APPEND | LOCK_EX);

        foreach ($user_ids as $user_id) {

            //$user = $member_handler->getUser($user_id);

            $user = $member_handler->getUsers(null, true);

            $ret[] = $user->getVar('email');

        }



        file_put_contents(OLEDRION_GATEWAY_LOG_PATH, "ret: " .  print_r($ret,true) . "n", FILE_APPEND | LOCK_EX);

        return $ret;

    }

Stats
Goal:	$100.00
Due Date:	Apr 30
Gross Amount:	$0.00
Net Balance:	$0.00
Left to go:	$100.00

Forum Index

Re: New users: cannot register with firefox, chrome, can with explorer

New users: cannot register with firefox, chrome, can with explorer

Re: Oledrion(ecommerce) RC2 update available for testing / blessing (mamba?)

Oledrion(ecommerce) RC2 update available for testing / blessing (mamba?)

Re: Really NOT a stupid php / sql problem

Re: How to create a new xoopsDB connection - from scratch

How to create a new xoopsDB connection - from scratch

Progress: Re: Really stupid php / sql problem

Re: Really stupid php / sql problem

Re: Really stupid php / sql problem

Login

Search

Recent Posts

Re: Rebuilding and Updating a 20 years old Xoops Website from 2.0.18? to 2.5.11

Rebuilding and Updating a 20 years old Xoops Website from 2.0.18? to 2.5.11

Re: NewBB v 5.1.0 b 6

Re: NewBB v 5.1.0 b 6

NewBB v 5.1.0 b 6

Re: XOOPS 2.5.11 search user is not working

Re: oledrion

Re: oledrion

Re: oledrion

Re: oledrion

Who's Online

Donat-O-Meter

Latest GitHub Commits

{{ record.sha.slice(0, 7) }} - {{ record.commit.message | truncate }}