加入收藏 | 设为首页 | 会员中心 | 我要投稿 李大同 （https://www.lidatong.com.cn/）- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置： 首页 > 百科 > 正文

Spacewalk 1.7 With PostgreSQL

发布时间：2020-12-13 17:47:10 所属栏目：百科 来源：网络整理
导读：This article will show you how to integrate spacewalk 1.7 with postgreSQL.Before you do,you must configure yum repository.Append following lines to your file: [Satellite] name = Spacewalk Satellite baseurl = http ://spacewalk.redhat.com/yu

This article will show you how to integrate spacewalk 1.7 with postgreSQL.Before you do,you must configure yum repository.Append following lines to your file:

 
 
    
  
  
  1. [Satellite]
    2. 
  
  
  2. name=SpacewalkSatellite
    3. 
  
  
  3. baseurl=http://spacewalk.redhat.com/yum/1.7/RHEL/6/x86_64/
    4. 
  
  
  4. enabled=1
    5. 
  
  
  5. gpgcheck=1
    6. 
  
  
  6. gpgkey=http://spacewalk.redhat.com/yum/RPM-GPG-KEY-spacewalk-2012
    7. 
  
  
    8. 
  
  
  8. [Satellite-Client]
    9. 
  
  
  9. name=SpacewalkSatellite
    10. 
  
  
  10. baseurl=http://spacewalk.redhat.com/yum/1.7-client/RHEL/6/x86_64/
    11. 
  
  
  11. enabled=1
    12. 
  
  
  12. gpgcheck=1
    13. 
  
  
  13. gpgkey=http://spacewalk.redhat.com/yum/RPM-GPG-KEY-spacewalk-2012
    14. 
  
  
    15. 
  
  
  15. [epel]
    16. 
  
  
  16. name=RedHatEnterpriseLinux$releasever-$basearch-Debug
    17. 
  
  
  17. baseurl=http://dl.fedoraproject.org/pub/epel/6/x86_64/
    18. 
  
  
  18. enabled=1
    19. 
  
  
  19. gpgcheck=1
    20. 
  
  
  20. gpgkey=http://dl.fedoraproject.org/pub/epel/RPM-GPG-KEY-EPEL-6
    21. 
  
  
    22. 
  
  
  22. [Centos]
    23. 
  
  
  23. name=Centos
    24. 
  
  
  24. baseurl=http://mirrors.163.com/centos/6.2/os/x86_64/
    25. 
  
  
  25. enabled=1
    26. 
  
  
  26. gpgcheck=1
    27. 
  
  
  27. gpgkey=http://mirrors.163.com/centos/6.2/os/x86_64/RPM-GPG-KEY-CentOS-6
    28. 
  
  
    29. 
  
  
  29. [Centos-Update]
    30. 
  
  
  30. name=Centos
    31. 
  
  
  31. baseurl=http://mirrors.163.com/centos/6.2/updates/x86_64/
    32. 
  
  
  32. enabled=1
    33. 
  
  
  33. gpgcheck=1
    34. 
  
  
  34. gpgkey=http://mirrors.163.com/centos/6.2/os/x86_64/RPM-GPG-KEY-CentOS-6
    35. 
  
  
    36. 
  
  
  36. [Jpackes]
    37. 
  
  
  37. name=jpackage
    38. 
  
  
  38. baseurl=http://mirrors.dotsrc.org/jpackage/5.0/generic/free/
    39. 
  
  
  39. enabled=1
    40. 
  
  
  40. gpgcheck=1
    41.

After,use following command to install spacewalk:

 
 
    
  
  
  1. yum-yinstallspacewalk-postgresql
    2.

Configure postgreSQL database

You will need to becomethe operating system user under which PostgreSQL was installed (usually postgres) to create the firstuser account. It could also be that you were assigned a PostgreSQL user name that is different from youroperating system user name.By default,postgreSQL has already created a user postgres.

 
 
    
  
  
  1. [root@sate~]#id-apostgres
    2. 
  
  
  2. uid=26(postgres)gid=26(postgres)groups=26(postgres)
    3.

