I’m having trouble getting Asset Server to run on my machine running Windows Server 2003. The installation goes fine and I set up an admin password. When I try to connect to the server through unity, it claims that the password for “admin” is incorrect, even though I’ve verified that it is correct. When I open the AssetServerControl on the host machine and reset the admin password I get the following error:
Some problem occurred when setting password:
could not find a “psql.exe” to execute
ERROR: role “admin” does not exist
I’ve checked “C:\Program Files\Unity\AssetServer\bin” and psql.exe DOES in fact exist.
The Unity Asset Server Control Panel does claim that the Server is running, but it does have to be started after the install. (It doesn’t start automatically after installation.) I noticed that when I install asset server on my win7 machine everything runs fine and the asset server starts running and doesn’t need to be started.
Any ideas? Thanks!
Anyone else having trouble with Asset Server on Windows Server 2003?
I haven’t tried server 2003 so can’t help on that front, but you could want to try sysinternal’s ProcessMonitor as a way of diagnosing the ‘could not find a “psql.exe”’ problem
it can show you whether or not the asset server executable is finding psql.exe and where it’s looking
Great! This helps a lot. Still trying to track down the issue. =\ The best idea I have so far is that some permissions thing is causing asset server not to install correctly.
I get the ‘…could not find “psql.exe” to execute…’ error when I try to reset the admin password from Asset Server Control Panel. Here is an example line I get from ProcessMonitor when the error occurs:
Process: AssetServerControl.exe
Operation: Process Create
Path: C:\Program Files\Unity\AssetServer\bin\psql.exe
Result: SUCCESS
Detail: PID: 5480, Command line: “psql.exe” -U unitysrv -d template1 -c"alter role admin with password ‘bully’"
…so as far as I can tell, asset server knows the path to psql.exe, and is successfully calling the executable. My best guess is that somewhere in the install process, something is preventing the “admin” role from being created. Maybe there is a name collision with ‘admin’ somewhere? I dunno, any pointers in the right direction would be really helpful!
if you install it on user UnitySrv with admin rights it will work fine.
otherwise it waill fail, at least it did on 2008 server.
bug was reported on the original AS 2.0 thread and unhappily is still not fixed
I’m sorry if this is obvious, but do you mean create a new user called “UnitySrv” in Windows, and install asset server under this user with admin rights?
Correct
Thats the account that the Unity Asset server will be using anyway for its operation so you potentially have it around already.
You can checkout the release thread, mentioned the steps there on how to get it to install correctly on 2008, in case you need it in detailed form.
It seems such a sloppy process to have to create a user with a specific name just to get the program running correctly. Is this how asset server will always have to be installed under Windows Server?
Which release thread are you referring to? Shouldn’t this information be available directly on the unity3d.com/asset-server page? I hate to complain so much. I’m not really upset, just curious about why this setup process seems so complicated. I feel like I’m a fairly smart guy, but its making me feel pretty dumb. =)
Unfortunately, the way my server is set up, I can’t log out of the administrator user and into the UnitySrv user I’ve created. I tried running the installer as UnitySrv to no avail. =/
I had similar problem (described in first post) in Windows7 x64. It had solved by reinstalling Unity Asset Server with administrator rights.
Even if your user belongs to administrators group and UAC turned off, try to install server with “Run As Admin.” option.
You should check if you installed Asset Server on NTFS driver or FAT32/FAT. As I know (and thank God, it worked for me), postgresql doesn’t support Fat32/Fat format. You must install it on a NTFS driver. (Reference here