Olivier,
I have another one for you :). When I define oscar client and select padding 1 everything works fine. When I select padding 2 It adds it but the error below pops up. I'm not sure if it added everything correctly so I will play with padding1.
[INFO – mksirange] Adding a new network adapter for client uhouhpc02)
--------- SQL query: Select Nodes.name From Nodes Where Nodes.id='1'
----------
--------- SQL query: Select Nodes.name From Nodes Where Nodes.id='1'
----------
--------- SQL query: Select Nodes.name From Nodes Where Nodes.id='5'
----------
--------- SQL query: Select Nodes.name From Nodes Where Nodes.id='1'
----------
--------- SQL query: Select Nodes.name From Nodes Where Nodes.id='1'
----------
--------- SQL query: Select Nodes.name From Nodes Where Nodes.id='5'
----------
2015-1-3 22:24:59 [SystemInstaller::Machine :: Line 122] Parsing adapters
2015-1-3 22:24:59 [SystemInstaller::Machine :: Line 131] Syncing /etc/hosts/ to database.
2015-1-3 22:24:59 [SystemInstaller::Machine :: Line 170] Re-adding currently defined machines.
[ACTION – mksirange] Updating block "OSCAR block: OSCAR hosts" in file /etc/hosts
[INFO – mksirange] About to replace line into /etc/hosts
[INFO – mksirange] Successfully updated block "OSCAR block: OSCAR hosts" in file /etc/hosts
2015-1-3 22:24:59 [SystemInstaller::Machine :: Line 212] Copying hosts file to scripts directory.
Ref: CODE
[INFO – oscar_wizard] Running: post_clients
[ACTION – oscar_wizard] About to run: /usr/bin/post_clients
Populating /root/.ssh/known_hosts with defined clients' host keys
[INFO – post_clients] Loaded OSCAR configuration (at Database.pm:445)
------------------ run_pkg_script for apitest (post_clients) -------------------
[INFO – post_clients] Called getitem with oscar_packages_path and returning /usr/lib/oscar/packages
[INFO – post_clients] Looking for /usr/lib/oscar/packages/apitest/api-post-clientdef...
[INFO – post_clients] Looking for /usr/lib/oscar/packages/apitest/post_clients...
-------------------- run_pkg_script for base (post_clients) --------------------
[INFO – post_clients] Called getitem with oscar_packages_path and returning /usr/lib/oscar/packages
[INFO – post_clients] Looking for /usr/lib/oscar/packages/base/api-post-clientdef...
[INFO – post_clients] Looking for /usr/lib/oscar/packages/base/post_clients...
--------------------- run_pkg_script for c3 (post_clients) ---------------------
[INFO – post_clients] Called getitem with oscar_packages_path and returning /usr/lib/oscar/packages
[INFO – post_clients] Looking for /usr/lib/oscar/packages/c3/api-post-clientdef...
[ACTION – post_clients] About to run: /usr/lib/oscar/packages/c3/api-post-clientdef
[INFO – api-post-clientdef] Loaded OSCAR configuration (at Database.pm:445)
[INFO – post_clients] Looking for /usr/lib/oscar/packages/c3/post_clients...
------------------ run_pkg_script for ganglia (post_clients) -------------------
[INFO – post_clients] Called getitem with oscar_packages_path and returning /usr/lib/oscar/packages
[INFO – post_clients] Looking for /usr/lib/oscar/packages/ganglia/api-post-clientdef...
[INFO – post_clients] Looking for /usr/lib/oscar/packages/ganglia/post_clients...
-------------------- run_pkg_script for nfs (post_clients) ---------------------
[INFO – post_clients] Called getitem with oscar_packages_path and returning /usr/lib/oscar/packages
[INFO – post_clients] Looking for /usr/lib/oscar/packages/nfs/api-post-clientdef...
[INFO – post_clients] Looking for /usr/lib/oscar/packages/nfs/post_clients...
----------------- run_pkg_script for ntpconfig (post_clients) ------------------
[INFO – post_clients] Called getitem with oscar_packages_path and returning /usr/lib/oscar/packages
[INFO – post_clients] Looking for /usr/lib/oscar/packages/ntpconfig/api-post-clientdef...
[INFO – post_clients] Looking for /usr/lib/oscar/packages/ntpconfig/post_clients...
-------------------- run_pkg_script for oda (post_clients) ---------------------
[INFO – post_clients] Called getitem with oscar_packages_path and returning /usr/lib/oscar/packages
[INFO – post_clients] Looking for /usr/lib/oscar/packages/oda/api-post-clientdef...
[INFO – post_clients] Looking for /usr/lib/oscar/packages/oda/post_clients...
-------------------- run_pkg_script for sc3 (post_clients) ---------------------
[INFO – post_clients] Called getitem with oscar_packages_path and returning /usr/lib/oscar/packages
[INFO – post_clients] Looking for /usr/lib/oscar/packages/sc3/api-post-clientdef...
[INFO – post_clients] Looking for /usr/lib/oscar/packages/sc3/post_clients...
-------------------- run_pkg_script for sis (post_clients) ---------------------
[INFO – post_clients] Called getitem with oscar_packages_path and returning /usr/lib/oscar/packages
[INFO – post_clients] Looking for /usr/lib/oscar/packages/sis/api-post-clientdef...
[ACTION – post_clients] About to run: /usr/lib/oscar/packages/sis/api-post-clientdef
using ODA to read the OSCAR database for node and adapters information ...
[INFO – api-post-clientdef] Loaded OSCAR configuration (at Database.pm:445)
reading SIS database for node and adapters information ...
[INFO – api-post-clientdef] Loaded OSCAR configuration (at Database.pm:445)
[INFO] Impossible to get the adapters
Setting node uhouhpc02 field installer to "sis" ...
Done setting node uhouhpc02 field installer to "sis"
[INFO – post_clients] Looking for /usr/lib/oscar/packages/sis/post_clients...
------------------ run_pkg_script for switcher (post_clients) ------------------
[INFO – post_clients] Called getitem with oscar_packages_path and returning /usr/lib/oscar/packages
[INFO – post_clients] Looking for /usr/lib/oscar/packages/switcher/api-post-clientdef...
[ACTION – post_clients] About to run: /usr/lib/oscar/packages/switcher/api-post-clientdef
[switcher] Executing: /opt/sync_files/bin/confmgr --add /opt/env-switcher/etc/switcher.ini
[INFO – post_clients] Looking for /usr/lib/oscar/packages/switcher/post_clients...
----------------- run_pkg_script for sync-files (post_clients) -----------------
[INFO – post_clients] Called getitem with oscar_packages_path and returning /usr/lib/oscar/packages
[INFO – post_clients] Looking for /usr/lib/oscar/packages/sync-files/api-post-clientdef...
[INFO – post_clients] Looking for /usr/lib/oscar/packages/sync-files/post_clients...
-------------------- run_pkg_script for yume (post_clients) --------------------
[INFO – post_clients] Called getitem with oscar_packages_path and returning /usr/lib/oscar/packages
[INFO – post_clients] Looking for /usr/lib/oscar/packages/yume/api-post-clientdef...
[INFO – post_clients] Looking for /usr/lib/oscar/packages/yume/post_clients...
ERROR: Invalid node ID at /usr/bin/oscar_wizard line 909
ERROR: Undefined value for key node_id at /usr/share/perl5/vendor_perl/OSCAR/Database.pm line 1467
Tk::Error: DB_DEBUG>/usr/bin/oscar_wizard:
====>Failed to insert values into table Node_Package_Status at /usr/share/perl5/vendor_perl/OSCAR/Database.pm line 1471.
OSCAR::Database::update_node_package_status at /usr/share/perl5/vendor_perl/OSCAR/Database.pm line 1471
main::populate_client_group_nodes at /usr/bin/oscar_wizard line 914
main::postaddclients at /usr/bin/oscar_wizard line 844
SystemInstaller::Tk::AddClients::run_addclients at /usr/share/perl5/vendor_perl/SystemInstaller/Tk/AddClients.pm line 235
Tk callback for .toplevel7.button10
Tk::__ANON__ at /usr/lib64/perl5/vendor_perl/Tk.pm line 250
Tk::Button::butUp at /usr/lib64/perl5/vendor_perl/Tk/Button.pm line 175
<ButtonRelease-1>
(command bound to event)
Continuing to play....
On January 3, 2015 at 4:41 PM a...@comserv-usa.com wrote:
Hey Olivier,
I'm finally working on our cluster and using the latest version (November 14th release). anyways, so far so go when it comes to the initial install and everything. I was editing the oscar packages I installed (Starting with Ganglia) and when I put my configuration settings in I received the following...
DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's OSCAR Cluster', 'cluster__name', 'global', 'ganglia')' at line 1 at /usr/share/perl5/vendor_perl/OSCAR/oda.pm line 713.
DB_DEBUG>/usr/bin/oscar_wizard:
====> in Database::do_insert SQL : INSERT INTO Packages_config (value, name, context, package) VALUES ('EPE's OSCAR Cluster', 'cluster__name', 'global', 'ganglia')
Error message: Failed to insert values into Packages_config table in database <oscar>: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's OSCAR Cluster', 'cluster__name', 'global', 'ganglia')' at line 1 at /usr/share/perl5/vendor_perl/OSCAR/oda.pm line 719.
/usr/bin/oscar_wizard: SQL command that failed was: <INSERT INTO Packages_config (value, name, context, package) VALUES ('EPE's OSCAR Cluster', 'cluster__name', 'global', 'ganglia')> at /usr/share/perl5/vendor_perl/OSCAR/oda.pm line 719.
Tk::Error: /usr/bin/oscar_wizard:Failed to insert values via << INSERT INTO Packages_config (value, name, context, package) VALUES ('EPE's OSCAR Cluster', 'cluster__name', 'global', 'ganglia') >> at /usr/share/perl5/vendor_perl/OSCAR/Configbox.pm line 501
Tk callback for .toplevel.toplevel.button2
Tk::__ANON__ at /usr/lib64/perl5/vendor_perl/Tk.pm line 250
Tk::Button::butUp at /usr/lib64/perl5/vendor_perl/Tk/Button.pm line 175
<ButtonRelease-1>
(command bound to event)
I'm guessing that its editing cluster__name instead of cluster_name maybe? just a guess. Hope this helps
Thanks,
Andy
------------------------------------------------------------------------------ Dive into the World of Parallel Programming! The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net
_______________________________________________ Oscar-users mailing list Oscar-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/oscar-users