1.Create database and user:

Before you do,you mustinitialize postgrsql and start it by following command.

 
 
    
  
  
  1. [root@sate~]#servicepostgresqlinitdb
    2. 
  
  
  2. Initializingdatabase:[OK]
    3. 
  
  
  3. [root@sate~]#servicepostgresqlstart
    4. 
  
  
  4. Startingpostgresqlservice:[OK]
    5. 
 
 
 
 
    
  
  
  1. [root@sate~]#su-postgres
    2. 
  
  
  2. -bash-4.1$PGPASSWORD=redhat //Set the spaceuser's password
    3. 
  
  
  3. -bash-4.1$createdbspacewalk //Create database
    4. 
  
  
  4. -bash-4.1$createlangplpgsqlspacewalk
    5. 
  
  
  5. -bash-4.1$createuser-P-sDRspaceuser //Create user
    6. 
  
  
  6. Enterpasswordfornewrole:
    7. 
  
  
  7. Enteritagain:
    8.

2.Append following contents to /var/lib/pgsql/data/pg_hba.conf:

 
 
    
  
  
  1. hostallall172.16.255.0/24trust
    2.

3.Append following lines to /var/lib/pgsql/data/psotgresql.conf:

 
 
    
  
  
  1. listen_addresses='*'
    2.

4.Restart postgresql service:

 
 
    
  
  
  1. [root@sate~]#servicepostgresqlrestart
    2. 
  
  
  2. Stoppingpostgresqlservice:[OK]
    3. 
  
  
  3. Startingpostgresqlservice:[OK]
    4.

5.Connect to spacewalk database:

 
 
    
  
  
  1. [root@sate~]#su-postgres
    2. 
  
  
  2. postgres=#cspacewalk
    3. 
  
  
  3. psql(8.4.9)
    4. 
  
  
  4. Youarenowconnectedtodatabase"spacewalk".
    5. 
  
  
  5. spacewalk=#
    6. 
  
  
  6. spacewalk=#db
    7. 
  
  
  7. Listoftablespaces
    8. 
  
  
  8. Name|Owner|Location
    9. 
  
  
  9. ------------+----------+----------
    10. 
  
  
  10. pg_default|postgres|
    11. 
  
  
  11. pg_global|postgres|
    12. 
  
  
  12. (2rows)
    13.

