as per the developer this seems to be a issue with configuration

https://pasteboard.co/Kj1NAaR.jpg

@girish @nebulon

Please assist with this it has been months and months now haven’t beeen able to get messaging working on pixelfed yet

@nebulon

I have up on Wordpress because it doesn’t send users who registers the confirmation email I tried various plugins it doesn’t work either although smtp is set up correctly other mails like forgot password etc works fine but i red to manually validate users who registers to site is a headache it’s a lame Wordpress has this issue of not sending confirmation email to users who am registers

@nebulon

Same instance but there is this issue where the site health in Wordpress says need ftp credentials and permissions are not set

@girish

After installing managed Wordpress and trying to repair Wordpress on Wordpress dashboard it asks for ftp credentials

Please take a look on the screenshots below

@jdaviescoates

Thank you for the reply

However I tried clearing safari history and cache it gives me the same message yet and server not found black screen

It took a while to show up I have no idea what went wrong seems like dns or browser issue

Thanks

Hello my main domain is spacemag.xyz

I was doing a Wordpress site on a sub domain
study.spacemag.xyz was using it for 3-4 days
Then I wanted to uninstall the app and reinstall it again using AppStore of cloudron on the same sub domain but after the fresh Wordpress installation had completed it says

You are seeing this page because this domain points to Cloudron server IP but no app is installed on that domain

I noticed this doesnt happen when I choose a different sub domain for example

somethingelse.spacemag.xyz

But when i install it on study.spacemag.xyz it gives me the above mentioned

You are seeing this page because this domain points to Cloudron server IP but no app is installed on that domain

@girish

@girish

Please take a look

https://github.com/pixelfed/pixelfed/issues/2752#

And the following

https://github.com/pixelfed/pixelfed/commit/2d0a253e071280c692b14516a6aac8d6c33c44d5

Daniel informed that he is using MySQL however the issue of sending messsges yet persists it’s still there not able to send messages yet

Hello I’m using iPhone 7 i know it’s not the latest device I’m really interested in playing PUBG mobile but when i start playing when i go to combat mode from lobby my network changes from 4G to 3G and im not able to win a match whether it’s a tdm or classic any idea of what’s going on?

@girish

Could you please update the pixelfed app to latest Daniel has updated to version 0.11.0 when I check for updates on dashboard it doesn’t do anything it still shows 0.10.0 as the latest

https://github.com/pixelfed/pixelfed

@girish

Following is the GitHub link

https://github.com/pixelfed/pixelfed/issues/2729#issuecomment-837986008

@girish

Reporting from GitHub

“

I was able to reproduce the direct message issue within a docker container, and I think I know why it is happening.

In these lines in the account controller, the following SQL query is generated:

[2021-05-10 21:41:58] local.DEBUG: array (
0 =>
array (
'query' => 'select * from profiles where id != ? and profiles.id = ? and profiles.deleted_at is null limit 1',
'bindings' =>
array (
0 => 297440899045134336,
1 => '297465207490482176',
),
'time' => 37.91,
),
)
As you can see, the id in the URL gets treated as string and that's why the query does not return any results.
I made a preliminary patch on this branch with int casts wherever necessary and it resolves the issue locally, but there must be some sort of underlying issue that needs to be investigated to tell why this stopped working
“

@girish

Direct messages does work to me when I login to pixelfed.social site without any issues.

@girish

Reporting from GitHub

“
I was able to reproduce the direct message issue within a docker container, and I think I know why it is happening.

Line

https://github.com/pixelfed/pixelfed/blob/4ad3de3b885b8d21a53ca9cc8a4a83e2a1d4a459/app/Http/Controllers/AccountController.php#L129-L132

in the account controller, the following SQL query is generated:

[2021-05-10 21:41:58] local.DEBUG: array (
0 =>
array (
'query' => 'select * from profiles where id != ? and profiles.id = ? and profiles.deleted_at is null limit 1',
'bindings' =>
array (
0 => 297440899045134336,
1 => '297465207490482176',
),
'time' => 37.91,
),
)

As you can see, the id in the URL gets treated as string and that's why the query does not return any results.
“

@girish

Like counts of image post are also not visible you can try my site like counts don’t work on iPhone behavior that can be produced is

Here’s my site https://spacemag.xyz

I have to like the post to see the count if someone else had liked it I cannot view it and even then if I like it and view most of the time I can only see my name on it it’s very rare I see the total profiles of those who had liked.

This moreover seems to be a conflict with ui or java from cloudron I guess ? It all works fine at pixelfed.social though, which is a raw installation of pixelfed.

I’m not certain but all i can say is there is something that’s not right

@nebulon

What I wanted to inform was after adding
skip-name-resolve=1 cloudron stopped working that’s it

@nebulon

In a fresh Ubuntu server installed cloudron when I ran the following command to check the optimal performance

./mysqltuner.pl

It gave me a message saying the memory usage is dangerously high.

I then adjusted the join size and buffer size of mysql including maximum packets accordingly to get optimal performance.

The command also asked me under general recommendation to do the following to further adjust the performance

Configure your accounts with ip or subnets only, then update your configuration with skip-name-resolve=1

When I did that on mysql conf the cloudron dashboard and inbuilt mail client stopped working so I had to undo it again.

I didn’t know how to configure accounts with ip and subnets only but I only added
skip-name-resolve=1

And it gave me the following error

Cloudron is offline. Reconnecting…

Cloudron Error
ER_HOST_NOT_PRIVILEGED: Host '127.0.0.1' is not allowed to connect to this MySQL server

@girish

I had adjusted the memory from mysql it gives optimal performance however by default the server had set the memory for high usage dangerously.

@nebulon

Cloudron has some memory usage error going on it consumes more memory that which is required and that is why i guess i was getting out of memory emails from my cloudron while using a 4GB dedicated

@onlybro

This is what I was trying to do

Configure your accounts with ip or subnets only, then update your configuration with skip-name-resolve=1

Then

Ok this was resolved after removing

skip name resolve

However it was mentioned on google and other forums on search that adding skip name resolve speeds up the website that’s why i was adding it sadly i had to remove it for cloudron to work not only that even pixelfed password reset wasn’t working but now all works fine except the speed

Hello

I made the following changes to mysql conf to further optimize pixelfed cause it was too slow
and logs on MySQL was stated as dangerously high memory!!!

Since then cloudron dashboard is reconnecting tried clearing cache on browser it’s the same but the app works fine and fast.

I’m using 4GB dedicated on linode
[mysqld]
performance_schema=ON
max_connections=200

innodb_buffer_pool_size=10M
key_buffer_size=220M
read_buffer_size=256K
sort_buffer_size=256K
join_buffer_size=256K

tmp_table_size=32M
max_heap_table_size=32M
innodb_log_file_size=1M

https://mathiasbynens.be/notes/mysql-utf8mb4

character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci

set timezone to UTC

default_time_zone='+00:00'

disable bin logs. they are only useful in replication mode

skip-log-bin
skip-name-resolve
[mysqldump]
quick
quote-names
max_allowed_packet = 16M
default-character-set = utf8mb4