After i changed my phone, i lost my admin privilege to my company Telegram group

I have been an admin of the company telegram group for about a year( The only admin). It is a public group. When i changed my phone with a similar phone number I suddenly don’t have access to my admin status.

Tried to contact Telegram but i haven’t received a response so far.

Any information will be helpful
Thanks

mariadb – Database connection lost whenever SQL query string is too long

I recently switched from running my Rails app on a single VM to running the database — MariaDB 10.3 — on a separate (Debian Buster) VM. Now that the database is on a separate server, Rails immediately throws Mysql2::Error::ConnectionError: MySQL server has gone away whenever it tries to make a query where the SQL itself is very long. (They query itself isn’t necessarily one that would put significant load on the system.)

An example query that causes the problem looks like this:

SELECT `articles`.`id` FROM `articles` WHERE `articles`.`namespace` = 0 AND `articles`.`wiki_id` = 1 AND `articles`.`title` IN ('Abortion', 'American_Civil_Liberties_Union', 'Auschwitz_concentration_camp', 'Agent_Orange', 'Ahimsa')

… except the array of titles is about 5000 items long, and the full query string is ~158kB.

On the database side, this corresponds to warnings like this:

2021-03-25 15:47:13 10 (Warning) Aborted connection 10 to db: 'dashboard' user: 'outreachdashboard' host: 'programs-and-events-dashboard.globaleducation.eqiad1.wikimed' (Got an error reading communication packets)

The problem seems to be with the network layer, but I can’t get to the bottom of it. I’ve tried adjusting many MariaDB config variables (max_allowed_packet, innodb_log_buffer_size, innodb_log_file_size, innodb_buffer_pool_size) but none of those made a difference. The problem seems to be that the connection is aborted while it is attempting to transmit the long SQL query string from the app server to the database server. (There’s no corresponding problem with receiving large query results from the database.)

I’ve tried adjusting several timeout-related settings as well, although that seems unlikely to be the problem because I can replicate the connection error without any significant wait, just by issuing one of the long-SQL-string queries from a Rails console.

I’ve tried using tcpdump to see what’s coming in, but didn’t pick up any additional clues from that.

seo – Switching from single to multi language website – indexing problem and lost rank

I have a website which used to be to available in a single language website: French. We wanted to purpose our product in other language (English, Portuguese, Spanish, etc.)

First, we have changed the URL structure by adding a language prefix:

Old Schema

  • https://mywebsite.example => French
  • Defaut language : French

New Schema

  • https://mywebsite.example/fr => French
  • https://mywebsite.example/en => English
  • https://mywebsite.example/es => Spanish
  • etc ..

In addition, we added hreflang meta tags

<link rel="alternate" hreflang="en" href="https://mywebsite.example/en" />
<link rel="alternate" hreflang="fr" href="https://mywebsite.example/fr" />
<link rel="alternate" hreflang="de" href="https://mywebsite.example/de" />
etc..

When users go to https://mywebsite.example, they get redirected to the language according to its browser. But the user has also the ability to switch language thank to a language menu.

The default language is English.

We have deployed this new version 10 days ago, and we have noticed that the French version (which had a strong SEO reputation) has been completely wiped out of the French version of Google.

There’s no error in the search console. What mistake did we make? Is it a question of time? I uploaded an XML sitemap, but I don’t think it’s a crawl problem.

google sheets – I’m lost. I’m trying to get a count of each number where the cell to the right is 1 number higher in an 8 column, 25 row grid


Your privacy


By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy.




Bootloop after flashing TWRP (Also lost recovery)

So I was going to root this (previsouly healthy) BQ A4.5. Unlocked the bootloader and flashed TWRP from here:

$ fastboot oem unlock
(bootloader) Start unlock flow

