Jump to content


Photo

Cannot configure server database backend

configure database server

  • Please log in to reply
29 replies to this topic

#1 s1000l

s1000l

    Member

  • Members
  • PipPip
  • 19 posts

Posted 24 July 2012 - 05:58 AM

When I run configureserver, the configuration of the database server backend fails. Nothing happens when I click on "change the database backend now".

This is a clean install with no changes. I uninstalled and then reinstalled after deleting all of the files in /opt/plasticscm4.

Thanks

#2 manu

manu

    Advanced

  • Administrators
  • 2,120 posts

Posted 24 July 2012 - 06:06 AM

Hello s1000l,

can you kindly tell us you Plastic SCM version? The admintool db migration must be opened when you click in "Change the database backend now" if the wizard is not opening it we can do it manually. Please execute the admintool program and inside the "Database" tab you will be able to change the backend.

Can you lease tell me which backend you are going to use?

#3 s1000l

s1000l

    Member

  • Members
  • PipPip
  • 19 posts

Posted 24 July 2012 - 06:47 AM

4.1.10.315 linux on ubuntu 12.04 server

#4 manu

manu

    Advanced

  • Administrators
  • 2,120 posts

Posted 24 July 2012 - 06:49 AM

Are you able to open the admintool?

#5 s1000l

s1000l

    Member

  • Members
  • PipPip
  • 19 posts

Posted 24 July 2012 - 06:56 AM

I execute "./configureserver" located in /opt/plasticscm4/server folder and step through the Plastic SCM server configuration wizard.

On the screen "Server configuration finished", I click on the highligted "change the ... if desired." and nothing happens. However, an error message appears in the terminal:

" xdg-open: unexpected argument 'database wizard' "

Can you tell me how I can execute the admintool program? I have tried to execute the admintool.exe program in the plastic server folder

#6 s1000l

s1000l

    Member

  • Members
  • PipPip
  • 19 posts

Posted 24 July 2012 - 06:57 AM

"base: admintool.exe: cannot execute binary fine"

#7 s1000l

s1000l

    Member

  • Members
  • PipPip
  • 19 posts

Posted 24 July 2012 - 06:57 AM

btw, great headgear!

#8 manu

manu

    Advanced

  • Administrators
  • 2,120 posts

Posted 24 July 2012 - 07:02 AM

hahahaha, thanks, I only use it on special dates :)

I'm starting thinking that the admin tool is not prepared for linux yet. Let's do it like the old school guys. Please tell me which back-end are you going to use.

#9 s1000l

s1000l

    Member

  • Members
  • PipPip
  • 19 posts

Posted 24 July 2012 - 07:05 AM

I am attempting to install Plastic on a Ubuntu 12.04 server (i386) running in VMPlayer on a Ubuntu 12.04 64-bit server.

In the virtual Plastic server, I have installed Ubuntu with the LAMP option and am attempting to switch the Plastic server over to the mySQL server.

Does this give you enough details?

#10 s1000l

s1000l

    Member

  • Members
  • PipPip
  • 19 posts

Posted 24 July 2012 - 07:06 AM

BTW, I am okay with Linux ... not a truly experienced administrator.

#11 manu

manu

    Advanced

  • Administrators
  • 2,120 posts

Posted 24 July 2012 - 07:11 AM

Ok, so here you have how to configure Plastic SCM with MySQL: http://www.plasticsc...with-mysql.aspx

Basically, if everything is fine at the MySQL side (port oppened, requests accepted, users and permissions stuff), you will only need to replace your current "db.conf" file with this new one: (The db.conf file is at the Plastic SCM server installation directory /opt/plasticscm/server)

<DbConfig>
  <ProviderName>mysql</ProviderName>
  <ConnectionString>Server=_SERVER_;User ID=_USER_;Password=_PASSWORD_;Database={0};Pooling=true</ConnectionString>
  <DatabasePath></DatabasePath>
</DbConfig>

