lbausch / sqlgreygui Goto Github PK

hello
Do you have a config Nginx on the subject?
thank you
mz

thanks for this gem!

running composer.phar update results in

{"error":{"type":"Symfony\\Component\\Debug\\Exception\\FatalErrorException","message":"Class 'Stolz\\Assets\\ManagerServiceProvider' not found","file":"\/home\/ma\/public_html\/web\/sqlgreygui\/vendor\/laravel\/framework\/src\/Illuminate\/Foundation\/ProviderRepository.php","line":157}}Script php artisan clear-compiled handling the post-update-cmd event returned with an error

after changing composer.json to:

"require": { "laravel/framework": "4.2.*", "rcrowe/twigbridge": "0.6.*", "stolz/assets": "0.0.9", "components/jquery": "1.11.*@dev",

it worked.

Hi,

I'm trying to get this nice software working on a current system:

• Ubuntu 22.04 LTS
• Apache/2.4.52
• mysql Ver 8.0.29-0ubuntu0.22.04.3
• PHP 8.1.2
• Composer 2.2.6

when running composer I get a lot of problems:

Problem 1
- doctrine/annotations is locked to version v1.4.0 and an update of this package was not requested.
- doctrine/annotations v1.4.0 requires php ^5.6 || ^7.0 -> your php version (8.1.2) does not satisfy that requirement.
Problem 2
- doctrine/cache is locked to version v1.6.2 and an update of this package was not requested.
- doctrine/cache v1.6.2 requires php ~5.5|~7.0 -> your php version (8.1.2) does not satisfy that requirement.
Problem 3
- doctrine/collections is locked to version v1.4.0 and an update of this package was not requested.
- doctrine/collections v1.4.0 requires php ^5.6 || ^7.0 -> your php version (8.1.2) does not satisfy that requirement.
Problem 4
- doctrine/common is locked to version v2.7.3 and an update of this package was not requested.
- doctrine/common v2.7.3 requires php ~5.6|~7.0 -> your php version (8.1.2) does not satisfy that requirement.
Problem 5
- ramsey/uuid is locked to version 3.7.1 and an update of this package was not requested.
- ramsey/uuid 3.7.1 requires php ^5.4 || ^7.0 -> your php version (8.1.2) does not satisfy that requirement.
Problem 6
- tijsverkoyen/css-to-inline-styles is locked to version 2.2.0 and an update of this package was not requested.
- tijsverkoyen/css-to-inline-styles 2.2.0 requires php ^5.5 || ^7 -> your php version (8.1.2) does not satisfy that requirement.
Problem 7
- zendframework/zend-diactoros is locked to version 1.6.1 and an update of this package was not requested.
- zendframework/zend-diactoros 1.6.1 requires php ^5.6 || ^7.0 -> your php version (8.1.2) does not satisfy that requirement.
Problem 8
- doctrine/common v2.7.3 requires php ~5.6|~7.0 -> your php version (8.1.2) does not satisfy that requirement.
- doctrine/dbal v2.5.13 requires doctrine/common >=2.4,<2.8-dev -> satisfiable by doctrine/common[v2.7.3].
- doctrine/dbal is locked to version v2.5.13 and an update of this package was not requested.

when trying to ignore these messages I got this next:

PHP Fatal error: During inheritance of ArrayAccess: Uncaught ErrorException: Return type of Illuminate\Http\Request::offsetExists($offset) should either be compatible with ArrayAccess::offsetExists(mixed $offset): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /root/lbausch-SQLgreyGUI-e870588/vendor/laravel/framework/src/Illuminate/Http/Request.php:552

Is there a way to make it work in 2022 ?

`root@rex:/var/www/SQLgreyGUI# npm update laravel-mix
root@rex:/var/www/SQLgreyGUI# npm install && npm run prod
npm WARN lifecycle undefined~postinstall: cannot run in wd %s %s (wd=%s) undefined yarn run prod /var/www/SQLgreyGUI
up to date in 12.943s

@ prod /var/www/SQLgreyGUI
npm run production

@ production /var/www/SQLgreyGUI
cp resources/assets/js/vue-strap/utils.js node_modules/vue-strap/src/utils/utils.js && cross-env NODE_ENV=production node_modules/webpack/bin/webpack.js --hide-modules --config=node_modules/laravel-mix/setup/webpack.config.js

ERROR Failed to compile with 3 errors 18:56:13

These dependencies were not found:

• /var/www/SQLgreyGUI/resources/assets/js/app.js in multi ./resources/assets/js/app.js ./resources/assets/sass/style.scss
• /var/www/SQLgreyGUI/resources/assets/js/public.js in multi ./resources/assets/js/public.js
• /var/www/SQLgreyGUI/resources/assets/sass/style.scss in multi ./resources/assets/js/app.js ./resources/assets/sass/style.scss

To install them, you can run: npm install --save /var/www/SQLgreyGUI/resources/assets/js/app.js /var/www/SQLgreyGUI/resources/assets/js/public.js /var/www/SQLgreyGUI/resources/assets/sass/style.scss
Asset Size Chunks Chunk Names
/js/vendor.js 432 kB 0 [emitted] [big] /js/vendor
/js/public.js 147 bytes 1 [emitted] /js/public
/js/app.js 250 bytes 2 [emitted] /js/app
/js/manifest.js 1.39 kB 3 [emitted] /js/manifest
npm ERR! code ELIFECYCLE
npm ERR! errno 2
npm ERR! @ production: cp resources/assets/js/vue-strap/utils.js node_modules/vue-strap/src/utils/utils.js && cross-env NODE_ENV=production node_modules/webpack/bin/webpack.js --hide-modules --config=node_modules/laravel-mix/setup/webpack.config.js
npm ERR! Exit status 2
npm ERR!
npm ERR! Failed at the @ production script.
npm ERR! This is probably not a problem with npm. There is likely additional logging output above.

npm ERR! A complete log of this run can be found in:
npm ERR! /root/.npm/_logs/2017-07-11T16_56_13_877Z-debug.log
npm ERR! code ELIFECYCLE
npm ERR! errno 2
npm ERR! @ prod: npm run production
npm ERR! Exit status 2
npm ERR!
npm ERR! Failed at the @ prod script.
npm ERR! This is probably not a problem with npm. There is likely additional logging output above.

npm ERR! A complete log of this run can be found in:
npm ERR! /root/.npm/_logs/2017-07-11T16_56_13_892Z-debug.log
root@rex:/var/www/SQLgreyGUI#
`

Hello
Config Nginx

server {
listen 80;

    server_name domain.com ;

    root   /var/www/domain.com/web/public;

    index index.html index.htm index.php index.cgi index.pl index.xhtml;

error_log /var/log/nginx/sqlgreygui-error.log;
    access_log /var/log/nginx/sqlgreygui-access.log combined;

location / {
    include /etc/nginx/nbs.rules;
    try_files $uri $uri/ /index.php?$query_string;
}

location ~ \.php$ {
        try_files /2998dc8fd5163833957da292dc5b3062.htm @php;
    }

    location @php {
    include /etc/nginx/fastcgi_params;
        fastcgi_pass unix:/var/run/php5-fpm.sock;
        fastcgi_index index.php;
        fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
        #fastcgi_intercept_errors on;
    }

}

Mz

Hi,

I would love to use SQLgreyGUI, but after installation I go to the URL and get this message:
Whoops, looks like something went wrong.

My .env file looks like this:

APP_ENV=production
APP_DEBUG=false
APP_URL=http://myurl:80
APP_TIMEZONE=Europe/Amsterdam
APP_KEY=23456kjhg34j653g51234565645

# database for SQLgreyGUI
# if you want to use a single database for both SQLgreyGUI and SQLgrey
# use only this config block
DB_HOST=localhost
DB_DATABASE=sqlgrey
DB_USERNAME=sqlgrey
DB_PASSWORD=**********

# Uncomment the following lines if SQLgrey resides in a different database
#SQLGREY_DB_HOST=null
#SQLGREY_DB_DATABASE=null
#SQLGREY_DB_USERNAME=null
#SQLGREY_DB_PASSWORD=null

CACHE_DRIVER=file
SESSION_DRIVER=file
QUEUE_DRIVER=sync

MAIL_DRIVER=mail
MAIL_HOST=mailtrap.io
MAIL_PORT=2525
MAIL_USERNAME=null
MAIL_PASSWORD=null
MAIL_ENCRYPTION=null

ASSETS_PIPELINE=auto

I use Ubuntu Server 14.04, Apache2 and Mysql
During the installation there were no errors.

Can you help me?

My .env :
`

Database for SQLgreyGUI

If you want to use a single database for both SQLgreyGUI and SQLgrey use only this config block

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=sqlgrey
DB_USERNAME=sqlgrey
DB_PASSWORD=XXX

Uncomment the following lines if SQLgrey resides in a different database

SQLGREY_DB_CONNECTION=postgresql
SQLGREY_DB_HOST=127.0.0.1
SQLGREY_DB_PORT=5432
SQLGREY_DB_DATABASE=sqlgrey
SQLGREY_DB_USERNAME=sqlgrey
SQLGREY_DB_PASSWORD=XXX
`
Log:

[2017-07-12 11:54:33] production.ERROR: exception 'PDOException' with message 'SQLSTATE[HY000] [2003] Can't connect to MySQL server on '127.0.0.1' (4)' in /var/www/SQLgreyGUI/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:43 Stack trace: #0 /var/www/SQLgreyGUI/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(43): PDO->__construct('mysql:host=127....', 'sqlgrey', 'XXX', Array)

While registering I get a few mails from spotify that are greylisted. When I try to whitelist them, the first one is whitelisted, all the others give this error:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '208.117.49-news.spotifymail.com-bounces+898596-add9-user=domain.' for key 'PRIMARY' (SQL: insert into from_awl (sender_name, sender_domain, src, first_seen, last_seen) values (bounces+898596-add9-user=domain.nl, news.spotifymail.com, 208.117.49, 2016-02-08 11:19:05, 2016-02-08 11:19:05))

Can you help me?

Hello,

I came across your gui - which looks very nice :)