OKAY ( 32.954s)
Finished. Total time: 32.960s
$ fastboot flash recovery downloads/twrp-3.3.1-0-dendeone.img
target reported max download size of 134217728 bytes
Sending 'recovery' (11342 KB)...
OKAY (  0.378s)
Writing 'recovery'...
OKAY (  0.335s)
Finished. Total time: 0.727s
$ fastboot reboot bootloader
rebooting into bootloader
OKAY (  0.003s)
Finished. Total time: 0.058s
$ fastboot reboot
Rebooting...

Finished. Total time: 0.058s

The first reboot to bootloader didn’t do anything.
Now it’s on a bootloop which states:

Orange State
Your device has been unlocked and can't be trusted
Your device will boot in 5 seconds

Pressing Volume Up + PowerOn used to work for recovery (that’s how I got into fastboot mode).
Now, pressing Volume Up/Down/Up+Down + PowerOn doesn’t do anything, fastboot stands indefinitely < waiting for any device >, and adb always responds with error: no devices/emulators found regardless of when it’s run.
If I press Volume Up+Down it turns off. Plugging in USB it turns on. Nothing else seems to respond.

dmesg states:

(32774.364937) usb 2-7: new high-speed USB device number 59 using xhci_hcd
(32774.514434) cdc_acm 2-7:1.0: Zero length descriptor references
(32774.514450) cdc_acm: probe of 2-7:1.0 failed with error -22
(32774.554519) cdc_acm 2-7:1.1: ttyACM0: USB ACM device
(32777.142205) usb 2-7: USB disconnect, device number 59

The disconnect happens before the bq logo appears.

Trash bin time?

mariadb – importing tablespace showing error 2013 (HY000): Lost connection to MySQL server during query

trying to recover innodb table from ibd file (576kb). this is the exact steps i do:

getting create table query using mysqlfrm command

create the table

Alter Table discard tablespace

moving the new tablespace to the db directory

Alter Table import tablespace;

and i’m getting this error after minutes:

ERROR 2013 (HY000): Lost connection to MySQL server during query

My current SQL configuration:

# Example MySQL config file for small systems.
#
# This is for a system with little memory (<= 64M) where MySQL is only used
# from time to time and it's important that the mysqld daemon
# doesn't use much resources.
#
# You can copy this file to
# C:/xampp/mysql/bin/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is C:/xampp/mysql/data) or
# ~/.my.cnf to set user-specific options.
#
# In this file, you can use all long options that a program supports.
# If you want to know which options a program supports, run the program
# with the "--help" option.

# The following options will be passed to all MySQL clients
(client)
# password       = your_password 
port=3306
socket="C:/xampp/mysql/mysql.sock"


# Here follows entries for some specific programs 

# The MySQL server
default-character-set=utf8mb4
(mysqld)
port=3306
socket="C:/xampp/mysql/mysql.sock"
basedir="C:/xampp/mysql"
tmpdir="C:/xampp/tmp"
datadir="C:/xampp/mysql/data"
pid_file="mysql.pid"
# enable-named-pipe
key_buffer=16M
max_allowed_packet=16M
sort_buffer_size=512K
net_buffer_length=8K
read_buffer_size=131072K
read_rnd_buffer_size=512K
myisam_sort_buffer_size=8M
log_error="mysql_error.log"

# Change here for bind listening
# bind-address="127.0.0.1" 
# bind-address = ::1          # for ipv6

# Where do all the plugins live
plugin_dir="C:/xampp/mysql/lib/plugin/"

# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
# Note that using this option without enabling named pipes on Windows
# (via the "enable-named-pipe" option) will render mysqld useless!
# 
# commented in by lampp security
#skip-networking
#skip-federated

# Replication Master Server (default)
# binary logging is required for replication
# log-bin deactivated by default since XAMPP 1.4.11
#log-bin=mysql-bin

# required unique id between 1 and 2^32 - 1
# defaults to 1 if master-host is not set
# but will not function as a master if omitted
server-id   =1

