How to copy an existing database in the same DB server

  1. Open the database in Sybase Central and select ‘Create Backup Images’
  2. Copy the newly generated DB file to another folder and rename it. DO NOT include the log file.
  3. Locate the dbeng9.exe file on the server and open a terminal on that directory and execute the ff. commands:
  4. Notes: ‘-f’ means to fix the DB file since it does not have a log file. The last command generates a new log file.
  5. Close the db server running in the task bar. (right click and click Exit)
  6. Rename the new log file. (must be the same as the db file)
  7. Go to Sybase Central->Tools->Adaptive Server Anywhere->Change Log File Settings and browse and select the new log file and click Finish.
  8. Your new db and log files are now setup and ready to be used on another system.
Posted in Others | Leave a comment

[Invoice] Terminated an invoice of Fu lum I-2108103

A note that the following services are terminated. The termination date is 9 NOV 2021.

Invoice number: I-2108103
Period: Yearly

Posted in Others | Leave a comment

Kiyohara SIOI and webaccount

The service will be terminated on 17 July, 2021
The site was stopped running at 11:59pm 16 July, 2021. 

Posted in Others | Tagged , | Leave a comment

How to remove a connection in Sybase

Open Sybase Central and logged in to the database. Open the Connected Users tab and right click on the Conn. ID number and click Disconnect.

This is useful in situations where some customers would generate lots of reports and will cause the SIOI or Webaccount sites to hang up for a long time. Disconnecting ALL the connections will restore the normal state of the sites.

To determine which database is using a lot of connections, just open the task manager and find the one with high CPU usage.

Posted in Database Servers, Databases, SIOI, Sybase SQLAnywhere, Webaccount | Leave a comment

Webaccount – New Year End functionality

We will now force all customers to backup their database before doing the Year End process. Customer will call support to allow them to do Year End.

Here are the steps:

  1. First, backup the database
  2. Find the current book in tbl_fiscal table
  3. set its backup_flag value to 1
  4. done!
Posted in Coldfusion, Webaccount | Leave a comment

IIC VPN Connection Procedures

IIC servers (web/database) are all located in Japan. We need to connect to their VPN to be able to connect via remote desktop.

Here is the installation manual: http://dev.hkisl.net/kbase/wp-content/uploads/2021/06/Installation_Manual.pdf

Here is the certificate to be installed (extract first): http://dev.hkisl.net/kbase/wp-content/uploads/2021/06/certificate.zip

 

Posted in SIOI, WebServers | Leave a comment

Update Git password in Windows

To update the expired password, go to Credential Manager in Windows (Windows Key + type ‘credential’) and edit the git entry under Windows Credentials -> Generic Credentials. Note: Not listed alphabetically.

Posted in Git | Leave a comment

How to Create Valid SSL in localhost for XAMPP

  1. Navigate to Apache directory in XAMPP in C:\xampp\apache
  2. Create “crt” folder where we will store our cert.
  3. Add the ff. files: cert.conf and make-cert.bat from this zip file.
  4. Edit cert.conf. Change {{DOMAIN}} text using the domain we want to use, in this case site.test and save.
  5. Run make-cert.bat. Double click the make-cert.bat and input the domain site.test when prompted. And just do enter in other question since we already set the default from cert.conf.
  6. After that, you will see site.test folder created. In that folder we will have server.crt and server.key. This is our SSL certificate.

    Double click on the server.crt to install it on Windows so Windows can trust it.



    And then select Local Machine as Store Location.



    And then Select “Place all certificate in the following store” and click browse and select Trusted Root Certification Authorities.



    Click Next and Finish. And now this cert is installed and trusted in Windows.

  7. Add the site in Windows hosts. Edit C:\Windows\System32\drivers\etc\hosts and add this in a new line: 127.0.0.1 site.test
  8. Enable SSL for this domain and let XAMPP know where we store the SSL Cert. So we need to edit C:\xampp\apache\conf\extra\httpd-xampp.conf. Add this code at the bottom:
    ## site.test
    <VirtualHost *:80>
    DocumentRoot "C:/xampp/htdocs"
    ServerName site.test
    ServerAlias *.site.test
    </VirtualHost>
    <VirtualHost *:443>
    DocumentRoot "C:/xampp/htdocs"
    ServerName site.test
    ServerAlias *.site.test
    SSLEngine on
    SSLCertificateFile "crt/site.test/server.crt"
    SSLCertificateKeyFile "crt/site.test/server.key"
    </VirtualHost>
  9. Restart your browser and Done!

