Skip to main content

Posts

ERROR: cross-database references are not implemented

You face this error while trying to query two tables from difference databases in Postgres, as Postgress is unlike SQL Server, you can't join two tables from different databases.
Instead you may have One Database with Two different Schemas.
Schemas group your data tables separately and give you the flexibility to query and join tables from across schemas in the same Database.

So if you have DB1 and DB2, you need to move the tables in DB2 to DB1 but in a new schema.

If you are using the public schema in DB2 you need to change the name:
alterschemapublic rename to new_schema_name;createschemapublic; Now Backup your Schema:

$ pg_dump --format custom --file "my_backup" --schema "new_schema_name" "db2"$ pg_restore --dbname "db1" "my_backup"
Your Done. If you have any question please let me know.



Recent posts

Windows font cache service status Stopping

I was trying to install a language package to my MSOffice 2013 and was stuck with an error:

Error 1920. Service 'Windows Font Cache Service' (FontCache) Failed to start...

In windows search look for services, then check the below service

Windows FontCache Service

Most likely the service is stopped or stopping or disabled. If you can't start the service what you need to do is install the service again, if you are running windows 10, 7 or 8 this website will help you:

http://batcmd.com/windows/10/services/fontcache/

Restore Default Startup Type for Windows Font Cache Service, by downloading the proper restore file to your computer. Run the restore file, restart your machine. All is done. You may install the Language package smoothly now.

Good Luck!

Change Confluence Logout Page

To change confluence logout page you need to edit the xwork.xml file located in confuence-x.x.x jar file. The jar file is normally located in installationdirectory [/atlassian-confluence-x.x.x/confluence/WEB-INF/lib/confluence-x.x.x.jar

unjar the file as shown the below on the command prompt:

jar xf  confluence-x.x.x.jar xwork.xml

edit the file and replace the line:

<result name="success" type="redirect">${logoutUrl}</result>

With your new logout file location.

save your work and then rejar xwork.xml to the jar file:

 jar uf  confluence-x.x.x.jar xwork.xml

Your Done!

Datatables Server Side Processing using Coldfusion

Datatables Server Side Processing using Coldfusion

Code: Coldfusion Server Side For Datatables

Environment: Datatables 1.10.16, Lucee 5.x, Postgres 9.6

Issue Date: 04/10/2017

Notes:
There is no warranty that the code will work on a different environment or different version.
You may create the DB table using the postgres.sql script included.
This project was tested and fully functioning.

Features:
Datatables query paging
Case Insensitive search filter to all query results.
Sort by all fields including date.
This repository does not include all Datatables features. In the code I'm only using datatables.js, but you may extend the features.

 Repository is available on github.

Enabling Collaborative Editing in Confluence 6.x is a must to be able to use the Rest APIs to Add or Update a Page

If you come a cross the below error when trying to add a page to Atlassian Confluence 6.x:

Unable to save changes made outside the editor to ContentId while collaborative editing is disabled confluence api

That means your Collaborative Editor is disabled, you need to enable the Collaborative Editing in case you need to run the APIs. If you are running Confluence behind a reverse proxy, what you need to do is to use Confluence internal proxy, this could be done by adding the below to line to Confluence Service:

-Dsynchrony.proxy.enabled=true

Then restart the service. To learn how to configure system properties click here

Install SSL Certificate on Tomcat OR Confluence Server

The below steps demonstrates how to install Existing Verified Certificates on Confluence server or Tomcat Application Server:

1- You should have your domain certificate and key, for example:

company_net.crt
company_net.crt
2- You should install openssl, I did it on windows platform:

https://wiki.openssl.org/index.php/Binaries

3- run the below command in openssl to generate the .p12 Personal Information Exchange

openssl pkcs12 -export -in company_net.crt -inkey company_net.key -out company_net.p12
4- Now move the .p12 to the server and run the keytool to generate the .jks key (Java Key Store), the keytool is normally located in the JDK or JRE directory whether in TOMCAT or JAVA Directory.

5- Run the keytool comman as below:
C:\tomacat\jre\bin>keytool -importkeystore -destkeystore c:\mykeystore.jks -srckeystore c:\company_net.p12 -srcstoretype pkcs12

6- Once the .jks is generate go to the server.xml file located in tomcat or confluence config directory and un-comment the Connector tag, …