# Replication Slave (comment out master section to use this)
#
# To configure this host as a replication slave, you can choose between
# two methods :
#
# 1) Use the CHANGE MASTER TO command (fully described in our manual) -
#    the syntax is:
#
#    CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>,
#    MASTER_USER=<user>, MASTER_PASSWORD=<password> ;
#
#    where you replace <host>, <user>, <password> by quoted strings and
#    <port> by the master's port number (3306 by default).
#
#    Example:
#
#    CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306,
#    MASTER_USER='joe', MASTER_PASSWORD='secret';
#
# OR
#
# 2) Set the variables below. However, in case you choose this method, then
#    start replication for the first time (even unsuccessfully, for example
#    if you mistyped the password in master-password and the slave fails to
#    connect), the slave will create a master.info file, and any later
#    change in this file to the variables' values below will be ignored and
#    overridden by the content of the master.info file, unless you shutdown
#    the slave server, delete master.info and restart the slaver server.
#    For that reason, you may want to leave the lines below untouched
#    (commented) and instead use CHANGE MASTER TO (see above)
#
# required unique id between 2 and 2^32 - 1
# (and different from the master)
# defaults to 2 if master-host is set
# but will not function as a slave if omitted
#server-id       = 2
#
# The replication master for this slave - required
#master-host     =   <hostname>
#
# The username the slave will use for authentication when connecting
# to the master - required
#master-user     =   <username>
#
# The password the slave will authenticate with when connecting to
# the master - required
#master-password =   <password>
#
# The port the master is listening on.
# optional - defaults to 3306
#master-port     =  <port>
#
# binary logging - not required for slaves, but recommended
#log-bin=mysql-bin


# Point the following paths to different dedicated disks
#tmpdir = "C:/xampp/tmp"
#log-update = /path-to-dedicated-directory/hostname

# Uncomment the following if you are using BDB tables
#bdb_cache_size = 4M
#bdb_max_lock = 10000

# Comment the following if you are using InnoDB tables
#skip-innodb
innodb_data_home_dir="C:/xampp/mysql/data"
innodb_data_file_path=ibdata1:10M:autoextend
innodb_log_group_home_dir="C:/xampp/mysql/data"
#innodb_log_arch_dir = "C:/xampp/mysql/data"
## You can set .._buffer_pool_size up to 50 - 80 %
## of RAM but beware of setting memory usage too high
innodb_buffer_pool_size=600M
## Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size=600M
innodb_log_buffer_size=600M
innodb_flush_log_at_trx_commit=5
innodb_lock_wait_timeout=600
wait_timeout=600
innodb_file_per_table=5

## UTF 8 Settings
#init-connect='SET NAMES utf8'
#collation_server=utf8_unicode_ci
#character_set_server=utf8
#skip-character-set-client-handshake
#character_sets-dir="C:/xampp/mysql/share/charsets"
sql_mode=NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION
log_bin_trust_function_creators=1

character-set-server=utf8mb4
collation-server=utf8mb4_general_ci
(mysqldump)
max_allowed_packet=600M

(mysql)
# Remove the next comment character if you are not familiar with SQL
#safe-updates

(isamchk)
key_buffer=20M
sort_buffer_size=20M
read_buffer=2M
write_buffer=2M

(myisamchk)
key_buffer=20M
sort_buffer_size=20M
read_buffer=2M
write_buffer=2M

(mysqlhotcopy)

Error Message showing like this;