Reference: https://shellcreeper.com/how-to-create-valid-ssl-in-localhost-for-xampp/

Posted in Apache, WebServers | Leave a comment

IIS web server and non-latin characters in URLs

If you are using an IIS web server to host your WordPress and you find that some of the pages/posts URLs cannot be opened, you could be experiencing a problem with non-latin URLs. URLs that contain non-English characters cannot be properly handled by Internet Information Service (IIS). As a result, WordPress will throw Page not found (404) on all URLs that have non-English characters. You can either avoid using posts/page slugs that have non-latin characters or apply the following fix in your index.php (this file is placed in WordPress root directory). Add the code after first opening PHP tag <?php

if (isset($_SERVER['UNENCODED_URL'])) {
    $_SERVER['REQUEST_URI'] = $_SERVER['UNENCODED_URL'];
}

You will also need to have properly configured web.config in order to allow WordPress pretty permalinks

<?xml version="1.0" encoding="UTF-8"?>
<configuration>
    <system.webServer>
        <rewrite>
            <rules>
                <rule name="WordPress Rule 1" stopProcessing="true">
                    <match url="^index\.php$" ignoreCase="false" />
                    <action type="None" />
                </rule>
                <rule name="WordPress Rule 2" stopProcessing="true">
                    <match url="^([_0-9a-zA-Z-]+/)?files/(.+)" ignoreCase="false" />
                    <action type="Rewrite" url="wp-includes/ms-files.php?file={R:2}" appendQueryString="false" />
                </rule>
                <rule name="WordPress Rule 3" stopProcessing="true">
                    <match url="^([_0-9a-zA-Z-]+/)?wp-admin$" ignoreCase="false" />
                    <action type="Redirect" url="{R:1}wp-admin/" redirectType="Permanent" />
                </rule>
                <rule name="WordPress Rule 4" stopProcessing="true">
                    <match url="^" ignoreCase="false" />
                    <conditions logicalGrouping="MatchAny">
                        <add input="{REQUEST_FILENAME}" matchType="IsFile" ignoreCase="false" />
                        <add input="{REQUEST_FILENAME}" matchType="IsDirectory" ignoreCase="false" />
                    </conditions>
                    <action type="None" />
                </rule>
                <rule name="WordPress Rule 5" stopProcessing="true">
                    <match url="^([_0-9a-zA-Z-]+/)?(wp-(content|admin|includes).*)" ignoreCase="false" />
                    <action type="Rewrite" url="{R:2}" />
                </rule>
                <rule name="WordPress Rule 6" stopProcessing="true">
                    <match url="^([_0-9a-zA-Z-]+/)?(.*\.php)$" ignoreCase="false" />
                    <action type="Rewrite" url="{R:2}" />
                </rule>
                <rule name="WordPress Rule 7" stopProcessing="true">
                    <match url="." ignoreCase="false" />
                    <action type="Rewrite" url="index.php" />
                </rule>
            </rules>
        </rewrite>
    </system.webServer>
</configuration>

Reference: https://help.servmask.com/knowledgebase/iis-web-server-and-non-latin-characters-in-urls/

Posted in IIS, WebServers | Leave a comment

Remove index.php in Codeigniter URLs

For Apache:

Create a .htaccess file in the root directory and add the following code:

RewriteEngine on
RewriteCond $1 !^(index\.php|public|\.txt)
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.*)$ index.php?$1

For IIS:

Include this in your Web.config which is located in the root of your project:

<rule name="Remove index" stopProcessing="true">
  <match url=".*" />
  <conditions logicalGrouping="MatchAll">
    <add input="{REQUEST_FILENAME}" matchType="IsFile" negate="true" />
    <add input="{REQUEST_FILENAME}" matchType="IsDirectory" negate="true" />
  </conditions>
  <action type="Rewrite" url="index.php" />
</rule>
Posted in Apache, Codeigniter, Frameworks, IIS, WebServers | Leave a comment