tsteiner
commented
11 years ago Originally Created By: tjensen2
Can someone please look at this as soon as possible.
Closed tsteiner closed 11 years ago
tsteiner
commented
11 years ago Originally Created By: tjensen2
Can someone please look at this as soon as possible.
ericras
commented
11 years ago This has been out of action for awhile since the registry was moved a couple weeks ago. I created a new mysql account on the new server for unlcms and gave the info to Tim about a week ago and he plugged it in. It must not have worked since it doesn't look like those sites ever got created.
It's going to require someone with neospire access to help debug if we just have a bad password copy/paste problem.
ericras
commented
11 years ago
mysql> show grants for unlcms
-> ;
+------------------------------------------------------------------------------+
| Grants for unlcms@% |
+------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'unlcms'@'%' IDENTIFIED BY PASSWORD '8675309' |
| GRANT SELECT, INSERT, UPDATE, DELETE ON `wdn`.* TO 'unlcms'@'%' |
+------------------------------------------------------------------------------+
2 rows in set (0.00 sec)Originally Created By: astark1
Have the site requests submitted during this outage been logged anywhere with the collected information?
If so, how can I accesss? If not, I will send a note to UNLcms list. Thanks.
ericras
commented
11 years ago
| id | url | site_admin | authorizing_unit_head | parent_site_url | create_alias | site_name | department | email | phone | comments | migration_url | migration_path | timestamp | site_type | alias_name |
| 583 | http://unlcms.unl.edu/spectrum-unl/spectrum-unl | s-tbowden1 | NULL | NULL | 0 | Spectrum UNL | Spectrum UNL | tybowd@gmail.com | 3083792888 | We are requesting the URL spectrum.unl.edu | qac.unl.edu | NULL | 2012-07-04 11:27:52 | student_org | NULL |
| 584 | NULL | astark1 | bbuffum1 | NULL | 0 | theatrix | JohnnyCarsonSchool | astark@unl.edu | 402 472 5615 | NULL | http://www.unl.edu/theatrix | /cwis/data/theatrix | 2012-07-09 16:38:56 | other | NULL |
| 585 | http://unlcms.unl.edu/modern-language-literature/czech-language-learning | msaskova-pierce1 | NULL | htttp://www.unl.edu/modlang | 0 | Czech Language Learning | Modern Language & Literature | msaskova-pierce1@unl.edu | 402 472 1336 | NULL | NULL | NULL | 2012-07-10 12:02:04 | other | Czech |
| 586 | http://unlcms.unl.edu/nebraska-forest-service/nebraska-forest-service | rarmbrust2 | sjosiah2 | NULL | 0 | Nebraska Forest Service | Nebraska Forest Service | rarmbrust2@unl.edu | 402 472 6640 | We're updating the NFS website, and we're interested in exploring CMS as an alternative to the previous template-based format. | nfs.unl.edu | NULL | 2012-07-10 15:40:59 | other | NULL |
| 587 | http://unlcms.unl.edu/nebraska-forest-service/nebraska-statewide-arboretum | rarmbrust2 | cpaxton1 | arboretum.unl.edu | 0 | Nebraska Statewide Arboretum | Nebraska Forest Service | rarmbrust2@unl.edu | 402 472 6640 | Looking to explore using UNL's CMS to run the NSA's website -- mainly to make future changes easier for staff. | NULL | NULL | 2012-07-10 15:48:27 | other | NULL |
| 588 | NULL | astark1 | srattanasuksun2 | NULL | 0 | tanu | rso | astark@unl.edu | 402 472 5615 | NULL | NULL | NULL | 2012-07-11 08:39:34 | student_org | NULL |
| 589 | NULL | mcunningham3 | NULL | biosci.unl.edu | 0 | Organismic Biology | School of Biological Sciences | mary.cunningham@unl.edu | 402 472 2721 | NULL | NULL | NULL | 2012-07-11 14:24:06 | individual | NULL |
| 590 | NULL | mcunningham3 | NULL | biosci.unl.edu | 0 | Organismic Biology | School of Biological Sciences | mary.cunningham@unl.edu | 402 472 2721 | NULL | NULL | NULL | 2012-07-11 14:24:57 | individual | NULL |
| 591 | NULL | s-lhock3 | sadams1 | http://agronomy.unl.edu/ | 0 | UNL Horticulture Club | Agronomy & Horticulture | lauracarmbrust@gmail.com | 3089915956 | We'd like to look into setting up a new site for Hort Club using the UNL Template, to improve the club's image and our ability to have timely updates and information. Thanks!
Laura (Hock) Armbrust, UNL Hort Club President | hortclub.unl.edu | NULL | 2012-07-12 13:27:09 | student_org | NULL |
| 592 | NULL | kburroughs2 | NULL | unl.edu/iota | 0 | Epsilon Rho-University of Nebraska-Lincoln | Iota Phi Theta Fraternity Inc. | kriston.burroughs@yahoo.com | 314-599-2672 | NULL | NULL | NULL | 2012-07-15 20:15:27 | individual | iota |
| 593 | NULL | acoleman1 | NULL | NULL | 0 | Steven Harris Lab | Office of University Communications | acoleman@unl.edu | 402 472 0072 | NULL | NULL | NULL | 2012-07-18 11:27:58 | individual | NULL |
| 594 | NULL | acoleman1 | NULL | NULL | 0 | David Holding Laboratory | Office of University Communications | acoleman@unl.edu | 402 472 0072 | NULL | NULL | NULL | 2012-07-18 11:28:27 | individual | NULL |
| 595 | NULL | jtemplin2 | NULL | NULL | 0 | Jonathan Templin | Psychology | jtemplin@unl.edu | 706 680 7148 | NULL | NULL | NULL | 2012-07-23 14:04:59 | individual | NULL |
| 596 | NULL | asmith45 | cjohnston1 | http://www.extension.unl.edu/web/Extension/PubsGraphicsWeb/Toolbox | 0 | Extension office: graphics and logos website | Agriculture/ 4-H | ashlie.pace@my.wheaton.edu | 760-533-1304 | I need to place the UNL extension logo and the NEP logo on a brochure that we are handing out at the county fairs. The website that Cathy Johnston gave me will not allow me to enter the site. Thank you! | NULL | NULL | 2012-07-24 10:52:18 | dept | NULL |
| 597 | NULL | alanham2 | NULL | NULL | 0 | UNL Runners Club | Campus Recreation | alanham2@unl.edu | 402 472 9481 | NULL | NULL | NULL | 2012-07-27 14:03:14 | student_org | NULL |
| 598 | NULL | astark1 | NULL | NULL | 0 | retreenebraska | Information Services | astark@unl.edu | 402 472 5615 | NULL | NULL | NULL | 2012-07-30 15:00:39 | other | NULL |
| 599 | NULL | astark1 | jkelling2 | NULL | 0 | retreenebraska | nfs | astark@unl.edu | 402 472 5615 | NULL | http://nfs.unl.edu/retreenebraska.asp | NULL | 2012-07-30 15:02:29 | other | NULL |
| 600 | NULL | astark1 | jkelling2 | NULL | 0 | ncfc | nfs | astark@unl.edu | 402 472 5615 | NULL | http://www.nfs.unl.edu/CommunityForestry/CFCouncil.asp | NULL | 2012-07-30 15:04:04 | other | NULL |
| 601 | NULL | acoleman1 | NULL | NULL | 0 | David Holding Lab | Office of University Communications | acoleman@unl.edu | 402 472 0072 | Lab site for David Holding Lab, to replace http://psiweb.unl.edu/holding/ | NULL | NULL | 2012-07-30 15:40:37 | individual | NULL |
| 602 | NULL | acoleman1 | NULL | NULL | 0 | Bin Yu Lab | Office of University Communications | acoleman@unl.edu | 402 472 0072 | Bin Yu lab website to replace: http://psiweb.unl.edu/YU_SIte/ | NULL | NULL | 2012-07-30 15:41:41 | individual | NULL |
| 603 | NULL | jtemplin2 | dhansen1 | http://psychology.unl.edu/labs | 0 | Jonathan Templin | Psychology | jtemplin@unl.edu | 706 680 7148 | NULL | NULL | NULL | 2012-07-30 16:46:51 | individual | templin |
| 604 | NULL | jwilson12 | maskren2 | is.unl.edu | 0 | IS acccounting | Information Services | jon.wilson@unl.edu | 402 472 5228 | NULL | NULL | NULL | 2012-07-31 10:11:51 | individual | NULL |
| 605 | NULL | jwilson12 | maskren2 | is.unl.edu | 0 | IS HR | Information Services | jon.wilson@unl.edu | 402 472 5228 | NULL | NULL | NULL | 2012-07-31 10:13:00 | individual | NULL |
| 606 | NULL | acoleman1 | rcrisler1 | NULL | 0 | Campus Master Plan | Office of University Communications | acoleman@unl.edu | 402 472 0072 | Site for campus master plan | NULL | NULL | 2012-07-31 10:37:46 | individual | NULL |
| 607 | NULL | rsutton1 | rgaussoin1 | agronomy.unl.edu | 0 | plants.unl.edu | Agronomy & Horticulture | rsutton1@unl.edu | 402 472 1127 | This website needs to operational for fall semester. It is an important web tool integral to the HORT/NRES/LARC/212, | NULL | NULL | 2012-07-31 14:54:17 | dept | NULL |
| 608 | NULL | mbasnet2 | NULL | www.unl.edu/nsaunl | 0 | Nepalese Student Organisation | Nepalese Student Organisation | nsaatunl@gmail.com | 6179552163 | NULL | www.unl.edu/nsaunl | NULL | 2012-08-03 15:14:18 | student_org | NULL Above is every request since July 1. Some of those early ones may have been created.
tsteiner
commented
11 years ago Originally Created By: astark1
Eric - THANK YOU for the list of requests and information collected. The format you have provided is fine. In a quick look at, I believe it was working until July 11. At any rate, I believe you have provided me the information needed so that I can get up to date on the sites that need to be created.
tsteiner
commented
11 years ago Originally Created By: bbieber2
I think the problem is simply that ucommsrv.unl.edu has port 3306 blocked. Liebgott can open port 3306 to the neospire/hosting.com ip addresses.
ericras
commented
11 years ago From Liebgott 7/15/12
port 3306/tcp incoming to ucommsrv is open to:
129.93.16.24 129.93.39.70 67.208.34.248
Jim L.
tsteiner
commented
11 years ago While the cron job to create sites is still running every 5 minutes, the job to check for new sites to be created was only running at 4:00. I have changed this to have that second cron job run every 5 minutes as well.
Originally Created By: astark1
When using the webform to request a new UNLcms site, the request is successfully submitted, however the process does not complete. The form is at: http://www1.unl.edu/wdn/?view=siterequest
I am not certain as to who to to assign to, but I am starting with Brett.