InnoDB: using atomic writes.
2021-03-30 10:05:58 0 (Note) InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-03-30 10:05:58 0 (Note) InnoDB: Uses event mutexes
2021-03-30 10:05:58 0 (Note) InnoDB: Compressed tables use zlib 1.2.11
2021-03-30 10:05:58 0 (Note) InnoDB: Number of pools: 1
2021-03-30 10:05:58 0 (Note) InnoDB: Using SSE2 crc32 instructions
2021-03-30 10:05:58 0 (Note) InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-03-30 10:05:58 0 (Note) InnoDB: Completed initialization of buffer pool
2021-03-30 10:05:58 0 (Note) InnoDB: Starting crash recovery from checkpoint LSN=316759
2021-03-30 10:05:58 0 (Note) InnoDB: Starting final batch to recover 1 pages from redo log.
2021-03-30 10:05:59 0 (Note) InnoDB: 128 out of 128 rollback segments are active.
2021-03-30 10:05:59 0 (Note) InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-03-30 10:05:59 0 (Note) InnoDB: Creating shared tablespace for temporary tables
2021-03-30 10:05:59 0 (Note) InnoDB: Setting file 'C:xamppmysqldataibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-03-30 10:05:59 0 (Note) InnoDB: File 'C:xamppmysqldataibtmp1' size is now 12 MB.
2021-03-30 10:05:59 0 (Note) InnoDB: Waiting for purge to start
2021-03-30 10:05:59 0 (Note) InnoDB: 10.4.18 started; log sequence number 316788; transaction id 185
2021-03-30 10:05:59 0 (Note) InnoDB: Loading buffer pool(s) from C:xamppmysqldataib_buffer_pool
2021-03-30 10:05:59 0 (Note) Plugin 'FEEDBACK' is disabled.
2021-03-30 10:05:59 0 (Note) Server socket created on IP: '::'.

designer workflow – Lost document properties after rest api listitem update via rest api

I have two SP 2013 workflows created with SharePoint Designer. Both workflows are reusable and perform api calls to update the current list item.

The first workflow runs automatically after a document is created and sets 3 properties:

  • WF-Authorname_Word
  • WF-DistributionList_Word
  • WF-DocumentSetName_Word

this operation runs perfect but if I run the second one, my 3 fields will be overwritten, removed or what else. This is crazy because this workflow does not performe an operation on this three fields. The second workflow just writes information about the approval status into another field.

enter image description here

The picture shows the version history of an document and version 0.4 is the result of the api call from the first workflow.

On both workflows I used the following headers for my POST Request:

  • Accept : application/json; odata=verbose
  • Content-Type: application/json; odata=verbose
  • IF-MATCH: *
  • X-HTTP-Method: MERGE

And at the second workflow I insert the Approval Status field at the request content:

enter image description here

Did anyone know why the properties will be removed or rewrite?

Thanks for your help.

key management – Windows X.509 certificate private keys lost

Have the same certificates installed on several machines, but this happens on only one of them.
The certificates are self-signed certificates.
The certificates are used for WCF message security.

Installing the certificates with the following PS script (or manually through Manage Computer Certificates, doesn’t make a difference):

function getKeyUniqueName($cert) {
     return $cert.PrivateKey.CspKeyContainerInfo.UniqueKeyContainerName
}

function getKeyFilePath($cert) {             
     return "$env:ALLUSERSPROFILEMicrosoftCryptoRSAMachineKeys$(getKeyUniqueName($cert))"
}

$certFromFile = New-Object System.Security.Cryptography.X509Certificates.X509Certificate2($certFile, $password)
$certFromStore = Get-ChildItem "$certStore" | Where-Object {$_.Thumbprint -eq $certFromFile.Thumbprint}
$certExistsInStore = $certFromStore.Count -gt 0
$keyExists = $certExistsInStore -and ($certFromStore.PrivateKey -ne $null) -and (getKeyUniqueName($cert) -ne $null) -and (Test-Path(getKeyFilePath($certFromStore)))

Write-Host "CertExistsInStore:$certExistsInStore, keyExists: $keyExists"

if ((!$certExistsInStore) -or (!$keyExists)) {

    $keyFlags = (System.Security.Cryptography.X509Certificates.X509KeyStorageFlags)::MachineKeySet 
    $keyFlags = $keyFlags -bor (System.Security.Cryptography.X509Certificates.X509KeyStorageFlags)::PersistKeySet
    $certFromFile.Import($certFile, $password, $keyFlags)

    $store = Get-Item "$certStore"
    $store.Open("ReadWrite")

    if ($certExistsInStore) {
        Write-Host "Private key missing: Re-adding certificate to store: $($certFromStore.Subject)"
        $store.Remove($certFromStore)
    }

    $store.Add($certFromFile)
    $store.Close()
}