Configure Spacewalk by spacewalk-setup command

 
 
    
  
  
  1. [root@sate~]#spacewalk-setup--disconnected
    2. 
  
  
  2. **Database:SettingupdatabaseconnectionforPostgreSQLbackend.
    3. 
  
  
  3. Hostname(leaveemptyforlocal)?sate.xzxj.edu.cn
    4. 
  
  
  4. Port[5432]?
    5. 
  
  
  5. Database?spacewalk
    6. 
  
  
  6. Username?spaceuser
    7. 
  
  
  7. Password?
    8. 
  
  
  8. ***Progress:##################################
    9. 
  
  
  9. *Settingupusersandgroups.
    10. 
  
  
  10. **GPG:InitializingGPGandimportingkey.
    11. 
  
  
  11. Youmustenteranemailaddress.
    12. 
  
  
  12. AdminEmailAddress?root@localhost
    13. 
  
  
  13. *Performinginitialconfiguration.
    14. 
  
  
  14. *ActivatingSpacewalk.
    15. 
  
  
  15. **LoadingSpacewalkCertificate.
    16. 
  
  
  16. **Verifyingcertificatelocally.
    17. 
  
  
  17. **ActivatingSpacewalk.
    18. 
  
  
  18. *EnablingMonitoring.
    19. 
  
  
  19. *ConfiguringapacheSSLvirtualhost.
    20. 
  
  
  20. Shouldsetupconfigureapache'sdefaultsslserverforyou(savesoriginalssl.conf)[Y]?
    21. 
  
  
  21. *Configuringtomcat.
    22. 
  
  
  22. **/etc/tomcat6/server.xmlhasbeenbackeduptoserver.xml-swsave
    23. 
  
  
  23. Reversed(orpreviouslyapplied)patchdetected!Skippingpatch.
    24. 
  
  
  24. 1outof1hunkignored--savingrejectstofileweb.xml.rej
    25. 
  
  
  25. *Configuringjabberd.
    26. 
  
  
  26. *CreatingSSLcertificates.
    27. 
  
  
  27. CAcertificatepassword?
    28. 
  
  
  28. Re-enterCAcertificatepassword?
    29. 
  
  
  29. Organization?xzxj
    30. 
  
  
  30. OrganizationUnit[sate.xzxj.edu.cn]?
    31. 
  
  
  31. EmailAddress[root@localhost]?
    32. 
  
  
  32. City?ShangHai
    33. 
  
  
  33. State?ShangHai
    34. 
  
  
  34. Countrycode(Examples:"US","JP","IN",ortype"?"toseealist)?CN
    35. 
  
  
  35. **SSL:GeneratingCAcertificate.
    36. 
  
  
  36. **SSL:DeployingCAcertificate.
    37. 
  
  
  37. **SSL:Generatingservercertificate.
    38. 
  
  
  38. **SSL:StoringSSLcertificates.
    39. 
  
  
  39. *Deployingconfigurationfiles.
    40. 
  
  
  40. *Updateconfigurationindatabase.
    41. 
  
  
  41. *SettingupCobbler..
    42. 
  
  
  42. cobblerddoesnotappeartoberunning/accessible
    43. 
  
  
  43. CobblerrequirestftpandxinetdservicesbeturnedonforPXEprovisioningfunctionality.Enabletheseservices[Y]?
    44. 
  
  
  44. cobblerddoesnotappeartoberunning/accessible
    45. 
  
  
  45. *Restartingservices.
    46. 
  
  
  46. Installationcomplete.
    47. 
  
  
  47. Visithttps://sate.xzxj.edu.cntocreatetheSpacewalkadministratoraccount.
    48.

Check Spacewalk service

 
 
    
  
  
  1. [root@sate~]#spacewalk-servicestatus
    2. 
  
  
  2. router(pid16795)isrunning...
    3. 
  
  
  3. sm(pid16802)isrunning...
    4. 
  
  
  4. c2s(pid16809)isrunning...
    5. 
  
  
  5. s2s(pid16816)isrunning...
    6. 
  
  
  6. osa-dispatcher(pid16832)isrunning...
    7. 
  
  
  7. tomcat6(pid16901)isrunning...[OK]
    8. 
  
  
  8. httpd(pid17126)isrunning...
    9. 
  
  
  9. 2012-03-0918:41:43Monitoring:-----------InstallSoftwareConfigSTATUS---------------
    10. 
  
  
  10. 2012-03-0918:41:44Monitoring:-----------NotifEscalatorSTATUS---------------
    11. 
  
  
  11. 2012-03-0918:41:46Monitoring:-----------GenerateNotifConfigSTATUS---------------
    12. 
  
  
  12. 2012-03-0918:41:47Monitoring:-----------NotifLauncherSTATUS---------------
    13. 
  
  
  13. 2012-03-0918:41:49Monitoring:-----------NotifierSTATUS---------------
    14. 
  
  
  14. 2012-03-0918:41:54Monitoring:-----------AckProcessorSTATUS---------------
    15. 
  
  
  15. 2012-03-0918:41:55Monitoring:-----------TSDBLocalQueueSTATUS---------------
    16. 
  
  
  16. 2012-03-0918:42:02MonitoringScout:-----------InstallSoftwareConfigSTATUS---------------
    17. 
  
  
  17. rhn-searchisrunning(17338).
    18. 
  
  
  18. cobblerd(pid17393)isrunning...
    19. 
  
  
  19. RHNTaskomaticisrunning(17451).
    20.