Replace the _SERVER_ string with the MySQL server machine.
Replace the _USER_ string with the MySQL user. Typically root just to see everything is fine.
Replace the _PASSWORD_ string with the MySQL password for the user provided.

Stop the Plastic SCM server daemon and start it again.

#12 s1000l

s1000l

    Member

  • Members
  • PipPip
  • 19 posts

Posted 24 July 2012 - 07:15 AM

I did try that and had what appeared to be a running Plastic server. I created a test repository and then logged into mySQL using a Linux client. When I accessed the mySQL server with Navigator or webmin, I cannot see any database created by Plastic.

I did restart plastic using "plasticsd restart" command.

#13 manu

manu

    Advanced

  • Administrators
  • 2,120 posts

Posted 24 July 2012 - 07:24 AM

That's strange, if the create repository didn't spit errors that's why

1) the server is still using sqlite.
2) the mysql database is created

Take a look into the Plastic SCM server log file (/opt/plasticscm/server/plastic.server.log) in order to get more information, if you are not able to get it up and running with MySQL we can schedule a short GoToMeeting session in order to fix it.

Can you please tell me your time zone?

#14 s1000l

s1000l

    Member

  • Members
  • PipPip
  • 19 posts

Posted 24 July 2012 - 07:26 AM

Pacific (PST).

I will need to redo the steps again as I did an uninstall and reinstalled without the db.conf changes. I will make these changes and get back to you shortly.

Thanks again

#15 s1000l

s1000l

    Member

  • Members
  • PipPip
  • 19 posts

Posted 24 July 2012 - 07:40 AM

After making the db.conf changes, "plasticsd stop" results in the following error:
Stopping PlasticSCM server:/opt/plasticscm4/server/plasticsd: line 120 [: too many arguments
No directory, logging in with HOME=/

When I attempt to restart plasticsd, I get the following error:

Warning: /tmp/plasticd4.exe.lock lock file exists but process is not running. Please delete this file.
No directory, logging in with HOME=/c
Starting PlasticSCM server: /opt/plasticscm4/server/plasticsd: line 69: [: too many arguments
No directory, logging in with HOME=/
Warning: /tmp/plasticd4.exe.lock lock file exists but process is not running. Please delete this file.
Warning: /tmp/plasticd4.exe.lock lock file exists but process is not running. Please delete this file.
...

When I look into the log file I see the last entry as:

plasticscm at FATAL Daemon - Configuration file '/opt/plasticscm4/server/remoting.conf' could not be loaded: Address already in use

#16 s1000l

s1000l

    Member

  • Members
  • PipPip
  • 19 posts

Posted 24 July 2012 - 07:41 AM

I have tried to delete the lock file and then restart plasticsd to no avail, it keeps giving me the same error(s).

#17 manu

manu

    Advanced

  • Administrators
  • 2,120 posts

Posted 24 July 2012 - 07:44 AM

It seems the server is still running

Address already in use


Try the following:
ps -fA | grep plasticd

take the PID and kill it, remove the "/tmp/plasticd4.exe.lock" file and try to start again the daemon.

if it doesn't work you can manually start the daemon by running this command:

/opt/plasticscm/server> ./plasticd --daemon


#18 s1000l

s1000l

    Member

  • Members
  • PipPip
  • 19 posts

Posted 24 July 2012 - 07:49 AM

I tried to kill the daemon twice and it still shows when I check with "ps -fA | grep plasticd" or just "ps -ax". In both cases, the daemon shows running on the same PID. In my case, this is 3481.

I am going to reboot the system ...

#19 s1000l

s1000l

    Member

  • Members
  • PipPip
  • 19 posts

Posted 24 July 2012 - 07:50 AM

btw, I am using a terminal under root

#20 s1000l

s1000l

    Member

  • Members
  • PipPip
  • 19 posts

Posted 24 July 2012 - 07:55 AM

system is now rebooted ..




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users