Run pytest from anywhere in the bench directory

[0xsirsaif]

The issue arises when connecting to the site, as the Database class attempts to access the database logger module (e.g., database.log). Within the logger module, the problem is attributed to the incorrect configuration of log_filename, which is currently dependent on a specific directory. This setup only functions properly when running pytest from the sites/ directory.

You can find the problematic code at the following location:
https://github.com/frappe/frappe/blob/bad161ad89412c162def3a9938a51c6bf2ce0484/frappe/utils/logger.py#L61

In essence, the issue stems from the log_filename configuration in the logger.py module, which lacks flexibility and is not adaptable to different directory structures.