Author Archives: TimL

•

Noodle will run on almost anything but we recommend the following setups:

Moderate dedicated server or VM only running operating system, Java, database, and Noodle:

  • 4GB RAM (1 for the OS 0.5 for Noodle and the rest for the RDBMS)
  • Dual core
  • 1TB drive space
  • 100mbps

Big configuration:

  • 2GB RAM + the size of your database
  • Quad core (any more cores will likely not be used)
  • AES-NI
  • software raid 0 (or SSDs)
  • 10mbps per user

An off site backup is recommended.

When using a VM shared IO can be a issue so be sure to verify your VM is getting the speed it needs.

•

How to reset PostgreSQL password on Windows:

0) Kill java from the task manager
1) Update your

%PROGRAMFILES%\PostgreSQL\9.0\data\pg_hba.conf

to "trust" for local connections.
2) Restart the PostgreSQL service
3) Connect as user postgres with PGAdmin
4) Set your password:

ALTER USER postgres WITH PASSWORD 'Pgsq1p@ssword';

5) Undo your changes to pg_hba.conf
6) Restart the PostgreSQL service
7) Restart the Noodle service

•

You need custom scripts enabled.

var doc=top.noodle.headWindow().document;
var el=doc.getElementById("status");
el.style.display="none";
el=doc.getElementById("currentUserId");
el.style.display="none";
el=doc.getElementById("currentUser");
el.style.margin="20px";
el=doc.getElementById("currentUserName").parentNode;
el.style.display="block";

• 
--Restore from file or on attach

---------------------------------------------------------
DECLARE tabcurs CURSOR
FOR
    SELECT 'intranet.' + [name]
      FROM sysobjects
     WHERE xtype = 'u'

OPEN tabcurs
DECLARE @tname NVARCHAR(517)
FETCH NEXT FROM tabcurs INTO @tname

WHILE @@fetch_status = 0
BEGIN

    EXEC sp_changeobjectowner @tname, 'intranet2'

    FETCH NEXT FROM tabcurs INTO @tname
END
CLOSE tabcurs
DEALLOCATE tabcurs
---------------------------------------------------------
--?--EXEC sp_changeobjectowner 'intranet.AllocObjectId', 'intranet2';
---------------------------------------------------------

•

Edit server.xml and add the following to the Engine tag;

<Valve className="org.apache.catalina.valves.AccessLogValve" directory="${catalina.base}/logs" prefix="access." fileDateFormat="yyyy-MM-dd" suffix=".log" pattern="%{YYYY-MM-dd HH:mm:ss}t,%a,%v,%r,%s,%p,%{user}r,%X,%{c}L" />

Restart Noodle.

Further options here.

•

You need custom scripts enabled.

var doc=top.noodle.headWindow().document;
var newNode =doc.getElementById("logo");
doc.body.insertBefore(newNode, doc.body.firstChild);
top.document.getElementById("body").rows="110,0,*";
newNode.style.position="inherit";
newNode.style.height="55px";
newNode.style.width="100%";

or you can use an image hosted elsewhere:

var doc=top.noodle.headWindow().document;
doc.getElementById("logo").style.display="none";
var newNode = doc.createElement('img');
newNode.src="https://vialect.com/wp-content/themes/quadro/images/logo.png";
newNode.style.height="55px";
newNode.style.width="100%";
doc.body.insertBefore(newNode, doc.body.firstChild);
top.document.getElementById("body").rows="110,0,*";

• 
function email(){
	var email=document.getElementsByName("val19238147")[0].value;
	top.location.href="mailto:"+email+"?subject=subject&body=body";
	document.mainform.submit();
}

function changeButton(name){
	var el=document.getElementById(name);
	if(el){
		el.type="button";
		top.noodle.cbc.addEventListener(el,"click",email);
	}
}

function doit(){
	changeButton("add");
	changeButton("addAnother");
	changeButton("update");
	top.noodle.core.logout_on_200=false;
}
setTimeout("doit();", 2000);

•

Moving Noodle from one environment to another can be done in a few ways:

Migrating your RDBMS data from one environment to another can be done in a few ways:

Notes/checklist:

  • Backup, vacuum, and lo_manage your database.
  • Upgrade Noodle, and empty the Noodle trash bin.
  • Obtain a new license key if the IP will differ
  • Check on the current database size, and make sure there is at least 2x that amount of storage available on the new server (and wherever the export file will initially be saved to). (amount of RAM for the new server should be at least database index size + a few GB for the operating system and apps)
  • Check the current database vendor and plan accordingly (SQL Server 2025 Express has a 50 GB limit, PostgreSQL 18 has no limit), Noodle export required if changing vendors, native export recommended otherwise. 
  • Install or copy Noodle to the new location and optionally set a domain name and HTTPS via ACME.
  • move the data