[Asterisk-Users] Astcc Configuration Problem

Darren Wiebe darren at aleph-com.net
Wed Aug 3 17:40:49 MST 2005


The missing file is nothing to worry about.  It still looks like either 
the config file is empty or apache can't read it.  Have you confirmed 
that your mysql server is running?

Darren Wiebe
darren at aleph-com.net



chawki hammoud wrote:

>There is mysql connection problem and missing files in
>
>var/www/html/.
>
>This is the error I get when I configure database
>
>[Tue Aug 02 23:43:25 2005] [error] [client 127.0.0.1]
>DBI connect('database=;host=','',...) failed: Can't
>connect to local MySQL server through socket
>'/var/lib/mysql/mysql.sock' (13) at
>/var/www/cgi-bin/astcc-admin/astcc-admin.cgi line 67,
>referer:
>http://localhost/cgi-bin/astcc-admin/astcc-admin.cgi?mode=Configure
>[Tue Aug 02 23:43:25 2005] [error] [client 127.0.0.1]
>File does not exist: /var/www/html/favicon.ico
>[Tue Aug 02 23:44:18 2005] [error] [client 127.0.0.1]
>DBI connect('database=;host=','',...) failed: Can't
>connect to local MySQL server through socket
>'/var/lib/mysql/mysql.sock' (13) at
>/var/www/cgi-bin/astcc-admin/astcc-admin.cgi line 67,
>referer:
>http://localhost/cgi-bin/astcc-admin/astcc-admin.cgi?mode=Configure
>[Tue Aug 02 23:44:18 2005] [error] [client 127.0.0.1]
>File does not exist: /var/www/html/favicon.ico
>
>
>The following error is created when I try to save the
>configuration.
>
>[Tue Aug 02 23:43:25 2005] [error] [client 127.0.0.1]
>DBI connect('database=;host=','',...) failed: Can't
>connect to local MySQL server through socket
>'/var/lib/mysql/mysql.sock' (13) at
>/var/www/cgi-bin/astcc-admin/astcc-admin.cgi line 67,
>referer:
>http://localhost/cgi-bin/astcc-admin/astcc-admin.cgi?mode=Configure
>[Tue Aug 02 23:43:25 2005] [error] [client 127.0.0.1]
>File does not exist: /var/www/html/favicon.ico
>[Tue Aug 02 23:44:18 2005] [error] [client 127.0.0.1]
>DBI connect('database=;host=','',...) failed: Can't
>connect to local MySQL server through socket
>'/var/lib/mysql/mysql.sock' (13) at
>/var/www/cgi-bin/astcc-admin/astcc-admin.cgi line 67,
>referer:
>http://localhost/cgi-bin/astcc-admin/astcc-admin.cgi?mode=Configure
>[Tue Aug 02 23:44:18 2005] [error] [client 127.0.0.1]
>File does not exist: /var/www/html/favicon.ico
>
>
>The following error is reported when I attempt the
>route configuration.
>
>[Tue Aug 02 23:50:44 2005] [error] [client 127.0.0.1]
>DBI connect('database=;host=','',...) failed: Can't
>connect to local MySQL server through socket
>'/var/lib/mysql/mysql.sock' (13) at
>/var/www/cgi-bin/astcc-admin/astcc-admin.cgi line 67,
>referer:
>http://localhost/cgi-bin/astcc-admin/astcc-admin.cgi?mode=Configure
>[Tue Aug 02 23:50:44 2005] [error] [client 127.0.0.1]
>File does not exist: /var/www/html/favicon.ico
>
>
>
>
>
>
>
>--- Darren Wiebe <darren at aleph-com.net> wrote:
>
>  
>
>>astcc-admin.cgi will post output to
>>/var/log/httpd/error_log  That 
>>should help solve the problem. 
>>
>>Darren Wiebe
>>darren at aleph-com.net
>>
>>chawki hammoud wrote:
>>
>>    
>>
>>>All suggested files were changed to be owned by
>>>      
>>>
>>root
>>    
>>
>>>and apache and I logged in as root.
>>>
>>>After I unsuccessfully try the route and trunk
>>>      
>>>
>>pages
>>    
>>
>>>and  go back to the configure page, I get the
>>>      
>>>
>>message
>>    
>>
>>>database is unavailable on the same page that
>>>      
>>>
>>created
>>    
>>
>>>it. I manually inserted data to astcc-config.conf
>>>but it seems apache is not writing or reading these
>>>files.
>>>Database is created successfully when I name the
>>>hostname= "localhost.localdomain" and it fails for
>>>hostname = "localhost". I don't know if apache is
>>>loosing communication due to localhost somewhere
>>>      
>>>
>>and
>>    
>>
>>>localhost.localdomain in other places.
>>>
>>>I will uninstall apache and reinstall it.
>>>I appreciate any more suggestions. 
>>>
>>>
>>>--- Darren Wiebe <darren at aleph-com.net> wrote:
>>>
>>> 
>>>
>>>      
>>>
>>>>Try this line in /var/lib/astcc and see if it
>>>>        
>>>>
>>helps.
>>    
>>
>>>>"chown apache *" and
>>>>
>>>>"chown -R apache *" from /var/www/cgi-bin.
>>>>
>>>>If it does not help, do an "ls -l" in /var/www and
>>>>see who owns it.  
>>>>Then repeat the command above with the correct
>>>>        
>>>>
>>user.
>>    
>>
>>>>Darren Wiebe
>>>>darren at aleph-com.net
>>>>
>>>>chawki hammoud wrote:
>>>>
>>>>   
>>>>
>>>>        
>>>>
>>>>>Hi:
>>>>>
>>>>>How do I check it? 
>>>>>
>>>>>Thanks
>>>>>
>>>>>--- Darren Wiebe <darren at aleph-com.net> wrote:
>>>>>
>>>>>
>>>>>
>>>>>     
>>>>>
>>>>>          
>>>>>
>>>>>>Check and make sure that astcc-config.conf is
>>>>>>       
>>>>>>
>>>>>>            
>>>>>>
>>>>owned
>>>>   
>>>>
>>>>        
>>>>
>>>>>>by the same process 
>>>>>>that owns apache.  Usually the problem is that
>>>>>>astcc-admin cannot write 
>>>>>>to the file due to permission problems.
>>>>>>
>>>>>>Darren Wiebe
>>>>>>darren at aleph-com.net
>>>>>>
>>>>>>chawki hammoud wrote:
>>>>>>
>>>>>>  
>>>>>>
>>>>>>       
>>>>>>
>>>>>>            
>>>>>>
>>>>>>>Hi:
>>>>>>>
>>>>>>>I used astcc to create database. After I get
>>>>>>>              
>>>>>>>
>>the
>>    
>>
>>>>>>>message database created, I save the
>>>>>>>         
>>>>>>>
>>>>>>>              
>>>>>>>
>>>>configuration
>>>>   
>>>>
>>>>        
>>>>
>>>>>>>    
>>>>>>>
>>>>>>>         
>>>>>>>
>>>>>>>              
>>>>>>>
>>>>>>and
>>>>>>  
>>>>>>
>>>>>>       
>>>>>>
>>>>>>            
>>>>>>
>>>>>>>I move to the next step to assign trunk and
>>>>>>>         
>>>>>>>
>>>>>>>              
>>>>>>>
>>>>route.
>>>>   
>>>>
>>>>        
>>>>
>>>>>>>    
>>>>>>>
>>>>>>>         
>>>>>>>
>>>>>>>              
>>>>>>>
>>>>>>But
>>>>>>  
>>>>>>
>>>>>>       
>>>>>>
>>>>>>            
>>>>>>
>>>>>>>I get the message:
>>>>>>>Database unavailable -- please check
>>>>>>>         
>>>>>>>
>>>>>>>              
>>>>>>>
>>>>configuration
>>>>   
>>>>
>>>>        
>>>>
>>>>>>>Cannot edit routes until database is configured
>>>>>>>
>>>>>>>I checked the databse and it's in mysql, the
>>>>>>>              
>>>>>>>
>>file
>>    
>>
>>>>>>>/var/lib/astcc/astcc-config.conf is empty.
>>>>>>>astcc-admin.cgi is supposed to write a file
>>>>>>>              
>>>>>>>
>>based
>>    
>>
>>>>>>>    
>>>>>>>
>>>>>>>         
>>>>>>>
>>>>>>>              
>>>>>>>
>>>>>>on
>>>>>>  
>>>>>>
>>>>>>       
>>>>>>
>>>>>>            
>>>>>>
>>>>>>>the configuration, but for some reason doesn't
>>>>>>>I inserted data manually into the databse
>>>>>>>              
>>>>>>>
>>tables
>>    
>>
>>>>>>>    
>>>>>>>
>>>>>>>         
>>>>>>>
>>>>>>>              
>>>>>>>
>>>>>>and
>>>>>>  
>>>>>>
>>>>>>       
>>>>>>
>>>>>>            
>>>>>>
>>>>>>>astcc works fine on asterisk and write data
>>>>>>>              
>>>>>>>
>>into
>>    
>>
>>>>>>>    
>>>>>>>
>>>>>>>         
>>>>>>>
>>>>>>>              
>>>>>>>
>>>>>>the
>>>>>>  
>>>>>>
>>>>>>       
>>>>>>
>>>>>>            
>>>>>>
>>>>>>>database.
>>>>>>>Why the web browser can't see the database it
>>>>>>>    
>>>>>>>
>>>>>>>         
>>>>>>>
>>>>>>>              
>>>>>>>
>>>>>>created?
>>>>>>  
>>>>>>
>>>>>>       
>>>>>>
>>>>>>            
>>>>>>
>>>>>>>could apache be the problem although it's
>>>>>>>         
>>>>>>>
>>>>>>>              
>>>>>>>
>>>>running?
>>>>   
>>>>
>>>>        
>>>>
>>>>>>>Regards;
>>>>>>>Chawki
>>>>>>>
>>>>>>>
>>>>>>>		
>>>>>>>    
>>>>>>>
>>>>>>>         
>>>>>>>
>>>>>>>              
>>>>>>>
>>>>____________________________________________________
>>>>        
>>>>
>>>>>     
>>>>>
>>>>>          
>>>>>
>>>>>>  
>>>>>>
>>>>>>       
>>>>>>            
>>>>>>
>=== message truncated ===
>
>
>
>		
>__________________________________ 
>Do you Yahoo!? 
>Read only the mail you want - Yahoo! Mail SpamGuard. 
>http://promotions.yahoo.com/new_mail 
>_______________________________________________
>Asterisk-Users mailing list
>Asterisk-Users at lists.digium.com
>http://lists.digium.com/mailman/listinfo/asterisk-users
>To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-users
>
>  
>




More information about the asterisk-users mailing list