CyberPanel Community

Setting up ftp user Gves Error

pe
peter #1

Hi

Using  Ubuntu 20.04


Current Version:  
2.3
Build:  
4
Current Commit:  
6eeaca15d3bb0defa1ef76bbaec642fb82230570

I am trying to create a FTP user and no matter what do or enter I get this

#### Operation Failed!

(1406, "Data too long for column 'Password' at row 1")

any advice would be appreciated

thx

update, even in the command prompt I get the same result

0,(1406, "Data too long for column 'Password' at row 1")
{"success": 1, "errorMessage": "(1406, \"Data too long for column 'Password' at row 1\")"}
11 replies
Su
Suhayl #2

I’m having this same issue.

This started to happen after I update my instance of CyberPanel.

After the initial install of CyberPanel, I was able to create ftp accounts for multiple Domains/Websites.

After I did an update to the latest version, I get this error when trying to add and FTP account to a newly created Domain.

sh
shoaibkk #3

Please share your server os and this issue was resolved and please update your server and issue will be resolved

pe
peter #4

I’ve done at least 10 updates with no problem but I never had to create another ftp user besides an FTP account for myself when the container was newly created. I just did a test on a new test server with a new installation it has the same build number and I was able to create multiple FTP accounts, i guess after updating the container so many times it gives this problem.

Su
Suhayl #6

WARNING: I am not responsible if this breaks your system beyond recovery. Please backup your entire server before attempting this update.

OS: Ubuntu 20.04 LTS

Short Answer:

Upgrading ubuntu from 20.04 LTS to 22.04.2 LTS solved this issue for me.

Long Answer,

Upgrading Ubuntu broke my CyberPanel installation and I couldn’t access the admin panel via my public domain nor local IP, BUT all my domains were working just fine. OpenLiteSpeed and Database were also working fine.

HOW I SOLVED THIS ISSUE

  1. Upgrade Ubuntu
          # sudo apt install update-manager-core
          # sudo do-release-upgrade -d
  1. When prompted about obsolete packges, I selected [y] YES
          Searching for obsolete software
          Reading state information... Done

          Remove obsolete packages?


          41 packages are going to be removed.

          Continue [yN]  Details [d] 
  1. After completion, I restarted the server. When I tried to access CyberPanel, I would get a 503 Error or nothing at all until it timed out.

  2. I ran the CyberPanel upgrade script in attempt to fix potential broken packages that were necessary for CyberPanel to work but the OS might have removed in step #2 above.

          # sh <(curl https://raw.githubusercontent.com/usmannasir/cyberpanel/stable/preUpgrade.sh || wget -O - https://raw.githubusercontent.com/usmannasir/cyberpanel/stable/preUpgrade.sh)

  1. This threw a error relating to python.
Could not find platform independent libraries <prefix>
Could not find platform dependent libraries <exec_prefix>
Consider setting $PYTHONHOME to <prefix>[:<exec_prefix>]
Python path configuration:
  PYTHONHOME = (not set)
  PYTHONPATH = (not set)
  program name = 'python3'
  isolated = 0
  environment = 1
  user site = 1
  import site = 1
  sys._base_executable = '/usr/bin/python3'
  sys.base_prefix = '/usr'
  sys.base_exec_prefix = '/usr'
  sys.executable = '/usr/bin/python3'
  sys.prefix = '/usr'
  sys.exec_prefix = '/usr'
  sys.path = [
    '/usr/lib/python38.zip',
    '/usr/lib/python3.8',
    '/usr/lib/lib-dynload',
  ]
Fatal Python error: init_fs_encoding: failed to get the Python codec of the filesystem encoding
Python runtime state: core initialized
ModuleNotFoundError: No module named 'encodings'
  1. I purged python, which broke my system even more.
          # sudo apt purge python*

          # whereis python3

          # sudo rm /usr/bin/python3 -r
          # sudo rm /usr/lib/python3 -r
          # sudo rm /etc/python3 -r
          # sudo rm /usr/share/python3 -r
          # sudo rm /usr/share/man/man1/python3.1.gz

          # sudo rm /usr/lib/python38.zip
          # sudo rm /usr/lib/python3.8
          # sudo rm /usr/lib/lib-dynload -r
  1. Then I reinstalled python. I purposely chose 3.8 because that was the version I believe CyberPanel was using before. I did try using the latest python (3.10) but that was not helping at all.
          #sudo apt install python3.8 python3.8-dev
  1. Finally I ran the CyberPanel Upgrade script in #4 above again and it completed successfully.(I did get errors of bad packages during the process but I removed them via “apt remove package-name -y” and repeat this step until it was successful.)

No Restart required after step #8. I was able to access CyberPanel again and create a new FTP account for my domains/websites.

WARNING: I am not responsible if this breaks your system beyond recovery. Please backup your entire server before attempting this update.

TD
Tien Dung Dao #7

Thank you also for the solution, I am using Ubuntu 20, CyberPanel version

Current Version: 2.3
Build: 4
Current Commit: 5512f136775fc22b1baf669b801dd6f69821ff20
Latest Version: 2.3
Latest Build: 4
Latest Commit: 5512f136775fc22b1baf669b801dd6f69821ff20

I am getting this error, I will backup and try your method.

Su
Suhayl #9

From my last reply to now, there was a new update for CyberPanel. I just did the update and my version is listed below.

Current Version:  2.3

Build:  4
Current Commit:  2a680bc8207c7e60994b13e7909b1d95a334332c

Latest Version:  2.3

Latest Build:  4
Latest Commit:  2a680bc8207c7e60994b13e7909b1d95a334332c

I am able to create an FTP account.

Your Current Commit should match the Latest Commit.

@daotiendung Can you try updating again and let me know what happens?

TD
Tien Dung Dao #10

I upgraded to

Current Version: 2.3
Build: 4Current 
Commit: 2a680bc8207c7e60994b13e7909b1d95a334332c
Latest Version: 2.3
Latest Build: 4Latest 
Commit: 2a680bc8207c7e60994b13e7909b1d95a334332c

But still error.

pe
peter #11

Just want to add after updating the lasted commit 93bf01922d2f4a9cb52a375809f94e0ed293cc2a
I can now add FTP user again without a problem thx

TD
Tien Dung Dao #12

Okay, confirm working in

Latest Commit:

93bf01922d2f4a9cb52a375809f94e0ed293cc2a

Sign in to reply