Right after the certificates are installed the keys are there and I can verify the key files are there.
But then a day later the key files are gone (the certificates are still there).
The certificates have been originally installed a couple of months ago and everything was fine, then recently this key loss started happening.
It seems as though this loss is happening when windows update runs.

There are older certificates that were originally used for the same purpose installed on the same machine and the keys for these are fine.

Differences that I can see between the old ones and the new ones are:

  1. The old ones had their private keys exportable and the new ones don’t.
  2. The old ones have a cusom-named key container and the new ones have auto-generated key container names (GUIDs).
  3. The provider for the old certificates is “Microsoft Strong Cryptographic Provider” and for the new ones it’s “Microsoft Enhanced Cryptographic Provider v1.0”.
  4. The signature algorithm for the old ones is md5RSA and for the new ones it’s SHA256RSA

I will try to follow points 1-3 above for the new certs and see if it helps, but curious to know what’s actually happening.

node.js – nodejs mysql on pool connection Error: Connection lost: The server closed the connection

My question is similar to this post but the solution didnt work for me probably because im using a different type of mysql connection (pool). This is my code:

    let config= {
        host: '***',
        user: 'admin',
        password: '***,
        port: '3306',
        database: '***',
        multipleStatements: true
    };

const con = mysql.createPool(config);
select();
function select(){
    return new Promise((resolve, reject) => {
        con.getConnection(function (err, connection) {
            if (err) throw err;
            else
                console.log("Connected!");
            let sql = "SELECT * FROM bidPrice WHERE idExchangePlatform = 2;";
            connection.query(sql, function (err, results, fields) {
                connection.release();
                connection.destroy();
                if (err) throw err;
                console.log(results)
                resolve(results);
            });

        });
    });
}

I also important to mention that im running this function using the following command

node –max-old-space-size=31744 index.js # Increase to 31 GB

This is because im working with millions of records from the database query If i run this with regular node command i would be getting Javascript heap out of memory

When i tried integrating the solution i mentioned earlier to my code i just get a “killed” log after a while and then the process stops, should i handle server disconnect in a different way when using mysql.pool?

enter image description here

I have lost my wallet, what can I do?

I had an account on a website, but don’t remember which one

Search your email account for an account creation confirmation email. Helpful search terms may include “bitcoin”, “wallet”, “exchange”, “btc”, “blockchain”, or “cryptocurrency”. If you purchased bitcoins, you may want to look at your old bank statements as well. There is no global register of bitcoin users or services, so if you cannot find anything you may be out of luck—we cannot help you, because we don’t know either.

I had a web wallet, but the service shut down since

If the service had custody of your bitcoin balance, it is likely lost. Research the name of the service to determine what happened to the service, in case it just rebranded and is still around.

My wallet service still exists, but I lost access

We don’t have insight into your customer relationship with services, so we cannot help you. Contact the service and initiate an account recovery process.

I had a self-custodial wallet, have lost the wallet, and have no backup

Bitcoin balances are tracked via the blockchain, and a user’s bitcoin wallet primary purpose is to secure the private keys which are used to establish ownership and to track any transactions related to those keys. The key space is enormous. If you have lost your wallet, the same keys will likely never be regenerated and no one will ever be able to spend the associated funds.

I had a self-custodial wallet, and still have the device that it was installed on

Looking over this selection of wallets may help you remember which one you used. If you still have the wallet files, you may be able to recover your funds. The name of the relevant files depends on the software that you used, but one of the most common file names is wallet.dat. If you find a wallet file, create a backup first before trying to recover the wallet.

I have a 12 or 24 word backup, what do I do?

This is called a mnemonic seed phrase. It is a standardized way to backup a wallet’s private keys. Keep the words confidential, do not enter the words in a website or untrustworthy software. You should be able to recover your wallet from the phrase. You can find instructions how to recover the wallet from it on this site.