yet I have no clue about how to get it running with nginx...

you have a .htaccess with rewrite rules in int for apache - if they are not avaible, then SQLGreyGUI refuses to work.

Is there a possibility to turn off "CleanURLs" which seems to be turned on by default? Just to have for example the plain old php style ?q=somthin after .php in SQLGreyGUI?

Thanks in advance,
-Paul

Fresh install, no errors so far. When I try to hit the public directory, I simply get a 404..

The requested URL /sqlgrey/public/login was not found on this server.

Looked through the zip and didn't see anything missing. Hopefully it's just a simple error on my part...

I successfully upgraded and used php 7.3, but php 7.4 breaks SQLgreyGUI with the helpful error;
whoops.. something went wrong
There's nothing in the apache or mysql error logs. I tried re-running composer;

composer install --no-dev Deprecation warning: Your package name lbausch/SQLgreyGUI is invalid, it should not contain uppercase characters. We suggest using lbausch/sq-lgrey-gui instead. Make sure you fix this as Composer 2.0 will error.
Loading composer repositories with package information
Installing dependencies from lock file
Nothing to install or update

[ErrorException]
file_put_contents(/var/www/html/adm/SQLgreyGUI/vendor/composer/installed.js
on): failed to open stream: Permission denied

install [--prefer-source] [--prefer-dist] [--dry-run] [--dev] [--no-dev] [--no-custom-installers] [--no-autoloader] [--no-scripts] [--no-progress] [--no-suggest] [-v|vv|vvv|--verbose] [-o|--optimize-autoloader] [-a|--classmap-authoritative] [--apcu-autoloader] [--ignore-platform-reqs] [--] [<packages>]...

What other info would be helpful to debug this further ?