Ookma-Kyi

In that case @wolstechcould you please reinstate my account on Lily? Sent you a pm with the details. Thanks

Yes it was deleted because I was no longer running a .Net app. I try to not waste resources as much as possible. Is it possible to open a Lily account without running a .Net app?

@wolstech I would like a MS SQL Express account please.

Sorry totally forgot my dev machine is running a different OS. Here are updated instructions from Google AI: To install the php_pdo_sqlsrv 82_ts extension for PHP 8.2 on Linux, you need to install the Microsoft ODBC Driver, the unixodbc-dev package, and then compile and install the extension using PECL. The specific commands for installing prerequisites may vary by distribution, and you will need to use pecl to install the driver, ensuring the PHP version and threadedness (TS for Thread Safe, NTS for Non-Thread Safe) match your environment. Step 1: Install prerequisites Install Microsoft ODBC Driver: Follow the official Microsoft instructions for installing the Microsoft ODBC Driver for SQL Server on Linux. Install build tools and unixodbc-dev: For Debian/Ubuntu: bash sudo apt-get install build-essential unixodbc-dev For CentOS/AlmaLinux/RHEL: bash sudo yum install make gcc-c++ gcc autoconf automake libtool-ltdl-devel Install PHP development files: Make sure you have the development files for your specific PHP version. For Debian/Ubuntu: bash sudo apt-get install php8.2-dev For CentOS/AlmaLinux/RHEL: bash sudo yum install plesk-php82-devel # Or the appropriate package for your system Step 2: Install the PDO_SQLSRV driver Use PECL to install the extension: bash sudo pecl install pdo_sqlsrv Enable the extension: Create a new .ini file in the PHP extensions directory (e.g., /etc/php/8.2/mods-available/pdo_sqlsrv.ini). Add the following line to the file, ensuring the filename matches your system's needs: ini extension=pdo_sqlsrv.so Enable the module: bash sudo phpenmod -v 8.2 pdo_sqlsrv Restart your web server: For example, for Apache: sudo systemctl restart apache2 Step 3: Verify the installation Create a phpinfo() file in your web server's document root and access it through a web browser. Search for pdo_sqlsrv to confirm that the extension is loaded correctly.

Could you please install the MS SQL Server extensions for PHP? The files needed are: php_pdo_sqlsrv_xx_ts.dll and php_sqlsrv_xx_ts.dll (where xx represents your PHP version) into your PHP's ext directory. Thanks

Just a heads-up: It lacks any semblance of a user interface at the moment, but it happily hosts websites with decent uptime. Be aware that if your site has been idle for a while (no traffic), the first page view might take a minute for the page to load. SSL is not provided by default but can be added upon request once the DNS finishes setting up if you want it. Lily only supports FTP, you cannot log at heliohost.org/login/ using this information as there is no control panel to log into. A 403 error is normal if you have no index page uploaded. If you need an additional domain added, please let me know and I can add it. Please keep in mind that the domain cannot already be attached to your account or the add will fail. Disk space limit is 1000MB (independent of your Plesk account) If you want your files in a folder other than the domain root (public_html), you will likely need to have a folder registered as an IIS Application in order for ASP.NET applications to run. If you need this, please let @wolstech know the folder name and he can register it for you. If you have questions about getting your app running, I can also help you with that. To upload files, Lily is accessible via FTP: Host: lily.heliohost.org Port: 21 (Plain FTP and FTP over Explicit TLS are supported) Many common IIS settings such as URL rewriting can be configured by creating/editing a web.config file in your application's folder. MySQL is available locally on Lily for databases. PhpMyAdmin is here: https://lily.heliohost.org:2083/phpmyadmin/ Username and password are the same as for FTP. SQL Server Express is available by request. If your software needs to send email, you can configure your software to use Tommy as the mail server: Type SMTP, host tommy2.heliohost.org, port 25, no authentication. Lily users can send mail using Tommy even if their Plesk account is on another server. For coding, ASP.NET (.NET 4.8, Classic ASP, .Net Core 3.1, .NET 5.0, .NET 6.0) and PHP 5.6 are supported. PHP 7.x and 8.x are available by request. Let me know if you have any questions.

While you wait for an admin who will most likely have to generate a stripe payment url, what international country are you in? I ask cause I know some countries are prohibited from making payments to/from the U.S.

Would you consider running Coldfusion on the Java Server? Lucee a free version of the Coldfusion engine uses Java. Is this a possibility for the future?

What is your opinion on this? I'm a bit worried that someone could do the unthinkable and cause the site to shut down. Do you have anything in place to alert you if it happens? I don’t want to cause any panic, but I acknowledge that numerous people choose to host their businesses or project sites here due to the attractive rates. The thought of having to relocate is quite unsettling. Source: https://www.wired.com/story/the-trump-administration-is-coming-for-nonprofits-theyre-getting-ready/

@marcodalcanto Also, try to limit the number of returned rows. Example select first_name, last_name from users limit 25;

@marcodalcantoTry not to use * when selecting columns in your queries as that tends to use up more resources. This is especially true if you only need the values from 2 to 3 columns in a table with many columns. Example select password from users where username = ${username}

Here are some helpful tips for getting a free account. You are also welcome to join the Tommy server for $2, which is guaranteed.

For webmail, did you reenable it? Back in May it was disabled globally to fix 503 server errors.

The following modules are part of the standard library and do not need to be installed. copy datetime io json os re uuid I suggest you read up on the standard library here. If you're new to Python, I suggest you read Python Crash Course. If you are not familiar with the standard library I suggest you read up on it at the site I linked or get the book for quick referencing.

The server name is Tommy, and the username is mimisvipsalon. The owner's email should be mimisvipsalon<removethis>@outlook.com, but it is currently set to an alternate email of mine because I donated the account to the person.