Create the Spacewalk administrator account

image

After created,use administrator account to access:

image

image

View Database information

1.List tables:

 
 
    
  
  
  1. [root@sate~]#su-postgres
    2. 
  
  
  2. -bash-4.1$psqlspacewalk
    3. 
  
  
  3. psql(8.4.9)
    4. 
  
  
  4. Type"help"forhelp.
    5. 
  
  
  5. spacewalk=#dt
    6. 
  
  
  6. Listofrelations
    7. 
  
  
  7. Schema|Name|Type|Owner
    8. 
  
  
  8. --------+--------------------------------+-------+-----------
    9. 
  
  
  9. public|dual|table|spaceuser
    10. 
  
  
  10. public|pxtsessions|table|spaceuser
    11. 
  
  
  11. public|qrtz_blob_triggers|table|spaceuser
    12. 
  
  
  12. public|qrtz_calendars|table|spaceuser
    13. 
  
  
  13. public|qrtz_cron_triggers|table|spaceuser
    14. 
  
  
  14. public|qrtz_fired_triggers|table|spaceuser
    15. 
  
  
  15. public|qrtz_job_details|table|spaceuser
    16. 
  
  
  16. public|qrtz_job_listeners|table|spaceuser
    17. 
  
  
  17. public|qrtz_locks|table|spaceuser
    18. 
  
  
  18. public|qrtz_paused_trigger_grps|table|spaceuser
    19. 
  
  
  19. public|qrtz_scheduler_state|table|spaceuser
    20. 
  
  
  20. public|qrtz_simple_triggers|table|spaceuser
    21. 
  
  
  21. public|qrtz_trigger_listeners|table|spaceuser
    22. 
  
  
  22. public|qrtz_triggers|table|spaceuser
    23. 
  
  
  23. public|rhn_check_probe|table|spaceuser
    24. 
  
  
  24. public|rhn_check_suite_probe|table|spaceuser
    25. 
  
  
  25. public|rhn_check_suites|table|spaceuser
    26. 
  
  
  26. public|rhn_command|table|spaceuser
    27. 
  
  
  27. public|rhn_command_class|table|spaceuser
    28. 
  
  
  28. public|rhn_command_groups|table|spaceuser
    29. 
  
  
  29. public|rhn_command_param_threshold|table|spaceuser
    30. 
  
  
  30. public|rhn_command_parameter|table|spaceuser
    31. 
  
  
  31. public|rhn_command_queue_commands|table|spaceuser
    32. 
  
  
  32. public|rhn_command_queue_execs|table|spaceuser
    33. 
  
  
  33. public|rhn_command_queue_instances|table|spaceuser
    34. 
  
  
  34. public|rhn_command_queue_params|table|spaceuser
    35. 
  
  
  35. public|rhn_command_queue_sessions|table|spaceuser
    36. 
  
  
  36. public|rhn_command_requirements|table|spaceuser
    37. 
  
  
  37. public|rhn_command_target|table|spaceuser
    38. 
  
  
  38. public|rhn_config_group|table|spaceuser
    39. 
  
  
  39. public|rhn_config_macro|table|spaceuser
    40. 
  
  
  40. public|rhn_config_parameter|table|spaceuser
    41. 
  
  
  41. public|rhn_config_security_type|table|spaceuser
    42. 
  
  
  42. public|rhn_contact_group_members|table|spaceuser
    43. 
  
  
  43. public|rhn_contact_groups|table|spaceuser
    44. 
  
  
  44. public|rhn_contact_methods|table|spaceuser
    45. 
  
  
  45. public|rhn_current_state_summaries|table|spaceuser
    46. 
  
  
  46. public|rhn_deployed_probe|table|spaceuser
    47. 
  
  
  47. public|rhn_host_probe|table|spaceuser
    48. 
  
  
  48. public|rhn_ll_netsaint|table|spaceuser
    49. 
  
  
  49. public|rhn_method_types|table|spaceuser
    50. 
  
  
  50. public|rhn_metrics|table|spaceuser
    51. 
  
  
  51. public|rhn_multi_scout_threshold|table|spaceuser
    52. 
  
  
  52. public|rhn_notification_formats|table|spaceuser
    53. 
  
  
  53. ............
    54. 
  
  
  54. (383rows)
    55.

