cmh

sure it's more important. Will waiting.

Can someone help me?

Hello. I need to update privileges for users. [hided]

DELIMITER //
DROP procedure IF EXISTS UserExist //
 
CREATE procedure UserExist (IN UserName VARCHAR(50), out RetMsg int)
 
  BEGIN
 
    SELECT id INTO RetMsg FROM Tab WHERE user = UserName;
 
  END;
//
DELIMITER ;
 
DELIMITER //
DROP procedure IF EXISTS SomeAuth //
CREATE PROCEDURE SomeAuth (UserName VarCHAR(50))
  BEGIN
    DECLARE pid int DEFAULT 0;
    DECLARE pMSG int DEFAULT 0;
    DECLARE pFile Mediumblob;
    DECLARE IsUser VARCHAR(20);
    set IsUser ='DefVal';
    call UserExist(UserName, @pMSG);
 
    if pMSG = 0 then
      set pid = 0;
        else
      set pid = 1;
    end iF;
  select @pid, @pMSG ;
  END //
 
DELIMITER ;
call SomeAuth('xxxxxxxxxxxxxxxxx'); 

In return i have:

@pid @pMSG

<null> 20

and so, I do not understand why

pid =<nul>?

why not 0 (as default value) or 1 (as if statement).

Looks like my account was suspended?

Server Tommy.

ok. First i will try migrate to PostgreSqL

Krydos, on 03 Jan 2018 - 12:33 AM, said:

.... I could recompile it manually but it would probably break all of the cpanel mysql functionality.

What does this mean in fact? Problems with the backup/restore, phpmyadmin etc?

Is it possible? if yes, where i can find certificates? is it Crt, Private key and CaB or something else?

As always, I apologize for my English

12.12.2017 at 09:40 Pm (utc+1)

09.12.2017 at 08:13 pm (utc:1)

May CloudFlare Help with MySql?

The decision that I deleted the account is the final one?

https://www.helionet.org/index/topic/29691-solved-tommy-down/?do=findComment&comment=134302

My mirror used only When Tommy is down (MySQl)

From post bellow, I thought that can create mirror.

Unfortunately, the tomy are often unavailable for about an hour. So I'm trying to solve this problem. When the volume is unavailable, the data is taken from Ricky.

You can make sure that these are simple rare requests. I do not overload the system

Hello. Can you help me with auto mirroring?

Master: cmh (tomy)

Slave: mcmh (ricky).

After read, please mask servers.

There's no new information to report right now. Updates will be provided when they become available.

Can you Send me Backup MySqL to my mail?

Hey. My site also does not work (CP and MySQL) I can not understand what is the reason? I must donate to you $ 12? or what. i have visitors from many countrys

As I see, the Tommy very often falls recently. Can I create a mirror site and base on another server? is it allowed by the rules?

i use only one client (firebird) and did not change the password, and now the old password works. The problem happened when the hosting was down. and my client tried to connect. ( ~UTC 04.50)

I get this message,

I dont use cpannel, only mysql. Also i cant connect to mysql

Thanks. Unfortunately, I have never worked with PHP and there is no certainty that Decod / Encode will be identical to mine. Although I use standard algorithms

All perfect, good luck

Thanks, all looks good. Just 1 question

*MASK*

and then mask it all again please.

oops, think that you will start process of deleting. Ok, now i do it.

as i can see, account is deleted.