2.List views:

 
 
    
  
  
  1. spacewalk=#dv
    2. 
  
  
  2. Listofrelations
    3. 
  
  
  3. Schema|Name|Type|Owner
    4. 
  
  
  4. --------+--------------------------------+------+-----------
    5. 
  
  
  5. public|all_primary_keys|view|spaceuser
    6. 
  
  
  6. public|all_tab_columns|view|spaceuser
    7. 
  
  
  7. public|rhn_contact_monitoring|view|spaceuser
    8. 
  
  
  8. public|rhn_customer_monitoring|view|spaceuser
    9. 
  
  
  9. public|rhn_host_monitoring|view|spaceuser
    10. 
  
  
  10. public|rhnactionoverview|view|spaceuser
    11. 
  
  
  11. public|rhnavailablechannels|view|spaceuser
    12. 
  
  
  12. public|rhncddevice|view|spaceuser
    13. 
  
  
  13. public|rhnchannelfamilyoverview|view|spaceuser
    14. 
  
  
  14. public|rhnchannelfamilypermissions|view|spaceuser
    15. 
  
  
  15. public|rhnchannelfamilyserverfve|view|spaceuser
    16. 
  
  
  16. public|rhnchannelfamilyserverphysical|view|spaceuser
    17. 
  
  
  17. public|rhnchannelfamilyservers|view|spaceuser
    18. 
  
  
  18. public|rhnchannelfamilyservervirtual|view|spaceuser
    19. 
  
  
  19. public|rhnchannelnewestpackageview|view|spaceuser
    20. 
  
  
  20. public|rhnchannelpermissions|view|spaceuser
    21. 
  
  
  21. public|rhnchanneltreeview|view|spaceuser
    22. 
  
  
  22. public|rhnchecksumview|view|spaceuser
    23. 
  
  
  23. public|rhnentitledservers|view|spaceuser
    24. 
  
  
  24. public|rhnhwdevice|view|spaceuser
    25. 
  
  
  25. public|rhnorgchannelfamilypermissions|view|spaceuser
    26. 
  
  
  26. public|rhnorgchanneltreeview|view|spaceuser
    27. 
  
  
  27. public|rhnorgerrata|view|spaceuser
    28. 
  
  
  28. public|rhnpackagechangelog|view|spaceuser
    29. 
  
  
  29. public|rhnserverentitlementphysical|view|spaceuser
    30. 
  
  
  30. public|rhnserverentitlementview|view|spaceuser
    31. 
  
  
  31. public|rhnserverentitlementvirtual|view|spaceuser
    32. 
  
  
  32. public|rhnservererratatypeview|view|spaceuser
    33. 
  
  
  33. public|rhnserverfeaturesview|view|spaceuser
    34. 
  
  
  34. public|rhnserverfvecapable|view|spaceuser
    35. 
  
  
  35. public|rhnservergroupmembership|view|spaceuser
    36. 
  
  
  36. public|rhnservergroupoverview|view|spaceuser
    37. 
  
  
  37. public|rhnservergroupovlitehelper|view|spaceuser
    38. 
  
  
  38. public|rhnserverneedederratacache|view|spaceuser
    39. 
  
  
  39. public|rhnserverneededpackagecache|view|spaceuser
    40. 
  
  
  40. public|rhnserverneededview|view|spaceuser
    41. 
  
  
  41. ..........
    42. 
  
  
  42. (58rows)
    43.

3.List roles:

 
 
    
  
  
  1. spacewalk=#dg
    2. 
  
  
  2. Listofroles
    3. 
  
  
  3. Rolename|Attributes|Memberof
    4. 
  
  
  4. -----------+-------------+-----------
    5. 
  
  
  5. postgres|Superuser|{}
    6. 
  
  
  6. :Createrole
    7. 
  
  
  7. :CreateDB
    8. 
  
  
  8. spaceuser|Superuser|{}
    9. 
  
  
  9. :Createrole
    10. 
  
  
  10. :CreateDB
    11.

4.Display table info:

 
 
    
  
  
  1. spacewalk-#drhnpackage
    2. 
  
  
  2. Table"public.rhnpackage"
    3. 
  
  
  3. Column|Type|Modifiers
    4. 
  
  
  4. -----------------+-----------------------------+------------------------
    5. 
  
  
  5. id|numeric|notnull
    6. 
  
  
  6. org_id|numeric|
    7. 
  
  
  7. name_id|numeric|notnull
    8. 
  
  
  8. evr_id|numeric|notnull
    9. 
  
  
  9. package_arch_id|numeric|notnull
    10. 
  
  
  10. package_group|numeric|
    11. 
  
  
  11. rpm_version|charactervarying(16)|
    12. 
  
  
  12. description|charactervarying(4000)|
    13. 
  
  
  13. summary|charactervarying(4000)|
    14. 
  
  
  14. package_size|numeric|notnull
    15. 
  
  
  15. payload_size|numeric|
    16. 
  
  
  16. build_host|charactervarying(256)|
    17. 
  
  
  17. build_time|timestampwithouttimezone|
    18. 
  
  
  18. source_rpm_id|numeric|
    19. 
  
  
  19. checksum_id|numeric|notnull
    20. 
  
  
  20. vendor|charactervarying(64)|notnull
    21. 
  
  
  21. payload_format|charactervarying(32)|
    22. 
  
  
  22. compat|smallint|default0
    23. 
  
  
  23. path|charactervarying(1000)|
    24. 
  
  
  24. header_sig|charactervarying(64)|
    25. 
  
  
  25. copyright|charactervarying(128)|
    26. 
  
  
  26. cookie|charactervarying(128)|
    27. 
  
  
  27. last_modified|timestampwithtimezone|notnulldefaultnow()
    28. 
  
  
  28. created|timestampwithtimezone|notnulldefaultnow()
    29. 
  
  
  29. modified|timestampwithtimezone|notnulldefaultnow()
    30. 
  
  
  30. header_start|numeric|notnulldefault(-1)
    31. 
  
  
  31. header_end|numeric|notnulldefault(-1)
    32. 
  
  
  32. ................
    33. 
  
  
  33. spacewalk-#
    34.

5.Query table:

 
 
    
  
  
  1. spacewalk=#selectcount(*)fromrhnpackage;
    2. 
  
  
  2. count
    3. 
  
  
  3. -------
    4. 
  
  
  4. 4812
    5. 
  
  
  5. (1row)
    6. 
  
  
  6. spacewalk=#select*fromrhn_os;
    7. 
  
  
  7. recid|os_name
    8. 
  
  
  8. -------+--------------
    9. 
  
  
  9. 4|LinuxSystem
    10. 
  
  
  10. 14|Satellite
    11. 
  
  
  11. (2rows)
    12.

For more infomation about postgreSQL from following links:

1.PostgreSQL 8.4.11 Documentation

2.PostgreSQL examples

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
    相关内容
      推荐文章
        站长推荐
        热点阅读

          【免责声明】本站内容转载自互联网，其发布内容言论不代表本站观点，如果其链接、内容的侵犯您的权益，烦请提交相关链接至邮箱bqsm@foxmail.com我们将及时予以处理。

          建议您使用1920×1080分辨率、谷歌浏览器Google Chrome、Microsoft Edge以获得本站的最佳浏览效果

          Copygight © 2008-2022 https://www.lidatong.com.cn/ All Rights Reserved. 李大同